How to identify warehouses no longer associated with product?

Hi,

We are getting warehouses for products that are no longer associated together on the UI. Is there any field that identifies whether warehouse is associated with product or not?

Thank you!

Hi @jwz
You are using the products query and getting Inactive products, is that correct?

Or maybe you could filter by warehouse when querying for products, something like this:

query {
  warehouse_products(warehouse_id: "V2FyZWhvdXNlOjgwNzU=") {
    request_id
    complexity
    data(first: 10) {
      edges {
        node {
          id
          legacy_id
          account_id
          value_currency
          on_hand
          inventory_bin
          backorder
          allocated
          available
          product {
            sku
            name
            id
          }
        }
      }
    }
  }
}

Let me know if this is not what you were referring to, or if you have an example of a request_id and the elements from the response you don’t want to show.
Thanks in advance!
Tom

Hi @tomasw
Thanks for your reply! Sorry for not being clear.

For example request, this product has 1 warehouse on UI but we received 2 sets of warehouse_product IDs from API response. We didn’t see a field that would identify the “active” warehouse_product that would be shown on UI. We can’t use the warehouse_product last updated_at date because there are cases where a product should have 2+ warehouse_product IDs.

Please let me know if I missed anything. Thank you!

“request_id”: “5ee11189201ea3a4c75f05be”

{
product(id:“UHJvZHVjdEluZm86MTE3ODQ4Mw==”) {
request_id
complexity
data{
id
warehouse_products {
id
warehouse_id
}
}
}
}

Hi @jwz
That is correct, we now display both Active and Inactive products, so in your case, you are seeing an Active product and the Inactive product when making that request.
We are currently working on a filter for returning only Active products, so I will let you know as soon as we have that and you can confirm that works for you
I will let you know as soon as we have it available
Thanks again!
Tom

Hi, could you provide ETA of when this will be available?
Thank you again too!

Hi @jwz
We don’t have yet an ETA on this, because its being worked along with other missing features.
I will request for this to be expedited or if it could be worked separately so it is available asap.
However I wouldn’t expect it for this or next week, but I will ask if this can be expedited
I will let you know as soon as I have an update about it.
Thanks again for the patience!
Tom

Hi Tomas,

Any updates on this? We would also really benefit from this feature.

Dan

Hi @dan @jwz
The feature should be live now

You should be able to query only for Active products by including a filter active: true
Something like this:

query {
  warehouse_products(warehouse_id: "V2FyZWhvdXNlOjeRzkw", active: true) {
    request_id
    complexity
    data(first: 1) {
      edges {
        node {
          on_hand
          product{
            sku
            legacy_id
          }
          inventory_bin
          inventory_overstock_bin
          reserve_inventory
          replenishment_level
          reorder_amount
          reorder_level
          backorder
          allocated
          available
          non_sellable_quantity
          custom
          customs_value
          created_at
          updated_at
          sell_ahead
          active
          inbounds(first: 10) {
            edges {
              node {
                sell_ahead
              }
            }
          }
        }
      }
    }
  }
} 

The way it works is

  • active: true it returns ONLY Active products
  • active: false it returns both Active and Inactive products

Let me know if there is anything else I could help you with.
Thank you once more for your patience while we worked on this
Tom

@tomasw - This is very exciting! We’ll dig in and let you know if we have any questions.