Scheduled Audits Are Key to Reliable Product Data


May 4, 2022

On average, it costs $1 to verify a record as it is entered, $10 to fix it later, and $100 if nothing is done to correct it.

Every electrical distributor and manufacturer has learned the hard way that inaccurate, outdated product content costs money. Whether it’s lost orders, processing returns, or extra work for employees, you know from experience that being proactive in updating and maintaining product content saves time and money in the long run.

As a major electrical industry product content provider and EDI service, IDEA recommends conducting annual and ongoing reviews to manage and ensure accurate digital product content.

Conduct an Annual Benchmark Review

Once a year, IDEA recommends companies review key areas of product content management to identify pain points, analyze costs, and optimize staff workflows.

The results of the audit help data teams manage the availability of product information, prioritize projects, and maintain ongoing metrics to measure improvements.

Analyze Costs

Documenting overall cost estimates, including staff, technology, and error resolution enables product data teams to compare costs, adjust budgets, and fix expensive issues.

We recommend manufacturers review processes to see how many one-off efforts are made to provide product content to trading partners vs. syndicating through IDEA Connector. Document the obstacles and any other reasons for these manual efforts, then review opportunities to automate these manual processes.

Likewise, distributors should identify any manual processes that can be automated or improved.

Examine Errors

Manufacturers can cut costs and increase sales by creating benchmarks for error rate, staff resources, and the corrections process.

  • Best practice: Respond to trading partners within 48-72 hours and correct the error as quickly as possible. Document how long it takes to fix product content errors reported by trading partners.
  • Best practice: Lower error rate to 15% or less. Document error rate (the number of errors divided by the total number of items) to ensure it is acceptable.
  • Identify staff time spent fixing these errors to assign a price to error resolution.

A popular metric is the cost of an incorrect purchase order (PO). Focusing on the price of a common error enables your team to trace and correct the mistake.

Availability of Product Data

Trading partners depend on timely product content updates to sell products with accurate information and prices.

Manufacturers, upload obsolete products, price changes, and new products in IDEA Connector as changes occur. Confirm that trading partners are receiving this critical product information the next day after a change.

Distributors should review their data extracts from each manufacturer in IDEA Connector to ensure that they are updated and accessing all of the manufacturer digital content that is available. 

Conduct Ongoing Maintenance Reviews

Follow the product life cycle

Start with a pre-launch item status of I (Introductory) through the product’s end of life O (Obsolete) and removal D (Delete) from IDEA Connector to ensure end-users always have the most up-to-date ordering status.

Review product status codes and stock indicator codes

Ordering problems happen when items are coded incorrectly as active stock or quick ship when non-stock or unavailable.

Load price changes in advance

This enables the distribution channel to work with its end users for necessary adjustments.

Review your load summaries and resolve errors

When product data loads error-free, distributors easily extract it for use in their ERP/PIM and data warehouse systems.

Reference Data Management Resources

Before uploading more extensive data changes quarterly, everyone creating, gathering, or loading data should reference resource documents in the IDEA Connector Learning Management System (LMS). Resources include: Digital Marketing Content Guidelines, CAS Attribute Value Guidelines, Catalog of Descriptive Fields, Category Attribute Specification and Data Dictionary.

Download the IDEA Product Content Best Practices Guide HERE.

Related Articles

Changing Scene

  • Nominations Open for BCEA Awards

    Nominations Open for BCEA Awards

    The purpose of this award is to recognize projects that have demonstrated design and/or construction excellence, energy efficient buildings, or new uses of technology.  It is not intended that the project size (financial or dimensional) be a significant criteria for selection of the award winner.  The governing criteria for award selection should. Read More…

  • BCCA’s Apprenticeship Services Project hits $10M Milestone

    BCCA’s Apprenticeship Services Project hits $10M Milestone

    The British Columbia Construction Association (BCCA) announced today that it has now issued $10M in financial incentives to small and medium-sized construction industry employers through its Apprenticeship Services project, with $4M more still available to applicants. The project provides employer participants with cash incentives to hire and register first-year apprentices in up to 39 Red… Read More…

Peers & Profiles

  • Taken from Graybar Canada Linkedin Post Enjoy a glimpse of the wonderful moments from Graybar Canada’s recent customer appreciation BBQs! The company was grateful for the smiles and connections made with our amazing customers and vendors. They are looking forward to the next gathering! Source Read More…

  • Article taken from Linkedin Post Electrozad is thrilled to spotlight their Chatham Branch and recognize their exceptional efforts in cleaning up their community. The team took time to coordinate a community clean-up around their branch. This is a commendable initiative that not only helps maintain the cleanliness and hygiene around the branch but also contributes… Read More…