osCommerce Order Totals

This section is for you to change shipping method and cost, provide or change the discount and see how it affects osCommerce order totals.

The most interesting option of this section is Calculation Settings. When you click on Settings Button you'll see the osCommerce Order Calculations window. Here you can configure how order values will be calculated.

Formula is an arithmetical expression. It can contain two types of elements - operand and operator.

There are three hardcoded operands:

sum_price - sum of "Price" * "Quantity" for all products in current order

sum_final_price - sum of "Final Price" * "Quantity" for all products in current order

average_products_tax - average tax % for all products in current order. Value 0.15 = 15% tax

Other operands can be inserted by clicking right mouse button on formula field.

Allowed operators: + add; - subtract; / divide; * multiply. Also you can use round brackets ( )

More information about expressions here.

Formula examples:

(subtotal - version #1 ):   sum_final_price

(subtotal - version #2 ):   sum_final_price - [ot_discount, 0.0]

(tax - version #1 ):         (sum_final_price - [ot_discount, 0.0] - [ot_coupon, 0.0]) * average_products_tax

(tax - version #2 ):         (sum_final_price * average_products_tax) + sum_final_price - ot_discount - ot_coupon

(total):                          ot_subtotal + [ot_tax, 0.0] + [ot_shipping, 0.0] - [ot_coupon, 0.0] - [ot_discount, 0.0]

Value specified in square brackets represents default value for an operand if specified operand name not found. As for example order total (formula above) calculated as subtotal + tax + shipping... but actually not every order have tax and shipping fields. If fields specified in formula not found it will take default value.

Formula operand [ot_tax, 0.0] has default value of 0.0, [ot_tax, 15.5] means default value of 15.5 and so on.

If you have any suggestions on osCommerce Order Totals, you're welcome to contact with our support team.