| Tenant | Domain | Owner | Plan (Sub) | Expires / Status | Published | Purge Status | Actions |
|---|
Changes take effect immediately. Discount % creates a Stripe coupon at checkout time.
Every conversion logged here. Use Manual Credit to issue a correction.
| Referrer | Referred | Items Awarded | Images Awarded | Date | Actions |
|---|
Edit plan pricing and limits below, then click Save to update the database. Click Sync to Stripe to create or update Stripe price objects. Stripe sync is only needed after changing a price — limit/feature changes take effect immediately.
When enabled, changes made in the demo account (?tenant=demo) are written directly to the
live database instead of being discarded at session end. Use this to curate the demo content,
then disable to lock it in — the current state is snapshotted to _demo/seed.json
and that snapshot becomes what visitors see at /demo.
Note: While enabled, anyone who visits the demo can make persistent changes.
Copies all items and images from a source tenant into the public demo.
Images are duplicated into a dedicated _demo/ R2 prefix so they
are never affected by changes to the source account.
Run this any time you want to refresh what visitors see at
/sale/shop.html?tenant=demo.
Platform-wide marketing page interactions (Last 30 days)
One-off: fills tenants.owner_email from Clerk for tenants that
predate this column. Run once after applying
migrate/patch-email-engine.sql. Safe to run again — it only
touches tenants with a null owner_email.
When a tenant's subscription expires and they do not renew, their store data
(items, images, offers, subscribers) is automatically purged after the grace period below.
Their login is preserved. The purge job runs daily via
GET /api/billing/purge-expired?secret=CRON_SECRET.
A sale created free and never published (build-before-pay) is deleted entirely — not just its data, the login too — once it has been idle longer than the retention period below. "Idle" resets every time the seller comes back and makes an admin change, so a warned seller who returns gets the full window again before deletion. While unpublished, a sale is capped at the item/image/subscriber plan below, regardless of whichever plan they eventually intend to buy.
| Code | Reward | Usage | Expires | Actions |
|---|
These values are set directly — they override what was granted by promos or referrals. Bonus = manual grants. Addon = purchased add-on slots.