Listwright guides / Shopify
How to bulk import products to Shopify with a CSV
In Shopify, go to Products → Import to upload a product CSV. Start with a small batch in draft, check the product handles and variants, and review the result before publishing your catalogue.
Reviewed October 12, 2026. By Listwright. Sources: Shopify Help Center.
Start with the right template
For an existing shop, export a few representative products first. Keep
that original file as your backup and work on a copy. For a new catalogue,
use the sample linked from
Shopify's product CSV reference.
Its current headers include URL handle and
Description. Older files use Handle and
Body (HTML). Shopify documents support for older column names.
A worked example: two products with similar names
Say you sell a blue mug and a green mug as separate products. Give them different handles even if their titles are similar. If they are colour options of one product instead, model them as variants of that product.
| Product | Handle | SKU | Status |
|---|---|---|---|
| Blue Stoneware Mug, 350 ml | stoneware-mug-blue | MUG-BLUE-01 | draft |
| Green Stoneware Mug, 350 ml | stoneware-mug-green | MUG-GREEN-01 | draft |
A repeated handle can describe another variant or image of the same product. It does not, by itself, create a separate product. Keep the option columns from your Shopify template when working with variants.
Prepare the product facts before the copy
A useful writing sheet keeps facts separate: SKU, name, material, colour, size and price. Here is an example input for Listwright, not a Shopify import file. Download the sample to keep these columns in a spreadsheet.
sku,name,material,colour,size,price
MUG-BLUE-01,Stoneware mug,stoneware,blue,350 ml,24.00
MUG-GREEN-01,Stoneware mug,stoneware,green,350 ml,24.00
Download Listwright's Shopify writing sample See how input columns work
Use the material and capacity in the description. Add care instructions, origin or certifications only when you can verify them. “Stoneware” alone is not evidence that a mug is dishwasher safe.
Check these fields before importing
| Field | What to check |
|---|---|
| Handle | Separate products have separate identifiers. Intentional variants stay together. |
| Title and description | The wording describes this exact item, including its material and size. |
| SKU and options | Your product code still matches your records and the right variant. |
| Price | The amount is correct for your store currency, with no currency symbol in the numeric field. |
| Image URL and alt text | The image opens publicly and the description matches what it shows. |
| SEO Title and SEO Description | A useful, distinct summary for each product, without repeating a list of keywords. |
| Status | Use draft while reviewing new products. |
Shopify's documented limits are 70 characters for an SEO title and 320 for an SEO description. Those storage limits do not promise how much a search result will display. Put the clearest product information first.
Import a small batch, then inspect it
- Save the working file as CSV in UTF-8. Keep your original export.
- Open Products → Import in Shopify and select the file.
- Check the publishing and overwrite settings for this batch.
- Continue to Shopify's import review, then confirm the import.
- Open the imported products and check copy, options, prices and images before publishing.
When overwriting matching handles, an included blank column can clear an existing value. An omitted column generally leaves it unchanged, subject to dependencies between fields. Follow Shopify's import instructions and review the overwrite guidance in its CSV reference before updating products that are already for sale.
Where Listwright fits
Listwright writes product copy from your rows, checks marketplace limits and returns a Shopify CSV. Its export includes SEO fields and sets new products to draft. You still review the file, complete your product data and decide when to publish.
Try one Shopify listing Check a listing for free
Related: common CSV import errors, marketplace listing limits, how Etsy's CSV differs and all listing guides.