Guide

How to find every product missing an HS code in Shopify

Here's the frustrating truth this question always leads to: Shopify has no report, filter, or export that shows you which products are missing HS codes. The field lives on each variant's inventory item, inside the collapsed "Customs information" subsection of the product page, and the standard product CSV export doesn't include a column for it. So "find the gaps" — the obvious first step of any customs cleanup — has no native answer. Here are the three real methods, from free-and-slow to fast.

Method 1: The admin walk-through (free, fine under ~50 SKUs)

Open each product, scroll to the variant, expand Customs information, check the HS code field. Multiply by your catalog size. At 30 products this is an honest afternoon; at 300 it's a week of clicking, and you'll miss variants — multi-variant products hide the field per variant, not per product.

Method 2: The inventory CSV round-trip (free, fiddly, catches most)

Shopify's inventory CSV export (not the product CSV) includes an HS code column for some configurations. Export it, open in a spreadsheet, filter the HS code column for blanks, and you have a gap list — for that field. Limitations: you're checking one field at a time (country of origin and weight need their own passes), malformed codes (five digits, stray letters — the ones behind Shopify's "harmonized code is invalid" error) pass a blank-check because they're not blank, and the fix still happens back in the admin, row by row in the bulk editor.

Method 3: Scan the catalog (two minutes, every field, catches malformed)

This is the audit tool Shopify never built, and it's Origova's whole first tab: connect the app, run the free scan, and every variant missing an HS code, country of origin, or weight — plus every malformed code that would fail at the border — appears in one list with a catalog-readiness percentage. From there you can fix in bulk (grouped, reversible, written straight back to Shopify) and the scan re-checks automatically as your catalog changes. The scan is free at any catalog size — the finding part costs nothing, however you choose to fix.

Which method for which store

Catalog size	Realistic pick	Time to a complete gap list
Under ~50 variants	Admin walk-through	An afternoon
50–300 variants	Inventory CSV filter	An hour, per field, if the export cooperates
300+ variants, or you also need origin/weight/format checks	Scan	~2 minutes

Frequently asked questions

Does Shopify show which products are missing HS codes?

No. There's no native report or filter for it. HS codes live on each variant's inventory item in a collapsed subsection, and the standard product CSV export has no HS code column — which is why finding the gaps is the hard part of every customs cleanup.

Can I export HS codes from Shopify to find blanks?

The inventory CSV export includes an HS code column in some configurations — export, filter for blanks, and you have a partial gap list. It won't catch malformed codes and covers one field at a time; country of origin and weight need separate passes.

What counts as a malformed HS code?

Anything under six digits, or containing letters or stray characters — these trigger Shopify's 'Harmonized code is invalid' error and get parcels flagged at customs even though the field isn't technically empty. Blank-checking a spreadsheet misses them; format validation catches them.

Is Origova's scan really free?

Yes — scanning your entire catalog and seeing every gap is free at any size, with 30 fixes included. Paid plans ($7.99 or $14.99/month) raise the fix limit. The audit itself never costs anything.

The gap list is the free part.

Scan your whole catalog in about two minutes — see every missing and malformed field before you fix anything.

Install on Shopify