Challenge
AeroPress needed a flexible inventory solution to accurately meet their growing demand
When Shawn Wilson joined AeroPress as the Director of Operations and Supply Chain, he inherited an outdated inventory management system that couldn't keep pace with the company's rapid growth.
In his first year at the company, AeroPress expanded from four to 15 physical locations and 10x'd their product line from 13 to 200 SKUs. But managing inventory across multiple channels — including direct-to-consumer and Amazon — entirely in Excel ushered in a host of additional tasks as the company scaled.
For instance, relying on multiple spreadsheets to manage warehouse stock levels and forecast demand required near-constant manual upkeep. This time-consuming and error-prone process often resulted in accidental data gaps and unreliable updates. "I was constantly chasing passwords for different store accounts to get the data," Shawn explains. "If I missed updating a single file or messed up a single digit, all our future purchases would be affected."
To effectively support the company's growth, Shawn knew he'd have to upgrade AeroPress' existing inventory management system and improve forecasting accuracy. He started looking for a sophisticated tool to provide:
- Real-time sales and inventory data: Historically, Shawn consolidated information from 4 channels into Excel so he could gauge stock performance and track items on hand across the company's 8 warehouses. This disconnect between key data sources undermined the brand's inventory visibility and data integrity.
- Flexible reporting: As AeroPress' growing product data piled up across fragmented spreadsheets, it was up to Shawn to filter and refine every file for actionable insights. To underpin inventory decisions, he needed a seamless way to access intuitive views for every item and channel.
- Reliable demand forecasts: Apart from running labor-intensive analyses by hand, Shawn test-drove a few popular demand planning tools. However, none of them delivered accurate forecasts that he could easily adapt to the brand's needs as it introduced new products and locations.
"Our business grew significantly in 2023, but we were still running our inventory management and forecasting in spreadsheets. We needed actionable data in one place and reliable demand planning capabilities to accurately meet demand."
Solution
Benefit #1: Complete inventory visibility with centralized data
With Moselle, Shawn no longer spends "hours manually updating Excel spreadsheets to get a single stock number." Instead, Moselle automatically organizes AeroPress' sales and stock data into a comprehensive inventory summary — complete with an "item master," or catalog of every product's status. This information is sourced directly from the brand's store accounts, such as Amazon, Shopify, and Walmart, providing an up-to-date overview.
"Moselle is the single source of truth we needed to inform our purchases without gated store accounts or outdated spreadsheets," explains Shawn.
Benefit #2: Intuitive insights with automated, granular reports
Thanks to Moselle, Shawn can drill into inventory levels whenever and however he needs — down to the last SKU. He simply pulls a tailored AI-generated report. For example, he now generates weekly reports that reveal demand overall and by location, ensuring he sends "the right items to the right warehouse at the right time."
Best of all, these reports are highly customizable. In seconds, Shawn can filter by SKU, channel, location, or time frame, making it easier to evaluate how each sales channel is performing and what product lines are most popular. As a result, he backs every decision with granular, intuitive insights to fuel even faster growth.
Benefit #3: Seamless scaling with accurate demand planning
For Shawn, "Moselle's forecasts are the most reliable I've ever seen." Rather than spending hours supply planning in Excel, he leans on Moselle's advanced algorithms to generate comprehensive projections for how much inventory AeroPress needs (by SKUs and channel) to meet their growing demand.
Because these forecasts update automatically, Shawn is confident they always reflect the latest stock levels or sales dynamics. Even better, he can easily tweak any forecast to account for upcoming product launches or marketing promotions, continuously refining the ML.
"Moselle's forecasts seamlessly adapt to our scaling business," shares Shawn. "Whenever we add new warehouses, locations, or items, its algorithms factor in this new knowledge so we can meet demand across all locations and channels."
"If it weren't for Moselle, I'd still be spending hours trying to manually crunch the numbers across spreadsheets. The platform's unified views, granular reporting, and accurate forecasting are now integral to our inventory planning."
Results
Effortlessly managing 160+ SKUs across 8 channels and 15 locations
Today, all of AeroPress' sales and inventory data lives on Moselle, powering their demand planning with sophisticated, tailored reports and accurate forecasts.Â
Without manual data analysis and spreadsheet upkeep, Shawn has dedicated significantly more time to growth-oriented tasks, such as introducing new items based on customer preferences. All the while, Moselle has helped him score some significant wins:
- 0 stockouts since partnering with MoselleÂ
- 40% of their workweek saved on inventory management tasks
- 160+ SKUs managed across 15 warehouse locations
Looking ahead, Moselle's modular and adaptable platform will be a key partner as AeroPress takes on their newest market: Europe.
"Moselle has everything we need — from detailed, customizable reporting to comprehensive forecasts. It's the perfect fit for our company and its future trajectory."
