If you have a lot of products that need to be removed from your dataset, I would ask someone to do it for you. 

Adept tools could do it. I am sure that there are other reputable data experts that could also do it.

(I am not connected to Adept)

Hi Ken, thanks for recommendation. However it isnt just a case of getting rid of a batch of product codes. Its that even streamlined as much as we can, we still need far more capacity than the recommended 20000 product codes.  Essentially we need to operate with 80-100k product codes as a minimum.  At that level Sage 50 doesnt operate well in the products list. ie you cant filter or delete records as Sage crashes.  So over time the amount of products constantly increases.  Essentially we need something to handle way more product codes than Sage 50 but we are not big enough for Sage 200 & Sage are refusing to even quote for Sage 200!

Sage 50 Accounts will fall over with  80-100k products, it sounds like you've outgrown the product.

A business partner will quote you for Sage 200, try Alphalogix

There are some rough costs on their website too.

Ian

Thanks.  I just dont get why Sage are refusing to quote us?? Admittedly we dont fit the normal criteria & are withing range on all other areas for Sage 50.  But it just isnt stable.

Not sure why they won't give you a quote but Sage doesn't sell 200 directly due to it's complex setup requirements, they use business partners to sell & support it. Alphalogix should be happy to help though 

ah that may be why I guess.  I have emailed Alphalogix already though. Thanks

There is a company on Sage Marketplace called ConnX which may be suitable.

You may have to look beyond Sage if the the Sage 200 quote is too much

Thanks Ken,  Ill take a look at ConnX too.  Im happy to look elsewhere if I need to. I just dont know where to look or where to find another solution!

We have a large number of products (17k+) on sage50 but don't encounter this issue - if you have dead/obsolete codes for products, you can clear the audit trails, make sure no units are in stock and no users are logged in, then from there you can remove them from your file. 

You would be wise to do a backup prior and a company archive to be sure and once the records are removed and deleted, run the maintenance tools to compress and reindex to help with sage running smoothly.

This is how it works for us and we haven't had any issues by doing this method to date.

Clear audit trail only removes transactions, not product codes or stock transactions.

Delete stock will remove products >> How to delete product records (sage.com)