The Salesforce system has the “Order Amount”(TotalAmount) order field - Salesforce calculate calculates it’s value automatically as a sum of your OrderItems price
Unfortunately, Salesforce doesn’t provide the fields for additional order fees like: Shipping Const, Tax Amount and Discount price. This is the reason why the “Order Amount” value and Magento order Grand Total value could be different
Our Salesforce package added the following additional fields for the order: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
| Code Block |
|---|
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
...