Order Charge Field Definitions

Order Charge Field Definitions

The definitions below are how CartRover uses and calculates price fields. If you do not follow this standard, CartRover 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 CartRover.  Order Status API Value Meaning New new The order has been downloaded from the shopping cart to CartRover and will be sent to the WMS. Cancel Sending new The order has been downloaded ...
    • 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, ...
    • Order Download

      The order download is the most basic function that all order sources support. This is used for loading orders into CartRover from your order source.
    • Red Stag Fulfillment Order Settings

      When Red Stag Fulfillment is selected as your CartRover WMS (Order Destination), there will be Red Stag Specific setting to set for each Shopping Cart (order source) connection in CartRover. These settings are listed and explained below: Red Stag ...
    • Purchase Order Download

      Purchase Order Download allows CartRover to load PO or ASN orders from the order source and send them to your OMS, WMS, or fulfillment. This will let them know what incoming products to expect for receiving. This functionality requires an OMS or WMS ...