The Inventory Export flow exports an item’s Quantity and Stock Availability from NetSuite to Magento. All other item fields are handled by the Item Export flow. Prior to exporting the quantity of an item from NetSuite to Magento, the Magento Item checkbox field under the Magento subtab on the item record must be checked. Depending on which items need to be linked to Magento, you may want to use NetSuite’s mass update feature to quickly update multiple items & check this field.
The Inventory Export flow exports the value in an item’s Quantity Available standard NetSuite field. Quantities from other standard fields such as Quantity On Hand or any custom fields are not exported. Items marked as drop ship in NetSuite are also not included in the export.
By default, the Item Name/Number field in NetSuite is used to find the corresponding product SKU in Magento. The Internal ID, External ID or any text custom field may also be used. In Magento, only the product SKU or product ID can be used for identifying items. This means that the Connector can use the NetSuite Item Name/Number, Internal or External ID, or any text custom field, but it can only attempt to match those values to the Magento SKU or product ID field.
By default, the Connector ignores an item if the Quantity Available field is blank (null) for all locations in NetSuite.
The Inventory Export runs every 15 minutes to export item quantities and stock availability from NetSuite to Magento. By default, connector only exports the available quantity of items for which the quantity has changed since the last export ran.
Weekly Inventory Export
The Connector also runs a Weekly Inventory Export to export the item quantities and stock availability from NetSuite to Magento for all the items which have been marked as ‘Magento items’ in NetSuite. The Weekly Inventory Export runs by default every Sunday morning US Pacific Time. Both of the flow schedules are customizable and the export can also be run on-demand. These flows can be monitored from the Integration Dashboard.
Supported NetSuite Item Types
- Inventory Item & its Sub Types including Matrix Items
- Assembly Item & its Sub Types
Inventory adjustment in NetSuite
Running the Inventory flow in the Integrator
Inventory export in progress
Inventory record successfully exported
Product catalog in Magento
Inventory items successfully exported and updated (incremented) in Magento