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 Acumatica 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 Acumatica, a stock item is merged with an existing product in BigCommerce if its ID in MYOB Acumatica—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 Acumatica fields to Shopify fields that is used during the export of stock items to Shopify.
| Source Fields (MYOB Acumatica) | 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 Acumatica 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. | |
| 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: GTIN/EAN/UPC/ISBN or Barcode | Cross-Reference tab | Barcode (ISBN, UPC, GTIN, etc.) | Product page > Inventory section |
The system searches for the matching cross-reference of the GTIN/EAN/UPC/ISBN type to export as follows:
If no match is found, the system continues the search for the matching cross-reference of the Barcode type in the same order. |
| Stock Item | General tab > General Settings settings | This is a physical product: Selected | Product page > Shipping section | |
| Page Title | eCommerce tab | Page title | Product page > Search engine listing section | |
| Meta Description | eCommerce tab | Meta description | Product page > Search engine listing section | |
| Source Fields (MYOB Acumatica) | Target Fields (Shopify) | ||
|---|---|---|---|
| Field Name | Form Object | Field Name | Page Object |
| Stock Items (IN202500) form, eCommerce tab | |||
| Availability: Set as Available (Track Qty.) | eCommerce tab | Track quantity: Selected | Product page > Inventory section |
| Availability: Set as Available (Don't Track Qty.) | eCommerce tab | Track quantity: Cleared | Product page > Inventory section |
| Availability: Set as Pre-Order | eCommerce tab | Track quantity: Cleared | Product page > Inventory section |
| Availability: Do Not Update | eCommerce tab | Track quantity: No changes | Product page > Inventory section |
| Availability: Set as Unavailable | eCommerce tab | Track quantity: Cleared | Product page > Inventory section |
| Status: no sales channel selected | Publishing section | ||
| Availability: Store Default | eCommerce tab | See the following rows of the table. | |
| The following settings are applied if Availability on the eCommerce tab of the Stock Items form is set to Store Default. | |||
| Shopify Stores form, Inventory Settings tab | |||
| Default Availability: Set as Available (Track Qty.) | Inventory Settings tab | Track quantity: Selected | Product page > Inventory section |
| Default Availability: Set as Available (Don't Track Qty.) | Inventory Settings tab | Track quantity: Cleared | Product page > Inventory section |
| Default Availability: Do Not Update | Inventory Settings tab | Track quantity: No changes | Product page > Inventory section |
| Default Availability: Set as Unavailable | Inventory Settings tab | Track quantity: Cleared | Product page > Inventory section |
| Status: no sales channel selected | Publishing section | ||
| The following settings are applied if Availability is set to Set as Available (Track Qty.) on the eCommerce tab of the Stock Items form and the item quantity becomes 0. | |||
| Stock Items form, eCommerce tab | |||
| When Qty. Unavailable: Do Nothing | eCommerce tab | Continue selling when out of stock: No changes | Product page > Inventory section |
| When Qty. Unavailable: Set as Unavailable | eCommerce tab | Continue selling when out of stock: Cleared | Product page > Inventory section |
| Status: no sales channel selected | Publishing section | ||
| When Qty. Unavailable: Set as Pre-Order/Continue Selling | eCommerce tab | Continue selling when out of stock: Selected | Product page > Inventory section |
| The following settings are applied if When Qty. Unavailable is set to Store Default on the eCommerce tab of the Stock Items form and the item quantity becomes 0. | |||
| Shopify Stores form, Inventory Settings tab | |||
| When Qty. Unavailable: Do Nothing | Inventory Settings tab | Continue selling when out of stock: No changes | Product page > Inventory section |
| When Qty. Unavailable: Set as Unavailable | Inventory Settings tab | Continue selling when out of stock: Cleared | Product page > Inventory section |
| When Qty. Unavailable: Set as Continue Selling | Inventory Settings tab | Continue selling when out of stock: Selected | Product page > Inventory section |