# How to get data same as "On Order" column of Products list page in ShipHero?

**URL:** <https://community.shiphero.com/t/how-to-get-data-same-as-on-order-column-of-products-list-page-in-shiphero/2338>\
**Category:** GraphQL API\
**Created:** [January 30, 2023, 6:15pm UTC](https://community.shiphero.com/t/how-to-get-data-same-as-on-order-column-of-products-list-page-in-shiphero/2338 "2023-01-30T18:15:25Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sannket](https://sea2.discourse-cdn.com/flex020/user_avatar/community.shiphero.com/sannket/32/380_2.png) [@sannket](https://community.shiphero.com/u/sannket)\
**Post date:** [January 30, 2023, 6:15pm UTC](https://community.shiphero.com/t/how-to-get-data-same-as-on-order-column-of-products-list-page-in-shiphero/2338/1 "2023-01-30T18:15:25Z")

</div>

Hi,  
How to get data same as “On Order” of Products list page in ShipHero ?

Actually, we want, how many are on PO’s unreceived for particular product ? I guess that is On Order column is.

Please help to understand & confirm.

---

<div class="post-metadata">

**Author:** ![sh-agent](https://avatars.discourse-cdn.com/v4/letter/s/e47774/32.png) [@sh-agent](https://community.shiphero.com/u/sh-agent)\
**Post date:** [January 30, 2023, 7:55pm UTC](https://community.shiphero.com/t/how-to-get-data-same-as-on-order-column-of-products-list-page-in-shiphero/2338/2 "2023-01-30T19:55:47Z")

</div>

Hey @sannket,

Thanks for reaching out!

Would a query like this solve your issue:

```auto

{
  warehouse_products(warehouse_id: "70405") {
    request_id
    complexity
    data(first: 10) {
      edges{
        node{
          id
          sku
          inbounds(first:10){
            edges{
              node{
                po_id
                quantity_received
                quantity_rejected
                status
              }
            }
          }
        }
      }
    }
  }
}

```

Let me know if this helps!

Best,  
RayanP