SQL for Listing all Products with Stock Numbers

[crabacle]

I admit to being a little poor navigating around the zen-cart database. Hence the dummies question.

What's the SQL please for listing all of the products with the product names with the numbers of each product - ie a simple stock list.

The 'Low Stock' report basically does this - but I want to run it from PHP-Admin so that I can get hold of the output as an excel sheet.

If anybody can help then please put me out of my misery.

Thanks!

[crabacle]

Come on - somebody must know this?

Please!!

[Ajeh]

Browse the products table ... or pull just the fields you need from it ...

I really am not sure what it is that you are asking for here ...

If you want just what is in the Low Stock report then use the select statement that is in there by just translating the constants to your real table names ...