Total Value Of Products

General Forums General Questions
#1

Hi

Is it possible and see the total value of all products in cs.cart?

Regards

Knut

#2

Hi

Is it possible and see the total value of all products in cs.cart?

Regards

Knut

Add HTML block with SMARTY support and the following code:

Total amount: {"SELECT COUNT(product_id) FROM ?:products"|db_get_field}
#3

Add HTML block with SMARTY support and the following code:

Total amount: {"SELECT COUNT(product_id) FROM ?:products"|db_get_field}

Did try it, but I cant get it to work. I get the total of products, but I want total value :)

#4 
Total value: {"SELECT SUM(price) FROM ?:product_prices"|db_get_field}

Edit: Note that this does not take in account inventory.

#5

You can display it however you want, but the smarty vsriable for the subtotal of the products is {$order_info.subtotal}.

#6 

Total value: {"SELECT SUM(price) FROM ?:product_prices"|db_get_field}
Edit: Note that this does not take in account inventory.


To exclude qty discounts info, please use

Total value: {"SELECT SUM(price) FROM ?:product_prices WHERE lower_limit = 1 AND usergroup_id = 0"|db_get_field}