Start from Shopify’s template, not the supplier’s file
Export one product from your shop, or download Shopify’s sample product CSV, and use its exact column headings. Shopify has renamed some columns over time, so older guides may say Variant SKU or Image Src where your template says something slightly different. Copy the supplier’s data into the template, never the other way round, and save it as CSV UTF-8.
Which supplier column goes where
- Supplier code or item code becomes your SKU. Keep it exactly as the supplier writes it, so reorders match.
- Description on a price list is usually a short line such as
Linen cushion 45cm natural. That is the start of your title, not your product description. - Trade price or cost goes in Cost per item, which only you see. Your selling price goes in Price.
- EAN, UPC or barcode goes in the barcode column, formatted as text first so no digits are lost.
- Brand goes in Vendor. Weight goes in the weight column, in grams in a CSV, which matters for shipping rates.
Split sizes and colours out of the title
Price lists often have one line per size and colour, with the variant written into the description: Linen cushion 45cm natural, Linen cushion 45cm charcoal, Linen cushion 60cm natural. In Shopify that is one product with two options, Size and Colour, and three variant rows sharing one handle. Take the size and colour out of the title, name the options (Size and Colour) in the option name columns, put each row’s size and colour in the option value columns, and give every row of that product the same handle. Without the option name columns, Shopify can delete your variants or set them to Default Title. Each row keeps its own SKU, barcode and price.
Prices you can stand behind
- Prices are plain numbers like
24.50, with no £ sign. - If the supplier gives a recommended retail price, that is a suggestion, not a price you have charged. Only fill in a compare at price if you really sold the product at that price, or the strike through can mislead buyers.
- Check whether the supplier’s prices include VAT before you work out your margin.
Images
Suppliers often send a folder of images named by their own code, or one big ZIP. Rename each image to its SKU so you can match it to the right row, upload the images somewhere public, and put each address in the image column. Check the file names before you upload; Shopify keeps the name once the image is on your shop. The address must open the picture itself, not a share page. Make sure your supplier agreement lets you use their photos and descriptions.
Import a few, check, then the rest
Import five products first, set to Draft in the status column, so nothing appears in your shop yet. Open each one in Shopify and check the title, variants, price, barcode and images. Fix the file, delete the test products, then import the full range as drafts and publish once you are happy. If the import fails, Shopify lists the row and the problem; our CSV import checklist covers the usual causes.