The CSV Exporter turns a supplier's products into a file you can import into your store. Pick what the file is for, pick the products, and download it when it's ready.
It's under Tools in the dashboard menu, at /dashboard/exporters/csv-exporter/, and it's on the
Premium plan and higher. Exporting a supplier's whole catalog in one go
needs Business or Enterprise.
The files it makes
You choose one in File to make. They're grouped by where the file goes:
- Shopify: Add products to Shopify and Update inventory in Shopify.
- Shopify apps: Quantity price breaks (Bold Commerce), Order minimums (MinMaxify) and Order minimums (Order Logic).
- Magento: Add products to Magento.
- Other: Match products already in your store, which lists each product ID with its Extra ID, and Raw PromoStandards data (for developers), a JSON file.
If we've built a custom format for your account, it's listed at the end. For most files, the box under the dropdown lists every column the file will have, in order.
Make your first Shopify file
- Open CSV Exporter under Tools in the dashboard menu.
- In File to make, choose Add products to Shopify.
- Choose the Supplier.
- Paste a few product IDs into Product IDs, separated by commas or new lines.
- Leave Price type on List, the retail price.
- Leave Product status on Draft, so the new products stay hidden until you publish them.
- Click Generate CSV.
- When the export page says your file is ready, click Download CSV.
Instead of product IDs, you can start typing in Category and pick one of the supplier's categories. Most files are ready in minutes. You can leave the page: we email you when the file is ready.
If you set Price type to Net or Customer instead, that's your cost, not a sell price. The Shopify product file then asks for a Markup % and sets your sell price to your cost plus that markup. Customer pricing needs your own credentials for that supplier.
To bring it into Shopify, go to Products in your Shopify admin, click Import, add the file and click Upload and preview, then Import products. When you're importing products you already have, tick the overwrite option so the new data replaces the old.
Good to know
- The product file has no stock in it. Make an Update inventory in Shopify file for that, and set Shopify location to your Shopify location's name exactly, capitals included.
- Missing a supplier? The list only has suppliers whose product data and media services are live, and it hides suppliers that need your own login until you add it in Supplier Credentials.
- Each export appears under Recent exports, with All exports for the full history. When some products are left out, the export page lists why under What was left out, and what to do, with a button to retry them and Download the problem list.
- Exports use your account's daily calls. If an export stops because the limit was reached, the export page says so (what the limit means).
Raw PromoStandards data (for developers) gives you one JSON file with the full product data as PSRESTful returns it. To pull the same data from code, use the Product Data and Media Content endpoints described at https://docs.psrestful.com/.
What to try next
- Build your list of product IDs in Product Search.
- On Shopify and want products kept up to date without re-importing files? Look at PromoSync.