Delete Products under tools on multisite setup

I’m going to then reimport using this tool, they say to export your /es store using this paid addon.
https://woocommerce.com/products/product-csv-import-suite/

Then using libre office to make any changes so no corruption will occur.

Excel has a habit of applying it’s own custom formatting to CSV files for things like dates or numbers. This can sometimes lead to corrupting the information. I’m not sure if that is the case here, but if you continue to have trouble I would recommend using something like Google Sheets or Open Office instead to edit your CSV files.

As for your question:

I don’t want to delete the products in My Sites – es setup

If this “ES” site is a separate site, then no you wouldn’t impact it. If you are using third-party plugins to create different front ends of your site for things like different languages, then yes those would be impacted. In those cases typically everything shares the same database. The exception would be if whatever third-party plugins you are using is cloning your products, so multiple copies exist. In that case you could selectively delete one product while keeping the other, but you’d need to do that manually. I would recommend checking with the developer of any plugins you are using to add the extra “sites”.

As for your question about deletion. There isn’t a tool in WooCommerce to mass delete products, aside from doing a bulk-edit on the “Products” page.

There are some third-party plugins that will mass-delete products. These typically work by doing a SQL query on your database to remove the products.

Hi Phil,

Yes I’m using wp multisite for each installation and Multilingual press so I can have separate languages and products for our UK store, it works a lot better for SEO.

Yes it does share the one database but has separate tables for each site install, that’s why I wasn’t sure if the Woocommerce tools would delete all the products or just the products for the UK multisite install.

I can’t even manually delete them from the products tab as they are not showing. Option1 would be to move site and delete and see, I checked the https://woocommerce.com/products/product-csv-import-suite/ demo site by importing products without editing the CSV file and this was ok. So maybe I will need to use third part tool to delete the products.

Thankyou for your detailed comments

Yes it does share the one database but has separate tables for each site install, that’s why I wasn’t sure if the Woocommerce tools would delete all the products or just the products for the UK multisite install.

I’d recommend checking with the MultilingualPress team, as I’m not sure how they structure these modified database tables. I assume they just append their own custom table. If so, then using third-party deletion tools like I recommended shouldn’t impact them. It’s best to be safe and check first though.

If the same CSV imported without errors, then it would indicate that something on your site is corrupting the data. That could either be a corruption in the database already that is impacting the newly imported info. Or it could be code on your site (a theme or plugin) impacting the data as it’s imported.

I’d recommend trying to temporarily switch to the default Twenty Twenty theme, then disable ALL plugins except WooCommerce. Once you’ve done that, try to import your products again from the “Products” tab.

Hi there,

We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

Kind regards,