The eBay - NetSuite integration app tracks which eBay listings have ended, so the inventory, pricing, and product flows stop sending updates to them. To end a listing from NetSuite, for example when an item sells out, and to relist it later, you update the item's record in NetSuite. This article covers the ended listings flow, the NetSuite fields it uses, and how to end and relist a listing.
How ended listings are tracked
The integration app records each item's eBay listing status in the item's Celigo eBay Item Id Account Map record in NetSuite:
- LISTING ENDED: Selected when the item's eBay listing ends.
- LISTING ENDED TIME: The date and time the listing ended on eBay.
The Celigo eBay Inventory Export Search, Celigo eBay Kit Inventory Export Search, Celigo eBay Pricing Export Search, and Celigo eBay Item Export Search saved searches skip items whose LISTING ENDED box is selected. The Celigo eBay Item Export Search also has two columns for ended listings on its Results subtab: Celigo eBay Item Id Account Map: Listing Ended Time and a Formula (Text) column.
Sync ended listings from eBay
The eBay Ended Listings to NetSuite Update flow finds listings that ended on your eBay account and updates their records in NetSuite. Without it, the inventory and pricing flows keep sending updates for ended listings, and those updates fail with errors.
The flow updates a record only when all of these are true:
- The record's eBay account ID matches the eBay account.
- The record's NetSuite item name matches the listing's SKU.
- The record isn't inactive.
- LISTING ENDED isn't already selected.
- The record's eBay listing ID matches the listing's item ID.
Each run syncs listings that ended since the previous run. For the first run, select Sync all ended listings with NetSuite under Settings > Inventory to sync every listing that ended in the last 120 days. After the first run, clear it.
End a listing from NetSuite
Before you end a listing, make sure the item is already listed on eBay, and that its Celigo eBay Item Id Account Map record isn't inactive, LISTING ENDED is cleared, and LISTING ENDED TIME is empty.
- In NetSuite, open the item, and go to the eTail subtab, and then Celigo eBay Item Id Account Map.
- Select Edit next to the account map record.
- Select LISTING ENDED, and then select Save.
- Edit and save the item record, so that the change is picked up.
- Run the NetSuite Item to eBay Item Add/Update flow.
The listing ends on eBay, and the flow fills in the EBAY LISTING ID and LISTING ENDED TIME on the account map record.
Relist an ended listing
- In the item's Celigo eBay Item Id Account Map record, clear LISTING ENDED.
- Run the NetSuite Item to eBay Item Add/Update flow.
The flow relists the item on eBay, updates EBAY LISTING ID with the new listing ID, and clears LISTING ENDED TIME.