I will build an excel inventory tracker with automatic reorder alerts
Excel inventory and reorder trackers for small shops
About this Gig
Never run out of your best sellers again.
Running out of stock loses you sales. Ordering too much ties up your cash. I'll build you a simple spreadsheet that tells you exactly what to restock, how much to order, and what it will cost.
How it works:
- Log your sales and deliveries in one simple list
- Stock levels update automatically
- Each product shows green (OK), amber (reorder soon), or red (urgent)
- A dashboard gives you a ready-made shopping list with quantities and costs
- Order quantities round up to your supplier's minimum order
Who it's for: online shops, small retailers, and home businesses selling physical products.
Why me: I'm studying logistics and supply chain management, so the restock maths is the same method professional buyers use, not guesswork.
No coding or Excel skills needed. Every tracker comes with a plain-English guide.
Message me before ordering if you're unsure which package fits. Check my gallery for a full sample.
Industry:
Financial services & business
•
Logistics
Tool:
Excel
•
Google Sheets
FAQ
Do I need to know Excel?
No. You type in what you sold and what arrived. The sheet does the rest, and you get a step-by-step guide.
Does it work on a Mac or in Google Sheets?
Yes. The Excel version works on Windows and Mac. The Premium package includes a Google Sheets version.
How does it decide when I should reorder?
It looks at how fast each product sells and how long your supplier takes to deliver, then adds a small safety buffer. When stock drops to that level, the product turns amber.
Can I add more products later?
Yes. Type it in the next empty row, and everything updates by itself. There is room for 300 products.
Will it connect to my Shopify or Shopee store automatically?
Not in these packages. You log sales in the sheet, or paste in an export from your store. Message me if you need something custom.
What if I have more products than my package covers?
Message me first and I'll send a custom offer.

