Exporting Mass Product Data From the PDW

Use the PDW Mass Product Export Utility to export large amounts of product information for products that do not exist in the Eclipse Product file yet from the Product Data Warehouse (PDW) Catalog into the Eclipse Product file. This utility saves you from having to create individual product records for each item you want to add to the Eclipse Product file.

For example, if you are a distributor that did not sell Leviton products in the past but have now started to sell Leviton products, use the PDW Mass Product Export Utility to populate the Eclipse Product file with these products instead of manually creating each product record.

Before exporting product data you need to complete the following tasks:

Define a layout for the mass product export on the PDW Mass Product Export Screen Layout Editor screen.
Map the PDW metadata items to the dictionary items in Export M

To export mass product data from the PDW:

From the Tools > Product Data Warehouse (PDW) > PDW Mass Product Exports menu, select PDW Mass Product Export Utility to display the PDW Mass Product Export screen.

Complete the following fields:

Field

Description

PDW Source

enter the PDW data source, such as Trade Service, from which you are gathering the data.

If you leave this field blank, the system displays all products from all sources.

Search Keywords

enter an indexed metadata item to select the products you want to export.

For example, if you want the system to select all products with the indexed metadata item LEV in their descriptions, enter LEV in this field.

Note: You must enter a search keyword or use the Filter hot key to narrow the selection of products. The search keyword must be an indexed metadata item.

View the product information in the following fields:

Important: The display changes based on the PDW Source you select and are the ones defined on the PDW Mass Export Screen Layout Editor screen. The following columns always display:

Field	Description
PDW ID (@ID)	The Eclipse product number.
UPC (unlabeled)	The product's UPC number.

In the Select column to the left of the PDW ID column, enter one of the following to indicate where the product record should be created:

P - List the product as a stock item in the Primary index.
C - List the product as a nonstock item in the Catalog index.
Blank - Do not create a product record for the product.

Note: If an asterisk (*) displays in this column, the product already exists in the Eclipse Product file. For such cases, you cannot export the product into the Eclipse Product file. Update the product file instead using the Eclipse Product File Update Utility.

Use the Begin Export hot key to export the data from the PDW Catalog into the Eclipse Product file, and exit the screen.

More Options for Using the PDW Mass Product Export Utility

The PDW Mass Product Export screen also offers these options.

Hot Key	Function
Filter	Displays the Filter Builder screen, which you can use to define selection criteria.
Product Maint	Displays the Product Maintenance screen for items that already exist in the Eclipse Product File. These are marked by asterisks (*).
PDW Data Viewer	Displays the PDW Data Viewer for the selected product.
Set All	Copies the value in the first column (P, C, or blank) of the selected line to all other lines that do not have an asterisk in that column.