Magento fields available
Various customer information present in Magento can be imported into MagNews.
Some of the available fields are virtual, that is, calculated at the time of import.
For Yes/No fields, the value 1 indicates the value Yes.
Fields preceded by the suffix CLIENT correspond to the fields in the customer profile on Magento.
- CUSTOMER - Is customer is valued at
VEROhen the contact refers to a Magento customer, and is valued atFALSOif the contact refers to a Magento newsletter subscription. - CLIENT - Newsletter subscription (Yes/No field) and CLIENT - Newsletter subscription status correspond to newsletter subscription and status.
- CUSTOMER - Age is calculated based on the date of birth.
To know what group a customer belongs to, the CUSTOMER - Customer Group (Id) field is available, which indicates the id of the group, while the CUSTOMER - Customer Group(varchar) field indicates the name of the group. - CUSTOMER - Store view indicates the store view from which the language can be inferred.
- CUSTOMER creation date corresponds to the date of eCommerce registration.
- CUSTOMER email confirmed indicates whether the customer's email has been confirmed.
- CUSTOMER VAT number contains the customer's VAT number.
- CUSTOMER prefix contains the prefix that may have been added to the contact name
- CLIENT suffix indicates the suffix eventually appended after the contact name
- CUSTOMER second name gives the possibility to import any second name of the contact into the database
Fields preceded by the suffix CART correspond to fields calculated from the last abandoned cart.
Fields preceded by the suffix BILLING ADDRESS correspond to default address values for billing.
Fields preceded by the suffix SHIPPING ADDRESS correspond to the values of the default address for shipping.
Fields preceded by the suffix WEB indicate the customer's eCommerce visit data.
Fields preceded by the suffix ORDERS indicate the aggregate data of all customer orders in the eCommerce. Only validated orders are considered, i.e., orders whose status is among those configured in the section:
Synchronization Configuration Special fields .
Fields preceded by the suffix ORDERS IN PERIOD indicate the aggregate data of orders placed in the recency period set.
Fields preceded by the suffix FIRST ORDER indicate the data of the first order placed by the customer.
Fields preceded by the suffix LAST ORDER indicate data from the last order placed by the customer.
The LAST ORDER - Days since previous order field indicates the number of days between the last order and the penultimate order.
Fields preceded by the suffix WISHLIST indicate wishlist data.