How to Manage Discounts and Promotions in Bubble

Create a 'Promotion' Data Type with: name (text), code (text — for coupon codes), discount_type (Option Set — percentage_off, fixed_amount, buy_one_get_one, free_shipping), discount_value (number — percentage or fixed amount), minimum_purchase (number — minimum cart total to qualify), max_uses (number — total allowed uses), current_uses (number), start_date (date), end_date (date), applies_to (list of Products — empty means all products), is_active (yes/no). Create a 'PromotionUsage' Data Type: promotion (Promotion), user (User), order_id (text), discount_applied (number), used_at (date).

Create an admin page for managing promotions. Add a form with all Promotion fields, date pickers for start and end dates, and a product selector for targeted promotions. Show a Repeating Group of all promotions with status indicators: green for active (within dates and under max uses), yellow for scheduled (start date in future), red for expired or exhausted. Add edit and deactivate buttons on each row. Include a usage count and revenue impact display for each promotion.

In your checkout flow, add a coupon code Input and an Apply button. When Apply is clicked, search for a Promotion where code = input value, is_active = yes, start_date <= current date, end_date >= current date, and current_uses < max_uses. If found, calculate the discount: for percentage_off multiply the cart total by discount_value/100, for fixed_amount subtract discount_value from total, for BOGO add the cheapest qualifying item as free. Validate minimum_purchase if set. Display the discount amount and updated total. Store the applied promotion reference for the order.

For promotions that apply automatically without a code (site-wide sales), search for active promotions where code is empty on cart page load. Apply the best applicable promotion automatically and show a banner: '20% off all items — ends March 31!' Build a promotional banner component that searches for active promotions with a 'show_banner' yes/no field. Display the banner at the top of relevant pages with the promotion details and a countdown timer to the end date. Use conditional visibility so banners only show during the active promotion period.

Build a promotion analytics page. For each promotion, display: total uses (PromotionUsage count), total discount given (sum of discount_applied), total revenue from orders using the promotion, average order value with the promotion vs without, and conversion rate (orders with promotion / total orders during the period). Add a chart showing daily usage over the promotion period. This data helps you understand which promotions drive the most revenue and inform future promotion strategy.