To delete Unused / Obsolete Product Codes:
- Do a Product Integrity Check
- Export all Products to Excel
- Delete all columns other than Code, Grp, Instock, Lastin, Lastout, Alloc, iconorder, border and poonorder.
- Sort by these columns and delete all products that have stock quantities or movement dates in the fields in above.
- Delete all columns except Code and Grp
- In Grp column replace all with ZZDELETE and save as csv file
- Create the new ZZDELETE Product Group in the live data set
- Create a Product import routine with Code and Group only.
- Backup data.
- Import the CSV file
- Check Products then run a test report on movements for the ZZDELETE Product Group to make sure nothing with any transactions has slipped through and amend where necessary.
- Install Bulk Product Delete By Group utility
- Delete all products for the Group ZZDELETE (Note this may take a number of hours to run through so do at the end of the day)
For older Versions of Excel With Cap of 65,000 lines
If using an old version of excel which has a cap of 65,000 lines then
- Move the products tables to an empty data set ie: demo
- In command mode delete all products with instock <> 0
- Delete all products where “lastin” and “lastout” are not empty ie: Delete for !empty(lastin)
- Delete all products where “alloc” is not empty
- Delete all products where “iconorder” and poonorder” are not empty
- Delete all products where “border” is not empty
- Still in command mode – set talk on
- Still in command mode – count
- Note number of records.
- If still in excess of 65,000 then check the names of product groups and pick a group name midway in the range – for example if the group names are alpha then group names starting with K is about half way.
- Then count for grp<”K” and check number of records. If less than 65,000 then copy to ***.xls xls for grp<”K” and repeat procedure for grp>”J”. If the counts still exceed 65,000 then break the group ranges into smaller sizes.
- Once all products have been exported to excel files execute steps “c” through to “k” above.