Get Excelify now
Get Excelify now

Update Shopify Product HS Code and Country of Origin in bulk

Import Shopify HS Codes in bulk|||||4.2 - Update Shopify Product HS Codes|5 - import excel file with HS codes into Shopify|6 - Imported Shopfify HS Code|3 - Shopify exported HS Product Code

With Excelify you can now easily update HS Code and Country of Origin for your Shopify Product Variants.

Export

1. Set up export

First head into the Excelify app and in the Export section select Products and Customs Information checkboxes.

If needed you can also apply filters to export only the items you wish and press the “Export” button to start the export.1 Export Shopify products with HS Codes

2. Exported file

Once the export is finished you can press the button “Download Exported File” to download the file.2 - Download Excel exported Shopify file

In the file, you will have basic Product columns and basic Variant columns.

You can find HS Code in the column “Variant HS Code” and country of origin in the “Variant Country of Origin”.3 - Shopify exported HS Product Code

Import

3. Construct the file

You can use the Exported Products file or Construct a new file to upload HS Code and Country of Origin.

We will only need the following columns:

  • ID or Handle – you need to have at least one of these columns to identify the Product
  • Variant ID, Variant SKU or Variant Barcode – you need to have at least one of these columns to identify the Variant
  • Variant HS Code
  • Variant Country of Origin

If you are using exported file then you can delete other columns and keep just those:4 - Update Shopify Product HS Codes

4. Update the information

Now you can update your HS Code and Country of Origin for your Products in this file:4.2 - Update Shopify Product HS Codes

5. Save and Import

Now you can save the file. Go back to the Excelify app and import the file in the Import section. The app will analyze the file and count how many Products you are importing.

Press the Import button to start the import.

If you see any Failed items, then after the import has finished, you can download the Import Results file and look into the “Import Comment” column. It will tell why particular Products has failed. Then you can fix that issue and re-import just those failed and fixed rows again.5 - import excel file with HS codes into Shopify

See the imported data in Shopify Admin:6 - Imported Shopfify HS Code

What to do next?