- Export the Shopify catalog as a CSV in UTF-8 format.
- Filter or sort the HS code and country of origin columns for blank cells.
- Identify the top high-volume and high-revenue SKUs among the blank cells.
- For each blank SKU, collect product facts: material, function, construction, origin country, destination market.
- Use the AI HS Code Finder for HS code candidates; verify against the destination tariff database.
- Enter verified production country from supplier or production records for country of origin.
- Write a short classification note for each filled SKU explaining the basis.
- Save the updated CSV and re-import into Shopify.
- Verify the re-imported values in the product editor.
Guide
How to Backfill Missing HS Codes and Country of Origin in a Shopify Catalog
Step-by-step guide to finding products with missing HS codes and country of origin in Shopify, prioritizing high-volume SKUs, and filling the gaps before international shipping.
Answer Summary
Preparation checklist
Missing HS codes and country of origin in a Shopify catalog create customs delays and invoice rejections.
A CSV export is the fastest way to audit an entire catalog for missing fields at once.
Prioritize high-volume and high-revenue SKUs first, then work through the rest systematically.
Use this workflow
Required fields or decision table
Fields to prepare before the document draft
| Field or decision | What to prepare |
|---|---|
| How to identify missing fields in CSV | Export the catalog, sort the HS code and country of origin columns for blank cells, and count how many SKUs are affected. Use conditional formatting or filter tools in the spreadsheet to surface the gaps quickly. |
| Prioritization strategy | Sort by sales volume or revenue to find the top 20% of SKUs that likely drive most customs risk. Fill those first. Then work through medium and low-volume SKUs in order. |
| How to fill missing HS codes | For each blank SKU, collect chief material, function, construction, and destination market. Use the AI HS Code Finder to generate candidates. Verify the full national code in the official tariff database. |
| How to fill missing country of origin | Cross-reference supplier invoices, purchase orders, or production records for each SKU. Enter the verified production country. Do not use the warehouse country or the Shopify store location. |
| Recording classification decisions | Keep a note for each SKU explaining why a particular HS code candidate or country of origin was chosen. This note helps brokers, internal teams, and future audits. |
| Re-import and verify | After filling the gaps, save the updated CSV and re-import into Shopify. Verify the imported values in the product editor before creating international labels or invoices. |
Step-by-step preparation
How to prepare the draft
Ecommerce example
How this looks in a seller workflow
A Shopify seller with 800 SKUs exports the catalog and finds 120 products with no HS code and 95 with no country of origin. The seller sorts by monthly sales and finds that the top 24 SKUs (apparel and accessories from China) make up 60% of international order volume. These 24 SKUs are backfilled first: each gets a verified HS code candidate and country of origin from the supplier invoice. The remaining 96 SKUs are filled in the second pass using a bulk update workflow.
Verification checklist
Review the draft before it travels with the shipment
Before a document draft is used, compare it against the order record, product catalog, carrier label, and any destination-specific instructions. The preparation checklist should confirm parties, shipment channel, item descriptions, value, currency, quantity, weight, origin, HS code candidate, and any package or reference fields.
What is required depends on shipment value, carrier, destination, and product facts, so a field that is optional in one postal or carrier workflow may be required in another. When a draft supports a repeated SKU, save the checked inputs with the product record so future shipments start from reviewed data.
Use the draft as a review artifact: it should make weak descriptions, missing origin, inconsistent values, and unsupported HS code candidates easy to spot before the parcel is handed to a postal operator, carrier, marketplace label flow, or freight team.
Common mistakes
What to avoid
- Filling all blank SKUs at once without prioritizing high-volume products first.
- Using a supplier code as the HS code without verifying it for the destination market.
- Skipping the country of origin verification and using the warehouse country instead.
- Not recording the basis for the HS code or origin choice, making future audits harder.
- Backfilling in alphabetical order instead of by sales volume or customs risk.
- Skipping the destination tariff verification and stopping at the 6-digit international heading.
Editorial
Editorial review note
Written by the TariffCatalog Editorial Team for ecommerce document preparation workflows. The page is designed as a preparation checklist, not a filing outcome.
Maintained by Ryan Cole, with review focused on ecommerce catalog, document, and source-check workflow clarity.
Document requirements may be required differently by carrier, destination, shipment value, and product facts. Use the methodology, sources, and corrections pages to understand how the page is maintained.
Official source note
References to verify
Use official sources, carrier guidance, postal operator rules, and destination requirements to verify before filing or shipping.
USITC HTS
Use this official source when checking final classification, duty treatment, or customs requirements.
CBPUse this official source when checking final classification, duty treatment, or customs requirements.
EU TARICUse this official source when checking final classification, duty treatment, or customs requirements.
UK Trade TariffUse this official source when checking final classification, duty treatment, or customs requirements.
FAQ
Common questions
How do I find products with missing HS codes in Shopify?
Export the Shopify catalog as a CSV, open it in a spreadsheet, and filter or sort the HS code column for blank cells. The same approach works for country of origin. Count the affected SKUs and prioritize by sales volume.
Which products should I backfill first?
Prioritize the top 20% of SKUs by international order volume or revenue first. These typically account for the majority of customs risk. Fill those, then work through the remaining SKUs in order of importance.
How do I fill missing HS codes in Shopify?
Collect chief material, function, construction, and destination market for the SKU. Use the AI HS Code Finder to generate candidates. Verify the full national code in USITC HTS, EU TARIC, UK Trade Tariff, or the destination tariff database. Enter the verified candidate in the CSV.
How do I fill missing country of origin in Shopify?
Cross-reference the supplier invoice, purchase order, or production record for each product. Enter the country where the product was manufactured or substantially transformed. Do not use the supplier address, warehouse, or store country.
Should I record the basis for each HS code I enter?
Yes. Keep a short note for each SKU explaining the material, function, and destination used to pick the HS code candidate, and the source used to verify the country of origin. This note helps brokers, internal reviews, and future catalog audits.
How do I re-import the updated CSV into Shopify?
Save the updated CSV with UTF-8 encoding, then go to Products → Import in Shopify admin, select the file, and confirm the mapping. Verify the imported values in the product editor for a sample of SKUs before creating international labels.
Disclaimer
TariffCatalog provides informational tools and preparation workflows only. Verify final classification, rates, document requirements, and filing treatment with official sources or licensed professionals.