Woo product table?

Hello @alexliii,

Since products are a custom post type, they will have associated entries in many of the core WordPress tables and will be more cleanly removed if you use the user interface to remove them.

To remove many products at once from the WordPress dashboard:

1. In your WordPress Dashboard navigate to your Products list.
2. Since you have many products, you can speed things up substantially by clicking the Screen Options near the top of the page and increasing the “Number of items per page” setting. Be careful about setting this very high (500+), as very large queries can cause issues depending on your server resources.
3. Next, select all the products on the page then select ‘Move to trash’ from the bulk actions menu and hit ‘Apply’. Repeat for every page.
4. Lastly, go to the Trash area an click ‘Empty trash’

If that isn’t fast enough for you, you can also find SQL instructions on the web, such as this article (not a Woo article). I recommend backing up your data before trying any direct database manipulation, and can’t guarantee SQL commands will work perfectly for your particular site (since you may have other customizations that would change the process).

I hope that helps, and don’t hesitate to reply if anything is unclear. Thanks!