Skip to main content

Build guide

Vintage Camera Restoration OS

Shutter timing, lens fungus treatment, and CLA history. — built on Universal Base.

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

Linked databases
7
Connections
5
Automatic calculations
11
Ready-made views
17

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, Camera Restoration Logbook

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

Camera Restoration Logbook

Industry operations database for Vintage Camera Restoration OS. Shutter timing, lens fungus treatment, and CLA history.

9 fields · linked to Products

Views: Master Registry, Active Board, By Mount

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 Vintage Camera Restoration OS →