eBay aged inventory desk: send offers and drop prices

Build me an aged inventory desk for my eBay store: one screen where I work through the listings that are just sitting there and push them out the door with discount offers or price drops, instead of clicking through Seller Hub one listing at a time.

The main view is a board of my active listings. Pull the listings from eBay with Get Inventory Items and Get Offers, and pull views and impressions per listing from Get Traffic Report. Each row shows the title and SKU, days live, current price, quantity remaining, and views and impressions from the traffic report. Let me sort by days live and by traffic, and let me search by SKU or title.

Filter the board by default to the aged inventory that is actually worth working: fixed price Buy It Now listings only, live for at least fourteen days, with traffic but no sales. Auction listings and auctions with Buy It Now must be excluded, because eBay does not allow seller initiated discount offers on them. Make the days live threshold and the traffic threshold adjustable from the UI, and let me clear the filters to see everything active.

Mark on each row whether eBay currently says the listing is eligible for a seller initiated discount offer, using Find Eligible Items. Do not compute eligibility yourself, take it from that call, and make ineligible rows visually distinct so I do not waste time on them. Note that the traffic report gives views and impressions only, so do not show or promise a per listing watcher count anywhere in the app.

From a row I need two actions. First, send a discount offer to interested buyers using Send Offer To Interested Buyers, where I pick the discount percentage and optionally a message. Second, drop the price outright using Bulk Update Price Quantity. Let me select multiple rows and apply a price drop across them, and batch the calls in groups of no more than twenty five records, which is the eBay limit for that call.

Enforce a floor price on both actions. I keep a Google Sheets cost and floor sheet with one row per SKU. Read it with Get Values, cache the floor per SKU so the app is not re-reading the sheet on every keystroke, and block any offer or price change whose resulting price would fall below that SKU's floor. When something is blocked, tell me the floor and the price I tried, do not just fail silently. If a SKU has no row in the floor sheet, flag that on the row and refuse the discount action until a floor exists rather than guessing one.

Log every offer and price change to a history tab in the same Google Sheets spreadsheet with Append Values: timestamp, SKU, listing title, action type, the old price, the new price or discount percentage, and the floor at the time. Surface that history back in the app so each row shows what I already tried on that listing and when, which keeps me from stacking offers on something I discounted three days ago.

Add a "Suggest this week's offers" button that kicks off a background agent. The agent reviews every eligible stale listing on the board, looks at its traffic trend from Get Traffic Report, reads its floor from the Google Sheets cost sheet with Get Values, and checks the logged history for whether the listing already got an offer recently. For each listing it writes back into the app a proposed discount percentage and a one line reason. The proposals land in the app as a review queue where I can approve or skip in bulk, and approving is what actually calls Send Offer To Interested Buyers. Nothing the agent proposes goes out to buyers without my approval, and every proposal still passes the floor price check before it can be sent.