If you've ever built or maintained a Shopify, WooCommerce, or PrestaShop store for a client using distributor price lists, you know the pain isn't clicking Import—it's what happens right after:
- Duplicate
Variant SKUrows silently overwriting existing products - European comma decimals (
18,50) or"TBD"/"Call for price"strings breaking price parsing - Excel stripping UTF-8 characters into mojibake (
é) - Trailing spaces in headers like
"Variant Inventory Qty "causing Shopify to reject the whole file - Case vs. unit pricing traps (
box of 12,100pcs/box) slipping straight into live store margins
A Quick Zero-Dependency CLI Check
I open-sourced a lightweight Node.js CLI validator (0 dependencies) you can run locally or in CI before touching Shopify Admin:
👉 GitHub: github.com/rayantabara/shopify-csv-validator
git clone https://github.com/rayantabara/shopify-csv-validator.git
cd shopify-csv-validator
node index.mjs sample-broken.csv
It checks required Shopify headers (Handle, Title, Variant SKU, Variant Price), duplicate SKUs, non-numeric prices, comma decimals, broken UTF-8, and pack/case pricing phrases—exiting with code 1 if anything needs fixing.
Prefer a Browser UI (or Dealing with Supplier PDFs)?
If your vendor only sent a 40-page PDF price list or a multi-tab .xlsx file (or you don't want to clone a repo):
- Free Unlimited Browser CSV Validator (up to 25,000 rows, 100% client-side): fichasync.app/shopify-csv-validator
-
Full AI Normalizer + Supplier Diff: fichasync.app turns raw supplier Excel/CSV/PDF sheets into clean Shopify, WooCommerce, or PrestaShop CSVs in ~2 minutes with deterministic Strict OEM SKU Lock and ephemeral Supplier Diff (compare a new tariff against your previous CSV in RAM to spot new SKUs,
%price changes, and dropped items).
Would love feedback on edge cases you've hit with distributor spreadsheets!
Top comments (0)