Price Check on Aisle Nine

Price Check on Aisle Nine

Data between trading partners doesnt match up, which creates all sorts of problems – and wastes millions of dollars.

Imagine an upside-down world in which everything you say is misinterpreted or misunderstood by nearly everyone with whom you come in contact.

It wouldn’t be very fun. Imagine ordering a hamburger and getting a hot dog. Or buying a plane ticket to Syracuse and ending up in Singapore. Some days it sure feels that way, but in the automotive aftermarket, its par for the course.

Our industry is a parts industry, but its more than that. Its a data industry. Without data, parts dont move off of your shelves.

Across the industry, we have a problem with non-standardized product data. Critical information like price, quantity and unit of measure dont match up between trading partners. WDs, retailers and manufacturers dont agree on what a part number should look like (does it have dashes or no dashes?) or what a minimum order quantity is (it is one unit or one pallet?) or even what to call something (is it Chevy or Chevrolet?).

To get a better handle on the depth of this problem, the Automotive Aftermarket Industry Association (AAIA) conducted a study to determine the extent to which this data doesnt match up. AAIA asked six suppliers and six distributors to submit a “significant and meaningful” product line. The average line had about 2,000 to 3,000 SKUs. AAIA then tried to match up important items such as part description, minimum order quantity, price and part number between the supplier and its customer.

The results were disturbing. The six manufacturers, for example, provided price data for a total of 26,873 part numbers in total. More than half of those did not match records in their own customers files.

The six distributors provided information for 14,509 part numbers, 7 percent of which were not found in the suppliers files.

How can the industry embrace essential technologies like e-commerce and universal bar coding when trading partner price data doesnt match up? And remember, this study just examined “significant and meaningful” lines; the data for other less significant lines must be in even worse shape.

All of this, of course, creates purchase errors, which ultimately cost money. The Electrical Industry Data Exchange Association conducted a six-month study to determine how much these errors cost. They found that between the distributor and vendor, $170,000 is wasted for every $10 million in business done between the two. As AAIAs Scott Luckett put it, “…1.7 percent is lying around out there due to data errors….and when you apply 1.7 percent to the aftermarket volume, you get a very, very, very big number.”

Luckett should know. Hes heading up a committee that is trying to eliminate these mix ups. The Product Information Exchange Standard, or simply PIES, provides an open standard that the entire industry can use to clean its data.

Lets hope the industry gets its data in order. Otherwise, you may just end up with a pallet of product, when you really only needed one. One unit, that is.

You May Also Like

What Will the ‘COVID-Era Consumer’ Do in 2022?

The beauty of the automotive aftermarket is that the economic conditions always seem to work in the industry’s favor.

Online Shopping

Remember the tariffs? Nathan Shipley does. Back in 2019, “that’s all we were talking about as an industry,” Shipley recalled, during his “Aftermarket Outlook 2022” presentation this past November at AAPEX.

Looking back at the “Distribution Preview” in the January 2019 issue of AMN/Counterman, aftermarket leaders consistently expressed concerns that former President Trump’s tariffs – and China’s retaliatory tariffs – could disrupt aftermarket supply chains, leading to higher prices and even production interruptions. Tariffs remained on their radar in January 2020, although it looked like the aftermarket was weathering the storm.

Right To Repair, Trade Associations And You

In the fight for Right to Repair legislation, aftermarket trade groups can’t do it alone.

Veterans Can Be Heroes Off the Battlefield Too

Veterans bring an incredible amount of value to the civilian workplace, in terms of nontechnical and technical skills.

Veterans and Vehicles
What’s Really Driving The Automotive Aftermarket’s Growth?

NPD’s Nathan Shipley looks at the many moving pieces contributing to the industry’s recent spike in demand.

aftermarket growth
Strength In Numbers

The automotive aftermarket is filled with great people. In fact, many say it’s our strong suit.

Teamwork automotive aftermarket

Other Posts

Never Stop Learning

With so much internet-based training content available, it’s never been easier to expand your knowledge base.

Continuing Education
Welcome To 2035 – What Things Might Look Like

The future is what we make it. We need to start addressing technology now so 2035 becomes a bright future.

Future of Transportation
Seems Like Everybody’s Talkin’ About Electric Vehicles

Not only are people talking about EVs, but according to the latest U.S. sales figures, they’re also buying them.

Tesla Electric Vehicle
Still Time To Nominate Someone For Counter Pro Of The Year

We’ll be accepting nominations through Aug. 1.