Mapping Customer Schema

Mapping Customer Schema

Customer schema must be mapped to ensure that customer data is properly syncing 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.

Next, navigate to the Kensium A-M Connector workspace in Magento and click Customer under the Mapping section.

  1. Select a Store View in the top left hand corner.

  2. Click Update Schema.

    • If the Magento Customer Attribute already exists for the Acumatica Customer Attribute, skip to step 8.
  3. Click Get New Attributes

    • The list of unmapped attributes from Acumatica will render.
  4. Click Create next to the Acumatica attribute that will be made into a Magento attribute.

  5. 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 a Input Type option.

      • This is the type of attribute that has been created in Acumatica (combo, multi combo, etc.).
  6. 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 Forms to Use In.

      • This will designate where the attribute will appear.
  7. 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.

  8. Click Update Schema.

  9. Click Map Attributes.

  10. Select a Magento Customer Attribute.

  11. Select an Acumatica Customer Attribute.

  12. Select a Direction.

    • This will allow a user to determine the direction of metadata syncs for individual product attributes.
  13. Click Save.

Customer Attribute Mapping

The attribute has now been mapped