Anyone know how to figure the total $$$ amount of product in inventory?

[Trentide]

Hi. Thanks for looking at my post. This would be useful to have and not too difficult, I imagine.

 

Any help on this would be appreciated.

 

Thanks, Jason

[Nullachtfuffzehn]

For a vanilla version with not attribute quantity tracking it's easy:

 

SELECT sum( products_price * products_quantity )
FROM products

[Trentide]

Sorry. I'm not too good with PHP.

 

On which page do I put the code?

 

Where do I view the info from there?

 

Thanks, Jason

 

For a vanilla version with not attribute quantity tracking it's easy:

 

SELECT sum( products_price * products_quantity )
FROM products

[Nullachtfuffzehn]

That's plain SQL. Open your preferred database management tool, i.e. phpMyAdmin and copy that code to the SQL box. You'll get the result by clicking 'Go'.

[Trentide]

that's pretty cool. Thanks. I'll try it!

 

Jason

 

 

That's plain SQL. Open your preferred database management tool, i.e. phpMyAdmin and copy that code to the SQL box. You'll get the result by clicking 'Go'.

[Dennisra]

So, this result:

 

 

746310.4233

 

would mean exactly what?

[Trentide]

I'm not sure. Is it possible you have 746,000+ dollars in inventory? I wouldn't sweat the remainder. Although I can't imagine how you got the ".4233"

[Nullachtfuffzehn]

The total amount in your default currency of all items you have in stock according to your shop database. As I said, it's just reliable for vanilla OSC versions. Any other you'll have to look if there might be different things that affect the stock value.

[Dennisra]

Okay, the dollar amount seemed correct. I just couldn't understand what the .4233 might be.

[Trentide]

Thanks for that info Manfred!! Do you think there's an easy way to get this info to be seen in the "Admin"?

 

Just wondering,

 

Thanks,

 

Jason

 

 

 

Okay, the dollar amount seemed correct. I just couldn't understand what the .4233 might be.