Report: I want to know the Quantity on hand

[gbagley]

Can someone explain how I can get a complete product listing and quantity from the database or the admin tool. Has anyone seen this? If so, please show me.

Thanks,

-gb

 

Example:

Widget1 = 10

Widget2 = 2

Widget3 = 0

[ScaleCreep]

You can install the EasyPopulate contribution (it's pretty easy to do). It creates a very handy screen, and one of the options is to download - as a file you can open in Excel - a list of all yout items, including the current qty.

 

Can someone explain how I can get a complete product listing and quantity from the database or the admin tool.  Has anyone seen this?  If so, please show me.

Thanks,

-gb

 

Example: 

Widget1 = 10

Widget2 = 2

Widget3 = 0

<{POST_SNAPBACK}>

[Rob123]

Would you like a sql query that you can use in phpmyadmin?

 

Simply tell me what fields that you want to be displayed.

Ex: Model Number, Name, Quantity and Status

 

HTH,

Robert

[Rob123]

Ok... I'm a impatient guy so here's a sql query in the format that you wanted:

Widget1 = 10

Widget2 = 2

Widget3 = 0

select concat(pd.products_name, ' = ', p.products_quantity)
as product_quantity from products p 
join products_description pd on (p.products_id = pd.products_id)
where pd.language_id ='1';

However, a query with additional info that may help you is below

select p.products_model, pd.products_name, p.products_quantity,
if(p.products_status=1,'Active','Not Active') as products_status from products p 
join products_description pd on (p.products_id = pd.products_id)
where pd.language_id ='1';

HTH,

Robert

 

Edit... Where's the spell check