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

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.

Hey @sannket,

Thanks for reaching out!

Would a query like this solve your issue:


{
  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