Inventory stock count collection template
One item is one SKU counted in one place on one day. Warehouse and shop staff, often as a photographed tally sheet rather than a file.
| Field | Type | Rules | Note |
|---|---|---|---|
| SKU | text | RequiredUnique | |
| Location | text | Required | |
| Counted quantity | number | Required | |
| Counted on | date | Required | |
| Counted by | Optional | ||
| Condition | enumNew · Open box · Damaged · Expired | Optional | |
| Notes | text | Optional |
What this collection refuses to accept
A count value holding “~40” or “40ish” is refused rather than entering stock as a guess.
A count date in the future is a date the collection accepts but you can see, because the whole column is one type rather than free text.
A condition outside the list cannot be invented at the point of counting.
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 moreVendor price listOne item is one product a supplier sells us, at a price.SKUtextProduct nametextUnit pricenumberCurrencyone ofand 4 more