Import of Products with Variants: Settings of Imported Items

You can import products with variants that have been defined in the external system instead of creating the products manually in MYOB Acumatica. When you import these products, the following items are created in MYOB Acumatica:

Template items on the Template Items (IN203000) form
Matrix items on the Stock Items or Non-Stock Items (IN202000) form, depending on whether the products represent physical items

Template Item Settings Imported from the External System

The following table shows the settings that are assigned to a template item on the Template Items (IN203000) form based on the corresponding settings of the source product from the product management page in the Shopify store.


MYOB Acumatica Element	Shopify Element
Summary area
Description	Title
General tab
Item Status The template item is assigned the Active status if the corresponding product has the Active status and the Inactive status if the product has the Draft status.	Status
Description tab
Item description	Description

Matrix Item Settings Imported from the External System

The following table shows the settings that are assigned to each matrix item created on the Stock Items (IN202500) or Non-Stock Items (IN202000) form when you import a product with variants. The system uses the settings of the template item that it has created for the product and the settings of the source product and product variants, which are specified on the product management and variant management pages in the Shopify store.


MYOB Acumatica Element	Shopify Element
Summary area
Description The system composes the description of the matrix item as follows: <SKU> (<Title>).	SKU, Title
Price/Cost tab
Default Price	Price
MSRP	Compare-at price
Description tab
Item description Because variants have no description, the system uses the description of the product.	Description
Cross-Reference tab
Alternate ID (in a row with the External SKU alternate type)	SKU
Alternate ID (in a row with the Barcode alternate type)	Barcode
eCommerce tab
Availability The Set as Available (Track Qty.) option is inserted in the box for the item if the corresponding product has the Track quantity check box selected, and the Set as Available (Don't Track Qty.) option is inserted if the check box is cleared.	Track quantity
When Qty. Unavailable The Do Nothing option is inserted in the box for the item if the corresponding product has the Continue selling when out of stock check box selected, and the Set as Unavailable option is inserted if the check box is cleared.	Continue selling when out of stock
Packaging tab
Weight The system populates the box for only a stock item.	Weight
Weight UOM The system populates the box for only a stock item.	Weight, the unit of measure

Assignment of the Tax Category

During the import of a product with variants from the Shopify store, the system searches for a tax category to assign to the corresponding template and matrix items created on the Template Items (IN203000), Stock Items (IN202500), and Non-Stock Items (IN202000) forms as follows until it finds a tax category:

It checks the mapping settings on the Import Mapping tab of the Entities (BC202000) form for the corresponding store and the Template Item entity.
It checks the substitution list specified in the Tax Categories box (Substitution Lists section) on the Order Settings tab of the Shopify Stores (BC201010) form.
It checks the tax category from the item class assigned to the template and matrix item on the General tab of the Template Items, Stock Items, and Non-Stock Items forms.

Assignment of the Vendor

During the import of a product with variants, the system may import vendor data for the imported products if both of the following conditions are met:

The product has a vendor specified in the Vendor box (Product organization section) of the product management page in the Shopify store.
The vendor specified for the product matches any existing vendor name in the Account Name box on the General tab of the Vendors (AP303000) form.

In this case, the system adds a row with this vendor on the Vendors tab to the corresponding template and matrix items created or updated on the Template Items (IN203000), Stock Items (IN202500), and Non-Stock Items (IN202000) forms. Also, the system selects the Default check box in the row with the added vendor.