Order Charge Field Definitions
The definitions below are how Extensiv Integration Manager uses and calculates price fields. If you do not follow this standard, Integration Manager cannot guarantee the price information the warehouse receives will be correct.
Â
Order Header Fields
sub_total:Â Sum of Order Line extended_amount fields.
- Does not include sales_tax, order_discount, or shipping_handling
- If loading orders, you may need to add the order_discount to the sub_total if the cart has one and doesn't include it in the sub_total.
order_discount:Â Total post-tax discount on order as a positive number.
- Overall discount passed from cart + (Sum of addl_discount from Order Lines)
sales_tax:Â Total tax on order
- If tax is set on Order Line this must match the sum of all order line tax fields. Most interfaces don't set tax on the order line.
shipping_handling:Â Total shipping charge for the order passed from cart. No relation to the order line shipping_surcharge field.
grand_total:Â sub_total + sales_tax +Â shipping_handling - order_discount
balance:Â Not used right now. Set to 0 or leave off completely.
Order Line Fields
quantity:Â Number/Quantity of this product ordered.
price:Â Cost of a single item. Does not include taxes, discounts, or shipping charges.
discount: Pre-tax Discount amounts to be applied to EACH single item as a positive number.
addl_discount: Post-tax Discount amount to be applied to the total item line as a positive number.
tax: Taxes applied to the total quantity of the total items in this line.
shipping_surcharge:Â Extra shipping charges that were added because of the total items in this line.
extended_amount:Â (price - discount) * quantity
- Does not take addl_discount or tax into account