# Inventory report and credit usage **URL:** \ **Category:** GraphQL API\ **Created:** [August 10, 2019, 5:39am UTC](https://community.shiphero.com/t/inventory-report-and-credit-usage/76 "2019-08-10T05:39:13Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![amit.wilson](https://avatars.discourse-cdn.com/v4/letter/a/a6a055/32.png) [@amit.wilson](https://community.shiphero.com/u/amit.wilson)\ **Post date:** [August 10, 2019, 5:39am UTC](https://community.shiphero.com/t/inventory-report-and-credit-usage/76/1 "2019-08-10T05:39:13Z")
Hi, this post is somewhere between a feature request and a limit-increase request. We need to pull a complete inventory report each day. We use this to place orders with suppliers and to transfer stock between warehouses. At our currently SKU volume, the inventory report requires in excess of 15,000 credits. And this credits-requirement will rise in the future. Once the inventory report is fetched our system makes transfer and purchase orders. And this requires even more credits. So in the first few hours of operation each day, we need a significant multiple of the current credit-limit of 5,000 per hour. So could you please look at 1. either increasing the credit limit? 2. Or setting the limit at 120,000 credits for 24 hours instead of an hourly limit 3. Or have a separate query with separate credit limits for standard reports like inventory? Thank you. ---
**Author:** ![jeremyw](https://avatars.discourse-cdn.com/v4/letter/j/3da27b/32.png) [@jeremyw](https://community.shiphero.com/u/jeremyw)\ **Post date:** [August 15, 2019, 3:01pm UTC](https://community.shiphero.com/t/inventory-report-and-credit-usage/76/2 "2019-08-15T15:01:36Z")
I, too, would like to see something like this. We’ve been moving some of our reporting and automation to use data from ShipHero instead of some of our other systems, but since some of the standard reports don’t include fields we need, we have to use the API. And since we generally need to have a full list of inventory and product attributes as a basis for the reports, hitting those limits makes the workflow a lot harder. I get why there are limits in place, but it certainly does create headaches when the data we need to get at en masse is available only in the API. ---
**Author:** ![seba](https://avatars.discourse-cdn.com/v4/letter/s/50afbb/32.png) [@seba](https://community.shiphero.com/u/seba)\ **Post date:** [August 16, 2019, 9:22pm UTC](https://community.shiphero.com/t/inventory-report-and-credit-usage/76/3 "2019-08-16T21:22:40Z")
@jeremyw @amit.wilson could you please share the queries you are using to fetch the inventory report you are trying to mimic? ---
**Author:** ![amit.wilson](https://avatars.discourse-cdn.com/v4/letter/a/a6a055/32.png) [@amit.wilson](https://community.shiphero.com/u/amit.wilson)\ **Post date:** [August 17, 2019, 4:56am UTC](https://community.shiphero.com/t/inventory-report-and-credit-usage/76/4 "2019-08-17T04:56:05Z")
``` Hi Seba, here is the query we are using: query { products { data ( after: "' + nextPage + '" ) { pageInfo { endCursor hasNextPage } edges { node { id name sku barcode value warehouse_products { on_hand inventory_bin } }}}}}; And the variable *nextPage* is the endCursor value. ``` ---
**Author:** ![jeremyw](https://avatars.discourse-cdn.com/v4/letter/j/3da27b/32.png) [@jeremyw](https://community.shiphero.com/u/jeremyw)\ **Post date:** [August 19, 2019, 3:31pm UTC](https://community.shiphero.com/t/inventory-report-and-credit-usage/76/5 "2019-08-19T15:31:32Z")
Hi @seba , Mine is a bit more hypothetical as we’re still so new to ShipHero and are in the process of development of our automation and reporting processes around it, so this is something that, I think, would cover nearly all bases in terms of product export, regardless of the final destination of the data. ``` query ($cursor: String){ products { request_id complexity data(sort: "sku", after: $cursor) { edges { cursor node { sku name value price kit kit_build barcode created_at components { sku } warehouse_products { inventory_bin inventory_overstock_bin on_hand reserve_inventory } vendors { vendor_id vendor_sku } } } } } } ``` ---
**Author:** ![seba](https://avatars.discourse-cdn.com/v4/letter/s/50afbb/32.png) [@seba](https://community.shiphero.com/u/seba)\ **Post date:** [August 21, 2019, 6:27pm UTC](https://community.shiphero.com/t/inventory-report-and-credit-usage/76/6 "2019-08-21T18:27:04Z")
Thanks guys, we will be looking into the inventory report issue and ways to make this possible. ---
**Author:** ![aaronb](https://avatars.discourse-cdn.com/v4/letter/a/91b2a8/32.png) [@aaronb](https://community.shiphero.com/u/aaronb)\ **Post date:** [September 15, 2025, 2:26pm UTC](https://community.shiphero.com/t/inventory-report-and-credit-usage/76/8 "2025-09-15T14:26:02Z")
Hello, Curious if any resolution has ben found here. We have a client having a similar issue running into limits, but then also errors when staging the query, “when I query ProductsQueryResult, there’s no pageInfo or after cursor to fetch the next page. Am I missing something?” Thanks ---
**Author:** ![sh-agent2](https://avatars.discourse-cdn.com/v4/letter/s/9f8e36/32.png) [@sh-agent2](https://community.shiphero.com/u/sh-agent2)\ **Post date:** [September 29, 2025, 5:41pm UTC](https://community.shiphero.com/t/inventory-report-and-credit-usage/76/9 "2025-09-29T17:41:45Z")
HI Aaronb, Please use the inventory snapshot feature to get a full snapshot of product inventory ---
**Author:** ![aaronb](https://avatars.discourse-cdn.com/v4/letter/a/91b2a8/32.png) [@aaronb](https://community.shiphero.com/u/aaronb)\ **Post date:** [October 1, 2025, 2:23pm UTC](https://community.shiphero.com/t/inventory-report-and-credit-usage/76/10 "2025-10-01T14:23:46Z")
Hey Austin, I have copied them into this thread. They are attempting this, and here’s the issue: When I try to paginate the products endpoint, I get the same results regardless of what I pass in the “after” parameter. Can you help, please? Thanks Aaron ---
**Author:** ![sh-agent2](https://avatars.discourse-cdn.com/v4/letter/s/9f8e36/32.png) [@sh-agent2](https://community.shiphero.com/u/sh-agent2)\ **Post date:** [October 6, 2025, 2:16pm UTC](https://community.shiphero.com/t/inventory-report-and-credit-usage/76/11 "2025-10-06T14:16:12Z")
```auto { products( sku: "string" ) { request_id complexity data(last: 1) { pageInfo { hasNextPage hasPreviousPage startCursor endCursor } edges { node { id } } } } } ``` Then you can put the endcursor as the after parameter.