Write-offs should be recorded instead of leaving dead items sitting as apparently valuable stock. Treat every physical item as one unit with one identity. The record should tell you what it cost, where it is and whether it is live, sold, returned or written off.
What matters most
The easiest way to think about handling lost, damaged and unsellable stock is to keep it simple. Use the facts you know, keep the important details together and learn from what actually sells.
- Use reason codes for damage or loss
- Keep evidence where appropriate
- Remove written-off items from active stock
- Review patterns by supplier
A practical workflow
- Start with the item or decision. Record the facts you know before changing price, listing details or stock status.
- Check the money. Use purchase cost, expected or actual sale price, fees, postage and packaging so the outcome is based on profit after costs.
- Make one clear change. Change the factor most likely to matter instead of editing everything at once.
- Track the result. Save what happened so future sourcing, pricing and listing choices get better.
- Review in batches. Weekly or monthly reviews are more useful than reacting emotionally to one item.
Numbers worth tracking
You do not need a giant spreadsheet. These few numbers are usually enough to tell whether things are working:
Common mistakes
- Reusing stock codes
- Keeping duplicate master records across channels
- Leaving lost/damaged stock active
- Measuring stock by optimistic asking price only
What to do next
Try this on a small group of real items first. If it helps, make it part of your normal routine. There is no need to change everything at once.
Related guides
How to Build a Simple Reseller SKU System
A stock code only needs to be unique, readable and connected to a physical storage location.
Reseller Storage System for Clothing
Numbered tubs, rails and shelves make packing and sending faster when each listing stores the same location code.
How to Deal With Dead Stock
Old stock ties up cash and space; give it a planned sequence of improvements, discounts, bundles or exit routes.
Quick questions
Do I need special software for this?
No. You can start with a clean spreadsheet or notes. Software becomes useful when you have enough stock that manual updates are slowing you down or causing mistakes.
How often should I review it?
For active sellers, a quick weekly check plus a fuller monthly review is usually enough to spot problems before they become expensive.
Should I optimise for the highest possible sale price?
Not always. Money coming in and going out, days-to-sell, risk and the amount of work involved can make a slightly lower but faster, cleaner sale more profitable overall.