01 / FIELD DATA SYSTEM
DOLCE & GABBANA BEAUTY · TRAVEL RETAIL MEA
Beauty Advisor Sales Tracker
We already licensed a platform for this. It could not be configured by the person accountable for the numbers, it was priced per seat, and spending more on it would not have fixed either problem. So I built the replacement. It runs on about two dollars forty per user a month at paid tiers, and at our volume it costs nothing, so there was no spend to approve and no case to make. Two days to a running site on Supabase, added to the advisors' home screens from the browser rather than shipped through an app store, and piloted with three advisors and their supervisor for a week before anyone else saw it.
I had backfilled everything up to launch, then advisors came online on different dates. For a while we were both entering the same advisor's days, with no way for her to see mine. The dedup key decides whether two rows are one event or two.
| ba_name | entry_date | store | shift | sales_amount | status |
|---|---|---|---|---|---|
| Hana M. | 2026-03-14 | Cairo | Morning | 1,840 | kept |
| Hana M. | 2026-03-14 | Cairo | Morning | 2,310 | removed |
The data columns and the four-column key are the real schema. Status is added here to show what the pipeline did, and the rule shown keeps the first occurrence. Values and advisor name are illustrative. The same export arrived with 38, 38, 40 and 37 columns across four consecutive months.
Try it · pick a city, type a target, and the card recalculates. Demo data, real arithmetic.
Demo data, and it is live. Set a target and the card recalculates.

