Customer Location Entity
This topic provides reference information about the standard filtering and field mapping used for the Customer Location entity during the synchronization between MYOB Acumatica and Shopify.
Customer Location Filtering
Filters are applied during the export of customer locations to Shopify. A customer location is skipped if any of the following is true:
- The customer location is a location of the guest customer. The guest customer is excluded from synchronization so its locations are not synchronized.
- The customer to which the customer location refers has not been synchronized.
During the import of customer locations to MYOB Acumatica, the customer location is skipped if the corresponding customer has not been synchronized.
Customer Location Export Mapping
The following table shows the mapping of MYOB Acumatica fields to Shopify fields that is used during the export of customer location data to Shopify.
| Source Fields (MYOB Acumatica) | Target Fields (Shopify) | |||
|---|---|---|---|---|
| Field Name | Form Object | Field Name | Page Object | Notes |
| Customer Locations (AR303020) form | ||||
| Attention (part before the first space) | General tab > Additional Location Info section | First name | New customer page > Address section | If Attention is empty, Account Name is used. |
| Attention (part after the first space) | General tab > Additional Location Info section | Last name | New customer page > Address section | If Attention is empty, Account Name is used. |
| Account Name | General Info tab > Additional Location Info section | Company | New customer page > Address section | If Account Name is empty, Customer Name of the related customer is used. |
| Customer ID | Not in the UI | Customer ID of the related customer, generated by Shopify. | ||
| Address ID | Not in the UI | Address ID is generated by Shopify. | ||
| Address Line 1 | General tab > Location Address section | Address | New customer page > Address section | |
| Address Line 2 | General tab > Location Address section | Apartment, suite, etc. | New customer page > Address section | |
| City | General tab > Location Address section | City | New customer page > Address section | |
| State | General tab > Location Address section | State/Province | New customer page > Address section | The state code is transformed to the state name. |
| Postal Code | General tab > Location Address section | Postal code | New customer page > Address section | |
| Country | General tab > Location Address section | Country/Region | New customer page > Address section | The ISO country code is transformed to the country name. |
| Phone 1 | General tab > Additional Location Info section | Phone | New customer page > Address section | If Phone 1 is empty, Phone 2 is used. |
Customer Location Import Mapping
The following table shows the mapping of MYOB Acumatica fields to Shopify fields that is used during the import of customer location data to MYOB Acumatica.
| Source Fields (Shopify) | Target Fields (MYOB Acumatica) | |||
|---|---|---|---|---|
| Field Name | Page Object | Field Name | Form Object | Notes |
| Customer Locations (AR303020) form | ||||
| Customer | Summary area | The customer ID is generated based on the numbering sequence specified for customers on the Customer Settings tab of the Shopify Stores (BC201010) form. | ||
| Location ID | Summary area | The location ID is generated based on the numbering sequence specified for customer locations on the Customer Settings tab of the Shopify Stores form. | ||
| Status | Summary area | By default, a customer location imported from a Shopify store is assigned the Active status. | ||
| Company | Customer page > Default address section | Location Name | Summary area | If Company is empty, First Name and Last Name are used. |
| Override | General tab > Additional Location Info section | The Override check box is selected. | ||
| Company | Customer page > Default address section | Account Name | General tab > Additional Location Info section | |
| First name | Customer page > Default address section | Attention | General tab > Additional Location Info section | |
| Last name | Customer page > Default address section | Attention | General tab > Additional Location Info section | |
| Customer page > Customer section | General tab > Additional Location Info section | |||
| Phone | Customer page > Default address section | Phone 1 | General tab > Additional Location Info section | |
| Phone number | Customer page > Customer section | Phone 2 | General tab > Additional Location Info section | |
| Address | Customer page > Default address section | Address Line 1 | General tab > Location Address section | |
| Apartment, suite, etc. | Customer page > Default address section | Address Line 2 | General tab > Location Address section | |
| City | Customer page > Default address section | City | General tab > Location Address section | |
| Country/Region | Customer page > Default address section | Country | General tab > Location Address section | The country name is converted to the ISO country code. |
| State/Province | Customer page > Default address section | State | General tab > Location Address section | The state name is converted to state code. |
| Postal code | Customer page > Default address section | Postal Code | General tab > Location Address section | |