CatalogHop

Shopify product CSV checker

Drop the CSV you plan to import into Shopify. The checker reads every row against Shopify's documented import rules and lists each problem with its line number and the fix, before you upload anything to your store.

Check a Shopify product CSV

Shopify product import

The product CSV you are about to import into Shopify, or the one Shopify just rejected.

Your file stays on this device

It is read and converted by this page, inside your browser. Nothing from the file is uploaded, and the tool keeps working offline once the page has loaded.

No file handy? or download the sample to look at it first.

The products in the sample are invented. It is checked on this device, the same way your own file would be.

Loading the converter...

Shopify import errors it finds

Also checked

  • Status must be active, draft or archived; Published on online store must be true or false.
  • More than three options, more than 2,048 variants, more than 250 images or more than 250 tags on one product.
  • SEO title over 70 characters, SEO description over 320, image alt text over 512.
  • Prices with currency symbols or commas, and weights that are not plain grams.
  • Packed dimensions filled in only partly, and Barcode and Barcodes columns in the same file.
  • Repeated SKUs (Shopify allows them, but they make stock harder to manage).

Not checked

  • Whether each image link actually downloads (only that it is a full public link).
  • Product category names against Shopify's category list ("Not a valid product category").
  • Image size limits ("exceeds the 20 megapixel limit").
  • Metafield references and the daily variant creation limit.

Questions

What does the checker look at?
The header row, file size and encoding, and every row: URL handles, titles, status, options and variants, prices, stock, weights, true or false fields, image links, tags, SEO fields and more. Each problem is tied to the rule Shopify documents.
If the check passes, will the import work?
It removes the errors that can be seen in the file. Shopify can still reject things the file cannot show: images that fail to download, product categories that do not match Shopify's list, or the daily variant limit on very large stores. Import a few products first.
Is my file uploaded anywhere?
No. The page reads the file with your browser and converts it there. The only thing the site records is an anonymous count: which converter was used, a rough row count, and whether it worked. The privacy page lists every field.

Sources

Moving from another platform? Convert your product export to Shopify first; every converted file is checked automatically.