Save it the right way
Shopify wants a CSV saved as UTF-8. In Excel, choose CSV UTF-8 when you save, not plain CSV, or accented letters and symbols like £ can turn into strange characters. Start from Shopify’s own product CSV template so the column names match exactly, and keep the file under Shopify’s 15 MB limit; split a big range into several files.
Handles and variants
- Each product has a URL handle (called Handle in older templates), a short unique name such as
linen-cushion-cover. Each size or colour is a row of its own, and every row of a product with variants needs the same handle. - Put the title, description and other product details on the first row of each product only. Later rows carry just the variant details: option values, SKU, price, barcode and stock.
- Name the options in Option1 name, Option2 name and so on, such as Size and Colour. Shopify allows up to three options per product. If two rows have the same option values, the import fails.
Images that don’t appear
The image address column (Product image URL in current templates, Image Src in older ones) must be a public web address that opens the image itself. A file on your computer won’t work, and nor will a Dropbox or Google Drive share page, because those open a web page, not the picture. Upload the images somewhere public first, or add them in Shopify after the import. Use the variant image column (Variant image URL) to give each colour its own picture.
Prices, barcodes and stock
- Prices are plain numbers, such as
24.50, with no £ sign. - Barcodes lose their leading zeros, and long ones can show as numbers like 5.01E+12, when a spreadsheet treats them as numbers. Set the column to text before you paste.
- Stock levels in the product file only apply to shops with one location, and only when inventory is tracked for that variant.
Updating products you already have
To change existing products, tick Overwrite products with matching handles when you import. Take care: a column you include but leave empty can clear what’s already in your shop. Export your products first as a backup. Keep the URL handle, Title and Option name and value columns, and add only the other columns you mean to change. If variant columns such as SKU go in without the Option columns, Shopify can delete the existing variants.
When it still won’t go in
Shopify lists the row and the problem when an import fails. Fix those rows and import again. If your supplier’s file is the problem, with sizes in the titles, prices in odd formats or images in a folder named anything but the SKU, that’s exactly the job our supplier onboarding service is built for.