- Home
- Ecommerce Orders and Stock Tracker
Ecommerce Orders and Stock Tracker
- 196,00 kr
Ecommerce Orders and Stock Tracker
- 196,00 kr
The problem. Orders sit in one place, stock counts in another, and returns in an inbox. It is hard to see which orders are waiting to ship, which are late, which products are about to run out and how much stock you are holding.
What this does. You keep one list of products, one of stock movements, and lists of orders, order items and returns. The workbook works out stock on hand, what is promised on open orders, what is available, each order total and days to ship, then counts them on a dashboard. You type everything by hand.
What you can do with it
- See orders to ship, orders late to ship, and orders and order total for the month.
- See products at or below the reorder level you typed, out of stock, or with negative stock.
- See stock value at cost, and margin for each product from your own typed cost and price.
- See orders by sales channel and by status, as tables and charts.
- See returns by reason, with units and refund amounts, and whether each return fell inside your returns window.
- Choose your industry (retail, food and beverage, or health and beauty) to load suitable product category and return reason lists, then edit them to suit you.
- Keep your records in a clear structure: a Data Dictionary explains every column, and six export sheets repeat your products, stock movements, suppliers, orders, order lines and returns under plain field names.
How it works
- Enter your business name, choose your industry, and type your sales channels, ship-within days and returns window.
- Add your suppliers and products, then your stock movements.
- Add your orders and their items, and your returns, then check the dashboard each day.
Orders and returns do not change stock by themselves. When you ship an order, you record an Out movement; when you restock a returned item, you record an In movement. A product is flagged to reorder when its quantity on hand is at or below the reorder level you typed.
Who it is for. Sole traders and small teams who sell online and want to see orders, stock and returns at a glance.
Who it is not for. Businesses that need shop, stock or shipping software that collects orders, prints labels or sends emails. This is a spreadsheet: it does not connect to any other software and does not work out tax.
What you need. Microsoft Excel 2016 or later. It was tested in Excel for Windows. No macros, no add-ins and no subscription.
Good to know
- 500 products, 3,000 stock movements, 1,000 orders, 2,500 order lines and 300 returns are ready, and you can add more by dragging the last row down.
- Ship-within days, the returns window and each reorder level are your own numbers, typed in the workbook. Nothing is a built-in rule.
- Orders hold customer names and email addresses. Keep your copy somewhere private.
- An example copy with a made-up shop shows every sheet working before you start.
- Nothing is locked or password protected.
- Use this template to capture and improve your business data now. In future you can automate with AI.
- General information only. It is not accounting, tax, legal or financial advice.
Enter your email to receive a one-time alert if this product's price decreases.
Customers also buy
You might also like
Recently Viewed
© 2026 TeleWorld Online


