Listwright™
Menu

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.

Example product plan before building the import file
ProductHandleSKUStatus
Blue Stoneware Mug, 350 mlstoneware-mug-blueMUG-BLUE-01draft
Green Stoneware Mug, 350 mlstoneware-mug-greenMUG-GREEN-01draft

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

FieldWhat to check
HandleSeparate products have separate identifiers. Intentional variants stay together.
Title and descriptionThe wording describes this exact item, including its material and size.
SKU and optionsYour product code still matches your records and the right variant.
PriceThe amount is correct for your store currency, with no currency symbol in the numeric field.
Image URL and alt textThe image opens publicly and the description matches what it shows.
SEO Title and SEO DescriptionA useful, distinct summary for each product, without repeating a list of keywords.
StatusUse 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

  1. Save the working file as CSV in UTF-8. Keep your original export.
  2. Open Products → Import in Shopify and select the file.
  3. Check the publishing and overwrite settings for this batch.
  4. Continue to Shopify's import review, then confirm the import.
  5. 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.