Deleted (Obsoleted) Parts
The PIES Documentation says that parts should not be deleted. Instead a part should be made inactive by setting the appropriate Life Cycle Status code in the EXPI segments.
Superseded parts are marked with “Life Cycle Status Code” of 7. Obsolete parts have a “Life Cycle Status Code” of 9. There are no pop codes for Superseded and Obsolete
PIESCentral keeps track of which parts are loaded by a particular script. If a part is dropped from the script, it is marked as deleted in the history tables. Parts that are marked deleted are not exported in either a full or a net change file. They are just dropped from the output file.
The only way to keep obsoleted parts from going out to a new customer is to not include those parts in the import for that customer’s brand.
Warning. The following is for advanced uses only and should be run only after speaking with Winsby Group Support.
If part numbers were loaded incorrectly and you would like to remove them completely from the system, the attached DeleteObsoleteParts.sql” script may be run against the PIESCentral database. Remember to back up your database and keep it in a safe place. Change the Cutoff date before running the script.
DeleteObsoleteParts.sql (4 KB)