Warehouse-to-Tour-Platform Inventory Sync (ShipHero ↔ atVenu)

A leading national concert-merch company (8-figure touring operation) tracked merch inventory in two systems that didn't talk to each other: the warehouse that physically holds the stock and the platform tour managers order through. The two drifted apart, so coordinators ordered quantities that weren't really available and ops had to edit those orders down. To keep the ordering platform accurate, a manager reconciled it by hand, opening it venue-by-venue, looking up each item, and re-typing warehouse counts to match, and after every quarterly cycle count, manually updated the platform with warehouse numbers. An earlier dashboard left blank rows nobody could identify, and at least one major artist (a multi-platinum hip-hop act) never synced at all because it was missing from a hand-maintained list.

Designed an inventory integrity workflow that compares warehouse stock against the tour-ordering platform, aligns items by SKU, separates ecommerce-only products, surfaces mismatches, and gives operators a clear action path for single-item or batch corrections. The system also replaced a hand-maintained artist list with automated account discovery so newly added artists would not silently fall out of sync.

A controlled catalog reconciliation auto-resolved roughly 72% of previously blank or un-syncable rows. A major artist account that had never synced correctly began showing accurate product names and an in-sync status, ecommerce-only rows were hidden from the tour-ordering workflow, and already-matched items were separated so staff could focus on real discrepancies instead of reviewing the full catalog by hand.