Caution

Importing a CSV file that has been sorted by a spreadsheet editor such as Microsoft Excel or Numbers will cause your products to be removed from their relevant image links on the CSV, and your product's images will be lost.

Importing products with a CSV file

Tip

Import products from another store

If you have a CSV file that was exported from another store or came from another source, make sure it matches the CSV file format. If the format doesn't match, or if there are any missing headers, then the import fails.

Your product CSV can't exceed 15MB. If you get an error when trying to upload a new CSV file, then check to make sure it doesn't exceed the size limit.

Steps:

From your Shopify admin, go to Products.

Click Import.

Click Choose File in the Import products by CSV file window.

Locate your CSV file, then click Open.

Click Upload file.

When your CSV file is uploaded you will receive a confirmation email from Shopify at the email account that you used to set up your Shopify store. Read some solutions to common problems.

Caution

You can't use a product CSV to import changes to products when you used an app like Oberlo to add products to your online store. Importing products by using a CSV causes orders for your Oberlo products to stop syncing.

Steps:

From your Shopify admin, go to Products.

Click Import.

In the Import products by CSV file dialog, click Choose File.

Locate your CSV file, then click Open.

Click the Overwrite existing products that have the same handle checkbox. This will override any data that is on Shopify.

Click Upload file.

When your CSV file is successfully uploaded you will receive a confirmation email from Shopify at the email account used to set up your Shopify store. Read some solutions to common problems.

Tip

If you are having issues with uploading your CSV file, we recommend using the Google Chrome browser.