Need help managing product catalogs and marketplace integrations?
We help businesses with:
- Web Development
- Ecommerce Integrations
- Automation
- Technical SEO
Shopify's product import fails per-row, not per-file - so a single bad price or a mismatched Option1 Name three thousand rows in can mean re-uploading and waiting through the whole import again just to find one cell. This checks a product CSV against Shopify's actual column rules before you upload it, and tells you exactly which row and column caused each problem.
When you'd use this
Before any bulk import or re-import - especially catalogs exported from another platform, since column names and formats (delimiter, price formatting, boolean values) rarely match Shopify's exactly on the first try.
It's also useful for catching the relational mistakes that a spreadsheet won't warn you about on its own: variant rows that don't share their parent's Handle, duplicate SKUs scattered across the file, or Option1/2/3 Name values that drift between rows that are supposed to belong to the same product.
Common errors
Errors (shown in red) mean the import will fail outright for that row - a missing required column, a price with a currency symbol in it, or an invalid barcode. Warnings mean the import will succeed but produce a wrong result, like a compare-at price that's lower than the actual price.
A semicolon-delimited file (common from European spreadsheet exports) is detected automatically - if your file still looks garbled, it's usually an encoding issue: this tool flags the character patterns that indicate a UTF-8 file was saved or re-opened as Latin-1 somewhere along the way.
Frequently asked questions
Does this check every possible Shopify import rule?
It checks the rules with real, testable consequences: required/unknown columns, price and quantity formats, barcode validity, and the Handle/Option/SKU relational rules that determine whether variant rows group into one product correctly. The rule set is versioned with a last-verified date shown on the page - Shopify's own schema is the final authority.
Why does an invalid barcode link to a different tool?
Barcode fields are validated with the same GS1 check-digit logic as the GTIN Converter, so an invalid barcode links straight there to fix or convert it, rather than making you retype it into a second tool from scratch.
What does the downloaded "annotated" CSV contain?
Your original file with one extra `_errors` column appended, listing every error and warning found for that row - so you can filter or sort in a spreadsheet instead of cross-referencing row numbers against a separate report.
Ecommerce & Catalog Cluster
Often used together when preparing marketplace listings - see the full workflow.
GTIN Converter
Convert product codes between GTIN-8, GTIN-12 (UPC-A), GTIN-13 (EAN-13) and GTIN-14, validate check digits, and normalise a whole catalog in bulk.
EAN / UPC Generator
Generate valid-checksum EAN-13, EAN-8, UPC-A and GTIN-14 product codes in bulk for test catalogs, and validate the check digit of any existing code.
Barcode Generator
Render a scannable EAN-13, UPC-A, CODE128 or ITF-14 barcode from a product code and download it as a PNG for labels and store listings.
SKU Generator
Generate consistent SKU codes in bulk from a custom pattern with variant permutations, sequential numbering and collision checking.
Marketplace Image Checker
Check product images against each marketplace's dimension, aspect ratio, file size and format rules before you upload them.
ISBN / ASIN Validator
Validate ISBN-10 and ISBN-13 check digits, convert between them, and check Amazon ASIN format in bulk.
IBAN Generator
Generate format-valid, checksum-correct IBAN numbers for any supported country for testing and QA, and validate the checksum of any IBAN.
Related Utilities You Might Need
Stack Selector
Select your project scope, budget, and features to instantly receive a vetted, modern tech stack and service recommendation.
IBAN Generator
Generate format-valid, checksum-correct IBAN numbers for any supported country for testing and QA, and validate the checksum of any IBAN.
EAN / UPC Generator
Generate valid-checksum EAN-13, EAN-8, UPC-A and GTIN-14 product codes in bulk for test catalogs, and validate the check digit of any existing code.
