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.

Select PDW By

Select one of the following to indicate how you want to select items for updating:

Price Line
Import Date
Effective Date

Note: If you select either Import Date or Effective Date, the system displays the Value field from which you can select the corresponding calendar date you want to use.

Include Product Data

Select the check box if you want the system to update product data.

Include Pricing Data

Select the check box if you want the system to update pricing data.

Create Update Report

Select the check box if you want the system to print an Update Report, which lists all items that changed with the update.

Create Error Report

Select the check box if 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 Create Update Report and Create Error Report fields in order to check the update for any errors.

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 File > Price Sheet Scan option to do this manually.

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 Begin to run the update and exit the screen.

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