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 |