Handmade & Craft Seller Inventory + Order Tracker (Excel)
Excel tracker for craft sellers: stock with reorder alerts, real cost and margin per product, orders with ship-by dates, one-screen dashboard.
14 USD · Get it on Gumroad
Launch offer: 30% off until Oct 22 (applied automatically)
✓ 30-day money-back promise – if it doesn't help, you get a full refund, no questions asked.
It's Sunday evening and the parcels are packed on the kitchen table. You reach for the last of the wax to pour tomorrow's candles, and the tin is empty. You knew it was getting low. You just didn't know when. Now the wholesaler is closed until Monday, and two orders are promised for Tuesday.
You open your notebook and flip through scribbled pages, looking for the ship-by dates. Somewhere in there is a price you set months ago. You wonder, quietly, whether that candle earns anything once the wax, the jar, the fees and your hours are counted. You don't want to know. You close the notebook.
Now it's handled. You glance at one screen, see what to reorder and what ships next, and know what each product really earns. The table is yours again, and so is the evening.
What you get – real screenshots
Materials run out, orders slip, and nobody knows the real margin per product. This Excel workbook gives you one calm place to see what to reorder, what to ship next and what each product really earns.
What's included
- Excel workbook with 7 sheets: Start here, Dashboard, Orders, Products, Materials, Stock Log, Settings
- Materials stock with reorder points, status (OK / Reorder / Short for orders / Out) and suggested order quantity
- Products with up to 5 materials each: material cost per piece, your time, margin before and after paying yourself, and a price suggestion for your target margin
- Orders with status, ship-by date and LATE / Due soon alerts, plus revenue, fees and profit per order
- Dashboard: ship-next list, restock list, margin chart, sales by channel
- Realistic sample data (a small candle, bag and jewellery shop) so you see how it works in minutes
- One-page quick-start PDF
Who it is for
Handmade and craft sellers on marketplaces, in their own web shop or at markets who have outgrown the notebook.
How to use
Open the Dashboard to see the sample, enter your hourly rate and fees in Settings, add a material, a product and an order, then delete the sample rows. Ten minutes a week keeps it current.
Requirements
Microsoft Excel 2010 or newer. No macros, no add-ins. Not tested in Google Sheets or LibreOffice.
Margins are simple estimates for organising your business and do not replace a tax professional, accountant or lawyer.
30-day money-back promise: if it doesn't help, full refund, no questions. Personal and commercial use allowed; no resale or redistribution.
This product was created with AI assistance by an autonomous AI agent and checked automatically.
FAQ
What exactly is inside?
An Excel workbook with 7 sheets (Start here, Dashboard, Orders, Products, Materials, Stock Log, Settings), a one-page Quick-Start PDF and a README. It comes filled with sample data from a small candle, bag and jewellery shop, so you can see how it works before you enter your own.
Who is it for, and who is it not for?
It is for handmade and craft sellers on marketplaces, in their own web shop or at markets who have outgrown the notebook. It is not for you if you want automatic syncing with shop platforms, or if you need accounting, tax or invoicing software. It is a tracker for stock, orders and margins.
How long does setup take?
About ten minutes to get going. Look at the sample on the Dashboard, enter your hourly rate and fees in Settings, add one material, one product and one order, then delete the sample rows. After that, ten minutes a week keeps it current.
Can I edit and customise it?
Yes. It is a normal Excel file with no macros and no add-ins, so you can add your own materials, products and orders and adjust it to your shop. Each product can use up to 5 materials. Personal and commercial use is allowed; resale and redistribution are not.
Which software do I need?
It is built for Microsoft Excel 2010 or newer. In our check it also opened and calculated in LibreOffice, but Excel is what it is made for. We have not tested it in Google Sheets or Numbers, so we can't promise it works there.
What if it doesn't help me?
You have a 30-day money-back promise: if it doesn't help, you get a full refund, no questions asked. The margins are simple estimates to help you organise your business and do not replace a tax professional, accountant or lawyer.