Sweetmag Insights v2 · Multi-Channel
Overview Ads Customers AI Sidekick
📅 Last 30 days · 27 Apr – 26 May 2026
💱 MYR (base)
📍 Malaysia
Refresh
CK
Channel
All channels
Shopify
Shopee
Lazada
TikTok Shop
Live · all connectors healthy · Match coverage 96.4%
ℹ️
Cross-channel reports roll up to a Unified Product Master (§5). Current SKU/barcode match coverage: 96.4% of channel sales mapped. Review 23 unmatched listings →
Blended Revenue
RM 487,234
▲ 18.4% vs prev 30d
Orders
7,412
▲ 12.7%
AOV
RM 65.73
▲ 5.1%
Ad Spend
RM 84,120
▲ 9.2%
Blended ROAS
5.79×
▲ 0.41×
Net Margin (fee-adj)
23.8%
▼ 1.2pp vs prev
Channel Mix
Revenue share by channel · base MYR
Last 30d
RM 487k total revenue
Shopify
42.0%
Shopee
31.0%
Lazada
18.0%
TikTok Shop
9.0%
Fastest grower: TikTok Shop +47.3% MoM · driven by live commerce (3 creator-led sessions, RM 14.2k attributed)
Revenue Trend
Daily · stacked by channel · MYR
Shopify Shopee Lazada TikTok
0 5k 10k 15k
Cross-Channel Product League Table
Master SKUs rolled up across all channels · click headers to sort · top 10 by revenue
Match coverage
96.4%
# Master Product SKU Revenue (MYR) Units AOV Channel mix Margin* Growth Stock
*Margin is net of channel-specific commissions (Shopee ~6%, Lazada ~4%, TikTok ~5%, Shopify gateway fees). Showing top 10 of 247 master products.
Unified Demand Forecast · Top 1 Product
Glow Serum 30ml · next 30 days · Holt-Winters (seasonal=7) · 80% CI · marks ⓘ 11.11 calendar uplift
MAPE 8.3%
0 50 100 150 200 today → ! 9.6 mid-year sale (Shopee+Lazada) 27 Apr 11 May 26 May (today) 9 Jun 25 Jun
7d units (act)
683
30d forecast
3,140 ±340
Mega-sale uplift
+62% (9 Jun)
Method
Holt-Winters · 9.6/11.11/12.12 tagged
Inventory Health
Unified velocity across all channels
3 alerts
Oversell risk: Honey Lip Balm 4g — committed/avail = 142 units across 4 channels, combined 7-day velocity = 28/day. Coverage = 5 days. Reconcile →
Stocking out: Niacinamide 10% Serum — 8 days to stock-out, lead time = 14 days. Reorder now →
Stocking out soon
Inventory value
RM 312k
Slow / dead stock
RM 48k
SKUs at risk
12
🎯 Prioritise
Products to push · weighted: revenue, fee-adj margin, velocity, stock
Push Glow Serum 30ml on TikTok Shop
Converts 2.8× better via live commerce than blended avg. Stock = 412 units (29-day cover). Recommend RM 4k ads + 2 live sessions.
TikTok Shop Score 94 ROAS 7.1×
Vitamin C Brightening Cream — scale Shopee ads
Best-margin SKU on Shopee (28% net). ROAS 6.2×, headroom on impression share. Suggested +30% budget.
Shopee Score 88
Bundle: Toner + Sheet Mask on Shopify
Both items have correlated baskets (62% co-purchase). DTC margin allows 15% off bundle while staying above blended margin floor.
Shopify Score 81
📦 Restock
Unified demand vs supply · lead time aware
Niacinamide 10% Serum 30ml
8 days cover · 14-day lead time. ROP breached. Suggested PO qty: 1,800 units (covers lead + review + safety).
Urgent σ = 12.4/day SL 95%
Honey Lip Balm 4g
5 days cover · oversell risk across 4 channels. PO: 2,400 units. Consider temporary inventory pull from one channel to flatten risk.
Urgent 4 listings
Aloe Gel Mask 5-pack
22 days cover but 9.6 mega-sale uplift forecast = +62%. Lead time will collide. PO: 3,500 units by 30 May.
Pre-sale 9.6 cal-tagged
🔀 Channel-Fit Shifts
Same product, different channel performance
Sunscreen SPF50+ converts 3.1× better on Shopee
vs Shopify. Shopee CR 4.8% / Shopify CR 1.5%. Shift RM 2k ad budget Shopify→Shopee for this SKU.
Shopify Shopee
Retinol Night Cream — Lazada listing underpriced
RM 79 on Lazada vs RM 89 on Shopify/Shopee. Net margin after fees = 9% (vs 22% blended). Consider price-up RM 5.
Lazada Margin compression
Cleansing Foam — best fit for live commerce
Low ticket (RM 32) + high consumable repeat = TikTok Live fit. Currently not promoted. Suggested test slot 2 Jun.
TikTok Shop Test
Connector Status
Per-channel sync, token health, and match coverage · isolated failures don't break the rest (R-CONN-1)
View status page →
Shopify healthy
Last sync: 2 min ago
Token: long-lived · scoped admin app
Webhooks: ✓ verified HMAC
Match coverage: 100% (anchor)
Cost-throttle: 12% of bucket
Shopee healthy
Last sync: 3 min ago
Access token: refreshes in 1h 22m · 4h lifetime
Refresh token: 27 days remaining
Match coverage: 98.1%
Listings: 247 / 252 mapped
Lazada healthy
Last sync: 8 min ago
Token: refreshes in 4d
Webhooks: ✓ Push verified
Match coverage: 96.7%
Listings: 232 / 240 mapped
TikTok Shop partial
Last sync: 14 min ago
Token: healthy · v2 API
Affiliate attribution: ⚠ 3 orders missing creator ID
Match coverage: 91.2%
Listings: 156 / 171 mapped · 10 unmatched bundles