What is the field mapping of Shopify to Salesforce?

Modified on Thu, 27 May 2021 at 11:09 PM

Skylio - CRM Connector support Standard field mapping and also Custom field mapping.

If you have custom fields available in Salesforce and you want to transfer the Shopify data to these fields then please set the mapping inside our App Dashboard.

Below fields are standard fields and will map the data using the standard rules.

Below tables ensure which Shopify data will map to which Salesforce fields.

Shopify Fields (CUSTOMERS)	SalesForce (ACCOUNTS)
Customer Company Name / Customer Name	Account Name
Customer Contact No	Phone
Customer Billing Address	Billing Address
Customer No	Account Number
Order Shipping Address	Shipping Address

Shopify Fields (CUSTOMERS)	SalesForce (CUSTOMERS)
First Name	First Name
Last Name	Last Name
Contact No	Phone
Email	Email
Primary / Default Address	Mailing Address

Shopify Fields (PRODUCTS)	SalesForce ( PRODUCTS)
SKU	Product Code
Name (With Variant Title)	Product Name
Product Original price	Unit Price

Shopify Fields (ORDER)	SalesForce (OPPORTUNITY)
Order Number	Name
Order Date	Close Date
Total Amount	Amount
Order Status	Status (Closed Won/Closed Lost)
Order Items	Product Line items

Shopify Fields (ORDER)	SalesForce (ORDER)
Order Number	Order Reference Number
Order Number	Name
Billing Address	Billing Address
Shipping Address	Shipping Address
Total Amount	Amount
Order Status	Status
Order Date	Effective Date
Order Items	Product Line Item

What is the field mapping of Shopify to Salesforce?

Shopify Fields (CUSTOMERS)