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 |
---|---|---|
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