Multi-channel ecommerce brand selling across Amazon, TikTok Shop, and DTC — with volatile demand patterns and no existing forecasting system.
HODL 21 was selling across multiple channels — Amazon, TikTok Shop, and direct-to-consumer — each with wildly different demand patterns. TikTok Shop in particular introduced extreme demand volatility, with viral moments driving sudden spikes that were impossible to predict using traditional methods.
The brand had no forecasting system. Inventory decisions were made reactively, based on gut feel and whatever data was most recently visible in each platform's individual dashboard. There was no unified view of demand across channels, no safety stock calculations, and no reorder point logic. Sales data lived in Amazon Seller Central, TikTok Shop analytics, and Sellerboard — three separate systems that didn't communicate with each other.
The result was predictable: stockouts on fast-moving items, overstock on slow movers, and no visibility into when the next crisis would hit. The founder was spending significant time manually monitoring inventory instead of focusing on growth.
Built a centralized data infrastructure that pulled sales, inventory, and order data from Amazon Seller Central, TikTok Shop, and Sellerboard into a single master sheet. Normalized data formats, naming conventions, and time periods so all channels spoke the same language — eliminating the manual reconciliation that was consuming hours each week.
Designed and implemented a forecasting system that accounted for the unique demand characteristics of each channel. Built velocity calculations with ABC segmentation, factoring in TikTok Shop's demand volatility alongside Amazon's more predictable patterns. The system provided forward-looking demand projections rather than backward-looking sales reports.
Implemented safety stock calculations and reorder point logic tailored to the brand's supplier lead times and multi-channel demand profile. Built stockout risk alerts that flagged at-risk SKUs before they ran out — giving the team enough lead time to act rather than react.
Delivered a fully functional Google Sheets-based master workbook with integrated forecasting, inventory position tracking, and automated calculations. Built for the team to use day-to-day — not a one-time deliverable that sits in a folder, but a living operational tool that drives decisions.
If you're managing multiple sales channels without a unified forecasting system, let's talk about building one that actually works.
Book a Discovery Call →