Non-Stock Item Entity
This topic provides reference information about the standard filtering and field mapping used for the Non-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.
Non-Stock Item Filtering
During the export of non-stock items, a non-stock item is skipped if it is a matrix item—that is, a template is specified for the item in the Template ID box on the General tab of the Non-Stock Items (IN202000) form. Matrix items are synchronized as part of the synchronization of template items
Merging of Duplicates
During the export of non-stock items from MYOB Advanced, a non-stock item is merged with an existing product in Shopify if its ID in MYOB Advanced—that is, the value in the Inventory ID box on the Non-Stock Items form—matches the SKU of the product in Shopify.
Non-Stock Item Export Mapping
The following table shows the mapping of MYOB Advanced fields to Shopify fields that is used during the export of non-stock items to Shopify.
| Source Fields (MYOB Advanced) | Target Fields (Shopify) | |||
|---|---|---|---|---|
| Field Name | Form Object | Field Name | Page Object | Notes |
| Non-Stock Items (IN202000) 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. |
| Require Shipment: Cleared | General tab | This is a physical product: Cleared | Product page > Shipping section | |
| Require Shipment: Selected | General tab | This is a physical product | Product page > Shipping section | |
| 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 (Don't Track Qty.) | eCommerce tab | Track quantity | Product page > Inventory section | The Track quantitycheck box is cleared. |
| Availability: Set as Pre-Order | eCommerce tab | Track quantity | Product page > Inventory section | The Track quantitycheck box is cleared. |
| Availability: Set as Unavailable | eCommerce tab | Track quantity | Product page > Inventory section | The Track quantitycheck box is cleared. In the Product availability section, no sales channel is selected. |
| Inventory ID | Summary area | SKU (Stock Keeping Unit) | Product page > Inventory section | |
| 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. |
| URL (Image) | eCommerce tab > Media URLs table | Product page > Media section | ||
| Alternate Type: Barcode | Cross-Reference tab | Barcode (ISBN, UPC, GTIN, etc.) | Product page > Inventory section | |