Order Charge Field Definitions

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

    • Related Articles

    • Order Statuses

      This page explains the meanings of each order status in Extensiv Integration Manager.  Order Status API Value Meaning New new The order has been downloaded from the shopping cart to Integration Manager and will be sent to the WMS. Cancel Sending new ...

    • Extensiv Order Manager Warehouse Name or Warehouse ID error

      Problem You are receiving errors in Extensiv Integration Manager mentioning the Extensiv Order Manager Warehouse that are similar to one of the following: Cannot do Inventory Sync with empty warehouse_id. Please make sure that your Warehouse Name ...

    • INVALID_FIELD No such column 'XXX' on entity 'YYY' - Salesforce

      Problem You are getting an error message like this when testing your Salesforce cart or running Order Download: Make sure you have given read access to the column & entity listed in the error message below. INVALID_FIELD: SELECT Id, AccountId, ...

    • Extensiv Order Manager OMS Settings Order

      This page details some of the various options available in your Extensiv Order Manager OMS connection. Inventory Settings Settings Description Default Other Options Inventory Sync Mode Defines how Extensiv Integration Manager should assign inventory ...

    • Order Download

      The order download is the most basic function that all order sources support. This is used for loading orders into Extensiv Integration Manager from your order source.