On order on the product file

GraphQL API
1

Is it possible to query the quantity on order at product level? Rather than getting all of the outstanding purchase orders.

2

Hi @dngreen !
Would a query like this work for you:

query {
  product(id: <productId>) {
    request_id
    complexity
    data {
      id
      legacy_id
      account_id
      name
      sku
      warehouse_products {
        id
        legacy_id
        on_hand
        backorder
        allocated
        available
        on_order
      }
    }
  }
}

With the on_order matching the value as seen on : https://app.shiphero.com/dashboard/products ?
Thanks!
Tom

1 Like
3

Tomas - Are you saying your query example will work?

“on_order” is not a member of the WarehouseProduct class. Am I missing something here? I would also like to get the “on_order” as calculated by Shiphero rather than iterating POs.

4

Hi @bbarrett!
I think that was intended for a Feature Request actually

Try with this Query instead:

query {
  product(sku: "1122334462") {
    request_id
    complexity
    data {
      id
      legacy_id
      account_id
      name
      sku
      warehouse_products {
        id
        legacy_id
        on_hand
        backorder
        allocated
        available
        inbounds (first:10) {
          pageInfo{
            hasNextPage
          }
          edges {
            node {
              quantity
              sell_ahead
              quantity_received
              quantity_rejected
              status
            }
          }
        }
      }
    }
  }
}

This one will give you an overview of the POs linked to that SKU and the status and quantities.

Let me know if that won’t work for you.
Thanks in advance!
Tom

5

Thanks Tomas. I believe using the inbounds collection will work for my purpose.

1 Like