inventory listing of all products with quantity

[bluecivic21]

is there a contrib where I can see all my products with the quantity remaining, it can be a 1 page listing if thats simple. can someone even post me the sql statement so I can try it out

[ryanf]

get all products and modify it a little to also show the quantity left next to the name. Shouldn't be too hard.

 

Ryan

[bluecivic21]

thanks gonna take a look now

[PVK]

@ Bluecivic21

 

the sql staement you wanted looks like this :

 

 

 

SELECT `products_quantity` , `products_model` , `products_status`

FROM `products`

WHERE 1 AND `products_quantity` < 1000000 LIMIT 0 , 10000

 

 

 

This does :

Output a list of products which amount on stock is below 1 million [i don't think you've got more on stock of any product B) ) and also shows those items for which the status is 1 [which is visible in your shop]

 

if you want to see your products which are oflline change the 1 into a 0

 

the 10000 number at the end is a free number.This number now displays 10000 items on screen.You can change that to whatever suits you best

 

Hope this helps you out.

It helps me every time ;)

[♥yesudo]

can also try this:

 

SELECT pd.products_name, p.products_quantity

FROM `products` p, `products_description` pd

WHERE p.products_id = pd.products_id LIMIT 0 , 10000;

[♥yesudo]

this thread made me think(not always good).

 

So i released this:

 

http://www.oscommerce.com/community/contributions,2309

 

please add to it if you can.

 

thanx.