All Tenants
OrgSlugPlanStatusContactActions
All Tenants
OrganisationSlugPlanStatusRenewalContactActions
All Leads
OrganisationContactEmailPhonePlan InterestStatusDateActions
Active Coupons
Welcome Email Template

Copy and customise this template after creating a tenant. Replace [PLACEHOLDERS] with real values.

Onboarding Steps
1

Lead Submits Sign-up Form

Customer fills out the form on /rewa-raffles.html or /rewa-events.html. Account is created automatically and appears in the Accounts tab.

2

Review the Lead

Check the lead details in the Leads tab. Contact the customer if needed. Mark as "contacted".

3

Create Tenant Account

Go to Tenants tab β†’ Create Tenant. Fill in org details. The slug auto-generates from the org name. Set a unique admin password.

4

Configure Raffle Settings

Use "Login As" to enter the customer's admin panel. Set up raffle title, draw date, ticket pricing, and prize baskets. Or do this together with the customer.

5

Send Welcome Email

Use the template above. Include their slug, admin URL, public raffle URL, and admin password. Mark the lead as "converted".

6

Customer Goes Live

Customer accesses /r/[slug] for the public page and /a/[slug] for their admin panel. Share the embed code if they want it on their own website.

Platform Tables

Each table downloads as a separate CSV. Your browser may ask to allow multiple downloads β€” click Allow.

πŸ‘€ Accounts
Self-serve + manually created
🎟️ Raffle Data
Settings, baskets, orders
🎫 Events Data
Events, ticket types, orders
πŸ“‹ Other
Leads, sellers, coupons
URL Structure
URLPurposeAuth
/ (index.html)Kete Koha homepage β€” both productsPublic
/rewa-raffles.htmlRaffles product page + signupPublic
/rewa-events.htmlEvents product page + signupPublic
/demo.htmlInteractive mock draw demoPublic
/r/[slug] (β†’ /r/index.html?slug=[slug])Customer public raffle pagePublic, iframe-embeddable
/a/[slug] (β†’ /a/index.html?slug=[slug])Customer admin panelPassword per tenant
/setup.htmlMaster admin dashboard (Louise)Master password
/terms.htmlTerms & ConditionsPublic
/guide.htmlPublic guide/help pagePublic
URL Routing Notes
!

Slug-based Routing

Since this is a static site on Genspark, slug-based routing uses one of two methods: (1) Path detection via JS: /r/index.html reads the slug from pathname or ?slug= query. (2) If the platform supports sub-path index files, /r/[slug] maps to /r/index.html and JS parses the path segment.

!

Multi-tenant Data Isolation

All tables include tenant_slug field. Every query filters by slug. No tenant can see another's data (enforced by query filtering).

!

Database Tables

Tables: rl_tenants, raffle_settings, raffle_baskets, raffle_orders, raffle_leads, rl_coupons. All accessed via RESTful Table API at /tables/[name].

!

Draw Integrity

Every draw uses crypto.getRandomValues(). Two witnesses required. Draw certificate generated with cryptographic seed. Terms page explains the draw process. Customers are responsible for their own compliance obligations.