Data Mapping

Data mapping establishes the relationship between customer information and activity from all stores related to your Magento website and specific contact fields in the dotdigital database. Data fields can be mapped manually or automatically.

The configuration settings in the Data Mapping section are used to map fields manually. The Data Mapping section displays a list of the available dotdigital contact data fields for each Magento data item. Initially there are only a few contact database fields as examples that can be mapped to Magento. You can create additional dotdigital contact data fields and also include mapping to Magento custom attributes. After mapping the data fields, each component of your Magento database can be synchronized for import into dotdigital. To learn more, see Data syncing: Data mapping - Magento 2.

Map data fields automatically

  1. On the Admin sidebar, go to Stores > Settings > Configuration.

  2. In the left panel, expand the DOTDIGITAL section and choose Developer.

  3. In the Sync Settings section under Admin Task, click Automap Data Fields Run Now.

    Sync Settings - Admin Task

Map data fields manually

  1. On the Admin sidebar, go to Stores > Settings > Configuration.

  2. In the left panel, expand the DOTDIGITAL section and choose Data Mapping.

  3. For each field in the following sections, choose the corresponding data field from your dotdigital dotdigital account.

    • Customer Information
    • Address
    • Sales
    • System Values
    • B2B Data
    • Enterprise Data

    Data Mapping

Sync data mappings

  1. In the Magento configuration, go to DOTDIGITAL > Sync Settings.

  2. In the Sync section, set each database component that you want to enable to Yes.

    • Customer Enabled
    • Guest Enabled
    • Subscriber Enabled
    • Order Enabled
    • Wishlist Enabled
    • Review Enabled
    • Catalog Enabled
    • Shared Catalog Enabled
    • B2B Quote Enabled
  3. Click Save Config.

  4. Go to System > Tools > Cache Management and clear any invalid cache.

  5. Wait an hour to ensure that all contact data is imported into your dotdigital account.

Sync

Sync B2B Company Details

  1. Automap the data fields needed, as described previously.

  2. After approving a new company request, sync the customer data type, as described previously.

  3. In your dotdigital account, verify that the customer data is correctly synced with the company data.

    To learn more, see Sync company data in the dotdigital Help Centre.

Sync B2B shared catalog

  1. In the Magento configuration, verify that Shared Catalog is enabled.

  2. If necessary, set up your shared catalog and pricing.

  3. On the Admin sidebar, go to Stores > Settings > Configuration.

  4. In the left panel, expand DOTDIGITAL and choose Sync Settings.

  5. Scroll down to the bottom of the Sync section and verify that Catalog Enabled is set to Yes.

    If you changed the setting, click Save Config before continuing to the next step.

  6. Set Shared Catalog Enabled to Yes.

    Sync Settings - Admin Task

  7. Click Save Config.

  8. On the Admin sidebar, go to System > Tools > Cache Management and refresh any invalid cache.

  9. Do one of the following:

    • Wait for the next cron run.

    • In the Magento configuration, go to DOTDIGITAL > Developer > Sync Settings. Under Manually Run Sync, click Catalog Sync Run Now.

    Manually Run Sync

  10. In your dotdigital account, go to Ecommerce > Catalogs.

  11. Verify that the Catalog_[Level]_[Shared catalog name] data is correct.

    To learn more, see Sync shared catalogs in the dotdigital Help Centre.

Sync B2B Quotes

  1. In the Magento configuration, verify that B2B Quotes is enabled.

  2. Before continuing, verify that you have Quote data available to sync with dotdigital. If not, wait until there are quotes available.

    Quotes

  3. In the Magento configuration, go to DOTDIGITAL > Sync Settings.

  4. Set B2B Quote Enabled to Yes and click Save Config.

  5. On the Admin sidebar, go to System > Tools > Cache Management and refresh any invalid cache.

  6. Wait for the next cron run.

  7. In your dotdigital account, verify that the imported quote data is correct.

    To learn more, see Sync B2B quotes in the dotdigital Help Centre.