The inventory flows when scheduled let you keep your simple item and bundle item inventories in sync with your Magento store. This lets you prevent overselling or underselling of your products listed on Magento and lets you maximize sales.
The "NetSuite Inventory to Magento Inventory" flow lets you sync your simple item's inventory from NetSuite to Magento.
The "NetSuite Kit Inventory to Magento Inventory" flow lets you sync your kit item's inventory from NetSuite to Magento.
Before you start
Understand definition and concepts
You have already run these flows in integrator.io
- Product flows
- All the flows under the General section of your Integration App settings.
Adjust item inventory in NetSuite
- Sign in to your NetSuite account.
- Go to Transactions > Inventory > Adjust Inventory.
- In the Inventory Adjustment record, enter appropriate values in Date, Adjustment account, Subsidiary, and Posting period fields.
- Under Adjustments, in the Item column, select the inventory item for which the inventory is to be adjusted.
- In the "Location" column, select the inventory location.
- In the "Adjust qty. By" column, enter the desired quantity.
- Click Save.
The quantity that you adjusted gets added to the existing quantity in Netsuite. For example, if you adjusted the item quantity by 50 and your existing item inventory is 500, the total item inventory will become 550.
When you make an update in the Inventory Adjustment record, the NetSuite saved searches that the Integration App uses fetches the updated records for syncing to your Magento store.
Configure and run the flow to sync simple item inventory
- Sign in to your integrator.io account.
- Click the Magento 2 - NetSuite Integration App tile.
- Go to Settings > Integration Flows > Inventory > Advanced Settings.
- From NetSuite Saved Search for syncing inventory levels, select the appropriate saved search. By default, the "Celigo Magento 2 Inventory Export Search [your instance]" saved search is used for syncing your simple items. You can modify the saved search to define your own criteria.
- Click the Run button corresponding to the "NetSuite Inventory to Magento Inventory" flow.
Info: If you are running this flow for the first time, no records will be synced. You will have to update the inventory adjustment record manually after the first run to sync the record. We recommend that you schedule this flow to run at regular intervals so that the flow picks your updated inventory adjustments automatically.
For syncing inventory levels of existing items, you will have to run the "Magento Product Id to NetSuite Item Mass Update" flow. This will update IDs for the existing items and store them in the "Magento 2 Item ID Map List" record.
You will then have to run this flow again to sync existing item inventory levels automatically to Magento.
Modify your criteria to sync simple items
- In NetSuite, in the global search bar, enter Celigo Magento 2 Inventory Export Search [your Magento instance].
- Press Enter.
- In the results that are displayed, find Celigo Magento 2 Inventory Export Search [your Magento instance].
- Click Edit this Search.
- Under the "Criteria" tab, add the desired criteria.
- Click Save.
Configure and run the flow to sync bundle item inventory
- Sign in to your integrator.io account.
- Click the Magento 2 - NetSuite Integration App tile.
- Go to Settings > Integration Flows > Inventory > Advanced Settings.
- From NetSuite Saved Search for syncing inventory for Kit Items, select the appropriate saved search. By default, the "Celigo Magento 2 Kit Inventory Export Search [your instance]" saved search is used for syncing your simple items. You can modify the saved search to define your own criteria.
- Click the Run button corresponding to the "NetSuite Kit Inventory to Magento Inventory" flow.
Info: If you are running this flow for the first time, no records will be synced. You will have to update the inventory adjustment record manually after the first run to sync the record. We recommend that you schedule this flow to run at regular intervals so that the flow picks your updated inventory adjustments automatically.
For syncing inventory levels of existing items, you will have to run the "Magento Product Id to NetSuite Item Mass Update" flow. This will update IDs for the existing items and store them in the "Magento 2 Item ID Map List" record.
You will then have to run this flow again to sync existing item inventory levels automatically to Magento.
Modify your criteria to sync bundle items
- In NetSuite, in the global search bar, enter Celigo Magento 2 Kit Inventory Export Search [your Magento instance].
- Press Enter.
- In the results that are displayed, find Celigo Magento 2 Kit Inventory Export Search [your Magento instance].
- Click Edit this Search.
- Under the "Criteria" tab, add the desired criteria.
- Click Save.
Configure settings for inventory sync
Define location for inventory sync
- Sign in to your integrator.io account.
- Click the Magento 2 - NetSuite Integration App tile.
- Go to Settings > Integration Flows > Inventory > Advanced Settings > NetSuite locations to pick inventory from.
- Select one or more locations.
- Click Save.
Info: The locations selected are automatically added as criteria in "Celigo Magento 2 Kit Inventory Export Search [your instance]" and "Celigo Magento 2 Inventory Export Search [your instance]" saved searches. Only the inventory of the items that belong to the selected locations will be synced to Magento.
Sync inventory levels for the entire catalog
- Sign in to your integrator.io account.
- Click the Magento 2 - NetSuite Integration App tile.
- Go to Settings > Integration Flows > Inventory > Advanced Settings.
- Select Always sync inventory levels for entire catalog.
Info: Select this checkbox if you want to sync inventory levels for all your Magento products whenever the inventory flows run.
Calculate kit inventory per location
- Sign in to your integrator.io account.
- Click the Magento 2 - NetSuite Integration App tile.
- Go to Settings > Integration Flows > Inventory > Advanced Settings.
- Select Calculate Kit Inventory per location.
Info: Select this checkbox if you want to calculate kit inventory per location. For example, the following table describes the quantities of simple products at different locations.
Location |
Item Name |
Qty |
Item Name |
Qty |
Location 1 |
Simple product 1 |
3 |
Simple Product 2 |
4 |
Location 2 |
Simple product 1 |
4 |
Simple product 2 |
8 |
Total Qty |
7 |
Total Qty |
12 |
If "one Kit Product = one simple product 1 + two simple product 2" and this checkbox is selected, then the total number of kit products available at "Location 1" is two and at "Location 2" is four.
If this checkbox is unchecked, the total number of kit products available at both locations combined will be six.
The Integration App uses similar calculations to populate your inventory levels in Magento for your bundle products based on your selection.
Comments
Please sign in to leave a comment.