Exporting PDW Data to the Eclipse Product File

Updating PDW Data in Batches to the Eclipse Product File

After you map your metadata items from the Product Data Warehouse (PDW) Catalog to the Eclipse Product file, use the Eclipse Product File Batch Update screen to export the data for multiple product items and update your files. This program takes the data from the most recent update of the PDW Catalog and updates the primary Product file.

On the Eclipse Product File Batch Update screen, indicate a price line and the type of update (pricing or non-pricing information).

Number Of History PDW Months During Order Entry - Enter how many months of price history should be exported to the product price sheet when a new Eclipse product record is created.
Allow Price Sheet Per Qty And UOM To Change On PDW Price Update - When doing a batch price update, this control record determines whether the system changes the price per unit of measure and price per unit of measure quantity on the product price sheet in the Product file to match the PDW.
If this record is set to Y, the system changes the price per unit of measure and the price per unit of measure quantity on the Eclipse product price sheet to match the UOM data in the PDW. For any Eclipse products that the system updates, you will need to manually adjust the average cost unit of measure for the branch on the Branch Costs screen and any UOM-specific sell matrix cells.
If this record is set to N, the pricing unit of measure on the Eclipse price sheet does not change when the corresponding PDW information changes.
Minimum % Variance To Include On Batch Update Report - Decide how the Batch Update Report includes products with price variances. For example, if a user enters a value of 10% then only product price updates with a price variance of 10% or greater would display on the report.

Run a preview before actually updating to ensure that the export is correctly set up.

To export PDW data to the Eclipse Product file:

From the Tools > Product Data Warehouse (PDW) menu, select Eclipse Product File Batch Update to display the Eclipse Product File Batch Update screen.

Complete the fields for the batch update:

Field

Description

Price Line

enter a price line that you want to update.

Use the Multi hot key to select multiple price lines for which to run the update.
If you leave this field blank, the system prompts whether you want to update all price lines. Enter Y to update all price lines or N to update only the items indicated in the item list.

PDW Update Date

enter the calendar date for which to run the update.

Update Type

press F10 and select either:

Price - Updates all pricing records in the Eclipse Product file.
Data - Updates all non-pricing records in the Eclipse Product file.
Both - Updates all records in the Eclipse Product file.

Print Update Report

Enter Y or N to indicate whether you want the system to print an Update Report, which lists all items that changed with the update.

Print Error Report

Enter Y or N to indicate whether you want the system to print an Error Report, which lists all items that did not change with the update and the reasons why.

Note: We recommend that you enter Y in the Print Update Report and Print Error Report fields in order to check the update for any errors.

Use the Preview hot key From the File menu, select Preview to generate both reports and view the dictionary items that will update for each product, along with the new values, without actually running the update.

If you are running a Price update, then the PDW Price Update Scan screen displays when you use the Preview hot key. Use this screen to verify that the correct price sheets and discount classes are being used for price lines that you are updating. Use the Price Sheet Scan hot key File > Price Sheet Scan option to do this manually.

Use the Items hot key From the File menu, select Show Items to display a list of the products to be updated.

Edit the list, if needed, by deleting any items you do not want to update.

From the File menu, select Use the Update hot key to run the update and exit the screen.

Note: You can use the Sched hot key Options > Schedule option to run the report at a later time.

More Options for Exporting Data into the Eclipse Product File

The Eclipse Product File Batch Update screen also offers these options.

Hot Key

Function

Price Sheet Scan

Displays the PDW Price Update Scan screen.

This hot key is active only when the update type is Price.

Item List

Displays the PDW Batch Update Item List screen which lists all products in the Eclipse Product file that will be updated.

Preview

Generates and displays both reports and view the dictionary items that will update for each product, along with the new values, without actually running the update.