Delete all products

In my testing, I have created many products - even crafted CSV files and imported them to test functionality.

I now need to delete all of the products so that I can start importing read data.

There are thousands of them. Is there a way to delete all of them in one go? The dashboard lists maximum 100 on a page at a time.

As far as I’m aware (although I could be wrong - I just learned about another feature today I didn’t know existed), the checkbox on the left side of the tool bar only selects what is visible on the page and does not have an option to select everything.

Have you tried selecting everything on one page, then going to the next page and doing the same, then deleting them? Does that delete 100 or 200?

Another option would be to access your MySQL database and delete them all from there.

Edit: I just played around with an idea and seems like it might work. Do note, I’m not at my computer, so it might be different with the desktop app. It might also be different in the web UI. So you’ll have to experiment.

However, looking at some test data with the mobile app, you can view all items at once (depending on which view option you’ve selected) and ticking the checkbox selects all items. I don’t have thousands of items, but do have just over 500 items and all of them were selected. You’d have to see if you can do this on the desktop app or web UI.

Hi,

There’s also an option to purge all data on Settings > Account Management

Thanks both.

@northhill, page by page was what I was using, but tedious.

@hillel, yes I saw the scary option, but worried that it would also delete settings, clients, designs, etc.

Can I also fully remove deleted items rather than just assigning them a deleted tag?

That option will delete your data but leave your settings. You can create a JSON export of your data/settings just in case.

2 Likes

Did you try using one of the apps?

I figured page by page was tedious.

Did you try using one of the apps?

No, switching between desktop and mobile can be tedious too :person_shrugging:

@JonnyTech I tested earlier today and unfortunately, even the desktop app only allows you to select 100 items at a time, similar to the web UI.

So, either manually editing your database or using @hillel’s recommendation are, unfortunately, the two quickest or easiest options.