Define which fields to include for magnews contacts

In this section, the mapping options between Magento fields and those of the platform are configured.

You can configure four sections:

• Map Magento fields with Database fields
• Map custom fields of Magento newsletter subscribers to Database fields
• Special fields
• Dynamic groups

Map Magento fields with Database fields

After defining the import rules, you need to specify which and how many fields from the Magento database will correspond to the fields present on the platform.

Automatically created fields

Following the installation of the connector, three fields are automatically created in the Master Database.

• One field represents the customer id MAGE_CUSTOMER_ID
• One field represents the store view id MAGE_STORE_VIEW_ID
• One field indicates whether the contact is imported from Magento MAGE_IMPORTED

Mapped fields

The fields that do not have a corresponding entry in MagNews can be created on the platform at this stage, in the section:

Proceed as follows:

1. Click the Add field button
2. Choose the Magento Field to import into the database and which field it will be associated with on the platform.
   If the field is not present in the database, it can be automatically created by selecting the option Automatically create platform field. 
   
3. Click Save
4. Repeat the operation for all fields you want to associate

For more details on the fields, consult the available fields section.

The Customer data preview button allows you to choose a contact to analyze and get an overview of the available fields to be associated in the database.

Map custom fields of Magento newsletter subscribers to Database fields

In this section, you can configure the association between the custom fields of newsletter subscribers in Magento (not necessarily those subscribed to eCommerce as customers) and corresponding fields in the platform database.
To associate a new field, first click the Add field button.
The association mask will open where you need to define:

• Magento Field:
  the name of the custom field in Magento that you intend to associate. This name is the one defined earlier in the Definition of custom fields of newsletter subscribers via Magento section on the Global Configuration of Magento Connector page.
• Platform field:
  choose from the menu the field to associate with that of Magento. If you have not already created it, you can automate its creation by selecting the value Automatically create a platform field.
  In this case, you will be prompted to assign a Name and an ID to the field you are creating.
  By clicking Save, the field will be automatically added to the list of those available for association.

Special fields

In the special fields section, you can modify, if necessary, the values related to:

• Recency period:
  the number of days to consider in the calculation of certain fields that account for recency.
  The import will only consider data entered or updated within the period covered by the recency period.
• Filter orders by:
  you can select whether the order statuses to be imported will be those from Magento's system (coded in the State field), or those custom defined by users and coded in the Magento Status field.
• Valid order statuses:
  the statuses of the orders you want to consider. Orders with a different status will be ignored. To add additional statuses, click the dropdown menu and select them to add them to the list.

Dynamic groups

During import, it is possible to automatically create groups in the destination database to facilitate communication and analysis operations.
To do this, within the dynamic groups section, click the Create dynamic groups button.

A window will open where you can specify the database in which to create your groups.

For more information on managing dynamic groups, you can refer to the user guide by following the path: Contacts > Contact groups and segmentation