Build guide
Convenience Store Operations OS
Retail stocks, food expire calendars, vendor invoice checklists, supplier index charts, and daily sales closing logs.
For: Boutiques, gift shops, specialty stores, florists and small online shops
- Linked databases
- 8
- Connections
- 5
- Automatic calculations
- 15
- Ready-made views
- 18
What it saves you
- Dated stock - dairy, bakery, sandwiches - with days left; anything inside 30 days with stock left is listed to mark down.
- End-of-day till count against POS sales - over/short is calculated so cash gaps are caught the same day.
- Margin and markup per product are calculated from cost and price
- Units sold and revenue per product roll up from the sales log
- Products below their reorder point form tomorrow's order list
- Late supplier orders and big-spending customers are one click away
How the parts work together
- Set up: Add products with cost, price and reorder point → Link each product to its supplier
- Daily close: Log sales from the till report → Link regulars as customers
- Weekly buying: Open "Reorder now" grouped by supplier → Raise a purchase order → Chase anything in "Late orders"
Databases inside
Products
Your catalogue with cost, price and stock. Units sold, revenue and margin are calculated from linked sales.
13 fields · 4 calculated automatically · linked to Suppliers, Sales Log, Batches & Expiry
Views: Catalogue, Reorder now, Best sellers, Shelf gallery
Sales Log
Sales by product and day, from the till export or typed in at close. Totals feed product revenue and customer spend.
8 fields · 1 calculated automatically · linked to Products, Customers
Views: This week, By channel, Sales calendar
Customers
Regulars and trade accounts with total spend rolled up from sales - your shortlist for events, previews and thank-yous.
8 fields · 2 calculated automatically · linked to Sales Log
Views: Top customers, Trade accounts
Suppliers
Makers and wholesalers with terms and lead times. Spend and product count roll up automatically.
8 fields · 2 calculated automatically · linked to Products, Purchase Orders
Views: All suppliers
Purchase Orders
Orders placed with suppliers, expected dates and totals. Late orders flag themselves.
7 fields · 1 calculated automatically · linked to Suppliers
Views: Incoming, Late orders
Promotions & Events
Sales, pop-ups and launches with dates, budget and results so you can repeat what works.
8 fields · 1 calculated automatically
Views: Promo calendar, Results
Batches & Expiry
Dated stock - dairy, bakery, sandwiches - with days left; anything inside 30 days with stock left is listed to mark down.
7 fields · 2 calculated automatically · linked to Products
Views: Expiring soon, All batches
Daily Close
End-of-day till count against POS sales - over/short is calculated so cash gaps are caught the same day.
8 fields · 2 calculated automatically
Views: Last 30 days, Investigate
You get the finished workspace, not homework.
Buy it once for $29 or get it with your membership, then duplicate it into Notion with every field, link, formula, view and example row already set up.
See Convenience Store Operations OS →