We have a database of 24,378 products in Zoho, We are planning to sync product with Magento eCommerce. Magento will be overwriting CRM products. I want to clean the CRM of all product records before the sync begins (although, I know that deleting products that are associated with sales orders, quotes and other records will not be possible). I would like to delete all product records that are not tied to other records.
The problem I have is that when I attempt a Mass delete operation on the product database, the operation stops when it encounters a record that is associated with a sales order, quote , etc., and it will not continue. It does not flag the record that is causing the operation to stop, so I have no way of knowing which record to skip.
Unless I find another way, I would have to attempt to delete one record at a time ... 24,378 times over.
Does anyone now another way?
Thanks