Forum OpenACS Q&A: Response to wanna show subtotal price of items in shopping cart

Collapse
2: Response to wanna show subtotal price of items in shopping cart (response to 1)
Posted by Gilbert Wong on 07/22/01 10:39 AM
There is a pl/pgsql function called ec_total_price(integer) which gives you the subtotal of the order (ie sum of all items before tax and shipping).  You will have to do a query using this function on the order_id.

select ec_total_price($order_id) as subtotal

Hope that helps.