Jul–Aug 2026
Opens 1 Jul · Locks 13 Jul · Dispatch target 28 Jul
Click any stat to jump to the matching filtered list.
Needs Attention
Customer Baskets
Jul–Aug 2026 · click a row, or "View items," to see what's in the basket
| Household | Items | Total Due | Wallet Credit | Confirmed | Status | Last Contacted |
|---|
Consolidated order sheet
| SKU | Name | Total Qty |
|---|
Looking for shipping stickers? That's per-household now — see the Fulfillment Tracker tab.
Fulfillment Tracker
Send each order to the partner, generate its shipping label, then track packing/dispatch. Address is always shown so you know exactly what's being printed.
Partner WhatsApp number: ... · change
- Weigh each packed box and note the weight in kg.
- Click "Export for Easyship" below — downloads a CSV with recipient, address, items, and box size already filled in.
- Fill in the Weight (kg) and HS Code columns per box (left blank here since per-SKU weights aren't tracked yet).
- Log in to Easyship and upload the CSV to generate the shipment.
- Print the courier label from Easyship — choose the 4×6 format to match the thermal printer already in use.
| Household | Address | Items | Status | Action |
|---|
| Household | Address | Items | Status | Action |
|---|
| Household | Address | Items | Status | Label |
|---|
No labels printed yet.
Needs Attention
| Household | Issue |
|---|
Price Watch — NTUC
Checks NTUC's grocery & household prices and compares them against what EDE currently charges for the matching item, so pricing can be adjusted with a clear reference point.
Live data - a daily automated job checks FairPrice prices for tracked products. "Our Price" shows as — until a product is matched to an EDE SKU.
| EDE Product | Size | NTUC Price | Our Price | Difference | Last Checked |
|---|
Marketing — Engagement & Follow-ups
Households ranked by days since their last order — reach out before they lapse. Follow-up opens a pre-filled WhatsApp message to the household.
| Household | Last Order | Days Since | Status | Follow-up |
|---|
Marketing — Sent Campaigns
Jul–Aug 2026 · campaign emails sent to households in this cycle
| Subject | Type | Sent | Recipients | Opens | Clicks | Open Rate |
|---|
Seeded demo data — once Gmail or HubSpot is connected, this pulls real send history instead.
Marketing — Content Library
Actual subject lines and message copy for every automated email and WhatsApp touchpoint, organised by journey stage.
Products
| Photo | SKU | Name | Category | Size | Price | Audience | |
|---|---|---|---|---|---|---|---|
| Loading... | |||||||
Edit Product
Members
Real customer accounts, not staff or team. Search by name, email, or mobile to look up wallet balance, transaction history, and account status for any member.
| Name | Mobile | Status | Wallet | Member since |
|---|
Analytics & Clarity Insights
Weekly UX/behavior snapshot pulled automatically from Microsoft Clarity for uat.edeclub.com, plus prioritized suggestions. New snapshots land here every Monday.
Snapshot history
| Week of | Sessions | Distinct users | Avg scroll depth | Rage / dead clicks | Script errors |
|---|
Post-purchase feedback
Ratings and comments from the post-purchase micro-survey on the member dashboard order history.
Team
Dashboard staff accounts and roles. Only admins can see and use this page — everything here runs through a server-side check, not just hiding the tab.
Security
Automated weekly scan of app dependencies against the public OSV.dev vulnerability database. Only admins can see this page — like Team, it's backed by a server-side check, not just a hidden tab.
| Component | Version | Status | Findings | Last checked |
|---|
Not covered by this automated scan: Deno's standard library (pinned at 0.168.0). It isn't published to a CVE-queryable package registry, so rather than falsely claiming it's "scanned," it's tracked manually — last reviewed 22 Jul 2026, kept pinned intentionally since 3 production Edge Functions depend on it and bumping risks behavior changes for low marginal benefit.