Lots of SKUs? How GWA Auto Parts analyzes its extensive product catalog

The challenge

Keeping track of 550+ unique products across Amazon isn’t easy. For Florida-based GWA Auto Parts, which sells everything from ignition coils to window switches, running a basic analysis on sales trends meant manually downloading as many as half a dozen reports per week. 

It was a painstaking process. Manually combining the reports took 1-2 weeks. If an employee forgot to pull even one report from Amazon, or if Amazon itself corrupted any of the data, all the information lost its value.

The solution

Every single day, Intentwise automatically downloads every single report that Amazon offers through its APIs. The Intentwise Analytics Cloud automatically unifies data from advertising, retail, inventory, sales reports, and more into a single, always-refreshing dashboard. 

Through Intentwise, GWA Auto Parts tied its advertising and sales data together with data on product reviews, products frequently bought together, return rates, and more. It built a rich, multi-dimensional view of its catalog, with no manual intervention necessary. 

From there, GWA connected workflow software to Intentwise Analytics Cloud, and set it up to issue alerts when a product’s return rate hit a certain level or when the average star rating began dropping. 

If not for the frequency and reliability of Intentwise’s data stream, setting up a workflow would not have been possible. “I definitely would consider it a game changer,” said Gregg Alper, founder of GWA Auto Parts. “What it’s allowed us to do is shift our time, resources, and thinking efforts into other areas of the business.”

For instance, the company could then use that data to make informed decisions about which products to cut and keep. The decisions would have been far hazier without Intentwise. After all, with your profitability numbers, ad performance, return rates, and more all in a single dashboard, it’s much easier to sleuth out products that aren’t pulling their weight.