Retail insights

Data refreshed at 08:00 · 2026-07-07

Insights reads the nightly snapshot, not the live DB — figures can trail today's operations by up to a day.

July sales (MTD, MYR)

3,846.50

+6.9% vs Jun 1–7

June consolidation

✓ Posted

rolled into wholesale SO on Jul 1

Open consolidation (MYR)

1,337.40

July lines not yet posted

Active customers

ordered in the last 90 days

Below-floor approvals

waiting on owner

Monthly retail sales

MYR per month, Mar–Jul 2026 · July is month-to-date (7 days)

July already at 91% of June after one week — Aunty Mei's Jul 5 restock plus the Jul 6 walk-ins.

Payment mix

how the 16,494.80 MYR of Mar–Jul retail sales was settled, at snapshot

Bank transfer 9,893.90 60.0%

Cash 5,263.50 31.9%

Unpaid 1,337.40 8.1%

Unpaid equals the open July consolidation — it clears when the month is posted to a wholesale SO.

Customer book — Mar–Jul — ranked by revenue · cadence = median gap between orders · DUE TO REORDER when silent > 1.5× cadence

Customer	Orders	Revenue (MYR)	Avg price vs floor	Cadence	Last order	Status
Aunty Mei — Restoran Mei Kee	22	6,842.00	+8%	every ~9 d	2026-07-05	Best payer — always cash
Kak Ros — Gerai Ros, Pasar Borong	14	4,120.50	+2%	every ~14 d	2026-06-18 · 19 d ago	DUE TO REORDER
Mr. Tan — Kedai Runcit Tan	9	2,731.80	−4%	every ~21 d	2026-07-02	Below floor — approval pending
Puan Salmah — homestay bulk	7	1,905.00	+5%	every ~30 d	2026-05-29 · 39 d ago	DUE TO REORDER
Uncle Lim — walk-in regular	5	895.50	+12%	irregular	2026-07-06	OK
5 customers	57	16,494.80	+5% avg

Project Gaia — static mockup in Filament v3 idiom. No backend. Figures reconcile to the seeded dataset (July 7 sales 3,846.50 MYR · open consolidation 1,337.40 · June posted); Mar–Jun monthly totals are illustrative.

Widget	Source query (in words)
July sales tile	fact_retail_sales (built from retail_sale_lines): sum of line totals in the current calendar month at the 02:00 cut; delta compares the same day-span of the prior month.
Consolidation tiles	consolidation runs — June's batch was posted into a wholesale SO on Jul 1 (✓); open = sum of July retail lines not yet consolidated.
Active customers / approvals tiles	dim_customer (retail segment) with a sale in the last 90 days; below-floor = retail lines priced under the item's price floor still awaiting owner approval.
Monthly sales chart	fact_retail_sales grouped by dim_week rolled up to month, Mar–Jul; current month flagged MTD.
Payment mix donut	payment method recorded on each retail sale; unpaid = lines with no payment reference at the cut (equals the open consolidation figure).
Customer book table	dim_customer × fact_retail_sales: order count, revenue, average unit price vs the item price floor, median days between orders; DUE TO REORDER when days since last order exceed 1.5× that median.

Widget

Source query (in words)

July sales tile

fact_retail_sales (built from retail_sale_lines): sum of line totals in the current calendar month at the 02:00 cut; delta compares the same day-span of the prior month.

Consolidation tiles

consolidation runs — June's batch was posted into a wholesale SO on Jul 1 (✓); open = sum of July retail lines not yet consolidated.

Active customers / approvals tiles

dim_customer (retail segment) with a sale in the last 90 days; below-floor = retail lines priced under the item's price floor still awaiting owner approval.

Monthly sales chart

fact_retail_sales grouped by dim_week rolled up to month, Mar–Jul; current month flagged MTD.

Payment mix donut

payment method recorded on each retail sale; unpaid = lines with no payment reference at the cut (equals the open consolidation figure).

Customer book table

dim_customer × fact_retail_sales: order count, revenue, average unit price vs the item price floor, median days between orders; DUE TO REORDER when days since last order exceed 1.5× that median.

Retail insights

Retail insights — field manifest

Engine notes