Google Sheets
Order Tracker for Small Business Google Sheets, Handmade Shop Inventory Spreadsheet with Ship-By Alerts, Product Margins & Low Stock Flags
π§Ά The money side of your shop has bookkeeping β this is the MAKING side. Every order with a ship-by countdown (red means pack it today), every product with its true margin exposed, and low-stock flags so your bestseller never quietly runs out the week before a fair.
Works across every channel you sell on β marketplace, your own website, fairs, Instagram, wholesale β and the dashboard tells you which one actually pays.
π WHAT'S INSIDE (5 tabs)
β’ Dashboard β revenue, open orders, ship-in-2-days alerts, low stock, best channel, bestseller & average order
β’ Orders β date, buyer, channel, item, status (New β Making β To pack β Shipped) and live ship-by countdowns
β’ Inventory β materials cost vs price = true margin per item, stock counts and "LOW β remake" flags
β’ Start Here β set up in twenty minutes
βοΈ HOW IT WORKS
1. Open your link and click "Make a copy"
2. List your products with cost, price and stock β margins calculate instantly
3. Log each order as it lands; pick the item from a dropdown
4. Work the countdowns: amber = 2 days, red = ship today
π·οΈ PERFECT FOR
β’ Handmade and craft sellers on any platform
β’ Makers doing fairs + online at the same time
β’ Anyone who's ever discovered a 3-day-late order at 11pm
β’ Pairs beautifully with our Bookkeeping & Profit Dashboard for the money side
π» FORMAT & ACCESS
β’ Made for Google Sheets β works on phone, tablet & desktop
β’ Nothing to install, no software fees β just a free Google account
β’ Delivered as a private "Make a Copy" link β one click and it's yours
β’ Your copy is 100% private and fully editable, forever
β’ All formulas built in β type, tick, and everything updates itself
β‘ INSTANT ACCESS β Your template link is available immediately after purchase. No physical item will be shipped.
π Please note: This is a digital product. Due to the instant-access nature of digital files, all sales are final and no refunds are offered. If anything looks off, message me and I'll happily help.
Helpful guides
- Craft Fair Prep: The Checklist That Sells Out Your StallGreat craft fairs aren't luck β they're stock maths, a table that stops walkers, painless payments and a kit bag with the boring essentials. Here's the four-week prep checklist, what to bring, and the tracking that turns one good fair into a repeatable system.
- Handmade Inventory: Stock, Orders and What Actually SellsMost makers track orders and guess at stock. Here is what to count, how often, and the one figure that tells you what to make next instead of what you feel like making.
- The Handmade Pricing Formula: What to Actually ChargeMost handmade sellers price by looking at what everyone else charges. Here is the formula that counts materials, labour and every fee β and the profit-per-hour figure that changes minds.
More in Google Sheets
Quick viewGoogle Sheets Mega Bundle β The Complete Collection, All 25 Dashboards: Budget, Wedding, Business, ADHD, Renovation & More (Β£338 Value)
Google Sheets
Β£49.99
Quick viewLife OS β The Master Dashboard, Google Sheets Life Planner Spreadsheet: Todayβs Top 3, Goals, Habits, Money & Weekly Review in One Live Dashboard
Google Sheets
Β£19.99
Quick viewHomeschool OS β Google Sheets Homeschool Planner Spreadsheet: Attendance Tracker, Lesson Planner, Progress & Curriculum Budget, Up to 4 Children
Google Sheets
Β£14.99
Quick viewCollege Student OS β Google Sheets Student Planner Spreadsheet: Assignment Tracker, Weighted Grade Calculator & Student Budget, Semester Dashboard
Google Sheets
Β£12.99
Quick viewNew Baby Budget β Google Sheets First-Year Planner Spreadsheet: Baby Checklist with Costs, Maternity Leave Cash Flow & First-Year Expense Tracker
Google Sheets
Β£12.99
Reviews
No reviews yet, bought this? Be the first to leave one below. Every review helps another shopper decide.
Write a review
Β£14.99