Materials/PT Colours/Import via CSV
Find order/31314:32 · UTC+8
Import PT colours
CSV · the PT_MASTER sheet shape · one row per colourBack to PT ColoursExport sheet
1 · Upload2 · Preview3 · Imported
File
you preview every change before anything is writtenpt_colors_2026_10_19.csvmax 10 MB · start from Export so the columns match
Bindings absent from the sheet are soft-retired (never deleted). An unknown pt_code creates the colour. A * after a code makes it that colour's primary for the component (at most one * per colour × component).
Columns in your current export
16 · derived live from Component Classespt_codenamestatusplain_lining_hgplain_lining_hg_compositionplain_lining_hg_weight_gsmplain_lining_ycplain_lining_yc_compositionplain_lining_yc_weight_gsmplain_lining_jsyplain_lining_jsy_compositionplain_lining_jsy_weight_gsmshirt_monogram_qfkeyhole_rkjacket_monogram_rmbhand_finish_z
Import preview — 63 rows
previewImport · nothing writtenNew bindings4
Changed rows3
Retired1
Colours created1
Unchanged59
Errors0
This import will soft-retire 1 binding no longer in the sheet: PT024 · Plain Lining · JSY402. Preserved, never deleted, restorable.
PT015 · Mahogany
| Component | Vendor code | Code | Primary | |
|---|---|---|---|---|
| Plain Lining | SHONG | new | HG115 | |
| Keyhole | FRR | changed | ★ |
PT063 new colour
| name | Bottle |
| status | live |
Confirm stays off until the retirement is acknowledgedCancelConfirm import