Stock Item Entity

This topic provides reference information about the standard filtering and field mapping used for the Stock Item entity during the synchronization between MYOB Advanced and BigCommerce. The topic also contains information about the merging of duplicate records during the synchronization.

Stock Item Filtering

Filters are applied during the export of stock items. A stock item is skipped if any of the following is true:

  • The stock item is a matrix item—that is, a template is specified for the item in the Template ID box on the General tab of the Stock Items (IN202500) form. Matrix items are synchronized as part of the synchronization of template items.
  • No item sales category is assigned to the stock item and no default category is selected in the Default Stock Categories box on the Inventory Settings tab of the BigCommerce Stores (BC201000) form.

Merging of Duplicates

During the export of stock items from MYOB Advanced, a stock item is merged with an existing product in BigCommerce if at least one of the following conditions is met:
  • The stock item's description in MYOB Advanced—that is, the value in the Description box on the Stock Items (IN202500) form—matches the Product Name of the product in BigCommerce.
  • The stock item's ID in MYOB Advanced—that is, the value in the Inventory ID box on the Stock Items form—matches the SKU of the product in BigCommerce.

Stock Item Export Mapping

The following table shows the mapping of MYOB Advanced fields to BigCommerce fields that is used during the export of stock items to BigCommerce.

Table 1. Stock Item Export Mapping
Source Fields (MYOB Advanced) Target Fields (BigCommerce)
Field Name Form Object Field Name Page Object Notes
Stock Items (IN202500) form
Inventory ID Summary area SKU Product management page > Basic Information section SKU also appears under Product Identifiers.
Description Summary area Product Name Product management page > Basic Information section The Description in MYOB Advanced must be unique.
Product Type Product management page > Basic Information section Default: Physical
Description Description tab Description Product management page > Description section
Weight Packaging tab > Dimensions section Weight Product management page > Basic Information section
Default Price Price/Cost tab > Price Management section Default Price Product management page > Pricing section If the Multiple Base Currencies feature is enabled on the Enable/Disable Features (CS100000) form, the system exports the default price defined in the currency of the branch selected on the Order Settings tab of the BigCommerce Stores form.
MSRP Price/Cost tab > Price Management section MSRP Product management page > Pricing section If the Multiple Base Currencies feature is enabled on the Enable/Disable Features (CS100000) form, the system exports the MSRP defined in the currency of the branch selected on the Order Settings tab of the BigCommerce Stores form.
Current Cost Price/Cost tab > Standard Cost section Cost Product management page > Pricing section
General tab
Default Issue From General tab > Warehouse Defaults section Bin Picking Number (BPN) Product management page > Product Identifiers section
Category ID Attributes tab > Sales Categories table Categories Product management page > Basic Information section
eCommerce tab
Visibility: Visible eCommerce tab Visible on Storefront Product management page > Basic Information section The Visible on Storefront check box is selected.
Visibility: Featured eCommerce tab Set as a Featured Product on my Storefront Product management page > Storefront Details section The Visible on Storefront check box is selected, and the Set as a Featured Product on my Storefront check box is selected.
Visibility: Invisible eCommerce tab Visible on Storefront Product management page > Basic Information section The Visible on Storefront check box is cleared.
Search Keywords eCommerce tab Search Keywords Product management page > Storefront Details section
Page Title eCommerce tab Page Title Product management page > Search Engine Optimization section
Meta Description eCommerce tab Meta Description Product management page > Search Engine Optimization section
Availability: Set as Available (Track Qty.) eCommerce tab Track inventory Product management page > Inventory section The This product can be purchased in my online store option button is selected, and the Track inventory check box is selected.
Availability: Set as Available (Don't Track Qty.) eCommerce tab Track inventory Product management page > Inventory section The This product can be purchased in my online store option button is selected, and the Track inventory check box is cleared.
Availability: Set as Pre-Order eCommerce tab This product is coming soon but I want to take pre-orders Product management page > Purchasability section The This product can be purchased in my online store option button is selected.
Availability: Set as Unavailable eCommerce tab This product cannot be purchased in my online store Product management page > Purchasability section The This product cannot be purchased in my online store option button is selected.
Custom URL eCommerce tab Product URL Product management page > Search Engine Optimization section
URL (Image) eCommerce tab > Media URLs table Images Product management page > Images & Videos section
URL (Video) eCommerce tab > Media URLs table Videos Product management page > Images & Videos section
Cross-Reference tab
Alternate Type: Vendor Part Number Cross-Reference tab Manufacturer Part Number (MPN) Product management page > Product Identifiers section The first row for Vendor Part Number with the default vendor is used.
Alternate Type: Barcode Cross-Reference tab Product UPC/EAN Product management page > Product Identifiers section The first row for Barcode with the base UOM is used.