WooCommerce DB remove all products

Hi there,

Thanks for reaching out!

Removing products by deleting them from the database might not be a good idea since you’d have to remove the records from wp_posts and wp_postmeta and there’s always a risk of breaking the site when operating on the database directly/via plugin like phpMyAdmin.

But the problem is that from dash board in “All products” section I do not see “screen options” to change the number of items showing per page (by default: 20 items per page and there are 600 pages).

So what is the easiest way to remove all items at a time?

With WooCommerce by default, it should be possible to specify the number of products per page from “screen options” and if that doesn’t appear on your site – I’d suggest checking for conflicts:

https://docs.woocommerce.com/document/how-to-test-for-conflicts/

When it comes to deleting existing products – there are some plugins that can be used to delete all WooCommerce products such as this one:

https://gist.github.com/mikaelz/d574457cb22f1f79f337

Once again, I would not recommend deleting products from the database directly but if that is absolutely necessary – the plugin code (the .SQL file in particular) contains the SQL queries you could use.

If that doesn’t help – you can completely remove all WooCommerce data by adding define( 'WC_REMOVE_ALL_DATA', true ); to wp-config.php file and then deleting the WooCommerce plugin.

This will remove all WooCommerce data including settings of some payment methods, your orders and pages.

I hope this helps!

Thanks for fast response, Grigaswp,

Was connected, I have not meant, to my DB thru phpMyadmin, did not find a table, gave up and wrote question in this forum. Your answer explained me that the idea to remove from DB is not good, thanks ??

Found which plugin makes this mess – WP smart import !

Without it change a number items showing per page and removed products faster.

Could you tell me good (easy to use) free plugin which I can use to import CSV or/and XML file (rally want to know free plugin)?
I think, when I get free plugin to make import easy, for more settings I would pay if I would need more.

Hi @mamandis,

I’m glad to hear you’ve found the plugin which seems to have messed up your database tables!

With WooCommerce by default, there’s this importer/exporter tool:

https://docs.woocommerce.com/document/product-csv-importer-exporter/

I’d suggest creating a sample product in wp-admin, exporting it, opening the file in Google Sheets and using the same formatting in your own .csv files.

Best regards

Thank you, @grigaswp,

I tried to import thru you told me and the same – no luck :/

From these dropshippers I can download CSV file – it should fit for every platform, but it is very messy, tried to edit but in it there is missing some fields to fit woocommerce.

Can download woocommerce xml file, but do not know how to import xml to woocommerce free – want to try XML importing.

Could you, please, tell me how to do that (import xml to woocommerce)?

Found free plugin with which I can import CSV and XML – WP all import .
Thanks for reading and thanks for answers/helpping, @grigaswp ??

Hi @mamandis,

Thank you for confirming that you’ve found a plugin for your import/export needs!

I’ll be marking this thread as solved now but feel free to create a new thread and link to this one if you have further questions.