Import PT colours

CSV · the PT_MASTER sheet shape · one row per colour

Back to PT ColoursExport sheet

1 · Upload2 · Preview3 · Imported

File

you preview every change before anything is written

pt_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 Classes

pt_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 written

New bindings4

Changed rows3

Retired1

Colours created1

Unchanged59

Errors0

I understand this import will soft-retire 1 binding not present in the sheet.

PT015 · Mahogany

Component	Vendor code		Code	Primary
Plain Lining	SHONG	new	HG115
Keyhole	FRR	changed	~~RK108~~ → RK109	★

PT063 new colour

name	Bottle
status	live

Confirm stays off until the retirement is acknowledgedCancelConfirm import

Fix the errors before importing

has_blocking_errors · the sheet cannot be applied as-is · zero writes

Row	Reason
17	Two * on PT015 · Plain Lining — at most one primary per colour × component
64	pt_code PT063 appears twice in this sheet
22	plain_lining_hg_composition “55 poly” is not a blend — skipped, the code change still applies

Blocking errors stop the run; a bad blend / weight is skipped with its reason and never blocks.

CancelConfirm import