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 Shopify. The topic also contains information about the merging of duplicate records during the synchronization.

Stock Item Filtering

A stock item is skipped if it is a matrix item—that is, if 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.

Merging of Duplicates

During the export of stock items from MYOB Advanced, a stock item is merged with an existing product in BigCommerce if its 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 Shopify.

Stock Item Export Mapping

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

Table 1. Stock Item Export Mapping
Source Fields (MYOB Advanced)		Target Fields (Shopify)
Field Name	Form Object	Field Name	Page Object	Notes
Stock Items (IN202500) form
		id	Visible in the URL of the product page (<store URL>/admin/products/<id>)	Product ID is generated by Shopify.
Description	Summary area	Title	Product page
Item Class	General tab > Item Defaults section	Product Type	Product page > Product organization section
Description	Description tab	Description	Product page	Images contained in the description in MYOB Advanced are not exported.
Vendor ID	Vendors tab	Vendor	Product page > Product organization section	The vendor for which the Default check box is selected on the Vendors tab is exported.
Search Keywords	eCommerce tab	Tags	Product page > Product organization section
Category ID	Attributes tab > Sales Categories table	Tags	Product page > Product organization section	Sales categories are exported to tags only if on the Shopify Stores (BC201010) form, the Sales Category Export box is set to Export as Product Tags.
Visibility: Visible	eCommerce tab		Product page > Product status section	The status is set to Active and the Online Store sales channel is selected.
Visibility: Featured	eCommerce tab		Product page > Product status section	The status is set to Active and the Online Store sales channel is selected.
Visibility: Invisible	eCommerce tab		Product page > Product status section	The status is set to Draft.
Availability: Set as Available (Track Qty.)	eCommerce tab	Track quantity	Product page > Inventory section	The Track quantity check box is selected.
Availability: Set as Available (Don't Track Qty.)	eCommerce tab	Track quantity	Product page > Inventory section	The Track quantity check box is cleared.
Availability: Set as Pre-Order	eCommerce tab	Track quantity	Product page > Inventory section	The Track quantity check box is cleared.
Availability: Set as Unavailable	eCommerce tab	Track quantity	Product page > Inventory section	The Track quantity check box is cleared. In the Product status section, no sales channel is selected.
When Qty. Unavailable: Do Nothing	eCommerce tab	Continue selling when out of stock	Product page > Inventory section	The setting applies only to synchronized items whose quantities have been synchronized. The state of the Continue selling when out of stock check box remains unchanged.
When Qty. Unavailable: Set as Unavailable	eCommerce tab	Continue selling when out of stock	Product page > Inventory section	The setting applies only to synchronized items whose quantities have been synchronized. If Available in the Quantity subsection becomes zero, the Continue selling when out of stock check box is cleared.
When Qty. Unavailable: Set as Pre-Order/Continue Selling	eCommerce tab	Continue selling when out of stock	Product page > Inventory section	The setting applies only to synchronized items whose quantities have been synchronized. If Available in the Quantity subsection becomes zero, the Continue selling when out of stock check box is selected.
Inventory ID	Summary area	SKU (Stock Keeping Unit)	Product page > Inventory section
Weight	Packaging tab > Dimensions section	Weight	Product page > Shipping section > Weight subsection
Weight UOM	Packaging tab > Dimensions section	Weight	Product page > Shipping section > Weight subsection
Default Price	Price/Cost tab > Price Management section	Price	Product 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 Shopify Stores form.
Tax Category	General tab > Item Defaults section	Charge tax on this product	Product page > Pricing section	The check box is selected if Tax Category is set to Taxable; the check box is cleared if Tax Category is set to Exempt.
MSRP	Price/Cost tab > Price Management section	Compare at price	Product 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 Shopify Stores form.
Alternate Type: Barcode	Cross-Reference tab	Barcode (ISBN, UPC, GTIN, etc.)	Product page > Inventory section
Stock Item	General tab > General Settings settings	This is a physical product	Product page > Shipping section	The This is a physical product check box is selected for a stock item—that is, for an item with an item class for which the Stock Item check box is selected on the Item Classes form.
Page Title	eCommerce tab	Page title	Product page > Search engine listing section
Meta Description	eCommerce tab	Meta description	Product page > Search engine listing section
Item Classes (IN201000) form
Stock Item	General tab > General Settings section	This is a physical product	Product page > Shipping section	The This is a physical product check box is selected for a stock item—that is, for an item with an item class for which the Stock Item check box is selected on the Item Classes form.