2021.2 1. Products and Items
- Gregor Pollak
Products and Items are the same concept NetSuite and Magento. Same thing, two different names. This section explains how those are connected in NetSuite Connector.
What?
The NetSuite Connector handles Item data one-way only. The data flows from NetSuite (Item Master) to Magento. In NetSuite, the following Item types are supported:
- Inventory Item
- Matrix Item
- Matrix Child Item
- Assembly Item
- Kit Item
- Item Group - see Roadmap for support (TBD Gregor Pollak link)
Thru NetSuite Connector, they are translated into the following Magento types:
- Simple Product
- Configurable Product
- Bundle Product
- Group Product - see Roadmap for support (TBD Gregor Pollak link)
The translation (or mapping as we call it) OOTB:
| NetSuite Item Type | Magento Product Type |
|---|---|
| Inventory Item | Simple Product |
| Matrix Item | Configurable Product |
| Matrix Child Item | Simple Product (linked to Configurable Product) |
| Assembly Item | Simple Product |
| Kit Item | Bundle Product |
| Item Group | Group Product |
Do you need a different combination? It can be done!
How?
The translation from NetSuite Item into Magento Product is split down into 3 simple sections:
Preset Data
Some of the (more technical) data is set through the NetSuite Connector Configuration in Magento, like Attribute Set or Store Scope. For more technical information, see Configuration & Setup.
Mapping Data
The main part of the translation is our Mapping table in NetSuite Connector Configuration in Magento. It allows linking the NetSuite Item field (either Standard or Custom) to Magento Product Attribute which makes data management between systems extremely easy.
Data Customization
Some parts of Item data coming from NetSuite require additional logic to get the Magento Product working as we want it. A good example - we've created a Customization that pulls Images from the NetSuite Item and saves them in the Magento Product.
What about stock?
The stock data is also synced one-way only. We fetch data from NetSuite in an interval defined by the client. It can be reduced down to 1 minute. We even support merging Stock data from multiple locations in NetSuite into a single stock number in Magento. If you want to use Magento Multi-Source-Inventory (or Advanced Inventory as it's called now - don't mix it up with NetSuite Advanced Inventory Module), it should be supported by the NSC in a future release. Check with your Account Manager for detail.