XLS sample_purchase_order.csv
A2fx11-6851-00
ABCD EFGH IJ
1 PRODUCT IDpartslinksupplier_partnumberSUPPLIER QUANTITYsublocationlengthwidthheightweight
2 11-6851-00hy2805137TY-6851TYC 24.1 F10.58.24.32.5
3 Ty260er-sto1321415US-260ERUSAUTO (blank → 1)4.1 F15.05.2
4 rh76260007hy1167111US-76260USAUTO 54.1 F20.010.08.012.0
5 rt10820000to1038217US-10820USAUTO (blank → 1)4.1 F
6 ra01490005au1043105US-01490USAUTO 104.1 F5.53.22.10.8
Column A — PRODUCT ID is required on every row Column E — QUANTITY (blank or 0 becomes 1)
Column order must match. WHIMS reads columns by their position (A–J), not by the heading text — keep the ten columns in this order and always keep row 1 as the heading row.