Is there an efficient way to update / upload HS Codes and Country of Origin? I would like to do a big edit using a CSV import using the Inventory CSV, but that is not updating the HS Codes or COO. And there isn’t a section on the product CSV import for HS Codes and COO.
A bulk edit is not as efficient for syncing with an ERP or WMS so ideally this would be possible using a csv update. Could anyone elaborate on this please?
Thank you,
Kyle
Hello @kyle-LESTIEN ,
Are you using any 3rd party shipping carrier service in your Shopify store?
May I know your country of origin?
If you are using FedEx as your shipping carrier, I would suggest the Ship, Rate, and Track for FedEx app.
Where the app lets you import and export the product CSV file to download the details of the products in the inventory.
With the app, you can update HS code and while adding different locations(if you are having multiple warehouses) or a single location you can set the original location as a default.
You can update the HS code and COO within the app by editing the custom option of each product by adding the required credentials.
You can also generate all other documents like Commercial invoices, tax invoices, packing slips, etc. under the Advanced tab by choosing download documents for each order while creating a shipping label.
I saw a post that these guys can help. They provide a hs code finder/lookup tool.
This thread is from 2021 but still relevant, so posting an update for anyone finding it now.
Shopify has since added a dedicated CSV specifically for HS codes and Country of Origin. It’s separate from both the product CSV and the inventory CSV, which is why you couldn’t find those fields before.
Here’s the current workflow:
Go to Settings → Taxes and duties → Duties and import taxes → click Manage
In the Product information section, click “Update with CSV” → Export
You’ll get a CSV with these columns: Product Handle, Product title, Variant SKU, Option1 Name, Option1 Value, Country of origin, HS code
Fill in the HS code and Country of origin columns in a spreadsheet
Import the same CSV back through the same screen
For Country of Origin, use ISO 3166-1 alpha-2 codes (CN for China, US for United States, DE for Germany, etc.).
One thing to watch: HS codes are at the variant level, not the product level. So if a product has 5 size variants, each row needs the code. For most products all variants share the same HS code, but if material differs by variant (cotton vs polyester), the code actually changes.
For anyone syncing with an ERP/WMS, this CSV format is straightforward to generate programmatically. You can also do it via the Shopify Admin API using the inventoryItem resource if you need full automation.