Sheet2StoreRESOURCES
Guides for getting supplier products into your store
Templates, fixes for Shopify import errors and practical guides for turning supplier price lists into Shopify and WooCommerce imports.
Free templates
Correctly formatted import files you can download and fill in.
Shopify 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.
↗FREE 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.
Shopify 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.
↗SHOPIFY IMPORT 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.
↗SHOPIFY IMPORT 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.
↗SHOPIFY IMPORT 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.
↗SHOPIFY IMPORT 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.
↗SHOPIFY IMPORT 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.
↗SHOPIFY IMPORT 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.
↗SHOPIFY IMPORT 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.
↗SHOPIFY IMPORT 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.
↗SHOPIFY IMPORT 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.
↗SHOPIFY IMPORT 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.
↗SHOPIFY IMPORT 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.
↗SHOPIFY IMPORT 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.
↗SHOPIFY IMPORT 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.
↗SHOPIFY IMPORT 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.
How 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.
↗GUIDEHow 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.
↗GUIDEHow 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.
↗GUIDEImporting 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.
↗GUIDEHow 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.
↗GUIDEStrange 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.
Free 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 → WOOPDF to WooCommerce CSV converter
Turn a supplier PDF into a WooCommerce import with variable products.
↗XLSX → WOOExcel 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.
↗