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 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 Acumatica,
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 Acumatica—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 Acumatica—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 Acumatica fields to BigCommerce fields that is used during the export of stock items to BigCommerce.
| Source Fields (MYOB Acumatica) | 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 Acumatica must be unique. |
| Product Type: Physical | Product management page > Basic Information section | |||
| 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: Selected | Product management page > Basic Information section | |
| Visibility: Featured | eCommerce tab | Visible on Storefront | Product management page > Basic Information section | |
| Set as a Featured Product on my Storefront | Product management page > Storefront Details section | |||
| Visibility: Invisible | eCommerce tab | Visible on Storefront: Cleared | Product management page > Basic Information section | |
| 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 | |
| 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 system searches for the matching cross-reference of the Barcode type to export as follows:
|
| Alternate Type: GTIN/EAN/UPC/ISBN | Cross-Reference tab | Global Trade Item Number (GTIN) | Product management page > Product Identifiers section |
The system searches for the matching cross-reference of the GTIN/EAN/UPC/ISBN type to export as follows:
|
| Source Fields (MYOB Acumatica) | Target Fields (BigCommerce) | ||
|---|---|---|---|
| Field Name | Form Object | Field Name | Page Object |
| Stock Items (IN202500) form, eCommerce tab | |||
| Availability: Set as Available (Track Qty.) | eCommerce tab | This product can be purchased in my online store: Cleared | Product management page > Purchasability section |
| Track inventory: Selected | Product management page > Inventory section | ||
| Availability: Set as Available (Don't Track Qty.) | eCommerce tab | This product can be purchased in my online store: Selected | Product management page > Purchasability section |
| Track inventory: Cleared | Product management page > Inventory section | ||
| Availability: Set as Pre-Order | eCommerce tab | This product is coming soon but I want to take pre-orders: Selected | Product management page > Purchasability section |
| Track inventory: Cleared | Product management page > Inventory section | ||
| Availability: Set as Unavailable | eCommerce tab | This product cannot be purchased in my online store: Selected | Product management page > Purchasability section |
| Track inventory: Cleared | Product management page > Inventory 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. | |||
| BigCommerce Stores form, Inventory Settings tab | |||
| Default Availability: Set as Available (Track Qty.) | Inventory Settings tab | This product can be purchased in my online store: Cleared | Product management page > Purchasability section |
| Track inventory: Selected | Product management page > Inventory section | ||
| Default Availability: Set as Available (Don't Track Qty.) | Inventory Settings tab | This product can be purchased in my online store: Selected | Product management page > Purchasability section |
| Track inventory: Cleared | Product management page > Inventory section | ||
| Default Availability: Set as Pre-Order | Inventory Settings tab | This product is coming soon but I want to take pre-orders: Selected | Product management page > Purchasability section |
| Track inventory: Cleared | Product management page > Inventory section | ||
| Default Availability: Do Not Update | Inventory Settings tab | This product is coming soon but I want to take pre-orders: No Changes | Product management page > Purchasability section |
| Track inventory: No Changes | Product management page > Inventory section | ||
| Default Availability: Set as Unavailable | Inventory Settings tab | This product cannot be purchased in my online store: Selected | Product management page > Purchasability section |
| Track inventory: Cleared | Product management page > Inventory section | ||
| The following settings are applied if Availability is set to Set as Available (Track Qty.) and the item quantity becomes 0. | |||
| Stock Items (IN202500) form, eCommerce tab | |||
| When Qty. Unavailable: Do Nothing | eCommerce tab | No changes | Product management page > Purchasability section |
| When Qty. Unavailable: Set as Unavailable | eCommerce tab | This product cannot be purchased in my online store: Selected | Product management page > Purchasability section |
| Track inventory: Cleared | Product management page > Inventory section | ||
| When Qty. Unavailable: Set as Pre-Order/Continue Selling | eCommerce tab | This product is coming soon but I want to take pre-orders: Selected | Product management page > Purchasability section |
| Track inventory: Cleared | Product management 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. | |||
| BigCommerce Stores (BC201000) form, Inventory Settings tab | |||
| When Qty. Unavailable: Do Nothing | Inventory Settings tab | No changes | Product management page > Purchasability section |
| Product management page > Inventory section | |||
| When Qty. Unavailable: Set as Unavailable | Inventory Settings tab | This product cannot be purchased in my online store: Selected | Product management page > Purchasability section |
| Track inventory: Cleared | Product management page > Inventory section | ||
| When Qty. Unavailable: Set as Pre-Order | Inventory Settings tab | This product is coming soon but I want to take pre-orders: Selected | Product management page > Purchasability section |
| Track inventory: Cleared | Product management page > Inventory section | ||