Purging Products

Use the Purge Products utility to delete all products in the Product file that have a status of Delete or Purge, as long as the products are not assigned to any control maintenance record and do not have sales history. In addition to deleting records from the PRODUCT file, the system also deletes the associated records from the PROD.NOTES, PROD.DYNAM, and PROD.PRICE files.

Before you can purge a product record, you must remove the product's sales history and flag the record for deletion. To remove a product's sales history, do the following:

Use the Merge Products utility to copy all of its data over to the product with which you are merging it.
Then assign the status of Delete or Purge to a product record in one of the following ways:
Use the Merge Products utility to merge two products, The system sets the status of the merge product to Purge.
In Product Maintenance, set the product status to Delete.

Use this topic to learn more about:

Setting a product status to Delete.
Purging product records marked for deletion.

To set a product status to Delete:

From the Maintenance menu, select Product to display the Product Maintenance window.
In the Product ID field, enter the product to flag for deletion.
In the Status field, enter the Delete status.
Save the updated product record.

To purge product records with a Delete or Purge status:

From the Maintenance > Merge/Purge menu, select Purge Products to display the Product Purge screen.
In the Select By field, select which option you want to use to base your purge: Price Line or Buy Line.
Set the price line/buy line parameters by doing one of the following:

To run the report for all price lines, leave the field blank.
To run the report for one price or buy line, in the field, enter the price line or buy line ID.
To run the report for multiple lines, use the Multi button and enter the IDs required. *Multi* displays in the field.

Set your options and run or schedule the purge.
At the prompt, confirm your request to run the program.

The system checks the flagged products to see if any of them have any current activity, on-hand quantities, or history. If a product has history, you cannot purge it. If a product is assigned to a control maintenance record, such as EDI Default Product If Not Found, the system does not purge that product. Otherwise, the system deletes all the items flagged with the Purge or Delete status. The system also deletes detail lots associated with deleted products.