{"product_id":"order-shipping-tracker","title":"Order and Shipping Tracker Spreadsheet","description":"\u003cp\u003eThis order tracker spreadsheet tells you what is still to go out and what it is worth. It is made for shops with more orders than they can hold in their head, on more than one channel, and it works out the profit on every order as you log it.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eEvery order, with its profit\u003c\/h2\u003e\u003cp\u003eEach order line shows the sale, the fee, what the product cost to make and the profit left, with the cost looked up for you from the Products tab.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eFulfillment: every status counted, with the value still in your queue\u003c\/li\u003e\n\u003cli\u003eA channel on every line, and what each channel earns\u003c\/li\u003e\n\u003cli\u003eCustomers: orders, units, spend and average for each one, read off the order list\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eOne file, actually connected\u003c\/h2\u003e\u003cp\u003eA product is entered once, on the Products tab. The recipe, the pricing calculator, the stock valuation and every order line all read that same row. Change one thing and everything that depends on it follows, with no copying a figure from one spreadsheet into another and hoping you remembered.\u003c\/p\u003e\u003ch2\u003eTen connected tabs\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eProducts:\u003c\/strong\u003e 120 rows, the one place a product is entered\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eMaterials:\u003c\/strong\u003e 120 rows with the unit cost of each\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003ePricing:\u003c\/strong\u003e cost, suggested price, your price, and margin before and after fees\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eInventory:\u003c\/strong\u003e stock on hand, valued at cost and at retail\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eOrders:\u003c\/strong\u003e 400 lines with profit per line\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eSales:\u003c\/strong\u003e the year by month, with fees and postage taken off\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eFulfilment:\u003c\/strong\u003e a shipping tracker with every status counted\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eCustomers:\u003c\/strong\u003e a customer tracker built from the order list\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eDashboard:\u003c\/strong\u003e six live figures and what each product did\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eSetup and Start Here:\u003c\/strong\u003e setup takes a few minutes\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat it does for you\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003ePrices every product from its own recipe of materials\u003c\/li\u003e\n\u003cli\u003eAdds your labor rate and overhead per item automatically\u003c\/li\u003e\n\u003cli\u003eShows the margin you actually keep after the platform's cut\u003c\/li\u003e\n\u003cli\u003eValues your stock at cost and at retail\u003c\/li\u003e\n\u003cli\u003eFlags anything below your reorder level, or below your target margin\u003c\/li\u003e\n\u003cli\u003eCharts that redraw from your own numbers\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eIt doubles as a sales tracker and profit tracker for a small business. The filled copy holds a whole year of a working shop, so you can see how it behaves before you type anything.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice. No Microsoft 365 subscription needed.\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. You get real spreadsheet files, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo add-ins, no macros and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook, filled with a worked example\u003c\/li\u003e\n\u003cli\u003eThe same workbook, blank and ready for your own numbers\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, with one-click links to the Google Sheets versions (filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready as soon as payment clears. The template is for use in your own business; please do not share or resell the files. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eCan I use it in Excel or Google Sheets?\u003c\/h3\u003e\u003cp\u003eBoth. The Excel workbook runs in Excel 2016 or later on Windows and Mac, and the instruction guide holds two one-click links to the Google Sheets versions.\u003c\/p\u003e\u003ch3\u003eHow many orders can it hold?\u003c\/h3\u003e\u003cp\u003eThe Orders tab has 400 lines, each showing the sale, the fee, the cost to make and the profit.\u003c\/p\u003e\u003ch3\u003eCan I track orders from more than one sales channel?\u003c\/h3\u003e\u003cp\u003eYes. Every order line carries a channel, and the workbook shows what each channel earns.\u003c\/p\u003e\u003ch3\u003eHow do I see what still needs to ship?\u003c\/h3\u003e\u003cp\u003eThe Fulfillment tab counts every status and shows the value still in your queue.\u003c\/p\u003e\u003ch3\u003eDoes it keep a customer list?\u003c\/h3\u003e\u003cp\u003eYes. The Customers tab reads orders, units, spend and average for each customer straight off the order list.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597861814366,"sku":"OPX-028","price":22.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/order-shipping-tracker-01.jpg?v=1790832083","url":"https:\/\/opxviashop.com\/products\/order-shipping-tracker","provider":"OPXVIA","version":"1.0","type":"link"}