Track stock for a small shop or online store in your browser: add items, record stock in and out, and get a reorder list when anything runs low. Export to Excel any time.
| SKU | Item | Category | In stock | Reorder at | Status | Value | Actions |
|---|
| Date | Item | Change | Balance after | Note | Undo |
|---|
Items at or below their reorder level. The suggested order brings each one back up to twice its reorder level; change the multiplier to suit your lead times.
| SKU | Item | In stock | Reorder at | Suggested order | Est. cost |
|---|
Export
CSV files open in Excel and Google Sheets.
Backup and restore
Your inventory is saved in this browser only. Download a backup to keep a copy or to move it to another computer, then restore it there.
How to use the inventory tracker
- Click Clear samples and start, then add each product with a SKU (your own short code), name, unit cost, opening quantity and reorder level.
- Record stock as it moves. Use + In when a delivery arrives and − Out when you sell or use something. Each movement goes in the log with a date and note.
- Check the Reorder list tab before you place orders. It lists everything at or below its reorder level, with a suggested quantity and cost.
- Download a backup now and then from the Export and backup tab.
The four boxes at the top update as you go: number of items, units in stock, total stock value at cost, and how many items are low or out.
Where your data is kept
Everything is saved in your own browser. There’s no account, and nothing is uploaded, so it’s private and fast. The trade-off is that your inventory lives on one device. To use it on another computer, download a backup, open this page there and restore the file. Clearing your browser data deletes the inventory, so keep a recent backup.
If several people need to update stock at the same time, you’ve outgrown a browser tool. A shared spreadsheet or proper inventory software is the better fit at that point.
Setting reorder levels
The reorder level is the quantity that should trigger a new order. A simple way to set it:
| Step | Example: sage mugs |
|---|---|
| How many you sell in a typical week | 3 |
| How many weeks a new order takes to arrive | 2 |
| Weekly sales × lead time | 3 × 2 = 6 |
| Add a small buffer for busy weeks | 6 + 2 = 8 |
Set the reorder level to 8 and you’ll be warned with roughly two weeks of stock left. The suggested order on the reorder list brings each item back up to twice its reorder level. Raise the multiplier if your supplier has a minimum order or your lead times are long.
Tips from running stock counts
Use count corrections for stock takes. When a shelf count doesn’t match, choose “Count correction (set to)” and enter what’s actually there. The log keeps the difference, so you can see how much goes missing or gets damaged over time.
Keep SKUs short and consistent, like MUG-01 and MUG-02. You’ll type them often, and sorting by SKU groups related products together.
Add a note to every stock in, such as the supplier or purchase order number. When a cost changes or a delivery is short, the log tells you which order it was.
Exporting to Excel
The Items and Stock movements buttons download CSV files that open straight into Excel or Google Sheets. The items file includes stock value per item, which is handy for year-end stock valuation. An Excel inventory template is coming soon if you’d rather keep everything in a spreadsheet.
Frequently asked questions
Is this inventory tracker free?
Yes, with no sign-up and no item limit.
Can I use it on my phone?
Yes, it works in a phone browser. Your phone keeps its own separate inventory, so use backup and restore to move data between devices.
What happens if I sell more than I have in stock?
The tracker stops the movement and tells you how many are left. If the shelf count is right and the record is wrong, use a count correction instead.
Can I undo a mistake?
Yes. The most recent movement has an Undo button in the Stock in / out log.