# Vendor sku for purchase order

**URL:** <https://community.shiphero.com/t/vendor-sku-for-purchase-order/701>\
**Category:** GraphQL API\
**Created:** [August 27, 2020, 10:18pm UTC](https://community.shiphero.com/t/vendor-sku-for-purchase-order/701 "2020-08-27T22:18:01Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![mishawn](https://avatars.discourse-cdn.com/v4/letter/m/858c86/32.png) [@mishawn](https://community.shiphero.com/u/mishawn)\
**Post date:** [August 27, 2020, 10:18pm UTC](https://community.shiphero.com/t/vendor-sku-for-purchase-order/701/1 "2020-08-27T22:18:01Z")

</div>

Hello,

We are in the process of creating purchase orders based on pdf invoices.  
Given we only know the vendor\_sku for items that we want in a purchase order what is the best way to look up sku’s of 20+ products to be used in a purchase order creation?

Thank you

---

<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:** [August 28, 2020, 11:44am UTC](https://community.shiphero.com/t/vendor-sku-for-purchase-order/701/2 "2020-08-28T11:44:15Z")

</div>

Hi @mishawn!  
We don’t have the query to filter by `vendor_sku`, but you could use the following query:

```
query{
  products{
    request_id
    complexity
    data(first: 100) {
      edges {
        node {
          id
          sku
          vendors {
            vendor_id
            vendor_sku
          }
        }
      }
    }
  }
}

```

So that way you can see the relationship between a certain SKU —\> The vendor ID —\> That Vendor’s SKU  
Then you could store all those relationships and reference that data to make the conversion

Let me know if that is not what you were looking for.  
Thanks in advance!  
Tom

---

<div class="post-metadata">

**Author:** ![mishawn](https://avatars.discourse-cdn.com/v4/letter/m/858c86/32.png) [@mishawn](https://community.shiphero.com/u/mishawn)\
**Post date:** [August 28, 2020, 1:02pm UTC](https://community.shiphero.com/t/vendor-sku-for-purchase-order/701/3 "2020-08-28T13:02:14Z")

</div>

Hi Tom,

Thank you for your response, this is similar to what we’ve came up with but this would cause us to have to make way too many queries. Is there a way for us to just return all of the products that are under certain vendors?

Thank you

---

<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:** [August 28, 2020, 2:53pm UTC](https://community.shiphero.com/t/vendor-sku-for-purchase-order/701/4 "2020-08-28T14:53:31Z")

</div>

We don’t have the ability to do that @mishawn but I will make a Feature Request to see if this could be added.

The Request is going to be able to Query for a vendor and all of its products, something like this:

```
query{
  vendors(id:"QWNjb3VudDo2MzM0"){
    request_id
    complexity
    data {
      edges {
        node {
          id
          products {
            edges {
              node {
                id
                sku
                vendor_sku
              }
            }
          }
        }
      }
    }
  }
} 

```

Would something like this work?  
Thanks again!  
Tom

---

<div class="post-metadata">

**Author:** ![mishawn](https://avatars.discourse-cdn.com/v4/letter/m/858c86/32.png) [@mishawn](https://community.shiphero.com/u/mishawn)\
**Post date:** [August 28, 2020, 3:13pm UTC](https://community.shiphero.com/t/vendor-sku-for-purchase-order/701/5 "2020-08-28T15:13:25Z")

</div>

Tom, I think this would reduce a lot of heartache for many not just for us. looking forward to something like this to be implemented. In the mean time I believe we can do a manual export of all the vendors and their products from the UI and constantly update that on a weekly basis for our usecase.

Thank you

---

<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:** [August 28, 2020, 3:46pm UTC](https://community.shiphero.com/t/vendor-sku-for-purchase-order/701/6 "2020-08-28T15:46:14Z")

</div>

Thanks for confirming that! Makes sense, I just posted a feature request with those details.  
I will let you know as soon as we have an update about it.  
Thanks again!  
Tom

---

<div class="post-metadata">

**Author:** ![originsid](https://avatars.discourse-cdn.com/v4/letter/o/cc9497/32.png) [@originsid](https://community.shiphero.com/u/originsid)\
**Post date:** [August 28, 2020, 7:15pm UTC](https://community.shiphero.com/t/vendor-sku-for-purchase-order/701/7 "2020-08-28T19:15:03Z")

</div>

@mishawn and @tomasw We definitely could use this!

---

<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:** [August 28, 2020, 7:38pm UTC](https://community.shiphero.com/t/vendor-sku-for-purchase-order/701/8 "2020-08-28T19:38:34Z")

</div>

Adding a +1 on the Feature Request then @originsid  
I will confirm once I get a response about this