Configuration to control Item Quantity during Inventory Export

You can configure the Inventory Export saved search to control the item quantity that is transferred from NetSuite to eBay.

At present, the Integration App doesn’t have a direct setting that allows you to control the quantity that is transferred from NetSuite to eBay. But, you can control the quantity to be transferred by editing the Inventory Export saved search.

Use the following steps to achieve this:

1. Identify the NetSuite saved search that is being used for syncing the inventory under the Inventory data flow.
   
2. Edit the respective saved search in NetSuite.
3. Under the Results tab, enter the formula for Quantity as needed.
   

Here are a couple of example scenarios:

1. Higher Quantity Cap: If the quantity of an item is greater than 5 then send 5 otherwise send the actual quantity.
   
   Case Statement:
   CASE WHEN (NVL({locationquantityavailable},0) > 5) THEN 5 ELSE NVL({locationquantityavailable},0) END
   
   
2. Conditional/Nested CASE Statement: 
   If the item is inactive then send quantity as 0 else perform the next check.
   If the item is a Drop Ship or a Special Item and the inventory location is preferred then send quantity as 30.
   If the item is a Drop Ship or a Special Item and the inventory location is NOT preferred then send quantity as 0.
   If the item is NOT a Drop Ship or a Special Item and the inventory location is preferred then send the quantity available for that Item.
   If the item is NOT a Drop Ship or a Special Item and the inventory location is NOT preferred then send quantity as 0.
   
   Case Statement:
   CASE WHEN {isinactive}='T' THEN 0 ELSE CASE WHEN {isdropshipitem}='T' OR {isspecialorderitem}='T' THEN CASE WHEN {inventorylocation}={preferredlocation} THEN 30 ELSE 0 END ELSE CASE WHEN {inventorylocation} = {preferredlocation} THEN NVL({locationquantityavailable}, 0) ELSE 0 END END END

Likewise, your specific requirement can be achieved by modifying the existing CASE statement.