Content >

Customer Mapping

Customer Mapping

Customer Mapping is followed by Category mapping in the Mapping section upon clicking on the [Kensium A-M] connector. Upon clicking the [Customer], you will be redirected to the following screen.

Customer Mapping in the Mapping section
Customer Mapping in the Mapping section
Options available in the Customer Attribute Mapping
Options available in the Customer Attribute Mapping

This includes the following options in the Customer Attribute Mapping screen.

  • Update Schema
  • Recommended Customer Attribute Mapping
  • Get New Attributes
  • Map Attributes

Update Schema:

The customer-selected fields in Acumatica will be synchronized within Magento once you click on [Update Schema]. Upon clicking on this a pop-up will appear and to update you need to click on [OK].

Confirmation message upon clicking [Update Schema]
Confirmation message upon clicking [Update Schema]
  • Recommended Customer Attribute Mapping:

In the first place, the customer attribute mapping browse will be blank on your screen. To bring the default customer attribute you need to click on the [Recommended Customer Attribute Mapping]. A confirmation message will appear on the screen. Click on [OK] and the default attributes will appear on the screen.

confirmation pop-up for recommended customer attribute mapping
Confirmation pop-up for recommended customer attribute mapping
Default values on recommended customer attribute mapping
Default values on recommended customer attribute mapping
  • Get New Attributes:

Upon clicking the [Get New Attributes] a Grid Slider will open up and here you find the list of Acumatica Attributes which are not yet present in Magento. Provide a screenshot of the Grid.

To create any attribute, click on the Create button and it will open up the Magento Customer Attribute Form with the loaded Acumatica attribute data. Provide the Screenshot of the form. After configuring the attribute data in the form click save to create the attribute in the Magento.

Once the attribute is saved it will be available for the mappings.

Created New Attributes displayed
Created New Attributes displayed

Go to the Attributes section.

Attributes section
Attributes section

Click on the Customer Schema and click on the Refresh Schema the SSN Number, the newly created attribute should be displayed within Acumatica.

New attributes creation
New attributes creation
Click on [Create] for new attributes
Click on [Create] for new attributes

The next screenshot is not available from Magento in the instance.

  • Map Attributes:
  • This feature allows you to configure to map the customer attributes. You can map the Magento Customer Attributes with the Acumatica Customer attribute. The mapping of customer attributes could be bi-directional. You will have 4 dropdowns as shown in the following figures.

    Option to Map the Attributes
    Option to Map the Attributes

    Upon clicking the [Map Attributes] the following pop-up will appear on your screen.

    Pop-Up upon clicking the map Attributes
    Pop-Up upon clicking the map Attributes

    Field

    Field Type

    Description

    Magento Customer Attribute

    Search Drop-down

    Select the field which you want to map with the Acumatica from Magento.

    Acumatica Customer Attribute

    Search Drop-down

    Select the Acumatica field which should be mapped with the Magento field.

    Use In

    Search Drop-down

    Select the option from the following drop-down list.

    • Create
    • Update
    • Create/ Update

    Direction

    Search Drop-down

    Select the direction from the drop-down. For Customers, you will have the option for bi-directional as customer records will be having both in Magento and Acumatica.

    • Acumatica to Magento
    • Magento to Acumatica
    • Bi-Directional

    If you select only one direction then updates will always be triggered from one side, i.e., the selected side. If you select Bi-Directional then the updates will be triggered from both the end.

    Since in Acumatica, the Account name refers to the Customer name. However, in Magento Customer name is defined as two separate text boxes first name and last name.

    Customer Name Field in Acumatica
    Customer Name Field in Acumatica
    Customer name is divided into First Name and Last Name
    Customer name is divided into First Name and Last Name

    The Account Name will be mapped with the Customer’s First Name and Last Name in Magento.
    In case you only have one name in Acumatica then at the time of mapping Magento will enter the name in the first name and the last name there will be a dot as it’s a mandatory field.