Purging PDW Catalog Record History

If it becomes necessary, you can delete record history from the Product Data Warehouse (PDW) Catalog.

Note: You can also use the Activity Log Purge to manage purging logs for PDW.

For example, the wrong data is imported. If an import of external data does not run properly, use the PDW Catalog Rollback Utility to delete the imported data. Or the file becomes too large. Because the PDW Catalog saves the data from each import and update, the file can become large. Use the PDW Catalog History Utility to delete the oldest data that no longer has any use.

To use the PDW Catalog Rollback Utility:

From the Tools > Product Data Warehouse (PDW) > PDW Purging menu, select PDW Catalog Rollback to display the PDW Catalog Rollback screen.

Note: If prompted, log on to the character-based system.

In the Purge Date field, enter a date that the system can use as a reference purge date when selecting the items to purge.
In the Selection Type field, select Effective Date or Load Date depending on how you want to reference the purge date:

Effective Date - The date the vendor's price is activated for use.
Load Date - Set by the system, this is the actual date the items were imported into the system.

In the Delete Data Items field, press F10 and select one of the following date options for purging:

Option	Purge
On Date	Records from only the date entered in the PDW Load Date field.
Before Date	All records with load dates that occur on or before the date entered in the PDW Load Date field.
After Date	All records with load dates that occur on or after the date entered in the PDW Load Date field.

In the Prevent Complete Deletion? (Y/N) field, enter Y or N to indicate if you want the system to safeguard you against deleting all records for a product.

For example, if you entered Before Date in the Purge Records field and N in the Prevent Complete Deletion? (Y/N) field, then all product records imported on or before the indicated date are completely deleted from the PDW Catalog.

If you indicate Y in the Prevent Complete Deletion? (Y/N) field, however, the system saves the most recent record and deletes the rest of the records for the product. Then, you do not completely delete the information for that product from the PDW Catalog.

In the Only if Synced? (Y/N) field, enter Y or N to indicate if you want the system to delete only synced records from the PDW Catalog.

For example: If you enter Y in this field, the system searches for and purges only those PDW records that are synced to an Eclipse Product File. You would delete only synced records in cases where you would no longer be updating the product, such as discontinued items.

In the Selection Options field, if needed, enter an indexed metadata item and a unique value to purge only that value from the PDW Catalog.
Use the Sources or Meta Items hot keys to enter a list of sources or metadata items to delete from the PDW Catalog.
Use the Begin hot key to run the purge and exit the screen.

To use the PDW Catalog History Utility:

From the Tools > Product Data Warehouse (PDW) > PDW Purging menu, select PDW Catalog History Purge to display the Purge PDW Catalog History screen.

Note: If prompted, log on to the character-based system.

In the Number of Versions to Keep field, enter the number of the most recent versions of PDW Catalog records to keep in the PDW Catalog.

For example: If you have five versions of PDW Catalog records and you want to delete the oldest two versions of the records, enter 3. The system deletes the oldest two versions and keeps the most recent three versions.

In the Minimum Date to Start Purge field, enter a date to indicate which records to purge, as needed. The system deletes all records loaded on or before the entered date, as well as, the record versions indicated in the above field.

Note: You can enter 0 in the Number of Versions to Keep field and indicate a date from which to run the purge in the Minimum Date to Start Purge field. The system will delete all record history on and before the date entered. Be sure that you want all of this history deleted before running the utility this way.

Use the Begin hot key to run the update or use the Schedule hot key to schedule the update, and exit the screen.