Guide

How to Find and Fill Country of Origin in a Shopify CSV Export

Step-by-step guide to locating the country of origin field in a Shopify CSV export, filling it with verified production data, and re-importing the updated catalog.

Answer Summary

Preparation checklist

Country of origin tells customs authorities where goods were manufactured or substantially transformed.

A Shopify CSV export may have a country of origin column that needs filling before international shipping workflows.

Fill each SKU with the actual production country; do not use the warehouse or ship-from country.

Required fields or decision table

Fields to prepare before the document draft

Field or decisionWhat to prepare
Country of origin vs ship-from country

Country of origin is where the product was made. Ship-from country is the warehouse that ships the parcel. These are not the same and both may appear in a CSV.

Where COO field appears in Shopify CSV

Country of origin may appear as "Country of Origin," "COO," "Country," "Made In," or similar. Confirm the column header against the Shopify version and market settings before filling.

How to find the COO column

Open the exported CSV in a spreadsheet editor. Search for column names containing "origin," "country," "COO," "made in," or "country/region of origin." Add a new column if none exists.

How to fill the COO column

Use the bulk editor to fill country of origin per product or variant, or export, fill the column, and re-import. Enter the actual production country as a two-letter ISO country code or full country name.

Variants and shared origin

If all variants of a product share the same country of origin, enter the same value for every variant row. If variants come from different production locations, enter the correct origin per variant.

Step-by-step preparation

How to prepare the draft

  1. Export the product CSV from Shopify: Products → Export → choose All products or Selected, and UTF-8 CSV format.
  2. Open the CSV in a spreadsheet editor and locate or add the country of origin column.
  3. Enter the verified production country for each SKU. Do not enter the warehouse country, supplier address, or Shopify store location.
  4. Use the bulk editor to apply country of origin to multiple products at once when the same origin applies across a group.
  5. Cross-check the entered origin against supplier invoices, purchase orders, or production records.
  6. Save the updated CSV and re-import into Shopify: Products → Import → select the updated file.
  7. Verify the re-imported values in Shopify before creating international labels or invoices.
Ecommerce example

How this looks in a seller workflow

A Shopify seller has 500 SKUs across apparel, accessories, and drinkware, all shipped from a Yiwu warehouse in China. The CSV export has no country of origin column. The seller adds a "Country of Origin" column, enters "CN" for every SKU (all products are manufactured in China), and re-imports. This satisfies the origin field for customs workflows without conflating the Yiwu warehouse address with production origin.

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

  • Entering the warehouse country or ship-from country instead of the country where the product was manufactured.
  • Leaving the parent product filled but leaving all variants blank.
  • Using a regional label such as "Asia" or "Greater China" instead of the specific country.
  • Treating all variants as having the same origin when some variants come from a different production country.
  • Filling country of origin from the supplier name or address rather than from production records.
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.

Maintainer

Reviewed by Ryan Cole

Ryan Cole maintains TariffCatalog from the perspective of a long-time ecommerce operator with 15+ years of experience in product catalog, international shipping, and pre-shipment data workflows. This page is reviewed for document preparation workflow clarity, source-check clarity, and estimate-only or candidate-only wording.

TariffCatalog is a preparation aid, not a customs broker, legal, tax, or freight-forwarding service. Verify final classifications, rates, documents, and filing treatment with official sources or qualified professionals.

Official source note

References to verify

Use official sources, carrier guidance, postal operator rules, and destination requirements to verify before filing or shipping.

FAQ

Common questions

What is country of origin in a Shopify CSV?

Country of origin in a Shopify CSV is the country where the product was manufactured or substantially transformed. It is used by customs authorities to determine duty rates, additional tariffs, and trade agreement eligibility. It is not the same as the warehouse, store, or ship-from country.

Where do I find the country of origin column in Shopify export?

Country of origin may appear under column headers such as "Country of Origin," "COO," "Country," "Made In," or "Country/Region of Origin" depending on Shopify version and market settings. Open the exported CSV, scan the column headers, and add a new column labeled with the exact name Shopify expects if none exists.

Can I fill country of origin using the Shopify bulk editor?

Yes. In Shopify admin, select multiple products using the checkboxes, click Edit languages, and add country of origin information to the selected products. As another option, export, fill the CSV column, and re-import. The bulk editor is faster for large groups sharing the same origin.

Should every product variant have its own country of origin?

Yes, when variants are manufactured in different countries. If variant A comes from China and variant B comes from Vietnam, enter "CN" for variant A and "VN" for variant B. Leaving variants blank causes customs mismatches when different-origin products share a product page.

What if my supplier is in one country but the product is assembled in another?

Use the actual country of last substantial transformation. If a product is manufactured in China but assembled or packaged in Vietnam, the country of origin depends on the applicable rules of origin in the destination tariff. Consult the origin rules for the destination country or ask a licensed professional when origin is ambiguous.

Do I need to fill country of origin for every SKU?

Yes, for international shipments. Every SKU that moves across a customs border should have a country of origin field. Even if a marketplace does not require it for listing, the commercial invoice and customs declaration will need it. Filling it now prevents customs delays and invoice rejections later.

Last reviewed: July 2026

Disclaimer

TariffCatalog provides informational tools and preparation workflows only. Verify final classification, rates, document requirements, and filing treatment with official sources or licensed professionals.