Importing your 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.

Grow your business

You can hire a Shopify Expert to import products for you and let you focus on other important parts of your business.

Before you begin

Before you begin, make sure you've read:

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

If you want to see more educational videos and tutorials like this one, visit our video library.

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 will fail.

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.

To add products from another store or source:

  1. From your Shopify admin, go to Products.

  2. Click Import.

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

    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 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.

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 your Shopify admin.

Caution

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

To import your product CSV:

  1. From your Shopify admin, go to 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 Overwrite existing products that have the same handle checkbox. This will override any data that is on Shopify.

  6. 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.

Want to discuss this page?

Visit the Shopify Community

Ready to start selling online with Shopify?

Try it free