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
- Open your store and go to Products.
- Choose Import.
- Select your CSV file and upload it.
- 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.
- 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
Related articles
Still need help?
Tell us what is going on and we will take it from there.
Contact support