# How we can get Product On order

**URL:** <https://community.shiphero.com/t/how-we-can-get-product-on-order/639>\
**Category:** GraphQL API\
**Created:** [August 5, 2020, 3:35pm UTC](https://community.shiphero.com/t/how-we-can-get-product-on-order/639 "2020-08-05T15:35:20Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![varun](https://avatars.discourse-cdn.com/v4/letter/v/e9bcb4/32.png) [@varun](https://community.shiphero.com/u/varun)\
**Post date:** [August 5, 2020, 3:35pm UTC](https://community.shiphero.com/t/how-we-can-get-product-on-order/639/1 "2020-08-05T15:35:20Z")

</div>

Is there a simple way and less credit cost to get the Products `On order` like in dashboard (for a list of products) [https://nimb.ws/uoIBKW](https://nimb.ws/uoIBKW) ?

---

<div class="post-metadata">

**Author:** ![tomasw](https://sea2.discourse-cdn.com/flex020/user_avatar/community.shiphero.com/tomasw/32/248_2.png) [@tomasw](https://community.shiphero.com/u/tomasw)\
**Post date:** [August 5, 2020, 9:59pm UTC](https://community.shiphero.com/t/how-we-can-get-product-on-order/639/2 "2020-08-05T21:59:25Z")

</div>

Hi @varun!  
You could use a Query like this one that will cost you 6

```
query{
  product(sku: "1122335050"){
    request_id
    complexity
    data {
      warehouse_products{
        inbounds (status:"pending",first:5) {
          edges{
            node {
             sku
              quantity
              quantity_received
              quantity_rejected
              sell_ahead
            }
          }
        }
      }
    }
  }
} 

```

Would that work for you?  
Thanks in advance!  
Tom

---

<div class="post-metadata">

**Author:** ![varun](https://avatars.discourse-cdn.com/v4/letter/v/e9bcb4/32.png) [@varun](https://community.shiphero.com/u/varun)\
**Post date:** [August 6, 2020, 8:01am UTC](https://community.shiphero.com/t/how-we-can-get-product-on-order/639/3 "2020-08-06T08:01:58Z")

</div>

Hi @tomasw  
Thank you for your quick reply.  
I’m trying to get On Order at least for 10 products at once.  
The cost of my current query is 101 credits, and if I’m increasing inbound it’s also increase the cost of request.

```
query {
  products{
    complexity
    data(first:10, sort: "-created_at") {
      pageInfo{
        hasNextPage
        hasPreviousPage
        startCursor
        endCursor
      }
      edges {
        node{
          id
          account_id
          name
          sku
          warehouse_products{
            on_hand
            allocated
            backorder
            inbounds(first:10, status:"pending"){
              edges{
                node{
                  po_id
                  quantity
                   quantity_received
                   quantity_rejected
                  po_date
                }
              }
            }
          }
          images{
            src
          }
        }
        cursor
      }
    }
  }
}
```

---

<div class="post-metadata">

**Author:** ![tomasw](https://sea2.discourse-cdn.com/flex020/user_avatar/community.shiphero.com/tomasw/32/248_2.png) [@tomasw](https://community.shiphero.com/u/tomasw)\
**Post date:** [August 11, 2020, 2:08am UTC](https://community.shiphero.com/t/how-we-can-get-product-on-order/639/4 "2020-08-11T02:08:13Z")

</div>

Hi @varun  
That is correct, the cost is based on the following calculation:

First 10 products, and the first 10 Purchase Orders for each of them + the 1 by default (10 \* 10 + 1).  
You could try by lowering the number of Purchase Orders (inbounds). Usually, there is 1 or 2 Purchase orders for a product

Let me know if that still won’t wor for you  
Thanks again!  
Tom