This is a conversion problem, not a traffic problem. The store draws ~4,300–5,400 sessions/year but converts only 5–6 orders/year — a conversion rate of roughly 0.1%, far below the typical 1–3% ecommerce benchmark. Getting to just 1% on the same traffic would mean ~50 orders/year instead of 5.
Complete source transcription
PoolBestBuy — Performance Baseline (2023–2025)
Baseline of store performance pulled from Shopify Analytics, to benchmark future improvements against. Currency is THB (store reporting currency). Note: transaction volumes are very low, so treat figures as directional.
Headline finding
Sales, orders & sessions (full calendar years)
| Year | Orders | Total sales (THB) | Sessions |
|---|---|---|---|
| 2023 | 6 | 21,660 | 5,006 |
| 2024 | 5 | 6,490 | 4,331 |
| 2025 | 5 | 35,850 | 5,421 |
Note: 2026 year-to-date is 3 orders / ~THB 2,000. Net sales tracked total sales closely (THB 19,383 in 2023, THB 5,841 in 2024, THB 32,589 in 2025); refunds/reversals reduced net in 2023–2024.
Key metrics to benchmark against
- Conversion rate: ~0.1% (biggest lever — far below the 1–3% norm)
- Sessions: ~5,000/year (stable — you already have an audience)
- Orders: ~5/year
- Average order value: ~THB 3,000–4,000 (already solid; volatile at this volume)
- Best year on record: 2025 at ~THB 35,850 total sales
Top products (2023–2025 combined)
Revenue is concentrated in a few pool-chemical products:
- TCCA Granular Chlorine 50kg — ~THB 39,000 (6 units)
- EM Series Underwater Light — ~THB 13,800 (1 unit; high-ticket outlier)
- Long Lasting Chlorine — ~THB 5,100 (3 units)
Strategic takeaway
The store doesn’t have a traffic or demand problem right now — it has a “visitors aren’t checking out” problem. Before pouring in effort, confirm why conversion is so low (checkout friction, pricing/shipping, trust signals, or whether some traffic is bot/junk). Chlorine/pool chemicals are the commercial backbone; the big light sale was a one-off.
Items sold — full breakdown (2023–2025)
Units sold and total sales per product. Only items with at least one unit actually sold are listed.
| Product | Units sold | Total sales (THB) |
|---|---|---|
| TCCA Granular Chlorine 50kg | 6 | 39,000 |
| EM Series Multi Colors - Underwater Light | 1 | 13,800 |
| Long Lasting Chlorine | 3 | 5,100 |
| Maxi Clear Skimmer Tablet 125g | 4 | 800 |
| Metal Magnet 1ltr | 1 | 870 |
| pH Minus | 1 | 700 |
| SHOCK AND SWIM | 1 | 650 |
| Eyeball wall return 2” (concrete pool) | 2 | 640 |
| pH UP 2kg | 1 | 300 |
Commercial priorities
Planning items from the Power BI report.