Product Import: General Information

You can import to MYOB Acumatica products that were initially configured in the BigCommerce store.

Learning Objectives

In this chapter, you will learn how to import products from the BigCommerce store to MYOB Acumatica, where they will be defined as stock and non-stock items.

Applicable Scenarios

You import products from an external system to MYOB Acumatica in the following cases:

• You are initially configuring MYOB Acumatica and need to import products that have already been defined in the external system.
• You manage product information in the external system, have updated any product settings after the product was synchronized with MYOB Acumatica, and need the changes to be reflected in the corresponding inventory items in MYOB Acumatica.

Configuration of Importing Products

Before initially importing products from the BigCommerce store to MYOB Acumatica, you need to specify the needed store settings. To do this, on the BigCommerce Stores (BC201000) form, you select the store and perform the following general steps:

1. You activate the Stock Item and Non-Stock Item entities and specify the proper sync direction for them. To do this, for the Stock Item and Non-Stock Item entities on the Entity Settings tab, you select the Active check box and select the Import option in the Sync Direction column.
2. You decide whether the inventory ID assigned to each item imported to MYOB Acumatica should be the stock-keeping unit (SKU) of the corresponding product in the external system or an ID based on an auto-numbering sequence defined in MYOB Acumatica. Depending on this decision, you do one of the following on the Inventory Settings tab (Import Settings section):
   • Leave the Inventory Numbering Sequence box empty. In this case, for each imported item in MYOB Acumatica, the system populates the Inventory ID box of the Stock Items (IN202500) or Non-Stock Items (IN202000) form with the SKU of the corresponding product in the external system. If a product has no SKU in the external system, the system fails to import it because the assignment of an SKU is required.
   • Select an auto-numbering sequence in the Inventory Numbering Sequence box. The system uses this numbering sequence to generate inventory identifiers for imported stock and non-stock items.
   Note:

   Regardless of whether you specify any numbering sequence, the system adds a row for each imported item on the Cross-Reference tab of the Stock Items or Non-Stock Items form. In the row, it inserts the product SKU from the external system as an alternate ID of the External SKU type.

3. You specify the default item classes for imported items in the Item Class for Stock Items and Item Class for Non-Stock Items boxes on the Inventory Settings tab (Import Settings section).

Product Import and Item Creation

The system imports products from the BigCommerce store to MYOB Acumatica while synchronizing the Stock Item and Non-Stock Item entities, depending on whether the products are physical or not. First, an e-commerce manager prepares the data on the Prepare Data (BC501000) form, and then they process it on the Process Data (BC501500) form.

Depending on the option selected for a product in the Product Type box (Basic Information section) of the product management page in the BigCommerce store, the system imports the product as follows:

• As a stock item on the Stock Items (IN202500) form if the Physical option is selected
• As a non-stock item on the Non-Stock Items (IN202000) form if the Digital option is selected

During the import, some settings of the created stock and non-stock items are imported from the external system, while others are copied from the item class. The system assigns each imported stock or non-stock item the item class specified in the Item Class for Stock Items or Item Class for Non-Stock Items box, respectively, on the Inventory Settings tab of the BigCommerce Stores (BC201000) form. For more details on how the system inserts the settings of imported items, see Product Import: Settings of Imported Items.

If a product has been already imported to MYOB Acumatica and some product settings are changed in the BigCommerce store, during the next import, the system updates the corresponding existing stock or non-stock item.

Limitations of Importing Products

The following limitations apply to the importing of products from the BigCommerce store:

• The length of the product SKU must not exceed the length of the INVENTORY segmented key configured on the Segmented Keys (CS202000) form; otherwise, the import fails.
• Product images are not imported.​
• The price and availability settings are imported only when MYOB Acumatica creates items. After that, these settings are updated in MYOB Acumatica and exported to the external system to prevent discrepancies in the systems.

Also, an alternate ID of the External SKU type assigned to an inventory item during import cannot be updated on the Cross-Reference tab of the Stock Items (IN202500) or Non-Stock Items (IN202000) form. However, the row of the External SKU type with this alternate ID can be deleted in MYOB Acumatica; this will not lead to the deletion of the SKU in the external system during the export of the item from MYOB Acumatica. The SKU can also be updated in the external system and synchronized during the import to MYOB Acumatica; in this case, the system adds the new SKU to the existing inventory item.