Salesforce: order fees and totals

The Salesforce system has the “Order Amount”(TotalAmount) order field - Salesforce calculates it’s value automatically as a sum of your OrderItems associated with the Order. Fees are not recorded as line items on the order in Magento therefore custom solution is required.

The Salesforce managed package by PowerSync has introduced the following custom fields to bridge the gap:

Field in Salesforce

Field in Magento

Notes

Field in Salesforce

Field in Magento

Notes

tnw_mage_basic__Subtotal__c

subtotal

This matches to the Order Amount field in Salesforce (usually)

tnw_mage_basic__Shipping_Fee__c

shipping_amount

Shipping charges for your Magento order

tnw_mage_basic__Tax_Fee__c

tax_amount

Tax charges for your Magento order

tnw_mage_basic__Discount__c

discount_amount

Any applied discounts for your Magento order

tnw_mage_basic__Grand_Total__c

 

A formula field in Salesforce

Formula

tnw_mage_basic__Grand_Total__c = tnw_mage_basic__Subtotal__c + tnw_mage_basic__Tax_Fee__c + tnw_mage_basic__Shipping_Fee__c + tnw_mage_basic__Discount__c


System mappings

PowerSync integration automatically sets up these mappings when you install our product