# How to Find Products Missing HS Codes in Shopify — Origova

> Shopify has no report for missing HS codes. Three real methods: the admin walk-through, the inventory CSV filter trick, and the two-minute full-catalog scan.

Canonical: https://origova.com/find-products-missing-hs-codes-shopify

---

# How to find every product missing an HS code in Shopify

_By [Spencer Flaherty](https://origova.com/about), founder of Origova_

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](https://origova.com/harmonized-code-is-invalid)) 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](https://origova.com/bulk-edit-hs-codes-shopify).

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

This is the audit tool Shopify never built, and it's [Origova's](https://origova.com/) 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](https://origova.com/bulk-edit-hs-codes-shopify) (grouped, reversible, written straight back to Shopify) and the scan re-checks automatically [as your catalog changes](https://origova.com/shopify-hs-code-sync). 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.

Primary source for US classifications: the official [Harmonized Tariff Schedule (hts.usitc.gov)](https://hts.usitc.gov). The statute ending de minimis: [19 U.S.C. § 1321 (Cornell Law, LII)](https://www.law.cornell.edu/uscode/text/19/1321).

Related: [Bulk HS codes in Shopify](https://origova.com/bulk-edit-hs-codes-shopify) · ["Harmonized code is invalid"](https://origova.com/harmonized-code-is-invalid) · [Keeping HS codes in sync](https://origova.com/shopify-hs-code-sync)