DEV Community

Rayan
Rayan

Posted on

Why Shopify CSV Imports Fail Silently on Supplier Spreadsheets (and a Zero-Dependency Validator to Catch Them)

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 SKU rows 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
Enter fullscreen mode Exit fullscreen mode

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)