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.
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. |