Attribute Mapping for Template Item Import

Form ID: (BC203000)

On this form, you define the rules for mapping MYOB Acumatica attributes and their values to product variants and their values from an external ecommerce system. These mappings are used while creating template items during product import from the external system.

The system adds rows to the table on the form after product import is prepared from the external ecommerce system on the Prepare Data (BC501000) form if the products to be imported have variants in the external system. The system deletes rows from the table on the form when the corresponding mappings are successfully used to create the template and matrix items.

Important: This form is available only if the Retail Commerce feature is enabled on the Enable/Disable Features (CS100000) form.

Form Toolbar

The form toolbar includes the buttons described below.

Button Description
View Attributes Opens the Attributes (CS205000) form in a pop-up window. You can use this form to review and update existing attributes and their values, as well as to create new attributes and values.
Update Item Class Populates the ERP Item Class column in the table with the item class selected in the Item Class to Assign box in the Summary area for the rows with the check box selected in the Selected column.

Summary Area

In this area, you can select the item class to be assigned to the mappings shown in the table.

Element Description
Item Class to Assign The item class the system assigns to mappings shown in the table when you click Update Item Class on the form toolbar.

Table Toolbar

The table toolbar has only standard buttons.

Table Columns

This table contains pairs of values, with each row containing the original value that is being replaced and the substitute value that will be used instead of the original value.
Column Description
Selected An unlabeled check box that you select to include this external item in the assignment of the items class specified in the Summary area. When you select the check box for an external item, the system automatically selects this check box for all linked items that share the same identifier in the External ID column.
External Description

The product name (title) in the external ecommerce system.

The column is read-only.

Store Name

The name of the ecommerce store with which data is synchronized.

The column is read-only.

Connector

The ecommerce connector used for the synchronization of data between MYOB Acumatica and the external ecommerce system.

The column is read-only.

External ID

The product identifier in the external ecommerce system.

The column is read-only.

External Option

The variant option of the product in the external ecommerce system that is set to the ERP attribute on import.

The column is read-only.

External Option Value

The variant value in the external ecommerce system that is set to the ERP attribute value on import.

The column is read-only.

ERP Item Class

The item class to be assigned to each template item imported to MYOB Acumatica from the external ecommerce system. This item class will be used to provide its default settings.

You can select the item class manually; alternatively, you select the check box in the Selected column for the row and then click Update Item Class on the form toolbar to automatically populate this column with the item class selected in the Item Class to Assign box. The system also assigns the inserted item class to all the rows with the same identifier in the External ID column as the one in the updated row.

ERP Attribute

The MYOB Acumatica attribute that corresponds to the external product variant. This attribute has been defined on the Attributes (CS205000) form.

When you select an attribute, the system assigns the attribute to all the rows with the same external identifier and external option as in the updated row.

ERP Attribute Value

The value of the MYOB Acumatica attribute that corresponds to the value of the external product variant. This attribute value has been defined on the Attributes (CS205000) form.