Order Math Calculations


The tables below refer to properties seen with Order retrieval only for the purpose of understanding calculation totals for each price point.

Amazon FBA Orders that will include Amazon-generated VAT tax values will have "AmazonInvoiced" as the OrderTag value.

Order Level Pricing & Calculations

PropertySOAP EquivalentRegular Mathematical Calculations
When TaxType = NoTax, Standard, ExclusiveVat

Mathematical Calculations
When TaxType = InclusiveVat
* not a real field; used for explanation purposes only

TotalPriceTotalOrderAmount(Sum of all items OrderItems[Quantity] x OrderItems[UnitPrice] ) +
TotalTaxPrice +
Total ShippingPrice +
TotalInsurancePrice +
TotalGiftOptionPrice +
AdditionalCostOrDiscount +
PromotionAmount +
(Sum of all items
OrderItems[Promotions[Amount]] +
OrderItems[Promotions[ShippingAmount]] +
OrderItems[RecyclingFee])
(Sum of all items OrderItems[Quantity] x OrderItems[UnitPrice] ) +
Total ShippingPrice +
TotalInsurancePrice +
TotalGiftOptionPrice +
AdditionalCostOrDiscount +
PromotionAmount +
(Sum of all items
OrderItems[Promotions[Amount]] +
OrderItems[Promotions[ShippingAmount]] +
OrderItems[RecyclingFee])
TotalTaxPriceN/A

(Sum of all OrderItems[TaxPrice]) + TotalShippingTaxPrice + TotalGiftOptionTaxPrice
 

Number generated here is estimate based on VAT settings in the profile (system log in required).
For representation only. No actual data provided by marketplace.
(Sum of all OrderItems[TaxPrice]) + TotalShippingTaxPrice + TotalGiftOptionTaxPrice 
TotalShippingPriceShippingSum of all OrderItems[ShippingPrice]Sum of all OrderItems[ShippingPrice] (will include ShippingVAT*)
TotalShippingTaxPriceVATShipping

Sum of all OrderItems[ShippingTaxPrice]

Number generated here is estimate based on VAT settings in the profile (system log in required).
For representation only. No actual data provided by marketplace.
Sum of all OrderItems[ShippingTaxPrice]
TotalInsurancePriceShippingInsuranceTotalInsurancePrice data - provided at order level only.
TotalGiftOptionPriceGiftWrapSum of all OrderItems[GiftPrice]Sum of all OrderItems[GiftPrice] (will include GiftVAT* as part of price)
TotalGiftOptionTaxPriceVATGiftWrapSum of all OrderItems[GiftTaxPrice]Number generated here is estimate based on VAT settings in the profile (system log in required).
For representation only. No actual data provided by marketplace.
Sum of all OrderItems[GiftTaxPrice]
AdditionalCostOrDiscountAdditionalCostOrDiscountAdditionalCostOrDiscount data - provided at order level only. Not commonly populated.
PromotionAmountUnitPricePromotionAmount data - provided at order level. Not a sum of Promotion Level pricing. A negative decimal.
Will not be populated if item level promotions exist.

Item Level Pricing Data

Property
SOAP EquivalentRegular Mathematical Calculations
When TaxType = NoTax, Standard, ExclusiveVat

Mathematical Calculations
When TaxType = InclusiveVat 
* not a real field; used for explanation purposes only
exception is for order with 'AmazonInvoiced' OrderTag

Quantity QuantityNumber of units purchased.
UnitPriceUnitPriceUnitPrice of the item.
This is not a sum of all units.
UnitPrice (will include UnitVAT*)
This is not a sum of all units.
TaxPriceTaxCostTaxPrice for all quantity of this item - based on data provided by marketplace.
This is not unit tax price.
Number generated here is estimate based on VAT settings in the profile (system log in required).
For representation only - no actual data provided by marketplace.
This is not unit tax price.
ShippingPriceShippingCost

Total ShippingPrice (provided by marketplace) for all quantity of this item.
This is not unit shipping price.

Total ShippingPrice (will include ShippingVAT*) for all quantity of this item.
This is not unit shipping price.

ShippingTaxPriceShippingTaxCostTotal ShippingTaxPrice for all quantity of this item - based on data provided by marketplace.
This is not unit shipping tax price.

Number generated here is estimate based on VAT settings in the profile (system log in required).
For representation only - no actual data provided by marketplace.
This is not unit shipping tax price. 

RecyclingFeeRecyclingFeeTotal RecyclingFee for all quantity of this item - based on data provided by marketplace.
This is not unit recycling fee.

GiftPriceGiftWrapCostTotal GiftPrice for all quantity of this item - based on data provided by marketplace.
This is not unit gift price.
Total GiftPrice (will include GiftVAT*) for all quantity of this item.
This is not unit gift price. 
GiftTaxPriceGiftWrapTaxCostTotal GiftTaxPrice for all quantity of this item - based on data provided by the marketplace.
This is not unit gift tax price.
Number generated here is estimate based on VAT settings in the profile (system log in required).
For representation only - no actual data provided by marketplace.
This is not unit gift tax price.
PromotionsItemPromoListDiscounts applied to the costs of the order item. See Promotions info below.

Item Level Promotions

PropertySOAP EquivalentMathematical Calculations
Amount UnitPriceTotal price discounted on all quantity of this item. A negative decimal.
ShippingAmount ShippingPriceTotal shipping discounted on all quantity of this item. A negative decimal.