Vendor price list template
One row is one product a supplier sells us, at a price. Suppliers, distributors, and wholesalers, usually as a spreadsheet attached to an email, and usually reformatted since the last one.
| Field | Type | Rules | Note |
|---|---|---|---|
| SKU | text | RequiredUnique | The supplier's product code. Rows join on this. |
| Product name | text | Required | |
| Unit price | number | Required | Price for one unit, excluding tax. |
| Currency | enumUSD · EUR · GBP · CAD · AUD | Required | |
| Minimum order quantity | number | Optional | |
| Lead time (days) | number | Optional | |
| Effective from | date | Optional | The date this price starts applying. |
| Discontinued | boolean | Optional |
What this sheet refuses to accept
A price written as “£1,240.00”, “1.240,00” or “1,240” arrives as the number 1240 either way, and a price cell reading “call for quote” is rejected rather than silently becoming zero.
The same SKU twice in one file is caught by the unique rule, so a supplier who appended rather than replaced does not double your catalogue.
A currency outside the list you accept is refused at the door instead of turning up in a total three months later.