The inventory flows in the eBay - NetSuite integration app send item quantities from NetSuite to your eBay listings, so eBay shows what you can actually sell. This article covers how the inventory flows work, how to link existing eBay listings to NetSuite items, the inventory settings, and how to control the quantity you send.
Prerequisites: Mark each item for eBay by setting ETAIL CHANNEL to eBay on the item's eTail subtab. For details, see How NetSuite items are linked to eBay listings.
How the inventory flows work
The NetSuite Inventory to eBay Inventory Add/Update and NetSuite Kit Inventory to eBay Inventory Add/Update flows send inventory levels from NetSuite to eBay every 15 minutes by default. By default, the item's Quantity Available in NetSuite is sent to the matching eBay listing.
These item types are supported:
- Inventory items, matrix and non-matrix
- Assembly items, matrix and non-matrix
- Kit items
If you use multi-location inventory in NetSuite, the flows add up the quantity available at each location and send the total to eBay. To use only some locations, select them in NetSuite locations to pick inventory from.
Link existing eBay listings to NetSuite items
Run the eBay Item Id to NetSuite Mass Update flow before the other inventory flows, so that every active eBay listing is linked to its NetSuite item. The other inventory, pricing, and product flows can't update a listing whose listing ID is missing or wrong in NetSuite.
When the flow runs, it finds the NetSuite item with the same SKU as each active eBay listing. If the item's listing ID in NetSuite is missing or different, the flow saves the eBay listing ID in the item's Celigo eBay Item Id Account Map record, with the item and the eBay account. Only active items are added to this record.
- The flow is part of the Starter edition.
- The flow supports multiple eBay accounts.
- For a matrix item, the flow sets the parent listing ID on every child item and links each child's own SKU.
Inventory settings
Inventory settings are under Settings > Inventory.
| Setting | Description |
|---|---|
| NetSuite saved search for syncing inventory | The NetSuite saved search that selects the items whose inventory is synced. Select Refresh to load the latest saved searches. |
| NetSuite saved search for syncing inventory for Kit Items | The NetSuite saved search that selects the kit items whose inventory is synced. |
| Calculate Kit Inventory per Location | When selected, the integration app calculates how many kits can be sold at each location from the quantities of their member items, and then sends the total across all locations. When cleared, it first totals each member item across all locations, and then calculates how many kits can be sold. |
| Always sync inventory levels for entire catalog | When selected, every NetSuite item linked to eBay is synced each time the inventory flow runs. This setting doesn't affect the kit inventory flow, which always syncs the entire catalog. |
| NetSuite locations to pick inventory from | The NetSuite locations to take inventory from. If you select more than one, the quantities from all of them are added together and sent to eBay. |
| Sync all ended listings with NetSuite | When selected, the ended listings flow syncs all listings that ended on eBay in the last 120 days. When cleared, it syncs only the listings that ended since the last run. Typically, you select it only for the initial sync. For details, see End and relist eBay listings from NetSuite. |
Control the quantity sent to eBay
No setting limits the quantity sent to eBay. To control it, edit the Quantity formula in the inventory saved search.
- Under Settings > Inventory, note the saved search selected in NetSuite saved search for syncing inventory.
- In NetSuite, edit that saved search.
- On the Results subtab, change the formula for the quantity column, and then save the search.
For example, to send at most 5 units:
CASE WHEN (NVL({locationquantityavailable},0) > 5) THEN 5 ELSE NVL({locationquantityavailable},0) ENDTo send 0 for inactive items, 30 for drop-ship and special-order items at their preferred location, the available quantity for other items at their preferred location, and 0 for any other location:
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 ENDChange the conditions in these CASE statements to fit your own rules.