Delete disabled products with cron?

[hstrom]

Hi everyone,

Every week I got a lot of products that has been set to "disabled" (not to show on frontend) when doing a sync with an offline catalogue. I would like to delete all of those products to keep the database clean and fast (I suppose). But to delete all these products (sometimes thousands) take forever doing it manually in the product catalogue.

Does someone know of a way to do this by a cron? Just delete all products that are disabled?

 

With kind regards,

 - Johan.

[joseantgv]

7 hours ago, hstrom said:

Hi everyone,

Every week I got a lot of products that has been set to "disabled" (not to show on frontend) when doing a sync with an offline catalogue. I would like to delete all of those products to keep the database clean and fast (I suppose). But to delete all these products (sometimes thousands) take forever doing it manually in the product catalogue.

Does someone know of a way to do this by a cron? Just delete all products that are disabled?

 

With kind regards,

 - Johan.

 

But these products will never be enabled again? And how many are they?

[hstrom]

Yes, these products will to 99% never be enabled again, If they are, we import the product again, as new. 

It will differ between a few hundred to 10.000-20.000 products, each week, that we disable. So without removing them, the database will contain a lot of disabled products, which in turn will burden the database a lot, I guess.