Skip to main content

Build guide

Commercial Studio & Camera Gear Rental OS

Commercial Studio & Camera Gear Rental OS: rental kit and hires & returns, connected to products, sales log and customers - calculations, views and example rows already set up.

For: Boutiques, gift shops, specialty stores, florists and small online shops

Linked databases
8
Connections
5
Automatic calculations
14
Ready-made views
18

What it saves you

How the parts work together

  1. Set up: Add products with cost, price and reorder point → Link each product to its supplier
  2. Daily close: Log sales from the till report → Link regulars as customers
  3. 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

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, Hires & Returns

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

Rental Kit

Cameras, lenses, lighting and grip with serials, day rate and replacement value - utilisation and payback are calculated.

7 fields · 2 calculated automatically

Views: By category, Best earners

Hires & Returns

Each hire with kit out, deposit and due-back date - late returns and damage are recorded before the deposit is released.

7 fields · 1 calculated automatically · linked to Customers

Views: Out now, Hire calendar

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 Commercial Studio & Camera Gear Rental OS →