16 Aug 2026
17 Aug 2026 19:04
17 Aug 2026 20:23
·
Stock master pulled 2026-08-17 19:04, 0 min apart from the daily feed — 1 store-SKU stock figures differ (+8 packs). Listed-but-unstocked stock levels come from the older file.
40
▼ -38%
= 240 · pack of 6 ·
+11%
548
· 3,288
124
· 73%
87
of 124
0.325
1.949
no data
—
Promo ÷ Base
| · | ||||
|---|---|---|---|---|
| EW Lemon (995657) 1 Aug – 16 Aug · 117 · avg 14.3d · pack 6 | 282 1692 | 0.169 1.011 | — | — |
| EW Grapefruit (307395) 1 Aug – 16 Aug · 124 · avg 13.29d · pack 6 | 266 1596 | 0.161 0.968 | — | — |
| EW Grapefruit | 169 | 124 | 73.4% | 45 | 44 |
| EW Lemon | 118 | 117 | 99.2% | 1 | 1 |
Received 8,284 packs (all booked at DC 860 / 882) ·
10,576 packs now on order or in transit — 5,120 at DC, 5,456 to 19 stores.
7,400
44,400
51.3
/day
144
350
→ Aug 2027
| packs/day | → | |||
|---|---|---|---|---|
| EW Lemon | 3,678 | 25.0 | 147 | Jan 2027 |
| EW Grapefruit | 3,722 | 26.3 | 141 | Jan 2027 |
| EW Lemon (995657) | 18 (108) | 282 (1692) | 3,678 (22,068) | 117 |
| EW Grapefruit (307395) | 22 (132) | 266 (1596) | 3,722 (22,332) | 124 |
580
3,480
51.3
/day
11.3x
PSD 0.325 → 4.68
| A | B | |||||
|---|---|---|---|---|---|---|
| W1 CP1 | 5 Aug – 11 Aug | 255 | 2.06 | 8.81 (6.1%) | 9.11 (6.3%) | ✗ |
| W2 CP1 | 12 Aug – 18 Aug | 257 | 2.07 | 8.88 (6.1%) | 9.18 (6.3%) | 5/7 — |
| W3 CP1 | 19 Aug – 25 Aug | — | ||||
| W4 CP2 | 26 Aug – 1 Sep | — | ||||
| W5 CP2 | 2 Sep – 8 Sep | — | ||||
| W6 CP2 | 9 Sep – 15 Sep | — | ||||
| W7 CP3 | 16 Sep – 22 Sep | — | ||||
| W8 CP3 | 23 Sep – 29 Sep | — |
CP1 open · 0/2CP2 open · 0/2CP3 open · 0/2
0
low
mid
high
: No
Replenishment flag EW Grapefruit N, EW Lemon N (1 historical blocked record ignored) · 144 days cover · no delist signal
44 listed branches still awaiting their first delivery
45 listed-but-unstocked in total, of which 1 are Blocked or Inactive at Makro and cannot be shipped. 4 have stock on order. Counted per SKU — a branch that was never listed for a SKU is not a gap.
37 stocked stores with zero movement
1,868 packs / 11,208 bottles idle
7 stores received stock yesterday
Koh Samui 4 · Hua Hin 4 · Ban Phe 4 · Srinakarin 2 4 · Koh Chang 4 · Ramkhamhaeng 24 4 · Praeksa 4
Watch stock: 8 fast stores under 45 days cover
Pattaya 12d (PSD 1.47) · Chiang Mai 22d (PSD 2.13) · Surat Thani 22d (PSD 2.13) · Chachoengsao 24d (PSD 2.0) · Sathon 33d (PSD 1.67) · Nong Khai 34d (PSD 1.64) · Sam Sen 36d (PSD 0.79) · Phetkasem 44d (PSD 0.69)
— not reviewed
Agent must fill this in after reviewing the data
SKU
| MTD | PSD |
|---|
| PSD (per store per day) | Average packs sold by one store in one day. The single best read of how fast the product actually moves, independent of how many stores are open.一家门店一天平均卖出多少箱。不受铺货门店数影响，是最能反映真实动销速度的指标。 | 548 packs ÷ 1,687 store-days = 0.325. Bottles: 3,288 ÷ 1,687 = 1.949.548 箱 ÷ 1,687 店日 = 0.325。瓶：3,288 ÷ 1,687 = 1.949。 | Sales By Item Loc - Daily, Day 1..N columns; denominator built from first_seen.csvSales By Item Loc - Daily 的 Day 1..N 列；分母来自 first_seen.csv |
| Store-day / days on shelf | One store having the product available for one day. Not a shelf-life or expiry figure.一家店有货可卖的一天。跟保质期完全无关。 | For each store: cut-off 16 Aug 2026 − that store's FIRST delivery date + 1. Summed over 124 stocked stores = 1,687; average 13.6 days. When several SKUs are selected the store's days on shelf is the EARLIEST arrival, never the sum of the SKUs.每家店：数据截止日 16 Aug 2026 − 该店**首次**到货日 + 1。124 家已上架门店求和 = 1,687，平均 13.6 天。多选 SKU 时取**最早到货**那个 SKU 的天数，绝不把各 SKU 相加。 | first_seen.csv (append-only, maintained daily) — NOT the Last Received Date columnfirst_seen.csv（每日只增不改维护）—— 不用 Last Received Date 列 |
| Listed vs Stocked | Listed = Makro has created the item record for that branch. Stocked = that branch has actually received stock at least once. A branch that was never listed for a SKU is not a distribution gap.已挂牌 = Makro 在该门店建了该商品档案。已上架 = 该门店至少收过一次货。某 SKU 压根没在该店挂牌，就不算铺货缺口。 | Listed = Item Status is non-blank. Stocked = has a first-delivery date. Counted per SKU, then combined: 45 branches are listed but unstocked, 1 of them Blocked/Inactive, so 44 are actionable.已挂牌 = Item Status 非空。已上架 = 有首次到货日。逐 SKU 判定后合并：45 家已挂牌未上架，其中 1 家已封锁/停售，故可开发 44 家。 | Sales By Item Loc - Current: Item Status, Blocked for ReplenishmentSales By Item Loc - Current 的 Item Status、Blocked for Replenishment 列 |
| Genuine Makro branch | A real retail branch that can sell to shoppers. The raw file mixes in distribution centres, fulfilment nodes, virtual stores and duplicate records.能对顾客卖货的真实零售门店。原始文件里混着配送中心、履约节点、虚拟店和重复记录。 | 290 location records filtered to 169. Removed: 9 siamfrozen, 26 unnamed, 30 system, 3 duplicate, 53 unknown.290 条 location 记录过滤为 169 家。剔除：siamfrozen 9 条、unnamed 26 条、system 30 条、duplicate 3 条、unknown 53 条。 | Location Name in Sales By Item Loc - Daily, matched against the retail-branch name prefixSales By Item Loc - Daily 的 Location Name，按零售门店名前缀匹配 |
| Day-over-day vs same weekday | Two different comparisons. Day-over-day compares yesterday with the day before, which mixes weekdays and weekends. Same-weekday compares like with like and is the one to read as a trend.两种不同的对比。日环比拿昨天和前天比，会把工作日和周末混在一起。同星期对比才是同类比同类，看趋势要看这个。 | Yesterday was a Sunday: 40 packs. Previous day 64 → -38%. Same weekday one week earlier (9 Aug) 36 → 11%.昨天是周日：40 箱。前一天 64 → -38%。上周同一天（9 Aug）36 → 11%。 | Day columns of Sales By Item Loc - Daily; weekday derived from the calendar dateSales By Item Loc - Daily 的 Day 列；星期由日历日期推出 |
| Days of cover | How long current stock lasts at the recent selling rate. Reported twice because there are two legitimate denominators.按近期销售速度，现有库存还能卖多久。给两个数字，因为有两种都成立的分母口径。 | Rate = last 3 days ÷ 3 = 51.3 packs/day. Store stock only: 7,400 ÷ 51.3 = 144 days (Jan 2027). Including on order & in transit: (7,400 + 10,576) ÷ 51.3 = 350 days (Aug 2027). Makro's own portal figure uses its own sales basis and will differ.速度 = 近 3 天 ÷ 3 = 51.3 箱/天。仅门店在库：7,400 ÷ 51.3 = 144 天（Jan 2027）。含在订/在途：（7,400 + 10,576）÷ 51.3 = 350 天（Aug 2027）。Makro portal 自己那个数用它自己的销售基准，会不一样。 | EOH Qty and On Order + In Transit Qty from Sales By Item Loc - CurrentSales By Item Loc - Current 的 EOH Qty 与 On Order + In Transit Qty 列 |
| DC model / the 328 pack difference | All receipts book at distribution centres 860 / 882, never at branches, and branch-level Receipts is always 0. Nothing in this data tracks DC-to-store transfers, so a gap between receipts and (branch stock + sales) is transit lag, not a loss.所有收货都记在配送中心 860 / 882，从不记在门店，门店层 Receipts 恒为 0。这份数据里没有任何字段追踪 DC 到门店的调拨，所以收货减（门店库存 + 销量）的差额是运输在途，不是损耗。 | 8,284 received − (7,400 on hand + 548 sold) = 328 packs, 4.0% of receipts. All three figures come from the same file at the same instant.8,284 已收 −（7,400 在库 + 548 已售）= 328 箱，占收货量 4.0%。三个数字取自同一份文件的同一时刻。 | Receipts Qty YTD, EOH Qty, Net Sales Qty YTD — all from Sales By Item Loc - CurrentReceipts Qty YTD、EOH Qty、Net Sales Qty YTD —— 全部来自 Sales By Item Loc - Current |
| NPD retention target | Makro's new-product retention rule: 145 packs per store per month, judged at three checkpoints. Passing any one checkpoint keeps the listing.Makro 的新品留存规则：每店每月 145 箱，分三个节点考核。通过任一节点即保留货位。 | Required chain rate = 145 × 124 stores ÷ 31 days = 580.0 packs/day vs current 51.3 = 11.3× short. Evaluation weeks run Wednesday to Tuesday from 5 Aug 2026.达标需要的全链速度 = 145 × 124 家 ÷ 31 天 = 580.0 箱/天，当前 51.3，差 11.3 倍。考核周为周三至周二，自 5 Aug 2026 起算。 | Target from the CP AXTRA retention scorecard (buyer document), volumes from the daily sales feed目标值来自 CP AXTRA 留存评分表（采购方文件），销量来自每日销售数据 |
| Pack and bottle | Every quantity in this report is packs unless it says bottles. pack of 6.本报告所有数量除标明「瓶」外，一律是箱。pack of 6。 | Bottles are computed row by row as packs × that row's own Makro Unit, then summed. A total is never multiplied by a single pack size, because pack size can differ by SKU.瓶数逐行计算为「箱数 × 该行自己的 Makro Unit」后再求和。绝不用总量乘单一规格，因为不同 SKU 规格可能不同。 | Makro Unit column of Sales By Item Loc - DailySales By Item Loc - Daily 的 Makro Unit 列 |
| Subclass rank / amounts | Where our product sits against the rest of the sports-drink subclass inside each store, and the baht value of stock.我们的产品在每家店运动饮料小类里的排名，以及库存的泰铢金额。 | Taken as published by Makro, not recomputed. This feed is pulled at a different moment from the sales feed, so ranks and sales can be a few hours apart.直接采用 Makro 公布值，未自行重算。该数据与销售数据的拉取时刻不同，排名和销量可能相差几小时。 | Sales Participation - Rank reportSales Participation - Rank 报表 |
| Three timestamps | The report separates when the data was generated, when it was pulled, and how fresh the sales are — they are three different things.报告把「数据生成时间」「拉取时间」「销售数据新到哪天」分开显示 —— 这是三件不同的事。 | Makro data cut-off: 16 Aug 2026 (sales are complete through this date). Pulled from the portal: 17 Aug 2026 19:04. Page built: 17 Aug 2026 20:23. Sales are always at least one day behind, because Makro finalises a day overnight.Makro 数据截止：16 Aug 2026（销售数据完整到此日）。从 portal 拉取：17 Aug 2026 19:04。页面生成：17 Aug 2026 20:23。销售数据永远至少滞后一天，因为 Makro 隔夜才结算当天。 | Download Date header row of each report各报表表头的 Download Date 行 |
- No independent sales confirmation exists in this pack. Net Sales MTD, Net Sales YTD and the day columns all come from the same Makro system, so they agree by construction. Store-days, however, are independently reproducible from two different columns and do agree.这套数据里没有独立的销量交叉验证源。Net Sales MTD、Net Sales YTD 和 Day 列都来自同一个 Makro 系统，一致是必然的。不过在架店日可以用两个不同字段各自算出来，且结果一致。
- PSD averages the launch ramp. Some store-SKU pairs have been on shelf only a day or two, so the window PSD of 0.325 understates a settled steady state. Read it as a floor, not a forecast.PSD 平均了开店爬坡期。有些门店-SKU 组合才上架一两天，所以窗口 PSD 0.325 低估了稳态水平。把它当下限看，不要当预测。
- 16 stores in the store master share one identical coordinate pair, hundreds of kilometres from their real locations. Those coordinates are discarded rather than plotted, so the map is incomplete by design.门店主数据里有 16 家门店共用同一组坐标，与真实位置相差数百公里。这些坐标已作废而非照画，所以地图是刻意不完整的。
- Grade A/B is our own derivation from first-order quantity. It is not a Makro grade and Makro will not recognise it.等级 A/B 是我方按首单量自行派生的，不是 Makro 的评级，Makro 不认这个口径。
- The store master records first orders in cartons while the reports work in packs, and the bridge between the two units is not documented. Carton figures are therefore never mixed into any volume statement here.门店主数据的首单量以 carton 记，报表以 pack 记，两者的换算关系没有文档说明。因此本报告任何销量陈述都不混入 carton 数字。