We're constantly trying to improve your support experience, and your feedback is extremely valuable to us.

Please take a moment to tell us about your experience today.
Sign up for future Help Center user research studies.

Importing products with a CSV file

Importing products is useful if you switched to Shopify from another platform or if you want to make many changes to your products or inventory.

When importing, Shopify converts the data from the CSV file into products.

Before you begin, make sure you've read the following topics:

Importing products with a CSV file

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:

  1. From your Shopify admin, go to Products > All products.

  2. Click Import.

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

  4. Locate your CSV file, then click Open.

  5. Click Upload file.

When your CSV file is uploaded you 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.

Import products after making changes to your CSV file

If you want to make changes to your products using a CSV file, then you need to export your products first. You can make changes to your CSV file in a spreadsheet program like Google Sheets, then import your updated CSV into the Shopify admin.

Steps:

  1. From your Shopify admin, go to Products > All products.

  2. Click Import.

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

  4. Locate your CSV file, then click Open.

  5. Click the Replace any current products that have the same handle checkbox. This overrides any data that is on Shopify. If there are any missing columns, then the products current values are not changed.

  6. Click Upload file.

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

Ready to start selling with Shopify?

Try it free