CSV stands for Comma Separated Value, which is a file format (like .doc, .jpg, .xls, .csv) for spreadsheets. Shopify accepts the import and export of CSV files for the Products, Orders (export only), and Customers of your store.
This is useful for stores that:
- are switching to Shopify from another e-commerce platform
- have a list of loyal Customer Accounts
- prefer to upload Products via a spreadsheet
- temporarily have limited internet connectivity.
Click to learn more about:
Import a CSV file into Google Sheets
When you export a CSV file from your Shopify admin, it opens as a .csv file in your computer's native text editor. You can also use an alternative text editor, but it's recommended that you use a spreadsheet program to view and edit your CSV files instead.
Shopify recommends using Google Sheets to view a formatted version of your CSVs. To use Google Sheets, you must import the CSV file in to the program, then export it as a .csv file to your computer.
To import a .csv in to Google Sheets:
On the Google Sheets page, click Blank in the Start a new spreadsheet section:
From the Untitled Spreadsheet page, go to File > Import...:
Locate and select the CSV file that you want to edit.
In the Import file dialog, select your preferred options under the Import action, Separator character, and Convert text to numbers and dates sections.
Your CSV will look similar to this after you've uploaded it:
From here you can edit your CSV. When you are done, you can export it from Google Sheets as a .csv file.
Advanced: CSV product imports with shipping required and taxable variants
If you need to edit the settings for a large number of products, you might want to perform a bulk update. For this, export the products that need to be updated as a .csv file, then edit the columns shown in the table:
|Variant Requires Shipping||Set to true or left blank if the variant is a tangible item. Set to false otherwise.|
|Variant Taxable||Set to true or left blank if the variant is taxable. Set to false otherwise.|
|Variant Grams||Enter a non-zero value if Variant Requires Shipping is set to true or left blank.
Leave blank or set to zero if Variant Requires Shipping is set to false.
When you've finished editing your .csv file, import it to your store. Be sure to check the option: Overwrite existing products that have the same handle.