Vendor price list template
One item 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. Items 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 collection 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 value 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.
Other collections people start from
Sales pipelineOne item is one company you are selling to.CompanytextContact emailemailStageone ofSeatsnumberand 4 morePrice watchOne item is one product page you are watching.Product URLurlProducttextRetailertextPricenumberand 3 moreLoad listOne item is one load: where it picks up, where it delivers, and what it pays.Load numbertextPickup citytextPickup statetextPickup datedateand 8 more