Pasta Maker Finds Right Recipe for Data

Case Study: AIPC uses Extol's Business Integrator for UCCnet Services to synchronize product information.

Things had come to a boil for American Italian Pasta Co., which has 1,500 retail items, a private label and a retail customer base that includes most major U.S. grocers.

Facing a mandate from its top retail customers, such as Wal-Mart Stores Inc. and Wegmans Food Markets Inc., to synchronize product data through standards body UCCnet Inc.s GDSN (Global Data Synchronization Network) product data pool, the companys IT department had a tough decision to make. It could send data as is through the registry and hope for the best, or it could take a hard look at cleansing the data internally before sending it to customers through the registry.

AIPC decided to take the high road, but not just because it was the right thing to do. Data errors such as inaccurate unit quantity can have a domino effect throughout customers inventory and pricing systems.

As a result, the maker of Muellers, Ronco, Pennsylvania Dutch and Anthonys food products decided it had no choice but to clean up its data internally before synchronizing it with UCCnets registry, where its customers would retrieve data through an AIPC catalog.

The company turned to software developer Extol International Inc. for a data synchronization solution. Extol provides business-to-business automation and integration software to the midmarket.

The company installed Extols Business Integrator for UCCnet Services, an application for maintaining, managing, and synchronizing trade item data internally and for synchronizing the data with retail customers through UCCnet Services.

The decision has proved propitious to date—and has illustrated for AIPC the real issues involved with its data. There is an old saying that if you throw spaghetti against the wall and it sticks, then its ready. Unfortunately, when AIPC tried this, not much stuck.

"We took a small sample of [product] attributes, got them together in the database and published them to one customer—this was the customer that was pushing us toward [UCCnet]," said Sabrina Hunter, manager of UCCnet and data synchronization at AIPC, in Excelsior Springs, Mo. "It was probably 25 items. Every single item came back with some sort of discrepancy."

/zimages/5/28571.gifClick here to read about Wal-Marts retail data warehouse, called the worlds largest.

That prompted an initial discovery phase. First, AIPC reviewed the business processes around each product. Then the company looked at its internal processes for product naming.

Hunter found 23 touch points where a decision about product item data could be made—that amounted to 23 potentially different descriptions for the same product.

"Just to clean up our data internally, we included almost every department from our company and went through a discovery phase—trying to find out about product attributes, where they came from and a way to implement accurate data and get that out to our customers," said Hunter. "That was a five- to six-month process. It was quite an effort."

Once AIPC was able to determine the life cycle for each inventory item, it could identify loopholes in the system, such as the ability to change product information without letting others know about the change.

"Pulling that together was the biggest challenge," said Hunter, who acknowledged that the eventual goal is to close all the loopholes for product data attributes in all phases—from production through promotions—with an automated workflow thats processed through Extols software.

Next Page: A whole new deal.