{"product_id":"ecommerce-orders-and-stock-tracker","title":"Ecommerce Orders and Stock Tracker","description":"\u003cp\u003e\u003cstrong\u003eThe problem.\u003c\/strong\u003e 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.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat this does.\u003c\/strong\u003e 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.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you can do with it\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eSee orders to ship, orders late to ship, and orders and order total for the month.\u003c\/li\u003e\n\u003cli\u003eSee products at or below the reorder level you typed, out of stock, or with negative stock.\u003c\/li\u003e\n\u003cli\u003eSee stock value at cost, and margin for each product from your own typed cost and price.\u003c\/li\u003e\n\u003cli\u003eSee orders by sales channel and by status, as tables and charts.\u003c\/li\u003e\n\u003cli\u003eSee returns by reason, with units and refund amounts, and whether each return fell inside your returns window.\u003c\/li\u003e\n\u003cli\u003eChoose 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.\u003c\/li\u003e\n\u003cli\u003eKeep 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.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eHow it works\u003c\/strong\u003e\u003c\/p\u003e\u003col\u003e\n\u003cli\u003eEnter your business name, choose your industry, and type your sales channels, ship-within days and returns window.\u003c\/li\u003e\n\u003cli\u003eAdd your suppliers and products, then your stock movements.\u003c\/li\u003e\n\u003cli\u003eAdd your orders and their items, and your returns, then check the dashboard each day.\u003c\/li\u003e\n\u003c\/ol\u003e\u003cp\u003e\u003cstrong\u003eOrders and returns do not change stock by themselves.\u003c\/strong\u003e 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.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWho it is for.\u003c\/strong\u003e Sole traders and small teams who sell online and want to see orders, stock and returns at a glance.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWho it is not for.\u003c\/strong\u003e 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.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you need.\u003c\/strong\u003e Microsoft Excel 2016 or later. It was tested in Excel for Windows. No macros, no add-ins and no subscription.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eGood to know\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e500 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.\u003c\/li\u003e\n\u003cli\u003eShip-within days, the returns window and each reorder level are your own numbers, typed in the workbook. Nothing is a built-in rule.\u003c\/li\u003e\n\u003cli\u003eOrders hold customer names and email addresses. Keep your copy somewhere private.\u003c\/li\u003e\n\u003cli\u003eAn example copy with a made-up shop shows every sheet working before you start.\u003c\/li\u003e\n\u003cli\u003eNothing is locked or password protected.\u003c\/li\u003e\n\u003cli\u003eUse this template to capture and improve your business data now. In future you can automate with AI.\u003c\/li\u003e\n\u003cli\u003eGeneral information only. It is not accounting, tax, legal or financial advice.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"TeleWorld Online","offers":[{"title":"Default Title","offer_id":48859262255309,"sku":null,"price":34.0,"currency_code":"AUD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0652\/1031\/9053\/files\/01-cover_bfe971af-5864-4ecf-acf7-506631615cc1.png?v=1795098264","url":"https:\/\/www.teleworld.online\/fil\/products\/ecommerce-orders-and-stock-tracker","provider":"TeleWorld Online","version":"1.0","type":"link"}