Listings API - searchListingsItems - Limited to 1000 records on results - How to get full set of results

[kevnhowe]

The Listings API searchListingsItems response returns a numberOfResults value, which returns the count of all listings returned by the query, but the full items list available is limited to 1000 objects. If I have a numberOfResults value greater than 1000, how am supposed to account for the delta? Normally, we'd count on a page token to allow for this, but the token used in this request is limited to the max results for any paginated request; to be used to request up to the max 1000 objects.
My use case - We have 1300 Listings, we need to return all listings on the seller account, but can only return 1000 of them, with no way to retrieve the remaining 300 listings.

[stefnats]

I think for your use case it might be the best approach to use the reports api and use a matching listings report type.
I didn't know that limitation either and I also think it should be addressed, even if it is a flag "moreThanThousand" as a bool. 🤷‍♂️

[ritikacd]

Hi @kevnhowe

We recommend using Inventory reports to retrieve all seller's listings in bulk. Search Listings Items API is intended to filter Selling Partner's listings based on different query parameters available.

Thanks,
Ritika
Selling Partner API Services

[MetaMan2023]

The Listings API searchListingsItems response returns a numberOfResults value, which returns the count of all listings returned by the query, but the full items list available is limited to 1000 objects. If I have a numberOfResults value greater than 1000, how am supposed to account for the delta? Normally, we'd count on a page token to allow for this, but the token used in this request is limited to the max results for any paginated request; to be used to request up to the max 1000 objects. My use case - We have 1300 Listings, we need to return all listings on the seller account, but can only return 1000 of them, with no way to retrieve the remaining 300 listings.

Oh interesting -- so what your saying is not only is there a page limit but a hard limit on the request?

As noted you could use the reports -- which is what we have done for years but I have found that the reports are flawed and don't always return the data, or there is a big lag in the data return.

Also something or be aware of -- let's say you do this:

• Request a report
• Update your catalog
• Request the report again a few minutes later

If you don't want long enough, your change won't show in the report -- typically 15+ minutes.

Also it's not proven, but it seems if you re-request a report within like an hour, you get the same report over and over -- so if you, for example keep requesting the report every 45 minutes, you just get the same report forever -- you have to wait past the window for the old report copy to go away. Again, not proven, but it seems to be the case in the past year that the last report is cached making syncing very complicated.

Also of note -- when finding FBA status reports, I find that FBA listings that are out of stock don't show in the reports which is very problematic. Meaning if you have a SKU that is FBA but currently OOS, it won't show in certain FBA reports -- it's just ignored, even though it is an actual FBA listing.

A workaround I can think of for your issue -- if that API allows you to filter on a SKU or ASIN in some way, you could be creative an run smaller listing requests like this:

• Give me up to 1,000 results for all listings titles begin with A-M
• Give me up to 1,000 results for all listings titles begin with N-Z

I don't know how the filters work and what options you have but it's just an idea to look into.