How to Bulk Update Country of Origin in Shopify

Need to bulk update Shopify country of origin per variant so customs forms, duty calculators, and tax reports all show the right manufacturing source? With EditEngine Bulk Product Editor, you export every variant to a spreadsheet, type the ISO country code on each row, and import the file back. Because each variant can ship from a different factory, per-variant editing is the only honest way to keep customs data accurate at scale.

What you'll learn

Export every variant with its current country of origin
Edit country of origin per row in a spreadsheet
Import the updated file back to Shopify

What you'll need

The EditEngine Bulk Product Editor app installed in your Shopify store
Products with multiple variants that ship internationally and need per-variant customs data
The list of ISO 3166-1 alpha-2 country codes you plan to assign (US, CN, VN, IT, and so on)
The Advanced import flow — per-variant customs fields write through the advanced importer
A spreadsheet editor (Excel, Google Sheets, Numbers — anything that opens CSV)

Country of origin is the two-letter ISO code that tells Shopify — and downstream customs systems — where a variant was manufactured. It feeds duty estimates, harmonized system reports, and the commercial invoice on every international shipment. The value lives on the variant, not the product, because the same hoodie can be sewn in Vietnam in one color and Portugal in another.

Step 1 — Export your Shopify country of origin

Open EditEngine and go to the Export page. This is where you pick the columns that will land in your spreadsheet.

EditEngine export page showing the column selector for bulk update Shopify country of origin per variant

Pick the right columns

Handle — the product-level identifier the importer uses to find the right product for each row.
Variant SKU — the variant-level matching key. Combined with Handle, it pins each row to one specific variant so the country code lands on the right one.
Variant Country of Origin — the column you'll edit. Expand the Variants group and tick Variant SKU and Variant Country of Origin so both ride along with Handle.

When the export finishes, click Download. You get one row per variant: a product with five sizes and three colors exports as fifteen rows, and the Handle repeats across every variant of the same product — that's how the importer ties them back together.

New to exporting? This guide assumes you know how to run an export and focuses only on the columns and edit unique to this workflow.

Step 2 — Bulk update Shopify country of origin per variant in your spreadsheet

Open the downloaded CSV in Excel or Google Sheets. The Variant Country of Origin column holds whatever code each variant has today — often blank for stores that never set it.

Exported spreadsheet with one row per variant and the Variant Country of Origin column highlighted

Type the correct ISO 3166-1 alpha-2 country code in Variant Country of Origin for every variant row. Codes are exactly two letters, uppercase: US for the United States, CN for China, VN for Vietnam, IT for Italy, DE for Germany. Sort or filter by SKU prefix to group variants from the same factory together — you can then paste the same code down a whole block at once.

✅ VN
❌ Vietnam, Made in Vietnam, vn, or VNM

Leave every other column exactly as exported. Do not edit Handle or Variant SKU — together they are the matching key, so changing either points the row at a different variant or at nothing at all. If a variant is truly drop-shipped from an unknown source, leave the cell blank rather than guessing; a wrong code on a customs form is worse than a missing one.

Edited spreadsheet with correct ISO country codes in the Variant Country of Origin column

Save the file as CSV when you're done, and keep the original export handy in case you want to revert.

Tip: Country of origin lives on the variant, not the product — even if every variant of a product ships from the same country, you still write the same code on every row. There is no product-level shortcut.

Step 3 — Import the edited file back to Shopify

Open EditEngine → Import and select Advanced import. Then upload the file you just edited.

EditEngine reads the file and shows a summary. Check the Headers panel: Variant SKU and Variant Country of Origin should both carry the VARIANT badge, which confirms the importer recognized them as per-variant fields. Leave Match Products By on Auto-detect and Default Command on Merge so existing data is preserved on columns you didn't include.

Note: This advanced import does not have a dry-run toggle. Country of origin is overwriting data that customs systems consume, so the safe path is a two-row test: import a copy of the file containing just two variants first, open those variants in the Shopify admin to confirm the codes wrote correctly, then run the full file. That catches a typo like Vietnam instead of VN before it lands on the whole catalog.

Click Start Import and wait for the job to finish — a small file takes seconds, larger catalogs a couple of minutes. When it completes, EditEngine shows a per-row summary.

Download the results CSV. It lists every row with a pass/fail status — that file is your proof the change went through, and the new values are now live in your Shopify admin.

Tips and troubleshooting

Use ISO 3166-1 alpha-2 codes, not full country names. Shopify's customs fields only accept the two-letter ISO code — US, CN, VN, IT, DE. Typing United States, Made in USA, or even the three-letter USA makes the row fail validation, and the importer will skip it. Keep an ISO code chart open in another tab while you edit; it saves a round of fixes the first time you do this.

Group variants by manufacturing source before you start typing. Sort the spreadsheet by SKU prefix, factory column, or supplier name so all variants from the same country sit together. You can then select a whole block of cells and paste one code down them instead of typing the same CN two hundred times. Mistakes drop sharply once the data is sorted.

Test a two-row batch before importing the full catalog. Country of origin feeds customs declarations, duty estimates, and tax reports — a wrong code on a thousand variants can show up as wrong duties charged to shoppers. Save a copy of the file with two rows, import that first, spot-check both variants in the Shopify admin, and only then run the full file. The five minutes of caution catches header-mapping mistakes and typos before they hit production.

About EditEngine: EditEngine Bulk Product Editor helps Shopify merchants bulk edit, import, and export their product catalog. Install on Shopify →