Does a fridge inventory spreadsheet work?
A fridge inventory spreadsheet works for exactly as long as someone keeps typing into it, which in most households is one shop, sometimes two. The sheet itself is fine. The columns it needs are not complicated. What kills it is the entry cost: a weekly shop is a trolley of items, each typed by hand on the night it comes home, by the one person who did the shopping, and the first week that does not happen the sheet is wrong from then on. Pantry fills the same columns from one photograph of the receipt. That is the whole difference, and the rest of this post is the detail.
The template, if you want one anyway
Five columns, and no more, because a sixth is the one that stops getting filled in.
| Column | What goes in it |
|---|---|
| Item | What it is, in the words the house uses |
| Bought | The date it came home |
| Keeps for | The window, from the shelf-life reference, taken at the short end |
| Where | Fridge, pantry or freezer |
| Whose | Who bought it, in a shared house |
That is the same shape as Pantry’s list, because it is the right shape. The problem was never the design of the sheet.
Where the sheet stops
Four things end a fridge spreadsheet, usually in this order.
- Entry. The example receipt on this site runs to 18 items. Typed by hand, with a date and a window looked up for each, that is a chore on the one night of the week nobody wants one, and it falls to whoever shopped. Skip it once and every later row is suspect.
- Exit. Nothing takes an item off. The milk gets finished and the row stays. Within a fortnight the sheet describes a fridge that no longer exists.
- Ownership. The sheet lives on one laptop. The flatmate at the shop on Thursday cannot see it, so the second bottle of milk gets bought anyway, and the sheet did not even record it.
- Silence. A spreadsheet never speaks. The mince turning tomorrow is a cell that nobody opens at 5:30pm.
What the receipt changes
One photograph replaces the entry column, the date column and the window column at once. Pantry reads the store, the date and every line on the docket, attaches a window to each item from the same data as the reference table, and shows you the list to confirm. Receipts are messy and some lines come back wrong. Fixing one takes two taps, and Pantry remembers the correction for next time. How it reads a faded Woolies slip is its own post. The point here is narrower: the sheet gets filled in on shopping day, in the car park, without anyone typing.
What a shared list changes
The exit and ownership problems go together, and so does their fix. Pantry’s household puts the list on every phone in the house, and members mark things as they go: the milk marked as opened, the baby spinach used, the mince moved to the freezer. A row disappears when the food does, from everyone’s view at once, and the person at the shop sees the fridge as it is right now, not as it was the last time someone updated a sheet.
What a nudge changes
The silence problem is the one no spreadsheet can solve, however well kept. Pantry’s morning digest reads the list to the household at 7:30am: what is turning this week and what it is worth. On Pro, the 5:30pm nudge names the item nearest the edge and a dinner for it. The sheet was the right idea with the wrong entry cost and no voice. When Pantry ships, that is what it is: the spreadsheet, filled by the receipt, read by the house, and speaking at the one moment a kitchen decision is still possible.