Articles in this section

Sync item inventory from NetSuite to Amazon

Saikumar Rachamalla
Updated

NetSuite inventory to Amazon inventory Add/Update

The flow syncs inventory data from NetSuite to Amazon. It consists of one source (export) and one destination (import). It exports modified inventory records from NetSuite in delta mode and processes them in batches. The flow only retrieves records that have been modified since the last successful run. This is determined by the 'lastquantityavailablechange' field, which tracks changes in inventory levels. The export is further optimized by grouping records based on their internal IDs and processing them in batches of up to 1000 records. The flow syncs inventory levels based on NetSuite's "Quantity Available" field to Amazon.

NetSuite Kit Inventory to Amazon Inventory Add/Update

A kit item represents a group of components sold together as a single product. The flow syncs inventory levels for kit items (bundled products) from NetSuite to Amazon. It consists of one source (export) and one destination (import). The flow sends the data in groups of up to 1,000 records at a time, with a limit of 15,000 records in a single request. This flow calculates kit availability in NetSuite based on component quantities and updates the corresponding kit SKUs in Amazon. It ensures correct stock availability for kits, preventing overselling and improving order accuracy.

Configure inventory or kit inventory settings

  • NetSuite saved search for syncing inventory: Select the appropriate saved search. Refresh to fetch the latest values for the saved search.

  • NetSuite saved search for syncing inventory for Kit Items: Select the appropriate saved search. Refresh to fetch the latest values for the saved search. Use a dedicated saved search for kit items when syncing kits.

  • Calculate Kit Inventory per Location: If enabled, the Integration App will first calculate a sellable inventory of kits per location using the quantity of each member item, and then will send the sum of all the sellable quantities across all the locations. If disabled, the Integration App will first calculate the total inventory for each member item across all the locations, and then calculate the inventory for a kit.

  • Always sync inventory levels for the entire catalog: NetSuite locations to pick inventory from: Inventory export data flow picks the inventory (for all the NetSuite items linked to Amazon) from the chosen NetSuite locations and syncs/exports it to Amazon. If multiple locations are selected, the inventory from all these locations is added to the total and synced to Amazon.

  • NetSuite locations to pick inventory from: Inventory export data flow picks the inventory (for all the NetSuite items linked to Amazon) from the chosen NetSuite locations and syncs/exports it to Amazon. If multiple locations are selected, the inventory from all these locations is added to the total and synced to Amazon.

  • Item aliases are configured in NetSuite: Use this check box if you have configured item aliases in NetSuite that link multiple Amazon SKUs with a single SKU in NetSuite. Ensures accurate synchronization across all aliases. For more information, see Item Aliases.

Note

Amazon only allows 15 feed requests per hour.

Understand the flows

  • Sync inventory levels

    • Exports quantity available from NetSuite.

    • Updates Amazon every 15 minutes (default schedule).

    • Consolidates multiple NetSuite locations into a single Amazon quantity

    • Amazon feed rate limits: Amazon accepts up to 15 feeds per hour

  • Supported item types

    • Inventory (Matrix and Non-Matrix) - Syncs all variations automatically

    • Assembly (Matrix and Non-Matrix) - Uses calculated available quantity

    • Kit Items (with special configuration) - Calculates availability based on component stock levels

  • Required fields

    • Item internal ID

    • Amazon SKU

    • Quantity available

    • Location (if using multiple locations)

    • For kit items:

      • Kit item internal ID

      • Component item details

  • Item mapping requirements

    • Each NetSuite item must have an Amazon SKU field populated

    • Amazon SKUs must match exactly between NetSuite and Amazon

    • Missing or incorrect SKUs will cause sync failures

  • Inventory Sharing Across Aliases

    • If using item aliases (multiple Amazon SKUs for one NetSuite item)

    • Ensure sufficient NetSuite stock to cover all Amazon SKU variations

    • Monitor closely to prevent overselling

    Note

    Amazon FBA inventory adjustments cannot sync back to NetSuite kit items due to NetSuite limitations

Item inventory calculations

  • Single location: Calculates sellable kit inventory per location and then aggregates across all locations. Select your primary warehouse location. All inventory will sync from this location only.

  • Multi-location: First calculates the total inventory for each member item across all locations, then computes the kit availability. Select multiple NetSuite locations in the NetSuite Locations to Pick Inventory From setting. Inventory levels will be merged/summed across all selected locations.

    Example: Location A (50 units) + Location B (30 units) = 80 units sent to Amazon.

  • Kit item inventory calculations

    • When enabled,

      • Calculates the sellable kit quantity for each location separately

      • Sums the sellable quantities across all locations

      • Sends the total to Amazon

    • When disabled,

      • Calculates total inventory for each component across all locations

      • Determines kit availability based on the limiting component

      • Sends the calculated kit quantity to Amazon

Examples

Example 1: Kit = 1x Item A + 2x Item B

  • Location 1: Item A (10), Item B (25) → Can make 10 kits

  • Location 2: Item A (15), Item B (30) → Can make 15 kits

  • Enabled: Sends 25 kits to Amazon

  • Disabled: Total Item A (25), Item B (55) → Sends 25 kits to Amazon

Example 2: Per Location Mode (Enabled)

Starter Kit = 1x Base Unit + 2x Accessories

  • Location A:

    • Base Units: 10 available

    • Accessories: 15 available (7 kits possible)

    • Location A can make: 7 kits

  • Location B:

    • Base Units: 8 available

    • Accessories: 20 available (10 kits possible)

    • Location B can make: 8 kits

Total sent to Amazon: 15 kits (7 + 8)

Example 3: Cross-location mode (Disabled) - Same kit, same inventory:

Total Across Locations:

  • Base Units: 18 total (10 + 8)

  • Accessories: 35 total (15 + 20) → 17 kits possible

  • Limiting component: Base Units (18 available)

Total sent to Amazon: 18 kits

Before you run the inventory flows

  • Verify the Amazon SKU field is populated in NetSuite. Check that the SKU matches exactly in Amazon Seller Central.

  • If you’re syncing item aliases, check that the Item aliases are configured in the NetSuite box and verify that the aliases are properly set up in NetSuite.

  • If you want to sync data with zero quantity, change the quantity field data type to "string" and add a handlebar expression for AFN items. For more information, see Sync item with quantity 0 to Amazon.

Run the inventory flows

  1. Log in to your integrator.io account.

  2. Click Amazon - NetSuite integration app.

  3. Go to Flows > Inventory.

  4. Next to the NetSuite Kit Inventory to Amazon Inventory Add/Update or NetSuite Kit Inventory to Amazon Inventory Add/Update flow, click Run.

You can find the flow progress on the

  • Flow Builder > Run console tab OR

  • Dashboard > Running flows tab

Sync Amazon’s “Remote Fulfillment with FBA” program data

Amazon updated the inventory feed processing for the sellers who have enrolled in the “Remote Fulfillment with FBA” program. If you are a seller who enrolled in the “Remote Fulfillment with FBA” program by Amazon, in the NetSuite Inventory to Amazon Inventory Add/Update flow, configure the SwitchFulfillmentTo mapping.

In the inventory feeds that do not meet the SwitchFulfillmentTo requirement, an error message is displayed: "For accounts enrolled in Remote Fulfillment with FBA, the inventory feed SwitchFulfillmentTo element must include the fulfillment channel (AFN: Amazon Fulfilled Network or MFN: Merchant Fulfilled Network)."

Note

This applies to the US, Canada, and Mexico marketplaces.

To sync inventory (feed submissions data), configure the following mapping:

  1. Log in to your integrator.io account.

  2. Click Amazon - NetSuite integration app.

  3. Go to Flows > Inventory.

  4. Next to the NetSuite Inventory to Amazon Inventory Add/Update flow, click Edit Mapping.

  5. Add the following mapping:

    Export field (NetSuite)

    Import field (Amazon MWS)

    Hard-code the value as either "AFN" or "MFN".

    If you wish to have both the values, add a lookup mapping.

    SwitchFulfillmentTo

  6. Click Save & close.

Sync item with quantity 0 to Amazon

To send an item with a quantity of 0 to Amazon, follow the steps below:

  1. Log in to your integrator.io account.

  2. Click Amazon - NetSuite integration app.

  3. Go to Flows > Inventory.

  4. Next to the NetSuite Kit Inventory to Amazon Inventory Add/Update flow, click Mapping.

  5. On the Flow Builder page, next to the Amazon Kit Inventory Import Adaptor., click Edit Mapping.

  6. Locate the quantity field mapping and click Settings.

  7. Change the data type of the quantity field to string.

  8. Click Save.

  9. Run the NetSuite inventory to Amazon inventory Add/Update flow.

The flow allows you to send the SKU with a quantity of 0 to Amazon. This sends quantity "1" for AFN items with 0 stock, "0" for MFN items.

If you're trying to sync an AFN (Amazon Fulfilled Network) item with a quantity of 0, use the following handlebar expression in the quantity mapping:

{{#compare [Switch Fulfillment To] "==="

"AFN"}}1{{else}}{{Quantity}}{{/compare}}