Import products from a CSV file

Add or update many products at once by uploading a spreadsheet, and review the import summary before it is applied.

If you have more than a handful of products, importing them from a CSV file is faster than adding them one by one. This is also the easiest way to bring a catalog from another platform.

Prepare your file

Save your spreadsheet as a CSV file with a header row. Use one row per product, or one row per variant for products with options. Include these columns where you can:

| Column | What to put in it | | --- | --- | | Title | The product name. | | Description | The product description. Plain text or simple formatting. | | SKU | A unique code for the product or variant. | | Price | The selling price, as a number without a currency symbol. | | Compare-at price | The original price, if the product is on sale. | | Inventory | The quantity available. | | Options | Option names and values, such as Size and Color. | | Images | Public image links, separated by commas. |

Download the import template from the import screen to see the exact column names.

Import the file

  1. Open your store and go to Products.
  2. Choose Import.
  3. Select your CSV file and upload it.
  4. Review the summary. It lists how many products and variants will be created or updated, and flags problems such as duplicate SKUs or missing prices.
  5. Fix any problems in your file and upload it again, or confirm the import.

Large files can take a few minutes. You can leave the page while the import finishes.

Ask your assistant

You can also share a spreadsheet with your assistant and say: "Import these products into my store as drafts and tell me about anything you could not import." Importing as drafts lets you review everything before customers see it.

Common problems

  • Images do not appear. The image links must be public and reachable. Links that need a login will not work.
  • Duplicate SKUs. Each variant needs its own SKU. Rename duplicates and try again.
  • Prices look wrong. Use a period for decimals and remove thousands separators and currency symbols.
  • Special characters look broken. Save the file with UTF-8 encoding.

What's next

Was this helpful?

Related articles

Still need help?

Tell us what is going on and we will take it from there.

Contact support