Guides for getting supplier products into your store
Templates, fixes for Shopify import errors and practical guides for turning supplier price lists into Shopify, WooCommerce, Amazon, noon, Trendyol, Hepsiburada, Salla and Zid imports.
Free templates
Correctly formatted import files you can download and fill in.
ShopifyFree templateShopify product CSV template: free download and column guide
Download a free Shopify product CSV template in the current column format, with a simple product and a product with variants. Column-by-column guide included.
WooCommerceFree templateWooCommerce product CSV template: free download and column guide
Free WooCommerce product CSV template for the built-in importer: a simple product and a variable product with variations, plus a column-by-column guide.
Fix a Shopify import error
What each message means and how to correct the file.
ShopifyTroubleshootingShopify CSV import errors and how to fix them
A plain-English list of Shopify product CSV import errors, what each message means and how to fix the file: quoting, headers, variants, prices, images.
ShopifyImport error“Illegal quoting on line”: how to fix this Shopify CSV error
Shopify says “Illegal quoting on line”? Curly quotes, inch marks or non-UTF-8 encoding broke the CSV. Here is how to find the line and fix it in minutes.
ShopifyImport error“Missing or stray quote on line”: fixing unclosed quotes in a Shopify CSV
Fix the Shopify CSV error “Missing or stray quote on line”: find the unclosed quote, inch mark or smart quote on that line and save the file correctly.
ShopifyImport error“Unquoted fields do not allow \r or \n”: fixing line breaks in a Shopify CSV
Shopify CSV error “Unquoted fields do not allow \r or \n”? A line break sits in a cell without quotes, or the file has old Mac line endings. Fix it here.
ShopifyImport error“Invalid CSV header: missing headers”: fixing the first row of a Shopify CSV
Shopify “Invalid CSV header: missing headers: Title”? The first row of your CSV doesn’t match Shopify’s column names. How to repair the header row.
ShopifyImport error“Validation failed: options are not unique”: duplicate variants in a Shopify CSV
Fix “Validation failed: options are not unique” in a Shopify CSV: find variant rows with the same option values or a reused URL handle, and correct them.
ShopifyImport error“The variant ‘Default Title’ already exists”: fixing a Shopify CSV import
Shopify CSV error “The variant ‘Default Title’ already exists”? Two rows of a product have no option values. Why it happens and how to fix the rows.
ShopifyImport error“Validation failed: price can’t be blank”: fixing prices in a Shopify CSV
Shopify CSV import error “price can’t be blank”? A variant row has no price or an unreadable one. How to find the rows and format prices correctly.
ShopifyImport error“Ignored line because it did not contain product data”: what it means
Shopify ignored lines “because it did not contain product data”? The first row for that handle has no title. Here is what that means and how to fix it.
ShopifyImport error“Ignored line because handle already exists”: fixing duplicate handles
Shopify skipped products because the “handle already exists”? Two products share a URL handle, or the product is already in your store. Fix handles here.
ShopifyImport errorShopify CSV image errors: “An error occurred while trying to download the image”
Shopify CSV import says “An error occurred while trying to download the image” or shows a getaddrinfo error? Fix image URLs so Shopify can fetch them.
ShopifyImport error“Fulfillment service can’t be blank”: quick fix for Shopify CSV imports
Shopify CSV import error “Fulfillment service can’t be blank”? Enter manual in the fulfillment column or delete the column. Quick fix and explanation.
ShopifyImport error“Inventory quantity is not a number” (and “can’t be blank”): fixing stock in a Shopify CSV
Fix Shopify CSV errors “Inventory quantity is not a number” and “Inventory quantity can’t be blank”: use whole numbers or turn off inventory tracking.
ShopifyImport error“Inventory policy is not included in the list”: fixing a Shopify CSV
Shopify CSV error “Inventory policy is not included in the list”? The out-of-stock column only accepts deny or continue. Fix the values in minutes.
ShopifyImport error“Not a valid product category”: fixing the Product category column
Shopify CSV import says “Not a valid product category”? The value must match Shopify’s Standard Product Taxonomy exactly. How to find and enter a valid one.
Guides
From a supplier price list to products in your store.
ShopifyGuideHow variants work in a Shopify product CSV
How Shopify CSV files store products with variants: one row per variant, shared URL handles, option names and values, Default Title and variant images.
ShopifyGuideHow to import products from Excel to Shopify
Import products from an Excel sheet into Shopify: match Shopify’s columns, keep SKUs and barcodes intact, fix prices, save as CSV UTF-8 and test as drafts.
ShopifyGuideHow to add a supplier’s products to Shopify in bulk
Turn a wholesale supplier’s PDF or Excel price list into Shopify products: pick the right cost, set prices, group variants, add images and import as drafts.
GuideHow to convert a PDF price list to Excel
Get a supplier PDF price list into Excel: check for selectable text, compare copy-paste, Excel’s PDF import, Acrobat and OCR, then clean the data for import.
GuideMarkup vs margin: how to price wholesale products for your store
Markup vs gross margin for product pricing: formulas, a markup-to-margin conversion table, keystone pricing, currency conversion and .99 price endings.
WooCommerceGuideImporting WooCommerce variable products with a CSV
How to import WooCommerce variable products by CSV: the parent row, variation rows, Parent SKU, attribute columns, global attributes and common mistakes.
WooCommerceGuideHow to import a supplier’s products into WooCommerce
Import a supplier’s price list into WooCommerce: clean the data, set prices, build variable products, add image URLs and run the built-in CSV importer safely.
ShopifyGuideStrange characters after a Shopify CSV import? Save the file as UTF-8
Seeing é, ’ or � in products after a Shopify CSV import? The file wasn’t saved as UTF-8. How to save CSV UTF-8 from Excel, Google Sheets and Numbers.
Converters and free tools
Upload the file your supplier sent and preview five rows free.
ShopifyFree toolFree Shopify CSV checker
Find missing prices, duplicate SKUs and repeated variant rows before you import.
PDF →ShopifyPDF to Shopify CSV converter
Turn a text-based supplier PDF price list into a Shopify product CSV.
XLSX →ShopifyExcel to Shopify CSV converter
Map supplier spreadsheet columns to a Shopify import with variants.
PDF →WooCommercePDF to WooCommerce CSV converter
Turn a supplier PDF into a WooCommerce import with variable products.
XLSX →WooCommerceExcel to WooCommerce CSV converter
Convert supplier spreadsheets into WooCommerce product imports.
TRY →ShopifyTurkish supplier catalog to Shopify
Read Turkish headings and decimal commas, then export a Shopify CSV.
XLSX →
AmazonSupplier catalog to Amazon bulk listing
SKUs, EAN/UPC, prices and parent–child variations in Amazon’s attribute names.
XLSX →
TrendyolSupplier price list to Trendyol upload file
Barcodes, model codes and VAT-inclusive TRY prices, checked against Trendyol’s rules.
XLSX →
SallaSupplier catalog to Salla import template
Product and option rows in Salla’s template, with prices in riyals.
XLSX →
ZidSupplier catalog to Zid import file
Zid’s import file with variants, SKUs, prices and stock.
XLSX →
HepsiburadaSupplier price list to Hepsiburada upload file
Seller SKUs, variant groups, barcodes and VAT-inclusive TRY prices, checked.
XLSX →
noonSupplier catalog to noon bulk upload file
Partner SKUs, GTINs, size variants, prices and stock in noon’s field names.