1. Payments2us/Shopify Field Mapping
The below tables provide some of the key field/object mapping between Salesforce Payments2us and Shopify.
1.1. Payment Txn Fields
Ā
| Salesforce Field | ShopifyĀ |
| AAkPay__firstName__c | order.billing_address.first_name |
| AAkPay__lastName__c | order.billing_address.last_name |
| AAkPay__mailingStreet__cĀ |
order.billin g_address.address1 + order.billing_address.address |
| AAkPay__mailingCity__cĀ | order.billing_address.city |
| AAkPay__mailingState__cĀ | order.billing_address.province_code |
| AAkPay__mailingPostalCode__cĀ | order.billing_address.zip |
| AAkPay__mailingCountry__cĀ |
order.billing_address.country NOTE - if blank, default country from Merchant Facility used |
| AAkPay__phone__cĀ | order.billing_address.phone |
| AAkPay__Donation_By_Name__cĀ |
order.billing_address.company NOTE - if NOT Blank, then Donation_By__c = 'Company' |
| AAkPay__firstName__cĀ | if no order.billing_address, then order.customer.first_name |
| AAkPay__lastName__cĀ |
if no order.billing_address, then order.customer.last_name NOTE - if blank, 'Shopify Customer' assigned |
| AAkPay__lastName__cĀ | If Ā AAkPay__lastName__c is not assigned from above, then āShopify Customerā |
| AAkPay__otherStreet__c | order.shipping_address.address1 + order.shipping_address.address2 |
| AAkPay__otherCity__cĀ | order.shipping_address.city |
| AAkPay__otherState__c | order.shipping_address.province_code |
| AAkPay__otherPostalCode__c | order.shipping_address.zip |
| AAkPay__otherCountry__c | order.shipping_address.country |
| AAkPay__Billto_eq_shipto__c | true when mailing... address fields equal other... address fields, otherwise set to false |
| AAkPay__AAkPay__Campaign__cĀ | PaymentForm, field: AAkPay__Default_Campaign__c |
| AAkPay__Email__cĀ | order.email |
| AAkPay__Subscribe_to_Email_Updates__cĀ | true when order.buyer_accepts_marketing |
| AAkPay__Payment_Source__cĀ | 'Shopify' |
| AAkPay__IP__cĀ | order.browser_ip |
| AAkPay__dpsTxnRef__cĀ | order.token |
| AAkPay__Transaction_Type__cĀ | 'Purchase' |
| AAkPay__Amount__cĀ | order.total_line_items_price |
| AAkPay__Discount__cĀ | (order.total_discounts / AAkPay__Amount__c ) * 100 |
| AAkPay__Tax_Amount__cĀ | order.total_tax |
| AAkPay__Freight__cĀ | order.shipping_lines.price |
| AAkPay__Voucher_Code__cĀ |
order.discount_codesĀ NOTE if more than one code, then comma separated. |
| AAkPay__AAkPay__Payment_CC_No__cĀ | order.payment_details.credit_card_number |
| AAkPay__Payment_CC__cĀ | order.gateway |
| AAkPay__Bank_Deposit_Date__cĀ | Todays Date |
| AAkPay__Transaction_Date__cĀ | Todays Date |
| AAkPay__Bank_Deposit_Account__cĀ | Merchant Facility, field: AAkPay__Bank_Deposit_Account__c |
| AAkPay__Receipt_Email__c |
AAkPay__Email__c NOTE - If blank, then the Merchant Facility, field: AAkPay__Print_Email_Receipt__c is used.Ā Ā Ā Ā Ā |
| AAkPay__Comments__cĀ | order.note |
| AAkPay__Currency__cĀ |
order.xCurrencyĀ NOTE - If Blank, then the default currency on the Merchant Facility is used |
Ā
2.2. Payment Item Fields
For Each order.line_items, a new related Payment Item is created with:
| Salesforce Field | ShopifyĀ |
| AAkPay__Payment_Txn__cĀ | is linked to the above Payment Txn record created. |
| RecordTypeIdĀ | 'Shopping Cart' |
| AAkPay__Product_Id__c | order.line_items.product_id |
| AAkPay__Quantity__cĀ | order.line_items.quantity |
| AAkPay__Amount__cĀ | order.line_items.price |
| AAkPay__Price__cĀ | order.line_items.price |
| AAkPay__Item_Description__cĀ | order.line_items.name |
| AAkPay__SKU__cĀ | order.line_items.skuĀ |
Ā