I have been running a service that updates the quantity on hand (QOH) for various listings for my clients. The process has always been lacking because the only ID I have on the warehouse side is the SKU. I cannot update ebay listings by Sku directly instead it must be by itemid.
I created a process that goes through and calls GetSellerList
It loops through this list and figures out the itemId by comparing the sku of the listing. I can't search by sku so I have to grab all of the active listings then loop through them. It saves these ids for later use, so it does not have to run again until something is missing. Not a bad process if its not run too much but some of my clients have very old listings which ebay will sometimes not even return and just timeout.
When I have a client that has very large amount listings, I request an ebay report that lists the items for sale. This is then processed via a manually run job.
This process is not great. Although I could probably automate the process via file I still run into issues with a listing that has multiple variations of the main item (small medium large, red, blue etc).
How can I improve this process? The newer rest inventory api does not work because it can only handle listings created through the UI or not the process the warehouses I support use to create their listings.