Inventory

Naga Sri Hari Gonaboyina

Updated July 14, 2026 18:25

Inventory Adjustment Sync from Amazon to NetSuite - Auto Serial Numbers

The inventory module keeps NetSuite item quantities aligned with what is physically available for fulfillment in Amazon's fulfillment centers. The flow fetches Amazon MCF inventory data via the SP-API Inventory Summaries API and creates an Inventory Adjustment record in NetSuite for each item whose quantity has changed since the last run.

Flow: Amazon inventory to NetSuite inventory adjustment

How the flow works

Export Inventory from Amazon: Calls the SP-API getInventorySummaries endpoint. Runs in delta mode by default using the offsetValue setting to control the time window. Returns fulfillable and unfulfillable quantity fields per seller SKU.
Lookup Items from NetSuite: For each Amazon SKU returned, searches NetSuite for the matching item using the configured Specify the Amazon field to search the matching items in NetSuite setting (sellerSku, fnSku, asin, or productName). If Search for Item Alias is enabled, the search also checks the alias table.
Lookup Item Aliases from NetSuite: If the item alias option is enabled, it performs an additional lookup in the NetSuite item alias table.
Adjust Inventory in NetSuite: Creates a NetSuite Inventory Adjustment record for the sellable quantity location. Sets the item's quantity to match the Amazon value based on the configured fulfillable quantity fields.
Update Amazon Quantities into NetSuite Item: If Update Amazon Quantity fields into NetSuite Item is enabled, writes the raw Amazon quantity field values (fulfillable, unfulfillable, etc.) back to the NetSuite item record.

Inventory settings

Access and configure all settings from the Integration tile > Settings > Inventory before enabling the flow.

Tab: Inventory

Setting (field label)	Type	Required	Default	Description
Specify the Amazon field to search for matching items in NetSuite	Select	Yes	—	Controls how Amazon SKUs are matched to NetSuite items. Options: sellerSku, fnSku, asin, productName.
Select the Amazon quantity fields that should be considered as the total fulfillable quantity.	Multiselect	No	fulfillableQuantity	Defines which Amazon quantity fields sum to the sellable quantity synced to NetSuite. Options: Fulfillable Quantity (fulfillableQuantity), Inbound Working Quantity (inboundWorkingQuantity), Inbound Shipped Quantity (inboundShippedQuantity), Inbound Receiving Quantity (inboundReceivingQuantity), Total Reserved Quantity (totalReservedQuantity).
Select the Amazon quantity fields that should be considered as the total unfulfillable quantity.	Multiselect	No	totalUnfulfillableQuantity	Defines which Amazon quantity fields sum to the damaged/unfulfillable quantity synced to NetSuite. Options: Total Unfulfillable Quantity (totalUnfulfillableQuantity), Customer Damaged Quantity (customerDamagedQuantity), Warehouse Damaged Quantity (warehouseDamagedQuantity), Distributor Damaged Quantity (distributorDamagedQuantity), Carrier Damaged Quantity (carrierDamagedQuantity), Defective Quantity (defectiveQuantity), Expired Quantity (expiredQuantity).
NetSuite Adjustment Account Internal ID	Text	Yes	—	Enter the internal ID of the NetSuite account to be applied to the inventory adjustment record.
Specify the NetSuite Item field ID that matches the Amazon SKU	Text	Yes	—	Enter the NetSuite field ID (e.g., itemid, custitem_sku) that holds the value matching the Amazon SKU field selected above.
Offset time to sync Amazon inventory	Number (minutes)	No	1	Enter the value in minutes to set the offset time to sync Amazon inventory. The recommended value is 4320 (72 hours). Example: if the flow start date is 08:00 AM January 4th, today is 05:00 PM January 7th, and the offset is 4320, inventory will be synced from 08:00 AM January 1st to 05:00 PM January 4th.
Search for Item Alias	Checkbox	No	Unchecked	When selected, the flow also searches the NetSuite item alias table when the primary item lookup does not return a match.
Update Amazon Quantity fields into NetSuite Item	Checkbox	No	Unchecked	When selected, writes the raw Amazon quantity field values back to the NetSuite item record in addition to creating the inventory adjustment.
Auto-assign number to Lot Numbered/Serialized items	Checkbox	No	Unchecked	When selected, automatically assigns inventory numbers to Lot Numbered or Serialized items in NetSuite during the adjustment.

Tab: Location

Setting (field label)	Type	Required	Description
Warehouse location Internal ID for sellable inventory	Text	Yes	Enter the Internal ID of the NetSuite warehouse location where sellable (fulfillable) inventory quantities will be tracked.
Warehouse location Internal ID for damaged inventory	Text	No	Enter the Internal ID of the NetSuite warehouse location where damaged (unfulfillable) inventory quantities will be tracked.

Quantity fields reference

Amazon quantity field	API value	Description	When to use
Fulfillable Quantity	fulfillableQuantity	Units currently in Amazon's fulfillment center and available to ship immediately.	Default and recommended. This is the quantity Amazon can fulfill today.
Inbound Working Quantity	inboundWorkingQuantity	Units in a shipment created but not yet shipped to Amazon.	Not recommended for order availability. Goods have not left your warehouse yet.
Inbound Shipped Quantity	inboundShippedQuantity	Units in a shipment in transit to Amazon.	Use only if your warehouse is very close to Amazon and you have high confidence in arrival time.
Inbound Receiving Quantity	inboundReceivingQuantity	Units at an Amazon fulfillment center being processed/received.	Not recommended for order availability. Goods are at Amazon but not yet fulfillable.
Total Reserved Quantity	totalReservedQuantity	Units reserved for existing orders and not available for new fulfillment.	Informational only. Do not include unless you explicitly want to account for reserved stock.
Total Unfulfillable Quantity	totalUnfulfillableQuantity	Sum of all unfulfillable/damaged quantity types.	Default unfulfillable setting. Use for tracking total damaged inventory in NetSuite.

Item Matching

Specify the Amazon field to search for matching items in NetSuite

Option value	Amazon field	When to use
sellerSku	Seller SKU	Most common. Ensure Seller SKUs in Amazon match the SKU or external ID on your NetSuite item records.
fnSku	FNSKU	Matches on the Fulfillment Network SKU assigned by Amazon.
asin	ASIN	Matches on the Amazon Standard Identification Number. Use if your NetSuite items store the ASIN.
productName	Product Name	Matches on the item display name. Use only if SKUs are not consistently maintained.