When I get order data I can see there is total_due and base_total_due. My question is what is the difference between these?
Basically I get to see if the order has been paid fully and unsure which I should check
On order tables,you cansee lot of columns name start with
base_ save price in base currency and
non base_ save current currency price value.
It created for bcoz of Multi currencies.
Suppose,you have a store which has multi currency USD, Euro
USD is used base currency at magentoand
Euro is another currencyat magento.So when you have place an order 100Euro from the store which current currency is euro then magento
save 121 USDIn
*. columnsave 100.And magentoa admin,you have set Euro to USD conversion rate is 1.21.