Purchase order import
What the import expects from your ERP export. One row per style, colour and size; one draft product per style.
Overview
Export the purchase order from your ERP as a spreadsheet and upload it on the Import page. Accepted files: CSV, TSV, TXT, XLSX and XLS (first sheet only). The header row may sit below a title or blank rows, blank lines and totals footers are ignored, and up to 500 styles fit in one file. For the click-by-click version, see import a purchase order in the help centre.
Each row is one stock keeping unit: a style, in one colour, in one size, with its quantity. Rows that share a style number become one product; rows that share a PO number become one purchase order. The column names below are recognised automatically, and any column can be re-mapped in the wizard before importing.
Columns
Required columns are marked. A column is matched by any of its accepted header names (case, spaces and punctuation are ignored, so Order No_ and Order No. are the same).
| Column | Required | Example | Notes |
|---|---|---|---|
| Style number | Yes | SR226-602 | Groups rows into one product; every size and colour of a style shares it. |
| Style name | Yes | Wool Jacket | Consumer-facing product name on the passport. |
| PO number | Yes | PO2001 | One style belongs to one PO number per file. |
| Supplier | No | Mill Co | A name or your ERP vendor code; codes are remembered once you rename them. |
| Color | No | Navy | Free text, kept exactly as written (a code plus name is fine). |
| Size | Yes | M | One row per size; letters, numbers or 1SZ. |
| Quantity | Yes | 240 | Whole units ordered for this size and colour. |
| Barcode / EAN | No | 5712952970021 | EAN or GTIN, 8 to 14 digits; needed to publish a passport per size. |
| HS code | No | 6203.42.31 | Customs tariff code; dots and spaces are removed. |
| Country of origin | No | Portugal | Country name or ISO code (PT); codes are expanded to names. |
| ETD | No | 2026-10-01 | Ship date; ISO or day-first (01-10-2026) formats. |
| ETA | No | 2026-11-15 | Arrival date; drives certificate deadline warnings. |
| Season | No | SS27 | Season or drop code. A known style number carries its earlier data into the new order. |
| Market | No | FR | Country where the pieces are sold (ISO code or name). Per-row markets sum into the order's EPR market split. |
| Quality / composition | Yes | 60% Cotton - Organic 38% Cotton 2% Elastane | Percentages with fibre names or ISO fibre codes (CO60%PES40%). |
| Image URL | No | https://cdn.example.com/sr226-602-navy-1.jpg https://cdn.example.com/sr226-602-navy-2.jpg | Public image links; several per cell separated by spaces or commas. |
Composition
Two spellings are read. Percentage first with fibre names: 60% Cotton - Organic 38% Cotton 2% Elastane. Or ISO fibre codes glued to percentages, as most ERPs export them: CO 60% CO38% EL2%. Decimal commas (60,5%) and separators between fibres are fine. Each component must sum to 100.
A garment with several components (a shell and a lining) is written as the components one after another: CO 100% PES 100%. The first component seeds the product; the rest are shown in the editor for you to place as layers.
A brand in brackets after an approved fibre name is fine: 95% Modal (TENCEL™) 5% Elastane reads as TENCEL™ Modal, and Cotton (Supima®) as cotton. Fibres outside the approved list are imported under their real name and flagged in the editor, never dropped. Codes the import knows:
| Code | Fibre | Approved |
|---|---|---|
AB | Abaca | Yes |
AC | Acetate | Yes |
AL | Alfa | Yes |
ALG | Alginate | Yes |
AR | Aramid | Yes |
CC | Coir | Yes |
CLF | Chlorofibre | Yes |
CLY | Lyocell | Yes |
CMD | Modal | Yes |
CO | Cotton | Yes |
CTA | Triacetate | Yes |
CUP | Cupro | Yes |
CV | Viscose | Yes |
EA | Elastane | Yes |
ED | Elastodiene | Yes |
EL | Elastane | Yes |
EME | Elastomultiester | Yes |
EOL | Elastolefin | Yes |
GF | Glass Fibre | Yes |
GI | Broom | Yes |
HA | True Hemp | Yes |
HE | Henequen | Yes |
JU | Jute | Yes |
KP | Kapok | Yes |
LI | Linen | Yes |
MAC | Modacrylic | Yes |
ME | Metal Fibre | Flagged |
PA | Nylon | Yes |
PAN | Acrylic | Yes |
PE | Polyethylene | Yes |
PES | Polyester | Yes |
PI | Polyimide | Yes |
PL | Polyester | Yes |
PLA | Polylactide | Yes |
PP | Polypropylene | Yes |
PU | Polyurethane | Yes |
PUR | Polyurethane | Yes |
RA | Ramie | Yes |
SE | Silk | Yes |
SI | Sisal | Yes |
SN | Sunn | Yes |
TV | Trivinyl | Yes |
VI | Viscose | Yes |
WA | Angora | Yes |
WK | Camel | Yes |
WL | Llama | Yes |
WM | Mohair | Yes |
WO | Wool | Yes |
WP | Alpaca | Yes |
WS | Cashmere | Yes |
WY | Yak | Yes |
Dates and countries
ETD and ETA accept ISO dates (2026-11-15), day-first dates with dashes or dots (15-11-2026, 1.6.2026) and slashes when the day is unambiguous. Both are stored as ISO dates. Two-digit years are not read.
Country of origin takes a country name or an ISO code (PT, CN); codes are expanded to names on import.
Barcodes and quantities
Barcodes are EAN or GTIN numbers of 8 to 14 digits; spaces and thousands separators are removed, and Excel number formatting is undone. A barcode per size is what lets a passport be published per size. Quantities are whole units; a decimal quantity is reported as a row error rather than rounded.
Images
An image cell holds one or more public https links separated by spaces, commas, semicolons or pipes. Links on rows of the same colour are combined, and the images are fetched and stored by Seamdex (public hosts only, up to 8 MB each). A large import keeps loading its images in the background after the drafts are created.
Suppliers and purchase orders
The supplier column may carry a name or your ERP vendor code. Once you edit a purchase order's supplier in Seamdex, that vendor code is remembered for your organization and the name is applied on the next import.
Supplier records themselves (capabilities, certificates, materials and partner access) are imported from their own file: see the supplier import guide.
One style belongs to one PO number within a file; a style listed under two PO numbers is refused before anything is written. Files with one purchase order per style import as such.
Prices and extra columns
Price columns (headers starting with RRP, Retail price, MSRP, or Price followed by a currency code) are read per style: a header that names a currency, such as RRP (EUR), becomes that style's retail price and prints on its price tags; one without a currency is kept on the purchase order for reference. Prices are never shown on a passport. Any other column, such as brand, is left unmapped and ignored; the wizard lists them so nothing is dropped silently.
Checks before importing
After the file is read, the wizard shows what will happen: how many compositions parsed, unrecognised fibre codes, dates it could not read, country codes it will expand, barcode problems, and vendor codes it remembers. Rows with problems are listed with their spreadsheet line number, and the import is refused until they are fixed.
Importing through the API
The same rows can be sent as JSON from your systems. See the API documentation for the endpoint, its limits and the publish requirements.