Example scenario · illustrative, not a real seller
Your example spreadsheet says available, but the item is in a return-inspection bag. The row is not the stock truth until the physical status agrees.
What you’ll get
- Connect the item, listing and location.
- Separate returned or untested stock from available stock.
- Use capacity and aging to guide the next buying decision.
Give the physical item a stable identity
A unique stock ID follows the item through purchase, inspection, listing, sale and any return. Its location and status can change; the identity should not. Keep the private record free of unnecessary buyer information.
The small-space guide turns that principle into a practical room layout. You do not need to buy a storage system before establishing reliable retrieval.
Worked example: capacity includes work in progress
Suppose a chosen layout has 18 listed positions, four untested positions and two outgoing positions. That is 24 total positions, not 24 additional places for listed stock. Filling the untested area also consumes room and review time.
These counts are a hypothetical layout, not a safe shelf-load rating. Do not compromise access routes or mix unsuitable materials to meet a numerical target.
Let status changes trigger a review
A sale commits stock; a return requires inspection; a stale listing needs a fresh decision. Update the physical location and digital record together. If they disagree, resolve the item before offering it again.
The useful inventory count is the stock you can find and accurately describe. A growing spreadsheet cannot compensate for an unmanageable pile.
Worked example · hypothetical, not a real seller
Keep the example in view
| Chosen shelf capacity | Positions |
|---|---|
| Listed and located | 18 |
| Untested, separate positions | 4 |
| Reserved outgoing positions | 2 |
| Total chosen capacity | 24 |
Before the next transaction
With JavaScript and browser storage, only checked-step IDs can stay on this device. No buyer details or amounts are saved.
Practical questions
Should a returned item immediately become available again?
Not without inspection and resolution of its actual condition. Match the item, document the return privately and update the offer only when accurate.
Do inventory records replace tax records?
No. They can connect to purchase and sale evidence, but tax treatment and substantiation are separate questions. Use the tax-records workbench for those details.
Do this next · one concrete move