Mass Item Purge (EZ Populate)

[JJDoench]

Have you tried a file compare using Excel? You can dump your EP file, and compare the item numbers to the current list from your distributor. Then you just set the missing items to status 9 in EP. I did it after our year end inventory, so I wouldn't be carrying around dead weight in my db. I think it also deleted the images for me...

I used this Excel tutorial I found online:

http://office.microsoft.com/en-us/ex...039151033.aspx

Good luck!

Jessica
Best Friends Quilt Shoppe
www.bestfriendsquilts.com

[schoolboy]

Have you tried a file compare using Excel? You can dump your EP file, and compare the item numbers to the current list from your distributor. Then you just set the missing items to status 9 in EP. I did it after our year end inventory, so I wouldn't be carrying around dead weight in my db. I think it also deleted the images for me...

I used this Excel tutorial I found online:

http://office.microsoft.com/en-us/ex...039151033.aspx

Good luck!

Jessica
Best Friends Quilt Shoppe
www.bestfriendsquilts.com

Seems like a good procedure - well done for alerting us Jessica!

And yes... v_status=9 will delete the image as well, I believe...