Inventory tracker template
SKU-level stock with locations, low-stock alerts, and CSV in/out. Built for teams who live in spreadsheets today.
What is in the box
- SKU records with variants, locations, and stock counts
- Movement log for every stock change with reason codes
- Low-stock alerts by SKU with custom thresholds
- CSV import and export with field mapping
- Multi-location with per-location permissions
- Reorder report based on velocity
Most ecommerce teams run inventory in a spreadsheet that one person owns. The system works until that person goes on vacation, until you add a second warehouse, or until a SKU goes negative and nobody notices for two weeks.
This template is the bridge between the spreadsheet and a real WMS. It is what we ship to teams that need real inventory tracking now and do not have time for a six-month NetSuite implementation.
What ships in the box
SKU records with variants and per-location stock. A movement log that captures every change with a reason code, so when stock looks wrong you can trace exactly who did what. Low-stock alerts at the SKU level with thresholds you set. A reorder report that ranks SKUs by velocity, not just by current stock.
Multi-location is built in from day one. Adding a warehouse is a row in the locations table, not a schema migration.
What is intentionally not in the box
No pick-and-pack workflow. No barcode scanning. No carrier integrations. Each of those is a real product on its own and bolting half-versions into an inventory template makes the template worse, not better.
If you need pick-and-pack, you are at the scale where a real WMS pays for itself. Use this template until that point, then graduate.
CSV in and out is not a hack
For teams coming from spreadsheets, CSV is the migration plan. The import wizard handles your existing format, remembers your mapping, and runs reconciliation so you can spot which rows did not match.
Export is the same shape so you can hand a current stock report to anyone who asks without giving them logins.
How to get the template
We share the template with teams that book a discovery call. We will look at your current inventory workflow and tell you what this template covers and what you would need to add.
Included with the template
- Supabase schema for SKUs, variants, locations, movements
- Stock movement helper functions (receive, ship, adjust, transfer)
- Reorder report view with sortable velocity column
- CSV import wizard with mapping memory
- Slack alerts for low stock
Frequently asked questions
Does this sync with Shopify?+
Not by default. Sync is a separate integration we can add as a paid extension. Most teams using this template treat the tracker as the source of truth and push to Shopify on a schedule, which is the safer pattern.
How many SKUs can it handle?+
Cleanly up to about a hundred thousand SKUs on Supabase Pro. Past that you want a different indexing strategy. The template ships with reasonable indexes for the common queries.
Multi-currency?+
Not in the template by default. Inventory itself is currency-agnostic (we track counts, not cost). If you want valuation reports, plan for a custom extension.
More templates
Got an idea? We can ship it next week.
30-minute discovery call. We tell you what's possible, what it costs, and when it ships.