Unable to remove products

Hi dblomster, you probably maxed out your allocated memory. I’ll post an update shortly that will work for very large Product catalogues.

Need to nuke 27,000 products, the plugin seems to be taking for ever to run to nuke them. Used this plugin before on a smaller dev store, but that was only on 2,500 products. Any ideas?

Or would the best method be running a MySQL command to remove the products?

https://www.kc-webdesign.co.uk/e_commerce/woocommerce-how-to-delete-all-products/

Cheers
Luke

Hi Luke, as simple as a delete SQL command is it leaves trash behind in the WordPress database from custom tables (e.g. woocommerce_termmeta). I’ve made a change to our Products nuke so it loops every 500 Products instead of loading all of them and then processing each one (in your case loading 27000 ID’s then going over each one). Shoot me an e-mail at [email protected] and I’ll send you an early release tomorrow morning

I’m exploring the idea of hooking up a WP-CRON that fires every minute to nuke a given dataset in loops of 500, 1000 depending on timeouts and memory limits, etc. ??

Hi Michael,

I just send an email over.

Cheers
Luke