Q: How do I export my Shopify products to a CSV file?
From your Shopify admin dashboard, go to “product” and then select “all products”. From here you will be able to export the set of data you want. You are able to export products, a customer list, orders, and discounts.
You are then able to select whether you want the export to be displayed in plain text, or in a spreadsheet format. If you were exporting a product list, this is what the CSV export would look like:
Now you have the ability to edit any of the contents in the columns of the spreadsheet.
Super easy, right?
For the most part, this is a fairly simple process. But things can go wrong with your CSV file when you go back to import it into Shopify. CSV imports can cause unwanted changes or even remove important data from your store. The most common problems we see are as follows:
- If any of the content in your columns are missing, or in the wrong order, it would result in a “missing headers” error.
- Stores with certain UTF characters inserted into their products find exporting the CSV files results in incorrect or missing characters being inserted into products.
- CSV files edited on Microsoft Excel or Numbers can cause your products to be removed from their relevant image links on the CSV file and lost product images.
Unfortunately, this was the case for one of our customers, Andrew Saunders:
“Do yourself a favour and download this plugin. Even though I have not used it – I wish I had downloaded it on my other store when 60% of my product images were deleted after importing a CSV file and costing me weeks of work locating and uploading the images again. Don’t take the risk.”
Our recommendation: Backup your store data with Rewind BEFORE importing a CSV file.
Rewind runs automatic backups of your entire store on a daily basis, but you can also run a backup yourself right before importing your CSV file, to make sure that your site stays undamaged. If something were to go wrong with your site after the import, you can simply go into your Rewind Vault, and rewind your store to the moment it was in before you made the CSV import.