Editing customs data with a CSV file

For many products at once, export your customs data, edit it in a spreadsheet, and import it again.

Export

On the Products page, click Export CSV. The file has one row per variant:

Column	Meaning	Imported
variant_id	Shopify's variant ID	Used to find the variant
sku	The variant's SKU	Used to find the variant when variant_id is empty
product, variant	Names, for reference	No
hs_code	HS code, 6 to 10 digits	Yes
hs_code_us	The 10-digit US code, printed on documents to the US	Yes
country_of_origin	Two-letter country code, such as NL, CN or GB	Yes
customs_description	What customs reads, up to 255 characters	Yes
preferential_origin	yes, or no for products that don't meet the rules of origin. See Statements of origin	Yes
weight_g, status	For reference	No

Edit

• Change only hs_code, hs_code_us, country_of_origin, customs_description and preferential_origin. Other columns are ignored.
• An empty cell keeps the current value. To change a value, type the new one.
• HS codes can be written with dots or spaces, like 6912.00; they're saved as digits.
• Save the file as CSV in UTF-8, so accented letters survive.

Import

1. Open Products, then Import CSV.
2. Choose the file and click Preview changes. Nothing is saved yet.
3. Check the table of changes, and the rows with problems, which are skipped.
4. Click Apply changes. The values are written to Shopify.

Common problems

• "SKU … not found, or used by more than one variant." Rows without variant_id are matched by SKU, which must be unique. Keep variant_id from the export.
• "… is not a two-letter country code." Use ISO codes, like DE for Germany, not names.
• "HS code … should have 6 to 10 digits." Remove letters and extra characters.
• "This variant appears more than once in the file." Keep one row per variant.