Delete all disabled products at once

Hi after i hade a time out wen deleting the category there is some left over products hanging around my store

how can i delete all disabled products? how can i do it from mysql ore is there some way?

Best Regards


Have you tried when logging in to admin area on the right you will see a disabled link in product Inventory. Clicking on the link it will show them and than select all and delete

yes that works but slowly i was hoping for somthing faster :o) i have about 7k off disabled i need to get rid off.

i think ill just take 500 at one time untill i am finnished :-S

Someone has to know a Msql command for that like

DELETE FROM table_name

WHERE some_column=some_value