Attribute Mapping for Template Item Import

Form ID: (BC203000)

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

On this form, you define the rules for mapping MYOB Acumatica attributes and their values to product variants and their values from an external e-commerce 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 e-commerce 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.

Form Toolbar

The form toolbar includes standard and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands are listed in the following table.

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 selected row (that is, the row you have clicked before clicking this button) and all the rows with the same identifier in the External ID column as the external ID in the selected row.

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 includes only standard buttons. For the list of standard buttons, see Table Toolbar.

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
External Description

The product name (title) in the external e-commerce system.

The column is read-only.

External ID

The product identifier in the external e-commerce system.

The column is read-only.

External Option

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

The column is read-only.

External Option Value

The variant value in the external e-commerce 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 e-commerce system. This item class will be used to provide its default settings.

You can select the item class manually; alternatively, you can click a row in the table 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 a 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.