News & Events

This Week in IDEA | December 2, 2009

Our eNewsletter, This Week in IDEA, keeps you informed with the latest news and education about IDEA, our solutions and services, and our customers and partners. IDEA’s knowledgeable staff and other contributing writers share insights, resources and special offers to help you Unleash the power of e. Subscribe now to receive This Week in IDEA in your email inbox every other Thursday and add our RSS feed to your reader.


Subscribe to This Week in IDEA

New IDEA IDX, IDW and IRD Customers

IDEA announces one new IDEA IDX, IDW customer and 42 new IDEA IRD customers. Read more about these companies and how you can begin trading with them electronically to expand your business.

New IDEA IDX and IDW Customer

Mission Controls & Supply, a distributor from San Antonio, TX, became an IDEA customer on November 19, 2009. Mission Controls provides a full range of motor controls and electrical products to customers in the industrial, manufacturing, construction, pharmaceutical and energy sectors. They will take advantage of the cost savings and reliability of Industry Data Exchange (IDX) to trade their B2B documents and will rely on Industry Data Warehouse (IDW) for their product and pricing needs. Find out more at Welcome aboard!

New IDEA IRD Customers

IDEA, a 1SYNC Data Pool On-Board Solution (OBS) partner, implements suppliers that subscribe to the 1SYNC data pool using IDEA's IRD CERICOMX® application. IDEA was recently assigned 42 suppliers:

These companies will be trained to use IRD CERICOMX®, an IDEA branded product for supporting and uploading supplier product information into the GS1 Registry® and GDSN via the 1SYNC Data Pool.

If you would like to find out more about the CERICOMX® product, please contact , Product Sales and Customer Support, at .

Tags for this post: idw customers idx ird

Back To Top

Manufacturers Claim the IDW Utilities Workstation is a “Huge Time Saver”

IDEA released the production version of the Industry Data Warehouse (IDW) Utilities Workstation this Monday, November 30th. This new data editing tool within IDW gives manufacturers the capability to quickly search and edit product data or correct minor data entry errors on-the-spot.

The workstation provides manufacturers with a higher level of efficiency and access to product line data management. Both the data editing and error correction functionalities are designed to help product data managers make quick fixes when product attributes have changed, or when they notice a mistake within their main data loads.

“The new IDW Utilities Workstation is a huge time saver. The tool is extremely user-friendly, making it easy for me to search and navigate to the specific field that needs to be corrected,” said Barbara Prince, Pricing & Quotations Manager, Thomas & Betts. “Our internal data management processes are strong but minor mistakes can still occur. It’s reassuring to know there is a solution available to quickly fix those errors without interfering with our internal systems.”

Data Editing

The Utilities Workstation gives manufacturers the ability to edit individual field values within their product data while bypassing their lengthy EZView or EDI data loading routine. For example, price changes to a specific class of products can be completed very quickly using the workstation search and edit tools (see example screenshot below).

Error Correction

The workstation also provides an interface for quickly managing data entry errors identified during the EZView or EDI data loads. The cause of the errors or error type can be searched, reviewed, edited and resubmitted within the workstation interface. For example, if a manufacturer receives a Pricing Zone Code error message from their data load report, that error will be stored and searchable in the workstation. Once you are ready to make a correction, you can edit the data for the individual field or entire column (see screen shot below).


The Utilities Workstation is available to all manufacturer users of IDW at no additional cost and the step-by-step user guide is located on the IDEA Portal under Training > IDW > User Guides. The upcoming training dates and times are Thursday, December 10 and 17, 10:00 AM and 2:00 PM EST. Individual and group training sessions can be scheduled by contacting , Manager Data Synchronization Platform at .

Tags for this post: idw news manufacturers utilities workstation data edits

Back To Top

Nicole Turch Joins the IDEA Team

Nicole Turch, formerly of Unified Industries Incorporated (UII), has joined the Data Synchronization Platform team as a Data Quality Analyst. Turch will monitor and manage all activities and processes that impact the quality of data available to IDEA customers. She will work with manufacturers, distributors and software providers to help resolve data quality issues and define and execute strategies to improve data quality.

Turch brings over 18 years of data analysis and quality assurance management experience to IDEA. She spent nine years managing data quality assurance personnel and assisted in the requirements definition, design, development and testing of software relating to the execution of the OHIO, SEAWOLF, and LOS ANGELES class submarine configuration audits.

Nicole can be reached at or . Welcome to the IDEA team!

Tags for this post: idw employees

Back To Top

Spotlight Article: Manufacturer/Distributor Study Reveals Distributor Data Requirements and Manufacturer Capabilities

By: Denise Keating, President, DATAgility and Angela Baraks, Director Data Sync Services, DATAgility

Poor Quality Data is often a silent gas guzzler, leaking precious profits and reducing operating efficiencies. But because no one complains too much about it, it is often ignored. Distributors have demanded high quality data in the past, but no one really understood the data requirements. Shortly after the 2008 IDEA E-Biz Forum, IDEA commissioned DATAgility to conduct a study to clarify the data requirements of distributors and gather information on what is important to them collectively. The study also assessed manufacturers to find out exactly what data they can provide distributors today and what is on the horizon for the future.

Background of the Study

Eighteen distributors and sixteen manufacturers participated in the study. The sample represented IDEA customers from various company sizes, structures and geographic regions. The manufacturers also represented the key business segments of the electrical industry including: electrical systems, lighting & lamps tools, and power generation.

Each distributor participant filled out a questionnaire about the data requirements they need to run their various business systems including procurement and web selling environments. Distributors could select from the following criteria: Mandatory, Helpful, Future or Do Not Need.

Manufacturer participants were given a similar questionnaire with the data fields listed and could select from the following criteria: Available, Not Available or Future Enhancement. “Available” is defined as data that is readily accessible within their current system to retrieve and send to Industry Data Warehouse (IDW).

Distributors and manufacturers were interviewed to elaborate on the questionnaire and shared further details about requirements and capabilities.

Key Findings from the Study

What distributors need:

The distributors said it’s time for manufacturers to expand their data beyond transactional fields and begin providing marketing data to drive web selling and counters sales. All distributor participants strongly stated the following data is required to drive sales growth in 2010 and beyond:

1. The United Nations Standard Products and Services Code® (UNSPSC) is more granular than the traditional legacy codes, and distributors will use it as their primary taxonomy
2. Product Descriptions must be meaningful and fit into the distributor’s purchasing and selling systems
3. Uniform attributes need to be applied to each product category (UNSPSC)
4. Images need to be supplied for all web oriented products

The study revealed that the top 75% of fields required by distributors are transactional data fields needed to run their business systems. In a cross analysis between the distributor requirements and the manufacturer fulfillment, it was evident that the majority of manufacturers are providing the required transactional data, but the perception of the distributors is that the quality of the data does not meet their needs. Quality data consists of measurable factors including: accurate, consistent, timely, complete, easy-to-use, standardized and synchronized. One distributor mentioned that having 900 images for a 10,000 item product line is just not enough.

What manufacturers can provide:


The industry identified the UNSPSC taxonomy for use in the electrical channel and is now mandating that every product in IDW must have a valid code assigned by December 31, 2009. The manufacturers were supportive of the initiative to move towards fully adopting the UNSPSC to be used by the distributors for their taxonomy. UNSPSC allows the channel to move towards an open standard available worldwide.

IDEA plays a unique role in the development of the electrical portion of the UNSPSC table which allows them to be responsive to the marketplace. IDEA is currently offering an assistance program powered by DATAgility, to help manufacturers assign the codes to meet the rapidly approaching deadline. The Electrical Industry Attribute Schema can be fully utilized once the manufacturers have their UNSPSC codes assigned. The attribute schema was published in October and is the first of its kind in any industry. The schema was a collaborative effort by the IDEA Standards Committee, DATAgility and Unilog. It provides the framework for the key product data attributes that should be populated by the manufacturers. The lowest level category of the UNSPSC is the basis for the schema.

Product Descriptions

One area that was brought up by many of the distributors was the consistency and reliability of the data populated in certain fields. For example, the industry data standard “Invoice Description” has a standard character maximum of 80 characters; however, distributor systems have a range of 24 to 40 characters available for their Invoice Product Descriptions. The manufacturers don’t have the same character limitations and most surveyed were not aware of the distributor system limitations that require shorter descriptions.

Placeholders in the industry product data standard currently allow for a 24, 35 and 250 character description which covers all the various distributor description requirements.

One manufacturer brought up a very interesting point about sending data via EDI. They mentioned that there is a kilocharacter cost and although small, it can really add up if you are sending more data than is needed. Cleaning up the descriptions may reduce characters across several transactions (Purchase Order, PO Acknowledgement, Invoice, etc.) which would reflect in an immediate and repeated cost savings.

Marketing Material & Catalog Data

Virtually all of the distributors in the study have immediate needs for marketing product data to support their web selling and advanced eCommerce programs. Many currently get this data directly from their suppliers or from other data services. Several distributors stated that other data sources would not be needed if they could acquire all the marketing data through IDW.

A review of all the manufacturer participant websites showed rich, robust data including: specification sheets, images, MSDS sheets, instruction manuals, catalog sheets, product selection guides, etc. Product images, standardized attributes (as found in the Electrical Industry Attribute Schema) and a number of other digital assets were identified as critically important to the distributor’s business systems. Manufacturers surveyed at the time were not able to supply marketing data to their distributors to the level of population demanded. Only 31% of the manufacturer participants had the MSDS, image, and specification URLs available in their system.

IDEA is working to bridge the gap between manufacturers and distributors by offering an assistance program to populate the supplier data with URL information that is currently on their website or within other sources.

Looking Ahead

The 2009 IDEA E-Biz Forum continued the efforts set forth in the previous year with the theme “Guide Change by Leading Change”. IDEA will continue to offer solutions to fit the growing needs of their customers and the electrical marketplace. Studying the current landscape of the technological needs of distributors will lead to enhancements in IDW and programs that offer assistance to manufacturers, so they can offer the valuable data needed to sell their products today. In a down economy, IDEA customers can look for ways to expand their eCommerce capabilities and increase operating efficiencies. We believe the quality data delivered will drive sales upward and keep you one step ahead of your competition. They say “time is money”, so what are you waiting for?

About DATAgility:

DATAgility, IDEA’s strategic partner for data management services, offers cost effective solutions that improve data quality which increases sales and reduces operating inefficiencies. Our suite of services include: DATAlignment, Data Governance Development, Data Quality Score Carding, UNSPSC Code Assignment, Attribute Building, Searchable Description Enhancement and Normalization & PIM Implementation Consulting. Managing and delivering the high quality data that your customer needs to run their business is more important than ever in this real time buying environment.

Get more education from DATAgility:

Tags for this post: unspsc standards electrical industry attribute schema datagility marketing catalog data data quality

Back To Top

December Training Opportunities: NEW UNSPSC and Utilities Workstation Training for Manufacturers!

This month IDEA continues to offer training sessions for customers online. A new UNSPSC and Utilities Workstation training will be available to manufacturers in addition to the IDW and IDX training sessions.

NEW! UNSPSC Training

The December 31st deadline to populate the United Nations Standard Products and Services Code® (UNSPSC) for all products in IDW is fast approaching and we want to make sure manufacturers have all the support they need to successfully complete the project in time. The population of these standardized category codes is essential for the industry to begin utilizing and benefiting from the first Electrical Attribute Schema. The training will walk manufacturers through how to read, review and filter the UNSPSC report delivered to their company, explain the importance of UNSPSC usage to manufacturers and distributors and provide direction on how to populate the codes in IDW for their products. December Trainings:

  • Thursday, December 10: 2:00 PM EST
  • Thursday, December 17: 2:00 PM EST

Contact your IDEA account manager or email to sign up this month.

NEW! IDW Utilities Workstation Training

The recently released Utilities Workstation is available to all manufacturer users of IDW at no additional cost and the step-by-step user guide is located on the IDEA Portal under Training > IDW > User Guides. Our product experts can help you start using this time-saving editing and error correction tool during these training dates:

  • Thursday, December 10: 10:00 AM and 2:00 PM EST
  • Thursday, December 17: 10:00 AM and 2:00 PM EST

Individual and group training sessions can be scheduled by contacting , Manager Data Synchronization Platform at .

On-Demand IDW Training

IDEA offers on-demand one-on-one IDW training sessions. The trainings are divided into two parts for manufacturers and distributors. Part one reviews the essential business elements of IDW and part two dives deeper into the application. These trainings will cover all the new IDW features that were revealed at the Forum. Niche training (e.g. net price, inbound mapping, etc.) is also available upon request.

Customers interested in scheduling an IDW one-on-one training session should contact , Data Sync Platform (DSP) Support Manager, at .

IDX Tracker Training Schedule

  • Tuesday, December 01: 1:30-2:30PM
  • Tuesday, December 08: 1:30-2:30PM
  • Tuesday, December 15: 1:30-2:30PM
  • Tuesday, December 22: 1:30-2:30PM

Times don’t work for your schedule? Contact our flexible IDX training expert, at to schedule a one-on-one training at a time that works for you.

Tags for this post: idw unspsc idx training utilities workstation

Back To Top

Need more info?

Customer Service:

View Latest eBusiness education and news for the electrical supply chain. Become an eBiz expert today! subscribe >