Category Configuration
Every pricing item has two independent category fields:
Product Category
Display and grouping only. Controls the filter dropdown in the quote generator and groups rows in the pricing table. No pricing logic attached.
Billing Category
Controls all pricing logic. Each billing category has a behavior type that determines how quantities are pooled and how upgrade items auto-fill their qty.
Behavior types:
STANDARD — no pooling; tier lookup uses this item's own qty.
POOL — items sharing the same pool group contribute to a combined qty for tier lookup.
FOOTAGE — like Pool but qty is feet (parsed from reel item names).
AUTO_SUM — qty auto-fills as the sum of other billing categories; manually overridable.
EXCLUDED — not counted in any pool or auto-sum (shipping, storage devices).
Product Categories
Display labels for catalog filter and pricing table groupingBilling Categories
Controls pricing behavior — pooling, auto-qty, AirTable field logicLocked fields are managed in code. All other fields take effect immediately.