Money in my shop

[yuikari]

Hello everyone!

I want to know what's the total price of the stock that i have in my shop.

For example, if i only have 4 items avaliable in my shop and in stock, worth $1, $2, $3 and $4 the total price of the stock would be 1+2+3+4=$10 :)

 

Is there any contribuition there for this? Is there anybody able to make one?

Thanks a million!!!

:lol:

[Guest]

well here is some code for it

 

  $total = 0;
 $total_query = tep_db_query("select (products_price*products_quantity) as total from " . TABLE_PRODUCTS . "");
 while($total_array = tep_db_fetch_array($total_query) ) {
$total += $total_array['total'];
 }
 echo $currencies->display_price($total, 0);

 

you could add it in a script or something and display it. Haven't tested it or anything but you could alter the query to display the total per category or something.

[yuikari]

well here is some code for it

 

  $total = 0;
 $total_query = tep_db_query("select (products_price*products_quantity) as total from " . TABLE_PRODUCTS . "");
 while($total_array = tep_db_fetch_array($total_query) ) {
$total += $total_array['total'];
 }
 echo $currencies->display_price($total, 0);

 

you could add it in a script or something and display it. Haven't tested it or anything but you could alter the query to display the total per category or something.

 

BRILLIANT!! Got it working, it's so simple! :thumbsup:

Ok, just in case someone is interested in this code, i copied in categories.php. Look for this code:

 

<td class="smallText"><?php echo TEXT_CATEGORIES . ' ' . $categories_count . '<br>' . TEXT_PRODUCTS . ' ' . $products_count; ?>

 

 

I added this:

 

<br>Total Stock for sale: <?php $total = 0;

$total_query = tep_db_query("select (products_price*products_quantity) as total from " . TABLE_PRODUCTS . "");

while($total_array = tep_db_fetch_array($total_query) ) {

$total += $total_array['total'];

}

echo $currencies->display_price($total, 0);

?>

 

 

Thank you so much enigma!!!

Edited July 6, 2007 by Melinda Odom
advertising is not allowed in your posts