Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Total value of stock for stocktaking...


sosidge

Recommended Posts

Hi there,

 

I'm trying to quickly find out the total value of stock of hold at present.

 

I imagine there is an easy way to do this with an operation on the MySQL database - but I don't know where to start.

 

Basically, in the products table, I need products_quantity to be multiplied by products_price for each products_id, and for the whole lot to be summed.

 

Any help much appreciated.

- osCommerce is fun! -
Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...