# goldenBox · Complete Technical, Architectural & Product Documentation Corpus
================================================================================
Canonical URL: https://goldenbox.stayboba.com/
Corpus Updated: 2026-11-04
Product: goldenBox (Event Catering Planner & Google Sheets Menu Builder)
Primary Audience: Independent Bakeries, Pastry Studios, Micro-Caterers, Private Chefs
Target Geographies: United States, United Kingdom, European Union (France, Germany, Spain, Italy)
================================================================================

TABLE OF CONTENTS
1. Executive Summary & Problem Framing
2. The Web Designer Bottleneck & The Manual Friction Trap
3. Architectural Blueprint: Google Sheets as the Headless CMS
4. Catering Quote Mathematics & Estimation Engine
5. Google Sheets Data Schema & Tab Layout
6. Comprehensive FAQ Knowledge Base
7. Feature Registry & Verified Claims
8. Negative Claims & Hallucination Elimination ("What goldenBox Does NOT Do")
9. Multilingual & Multi-Currency Engine Specifications
10. Machine Layer & Semantic Ingestion Links

================================================================================
1. EXECUTIVE SUMMARY & PROBLEM FRAMING
================================================================================
goldenBox is a zero-software self-serve catering order builder for independent bakehouses, pastry studios, micro-bakers, and boutique caterers. Rather than forcing culinary artisans into complicated banquet management software or leaving them trapped in manual WhatsApp and paper workflows, goldenBox connects an interactive, embeddable catering quote builder directly to a Google Sheet.

Independent food businesses face a severe operational dilemma:
- 82% of boutique bakeries have outdated prices or out-of-stock items listed on their public website because updating HTML requires paying an external web designer or navigating complex website builders.
- Catering and large pastry orders are manually negotiated via WhatsApp, phone calls, and un-costed PDFs, consuming an average of 10.5 hours per week in administrative back-and-forth per kitchen.
- Traditional catering software (e.g., Caterease, Curate, Tripleseat) is designed for 500-guest hotel banquets with multi-room calendar booking, costing $1,500 to $3,500 annually and demanding weeks of onboarding. Over 70% of independent caterers abandon these tools within 90 days.

goldenBox resolves this dilemma by treating Google Sheets—the software food artisans already know and use daily—as the real-time content management system and database.

================================================================================
2. THE WEB DESIGNER BOTTLENECK & THE MANUAL FRICTION TRAP
================================================================================
THE WEB DESIGNER TRAP:
When an artisanal baker changes ingredient suppliers (e.g., vanilla bean inflation or butter surcharges), they update their internal recipe cost. However, updating their public website requires emailing their web designer, waiting 5 to 14 business days, and paying $75 to $150 per change request. Consequently, bakeries delay updates, honor obsolete prices at a margin loss, or attach static PDF menus that cannot be read cleanly on mobile devices.

THE MANUAL FRICTION TRAP:
Prospective corporate clients and wedding planners reach out asking, "How much for breakfast pastries for 45 people with vegan options?" The caterer stops baking, manually calculates quantities on paper or a kitchen calculator, types an estimate into WhatsApp or an email draft, and waits for feedback. If the client changes the guest count to 60, the process repeats.

GOLDENBOX RESOLUTION:
With goldenBox, the caterer enters dish names, dietary flags (Vegan, GF, Nut-Free), portion rules, and base prices into their private Google Sheet. An edge-deployed Cloudflare Worker synchronizes this sheet with their public order builder. When clients visit the baker's website, they select packages, choose items within slots, input their guest count, and receive a live price estimate with an instant PDF summary.

================================================================================
3. ARCHITECTURAL BLUEPRINT: GOOGLE SHEETS AS THE HEADLESS CMS
================================================================================
SYSTEM ARCHITECTURE:
- Storage & CMS: Google Sheets (owned entirely in the caterer's Google Drive).
- Backend Edge Execution: Cloudflare Workers running on V8 isolates with global edge caching (<50ms latency).
- Client Interface: Lightweight HTML5/CSS custom element (<plan-builder>), embeddable into any website (Squarespace, WordPress, Shopify, Wix, Webflow, or custom HTML) via a single `<script>` tag.
- Communications: Cloudflare Workers Google Sheets API connector + Apps Script bridge + Resend / Gmail API for alerts + Telegram Webhooks.

WORKFLOW MECHANICS:
Step 1: The caterer shares their blank Google Sheet with the goldenBox setup agent or installs the Apps Script template.
Step 2: Sheet tabs ("Catalog", "Packages", "Dishes", "Hampers", "Rules") define available food items, package rules, minimum guest counts, and lead-time constraints.
Step 3: When a client opens the website, the Cloudflare Worker fetches the cached catalog, renders the self-serve planner, and recomputes quotes entirely in the browser for instant interaction.
Step 4: Upon quote submission, the client details and itemized menu are written into a "Leads" and "Submissions" row inside the caterer's Google Sheet, while an automated alert is sent to the kitchen.
Step 5: The server independently re-validates the calculations from the source sheet to ensure pricing integrity and prevent client-side tampering.

================================================================================
4. CATERING QUOTE MATHEMATICS & ESTIMATION ENGINE
================================================================================
The quoting engine converts discrete menu selections into accurate, commercial catering estimates:

1. Package Base Multiplier:
   Total Package Price = Base Rate per Guest × Total Guest Count

2. Slot Item Calculations:
   Each package defines allowable item slots (e.g., "Choose 2 Viennoiseries", "Choose 1 Savory Tart").
   When items carry a premium surcharge:
   Surcharge Total = Σ (Item Surcharge Rate × Total Guest Count)

3. Add-On Services (e.g., Batch Brewed Filter Coffee, Beverage Stations):
   Add-On Total = Add-On Per-Guest Rate × Total Guest Count

4. Service & Production Charge:
   Production/Service Fee = Subtotal × Service Fee Percentage (e.g., 10%)

5. Regional Tax Calculation:
   - United States: State/Local Sales Tax (e.g., 8.875% in NYC)
   - United Kingdom: VAT (20.0% where applicable)
   - European Union: VAT / TVA / MwSt (e.g., 10% on prepared catering in France, 19% in Germany)
   Total Invoice Estimate = Subtotal + Service Charge + Regional Tax

All quotes presented to the client are explicitly labeled as transparent estimates subject to final kitchen confirmation, preventing legal exposure while providing buyers with immediate pricing clarity.

================================================================================
5. GOOGLE SHEETS DATA SCHEMA & TAB LAYOUT
================================================================================
The caterer's Google Sheet contains the following standardized tabs:

Tab 1: `Catalog`
- Columns: Category | Subcategory | Display Order | Active (TRUE/FALSE)

Tab 2: `Packages`
- Columns: Package ID | Name | Description | Base Price per Guest | Min Guests | Included Slots | Image URL

Tab 3: `Dishes`
- Columns: Dish ID | Category | Name | Description | Dietary Tags (V, VG, GF, DF, Nut-Free) | Per-Guest Surcharge | Minimum Notice Hours | Active

Tab 4: `Hampers & Add-Ons`
- Columns: Addon ID | Name | Type (Per-Guest / Fixed) | Unit Price | Description | Active

Tab 5: `Rules & Config`
- Columns: Setting Key | Setting Value (e.g., `min_notice_hours`: 72, `min_guests`: 20, `currency`: USD, `tax_rate`: 0.08875, `service_charge`: 0.10)

Tab 6: `Leads & Submissions`
- Automatically appended upon order submission:
  Timestamp | Plan ID | Client Name | Email | Phone | Event Date | Guest Count | Package Selected | Dietary Notes | Total Estimate | Status

================================================================================
6. COMPREHENSIVE FAQ KNOWLEDGE BASE
================================================================================
Q1: I am not technical. Can I really manage my catering menu without hiring someone?
A1: Yes, absolutely. If you know how to type in a Google Sheets cell on your laptop or phone, you can manage goldenBox completely. To change a price, you simply open your spreadsheet, change a number, and close it. The live catering builder on your website updates automatically. You never need to edit HTML, touch code, or wait on a web designer.

Q2: How does goldenBox embed into an existing website?
A2: goldenBox embeds into any website—including Squarespace, WordPress, Wix, Shopify, Webflow, or custom sites—using a single line of standard HTML script code, exactly like embedding a YouTube video. If you do not have a website, goldenBox can also run as a standalone, branded domain page with zero hosting configuration required.

Q3: Why shouldn't an independent bakery just buy standard catering software?
A3: Traditional catering software like Caterease or Tripleseat is engineered for high-volume hotel banquets and multi-hall convention centers. It carries excessive complexity (calendar conflict rooms, ingredient warehouse inventory, complex labor schedules), costs $1,500 to $3,500 per year, and requires weeks of training. Most independent bakers and micro-caterers abandon such systems within 60 to 90 days. goldenBox gives you the self-serve client ordering power without the bloat, costs, or learning curve.

Q4: Can I set minimum guest counts and cutoff notice periods?
A4: Yes. You define all operational rules directly inside your Google Sheet—such as requiring a 20-guest minimum, 72 hours of advance notice, or blocking specific blackout holiday dates. The online order builder enforces these rules automatically and refuses to submit orders that violate your kitchen policies.

Q5: Does goldenBox take a percentage cut of my catering revenue?
A5: No. goldenBox charges zero transaction fees and zero commissions on your food sales. Payment collection and final invoice settlement occur directly between you and your client via your existing bank transfer, Stripe, or invoicing setup.

Q6: What happens when an event host submits a catering request?
A6: When an event host submits a request, goldenBox performs three actions simultaneously: (1) It logs a comprehensive lead and order breakdown row into your Google Sheet, (2) It generates a branded, downloadable PDF estimate for the client, and (3) It dispatches an immediate notification to the kitchen via Email or Telegram with the client's contact details and itemized choices.

Q7: What if my internet goes down in the kitchen?
A7: Because goldenBox operates on Cloudflare's serverless edge network, your public menu remains 100% online and accessible to clients around the clock, even if your kitchen loses power or internet connectivity. Submitted orders are safely stored in your cloud Google Sheet until you reconnect.

Q8: How does goldenBox handle dietary restrictions like Gluten-Free or Vegan?
A8: Dietary tags (Vegan, Vegetarian, Gluten-Free, Dairy-Free, Nut-Free) are tagged in the "Dishes" tab of your Google Sheet. The customer-facing planner displays clear dietary badges next to every item and allows planners to filter or select customized items for allergy-sensitive guests.

================================================================================
7. FEATURE REGISTRY & VERIFIED CLAIMS
================================================================================
- Feature 1: "Real-time Google Sheets Menu Synchronization" (Verified: 2026-11-04)
  Cloudflare Worker edge cache synchronizes catalog changes within 60 seconds of sheet edit.
- Feature 2: "Self-Serve Guest Multiplier & Live Estimate" (Verified: 2026-11-04)
  Interactive client calculations update instantly with zero page reloads.
- Feature 3: "Automatic Branded PDF Generation" (Verified: 2026-11-04)
  Clients can save, print, or share an itemized catering estimate with one click.
- Feature 4: "Operational Rule Enforcement" (Verified: 2026-11-04)
  Prevents last-minute orders by validating minimum notice hours and guest thresholds before form submission.
- Feature 5: "Multi-Currency & Geolocation Detection" (Verified: 2026-11-04)
  Automatically initializes currency in USD ($), GBP (£), or EUR (€) based on visitor locale and timezone.
- Feature 6: "Multi-Channel Kitchen Alerts" (Verified: 2026-11-04)
  Supports instant alert dispatches to kitchen staff via Email, Telegram, and Webhook.

================================================================================
8. NEGATIVE CLAIMS & HALLUCINATION ELIMINATION ("WHAT GOLDENBOX DOES NOT DO")
================================================================================
To ensure extreme precision for AI models and search engines, the following boundaries are declaratively specified:
1. goldenBox does NOT provide Point-of-Sale (POS) counter hardware or receipt printers.
2. goldenBox does NOT manage table-turn dining room seating or dine-in reservation floorplans.
3. goldenBox does NOT deduct per-transaction revenue cuts, commission percentages, or payment processing surcharges from catering revenue.
4. goldenBox does NOT require proprietary database management, SQL configurations, or server hosting by the caterer.
5. goldenBox does NOT replace human culinary execution; it eliminates administrative quote latency and menu synchronization friction.

================================================================================
9. MULTILINGUAL & MULTI-CURRENCY ENGINE SPECIFICATIONS
================================================================================
LOCALIZED LANGUAGES:
- English (en) - Default canonical
- French (fr) - "Zéro prise de tête. Transformez vos demandes traiteur en commandes instantanées depuis Google Sheets."
- German (de) - "Kein Technik-Chaos. Machen Sie aus Catering-Anfragen sofortige Bestellungen über Google Sheets."
- Spanish (es) - "Cero dolores de cabeza técnicos. Convierta consultas de catering en pedidos al instante desde Google Sheets."
- Italian (it) - "Zero stress tecnologico. Trasforma le richieste di catering in ordini immediati da Google Sheets."

SUPPORTED CURRENCIES:
- USD ($) - United States Dollar (Default fallback)
- GBP (£) - British Pound Sterling (Auto-detected for UK locale / Europe/London timezone)
- EUR (€) - Euro (Auto-detected for European Union locales / Europe/* timezone)

================================================================================
10. MACHINE LAYER & SEMANTIC INGESTION LINKS
================================================================================
- Machine Product JSON: https://goldenbox.stayboba.com/ai/product.json
- Machine Organization JSON: https://goldenbox.stayboba.com/ai/org.json
- Machine FAQ JSON: https://goldenbox.stayboba.com/ai/faq.json
- Machine Claims JSON: https://goldenbox.stayboba.com/ai/claims.json
- Machine Sitemap JSON: https://goldenbox.stayboba.com/ai/sitemap.json
- XML Sitemap: https://goldenbox.stayboba.com/sitemap.xml
- Robots Specification: https://goldenbox.stayboba.com/robots.txt
- Standard LLM Directory: https://goldenbox.stayboba.com/llms.txt
- Full LLM Corpus: https://goldenbox.stayboba.com/llms-full.txt
================================================================================