Total number of products in stock

[DigitalShadow]

Could anyone help me write a bit of code that would total up all the product stock quantities I have on the shop to tell me how many items I have in total.

for example

product 1 - out of stock
product 2 - 1 in stock
product 3 - 3 in stock
product 4 - 4 in stock
product 5 - 1 in stock
product 6 - out of stock
product 7 - 7 in stock
product 8 - 2 in stock

8 products - 18 items in stock

I'm after the total number in stock, is it possible to generate this number?

[superprg]

May be go to phpmyadmin and run

SELECT count(products_quantity) from products

[DigitalShadow]

How could I call that from the shop side so I can have a display in the admin.

[DigitalShadow]

SELECT count(products_quantity) from products

that just totals the number of individual products on the store and not the total number available

would this work?

SELECT SUM( products_quantity ) FROM zen_products

[superprg]

Yes, I mean that...sorry about putting the count :)