cancel
Showing results for 
Search instead for 
Did you mean: 

Magento 1.x - Item Price including tax

Magento 1.x - Item Price including tax

Hi there, 

 

We have an integration with Magento 1, when importing orders from Magento, we receive an extensive list of fields relating to item pricing. 

 

Question: 

  • Which field should we use to pull the final price including tax? 
    • Is it possible to use just one field, or are we best to use a combination of a fields, for example item price = tax_invoiced + row_invoiced

 

Here's an example of the fields we receive:

<base_price xsi:type="xsd:string">24.1700</base_price>
<original_price xsi:type="xsd:string">29.0000</original_price>
<base_original_price xsi:type="xsd:string">29.0000</base_original_price>
<tax_percent xsi:type="xsd:string">20.0000</tax_percent>
<tax_amount xsi:type="xsd:string">4.8300</tax_amount>
<base_tax_amount xsi:type="xsd:string">4.8300</base_tax_amount>
<tax_invoiced xsi:type="xsd:string">4.8300</tax_invoiced>
<base_tax_invoiced xsi:type="xsd:string">4.8300</base_tax_invoiced>
<discount_percent xsi:type="xsd:string">0.0000</discount_percent>
<discount_amount xsi:type="xsd:string">0.0000</discount_amount>
<base_discount_amount xsi:type="xsd:string">0.0000</base_discount_amount>
<discount_invoiced xsi:type="xsd:string">0.0000</discount_invoiced>
<base_discount_invoiced xsi:type="xsd:string">0.0000</base_discount_invoiced>
<amount_refunded xsi:type="xsd:string">0.0000</amount_refunded>
<base_amount_refunded xsi:type="xsd:string">0.0000</base_amount_refunded>
<row_total xsi:type="xsd:string">24.1700</row_total>
<base_row_total xsi:type="xsd:string">24.1700</base_row_total>
<row_invoiced xsi:type="xsd:string">24.1700</row_invoiced>
<base_row_invoiced xsi:type="xsd:string">24.1700</base_row_invoiced>