Can I vibe code Voucherify?

Build an API-first internal promotions service in Node.js/TypeScript using Express and PostgreSQL to replace basic Voucherify functionality.

1. DATA MODEL:
- Design tables for `campaigns`, `vouchers`, `redemptions`, and `gift_cards`.
- Vouchers must support fields: code (indexed, unique), campaign_id, discount_type (percentage, fixed_amount), discount_value, max_redemptions, redemption_count, expiration_date, active (boolean), and a JSONB column `validation_rules`.
- Gift cards must track original_balance, current_balance, and currency.
- Redemptions table must store order_id, customer_id, voucher_id, amount_discounted, and timestamp.

2. CORE VALIDATION & REDEMPTION API:
- Create a POST endpoint `/v1/promotions/validate` accepting cart payload (customer_id, items array with price/category, cart subtotal) and voucher code. Parse the JSONB validation_rules (e.g., minimum cart subtotal, allowed customer segments, required SKUs) and return valid/invalid with calculated discount.
- Create a POST endpoint `/v1/promotions/redeem`. MUST use PostgreSQL transactions (`BEGIN; SELECT ... FOR UPDATE; UPDATE ... COMMIT;`) to prevent race conditions during concurrent redemptions. Increment `redemption_count` atomically and verify `redemption_count <= max_redemptions` inside the lock. If exceeded, rollback and return 409 Conflict.

3. GIFT CARD LEDGER:
- Create `/v1/gift-cards/charge` endpoint using atomic decrements (`UPDATE gift_cards SET current_balance = current_balance - $1 WHERE id = $2 AND current_balance >= $1`). Return remaining balance.

4. FAILURE MODES & CONCURRENCY:
- Handle database connection pool exhaustion under load.
- Set strict query timeouts (sub-50ms target) for the validation endpoint.
- Implement structured JSON error codes for common validation failures (e.g., CODE_EXPIRED, MIN_SUBTOTAL_NOT_MET, REDEMPTION_LIMIT_REACHED).

Out of scope: Visual drag-and-drop rule builder UI, dynamic loyalty points accrual, automated referral fraud scoring.

$ each button prefixes agent-specific run instructions · build your own product, never copy proprietary code, trademarks or designs