Delete products, which have never had orders or sales, and are disabled for more than 3 months.

[edgarveloso]

Hello.

I need delete products, which have never had orders or sales, and are disabled for more than 3 months.

The "img" folder has more than 150 Gb. I already have a script that deletes images that the product does not exist.

I need a query to find disabled products older than 3 months and delete them in the remaining tables.

Does anyone have any tips?

Prestashop 1.6.1.7

Edited February 24, 2018 by edgarveloso (see edit history)

[edgarveloso]

solved

Edited February 24, 2018 by edgarveloso (see edit history)