Most of you must be wondering why the order item values has so many “repeated” fields like the following:

  • price
  • row_total
  • row_invoiced
  • row_total_inc_tax
  • tax_amount
  • tax_invoice

While you also have the following

  • base_price
  • base_row_total
  • base_row_invoiced
  • base_row_total_inc_tax
  • base_tax_amount
  • base_tax_invoice

You might be having a single website using a single currency and for each item your orders have you will se the exact same values. But the thing changes when you store(s) handles several currencies.

For instance, if you have a store that accepts US Dollars and Euro, but your default currency is USD, the base fields will be expressed on the default currency, while the other will be on the currency of the store the order was purchased.

This a very common question on the day to day or even something you need to know if you are going to take the Magento certification.

Leave a comment