Home › Guides › CSV column template
CSV columns for EU product identifiers
Short answer: Keep one row per variant with: SKU (merchant code), product, variant, manufacturer code, barcode, barcode status (present / confirmed_none), source note. Download the CSV template.
| Column | Customs field | Example | Notes |
|---|---|---|---|
| Variant SKU | C127 merchant code | TW-BGVL3-10 | Unique per variant |
| Product | — | Boxing gloves | For humans |
| Variant | — | 10 oz / Black | For humans |
| Manufacturer code | C128 NS-PID | BGVL3-10-BLK | Exactly as the maker writes it |
| Barcode | C129 S-PID | 8858812345671 | GTIN 8/12/13/14 digits |
| Barcode status | Y081 basis | present / confirmed_none / unknown | confirmed_none only after supplier confirmation |
| Source | — | Supplier sheet 2026-09-15 | Where the codes came from |
How to use it
- Export products from Shopify; copy SKU, product and variant into the template.
- Send the template to each supplier with the manufacturer-code and barcode columns empty (email text).
- Paste answers back, set the status column, note the source.
- Load the file in the checker and map the columns; or keep it beside your Shopify export.
Questions
Can I send this file to my carrier?
Ask them. Most express carriers take the values per line item on the commercial invoice or in their shipping tool; the template is the source you copy from.
Why a status column?
A blank barcode is ambiguous. 'confirmed_none' records that the maker confirmed there is no barcode, which is what Y081 requires.