Shopra

Shopra — Unified three-tier beverage alcohol movement data: automated ingestion and normalisation of distributor data exports (VIP / Vermont Information Processing depletions, Southern Glazer's Encompass, ERP/NetSuite shipments) joined to retailer scanned-sales data, producing a modelled cross-distributor panel of shipments, depletions, retailer scans, distributor warehouse inventory, mandated store lists, last-buy and out-of-stock status at account and SKU level. The genuinely scarce derived asset is the cross-distributor schema-alignment and SKU/retailer identifier mapping layer, plus a pub…

Shopra offers (Alternative, Supply Chain, Fundamental) — Per brand client: monthly-to-daily depletion, shipment and scan records spanning that brand's distributor network — typically 10^5 to 10^7 account-SKU-month rows depending on distributor breadth (the blog's benchmark framing of 'Top 10 US beverage distributors' and 50+ location chains implies national footprints). Aggregated across the client book plus the published velocity benchmark set, order of 10^8 rows lifetime. The mapping table linking SKU to distributor codes to retailer UPCs across banners is comparatively small but far scarcer..

Alcohol depletion and off-premise sell-through measurement outside syndicated panels; distribution-point and whitespace modelling for brand expansion; demand planning and forecasting trained on shipment-versus-depletion-versus-scan gaps; out-of-stock and shelf-execution detection models; trade-spend promotion-lift attribution; entity-resolution and record-linkage model training over distributor-to-retailer identifier mapping; and text-to-SQL / agentic-analytics evaluation data from natural-language questions grounded against known correct depletion answers.

The data is with 2 years of history.

Coverage spans US; Application Software, Brewers; alternative, supply_chain, fundamental; equities.