Delete all products

[luismfbsilva061980]

The problem is this,
I use PS 8.1.4 and PHP 8, so due to a stupid cron that I created to import 20k products, it was repeated N times and now I have thousands of articles and images repeated until exhaustion since the import key was the ID, so I was asking anyone who could help me with an SQL script to delete all content from the products table, images, categories, etc...

I don't have any sales or customers yet, just the settings, so it will be easier

[Daresh]

Just import an empty CSV file with option to delete all products / categories set to YES.

[b3liar]

Sorry for digging this up, but how do you actually do this? Is the basic Prestashop enough, or do you need some extra module? And where exactly do you run the import—in the back office, or somewhere else?

[JBW]

You can use
https://github.com/PrestaShop/pscleaner

(should still work in 8.2)