Access to Back Order QTY & Store from product query

Hello,
Is there a way to get the back order qty of a sku. I’d also really like to get the store that the product was created from. Does this exist?

Hello,
Is there any update on this?

Hi JFurr!
I apologize for the delay. We already have a Feature Request for this, but I’ll check with the Engineering team to see if we have ETA on this.
Thank you for your patience!
Tom

1 Like

Hi JFurr!
field should be available now ( on the WarehouseProduct ).
You could use a query like this one:

query {
  product(sku: "somesku") {
    request_id
    complexity
    data {
      id
      legacy_id
      warehouse_products {
       id
    legacy_id
    warehouse_id
    on_hand
    reserve_inventory
    replenishment_level
    reorder_amount
    reorder_level
    backorder
      }
    }
  }
}

Let me know if it works for you,
Thank you for your patience!
Tom

Hey Tom,
This worked. Is it possible to access the store that the product is linked to? We have some clients with hundreds of stores and They need data broken down. This would save me a ton of time. Thanks for adding the Backorders!

Hi JFurr!
We currently don’t have a way of doing so. That operation might turn out to be quite expensive, but what we could try is to specify the store and get products based on that.
Would that work for you?
Thanks!,
Tom

That could work for sure. We’d need a way to access all stores under a specific client account_id as well so we could iterate over all stores for all clients. Adding this as a column for the inventory > products page in the webapp would be just as effective for us.

Thanks!

1 Like