Delete unsaled products

jadawin · **Joined:** Fri Jan 04, 2008 10:16 am **Posts:** 16

Hi all,

i have over 150.000 products in my ERP Database, an i think there are only 1000 - 5000 products we ever sold.
Now i want to delete all products we have naver soled.
How can i do that?

greez jada

peterm · **Joined:** Wed Jun 09, 2010 2:08 pm **Posts:** 135

You may do this with a sql query like that:

Code:

select p.id,m.product_id
into temp t66
from product_product p LEFT OUTER JOIN stock_move m
on p.id=m.product_id
group by 1,2
order by 1;

update product_product set active = false from t66
where product_product.id = t66.id and t66.product_id is null;

This will deactivate all products with no stock movement at all.

Note: i have not tested this. Do not execute this query on your production database.

gdaddy · **Posted:** Wed Dec 21, 2011 7:11 pm

I would not use that SQL query if you have any services or direct delivieries as not every sale/purchase creates a stock move, only ones that go via your own inventories.