# Getting product by specific field

**URL:** https://community.shiphero.com/t/getting-product-by-specific-field/609
**Category:** GraphQL API
**Created:** [July 20, 2020, 10:27am UTC](https://community.shiphero.com/t/getting-product-by-specific-field/609 "2020-07-20T10:27:05Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![ShamaliR](https://avatars.discourse-cdn.com/v4/letter/s/4da419/32.png) [@ShamaliR](https://community.shiphero.com/u/ShamaliR)
#### Post date: [July 20, 2020, 10:27am UTC](https://community.shiphero.com/t/getting-product-by-specific-field/609/1 "2020-07-20T10:27:05Z")

</div>

Can I get product from shiphero based on Sku and Warehouse-id, I want to filter out the products by Sku and Warehouse-id.

---

<div class="post-metadata">

### Author: ![tomasw](https://sea2.discourse-cdn.com/flex020/user_avatar/community.shiphero.com/tomasw/32/248_2.png) [@tomasw](https://community.shiphero.com/u/tomasw)
#### Post date: [July 21, 2020, 1:37pm UTC](https://community.shiphero.com/t/getting-product-by-specific-field/609/2 "2020-07-21T13:37:24Z")

</div>

Hi @ShamaliR  
We don’t have this combination but you can accomplish that using the following Query

```
query{
  products(sku: "46101204"){
    request_id
    complexity
    data(first: 10) {
      edges {
        node {
          id
          sku
          warehouse_products {
            warehouse{
              identifier
            }
            warehouse_id
            on_hand
          }
        }
      }
    }
  }
}

```

That should bring you all the warehouses, for example:

```
{
  "data": {
    "products": {
      "request_id": "5f16eeee7032073ec1696114",
      "complexity": 11,
      "data": {
        "edges": [
          {
            "node": {
              "id": "UHJvZHVjdEluZm86MjcyMDk3OTA4",
              "sku": "46401204",
              "warehouse_products": [
                {
                  "warehouse": {
                    "identifier": "Primary"
                  },
                  "warehouse_id": "V2FyZWhvdXNl1jExNzkw",
                  "on_hand": 8
                },
                {
                  "warehouse": {
                    "identifier": "Warehouse TWO"
                  },
                  "warehouse_id": "V2FyZWhvdXNlOjE1MTc0",
                  "on_hand": 351
                }
              ]
            }
          }
        ]
      }
    }
  }
}

```

And then you could filter for the warehouse you need  
Let me know if this doesn’t work for you  
Thanks in advance!  
Tom