I need to periodically get the inventory on_hand of my 4000+ products. Currently, I am running a “products” query, returning SKU and the warehouse_products data for on_hand. I then loop through the pages to build up my data for processing with my ERP/reporting etc.
This is working fine except, even though I am only returning 2 fields, each query is 101 credits. I run out quickly. Then I have to wait until I get enough credits to run the next page, etc. Not to mention the “Unexpected Errors” along the way. This process is tedious and I figure there has to be a better way. Can anyone point me in a direction that would allow me to get my inventory through the API faster with lower credit usage?