Content >

Mapping Customer Schema

Mapping Customer Schema

Customer schema must be mapped to ensure that customer data is properly synced between Acumatica and Magento. To begin, navigate to the Magento Connector workspace in Acumatica and select Customers under the Schema Management section.

  1. Click Refresh Schema.

    • The attributes will refresh successfully with a green checkmark.
  2. Toggle the Active box next to the attribute that must be mapped.
  3. Click Save.
  4. Next, navigate to the Kensium A-M Connector workspace in Magento and click Customer under the Mapping section.

  5. Select a Store View in the top left-hand corner.
  6. Click Update Schema.

    • If the Magento Customer Attribute already exists for the Acumatica Customer Attribute, skip stepping 8.
  7. Click Get New Attributes

    • The list of unmapped attributes from Acumatica will be rendered.
  8. Click Create next to the Acumatica attribute that will be made into a Magento attribute.
  9. Under Attribute Properties

    • Enter a Default Label

      • This is the display name of the attribute.
    • Enter an Attribute Code

      • This is an internal documentation of the attribute.
    • Enter an Input Type option.

      • This is the type of attribute that has been created in Acumatica (combo, multi combo, etc.).
  10. Under Storefront Properties.

    • Enter a Show on Storefront Option.
    • Enter a Sort Order.

      • This will designate where the attribute will appear in conjunction with other attributes if visible on the storefront.
    • Enter a Form to Use In.

      • This will designate where the attribute will appear.
  11. Click Save Attribute. The Magento Attribute will now be created based on the information from the Acumatica Attribute and appear in the Magento Customer Attribute column of the Customer Attribute Mapping page.
  12. Click Update Schema.
  13. Click Map Attributes.
  14. Select a Magento Customer Attribute.
  15. Select an Acumatica Customer Attribute.
  16. Select a Direction.

    • This will allow a user to determine the direction of metadata syncs for individual product attributes.
  17. Click Save.
Select an attribute using the spinning button & and direction from the drop-down menu
Select an attribute using the spinning button & and direction from the drop-down menu

The saving of the value of the attributes will be mapped.