Structuring Multi-Tier Fest Bundles: Bundling Passes, T-Shirts, and Meal Vouchers

The Nightmare of Manual Merchandise Tallying

For college fest organizers, selling official festival T-shirts and meal vouchers is a great revenue generator, but an inventory nightmare: In Google Forms, students select "Size L". By the time the printer delivers 200 Large T-shirts, 350 students have registered for Size L, while 100 Small T-shirts sit unclaimed. * At the distribution desk, volunteers scramble through cardboard boxes while long lines form.

---

1. Decoupling Admission from Add-on Inventory

The professional approach to festival logistics is to separate Admission Tiers from Physical Add-ons:

Base Ticket Tier: Confers legal admission into the festival venues and competitions. Modular Add-ons: Physical entitlements with individual stock quotas: Official Fest Hoodie / T-Shirt (Stock: 500 units, tracked by size: S, M, L, XL, XXL) Day 1 & Day 2 Lunch Combo (Stock: 800 meal tokens) Cloud Lab Workshop Access Key*

---

2. How Spark Manages Bundle Inventory

In Spark (event_addons schema): 1. Organizers configure each add-on with a Price (INR), Total Stock, and customizable Options (e.g., sizes or dietary preferences). 2. During registration, attendees select their base tier and toggle desired add-ons. Spark calculates the bundle total atomically. 3. Once an add-on option reaches its stock limit, Spark automatically disables that option, preventing over-commitment.

---

3. Gate Fulfillment & Single-Claim Stations

On event day, merchandise is redeemed using Spark's Check-in Stations: The volunteer at the Kit Desk scans the attendee's dynamic ticket pass. The system displays: Entitled to: Fest T-Shirt (Size L). The volunteer hands over the shirt and marks it as Claimed. If the student returns later claiming they never received their kit, the system shows: Already Claimed at 10:42 AM by Desk Volunteer 2, eliminating duplicate giveaways.