Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Total value of stock for stocktaking...


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


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

  • Create New...