Our Partner & Developer boards on the community are moving to a brand new home: the .dev community forums! While you can still access past discussions here, for all your future app and storefront building questions, head over to the new forums.

Getting the list of all vendors - the best method

Getting the list of all vendors - the best method

webxtor
Visitor
2 0 4

Another day another struggle.

Needing a list of ALL vendors of the shop. After searching for quite a while, came up with these solutions:

1. Iterating through all products. Obviously, less effective.

Example: https://community.shopify.com/c/shopify-apis-and-sdks/is-there-any-way-to-get-list-of-vendors-and-ty...

{
  products(first: 250, after: "#{cursor}") {
    edges {
      cursor
      node {
        id
        vendor
      }
    }
    pageInfo {
      hasNextPage
    }
  }
}

2. Getting vendors through Shop's productVendors object. Has limit of 250 records though "first" parameter and no way to iterate, thus absolutely useless when we need to get them all.

Code example: https://community.shopify.com/c/shopify-apis-and-sdks/json-list-of-vendors-api/m-p/600737/highlight/...

query productVendors {
  shop {
    productVendors(first: 200) {
      edges {
        node
      }
    }
  }
}

There is a similar problem with product tags as mentioned in this thread. There even Shopify official staff admitted the problem but years passed, the problem is still there.

3. Creating a template accessible via store custom page with content similar to:

{% layout none %}{{shop.vendors|json}}

 Code example from the same thread as above.

There is even a blog post that describes how to use similar method to get all the vendors and product tags as it's impossible to do with API. His code for the vendors seems to be more complicate from the quoted above.

Well this solution likely works, and in one of the threads above it's been reported as the year-proof solution, but there is a problem in my case. The store is password protected so to access this page from within my app, I would need to write a separate authentication code just for this task. So I thought I could query the page through admin API. And I actually could, but page's body_html is empty, so it returns an uninterpreted page content and I haven't figured out how can you request the actual page content though the API.

4. As found on this stackoverflow thread you can also get this straight without the need to create any page templates by querying

https://{{ shop_doamin }}/admin/products/vendors.json

This is probably something that the web based Shopify app uses by itself and is not intended to be used by an external API which again would require another layer of authorization to code.

 

So how could I query all the vendors with API or access the contents of the generated page which uses a custom template as in case 3. ?

Replies 10 (10)

cfc_webmaster
Explorer
47 0 119

Tragically, I do not think you can solve this "perfectly" (as desired in case 3)

 

First off: GREAT post here, I am dealing with a similar problem

 

Second: I was horrified to see Shopify does not treat "vendors" like a Taxonomy or a Collection, so I am in a situation where a vendor name needs to change, but seems like our only option is to use the bulk editor and copy/paste them all one.at.a.time

 

Lastly: I think your only 2 solutions for CASE 3 (as you describe it) is to

1- manually enter ALL the vendors you want on the server side of your system [yuk]

- or -

2- you COULD (in theory) scrape the page. For example, this may be absurd but might work: create a CUSTOM page template that spits out XML! then use that "page template" as your makeshift feed into your system to "access the contents of the generated page". In this case you need yet another page.

 

For example:

New Page Template: MyVendorsAPI = have that page spit out JSON or XML for your vendors, just code it up in liquid. Make sure that page does not render HTML (nor the template, nor header, nor anything) - then try to SCRAPE that page for your JSON or XML list of "all vendors". Once you have that then you can "do stuff" with it.

 

But yea... Its crazy to me there is no way to just "get all vendors" via the API. 

julienprivat
Shopify Partner
1 0 0

up ! 

UncleBabyKern
Shopify Partner
5 0 1

This is still busted and inefficient. After finding no other support, I'm settling with option 1 to query vendor and cursor for all products then I remove duplicates.

I would rather use the `after` argument with a cursor in the `productVendors` query to collect all vendors.

It's a long shot, but can anyone internally propose this change to the graphql Admin API?

andrewrobbins
Shopify Partner
26 0 12

The fact that they have both productTypes and productTags available to query, is ever more reason to give us productVendors.

 

https://shopify.dev/docs/api/storefront/2024-07/queries/productTypes

Creator of ShopWP https://wpshop.io
seance_spiriti
Shopify Partner
1 0 1

they actually do have it now, you can use this query in Shopify's GraphiQL: 

 

query productVendors {
shop {
productVendors(first: 200) {
edges {
node
}
}
}

 

If you have over 200 vendors you need to have pagination. 

andrewrobbins
Shopify Partner
26 0 12

What API version are you using? I'm getting this error when I run that query on the Storefront API (2024-07):

 

Field 'productVendors' doesn't exist on type 'Shop'
Creator of ShopWP https://wpshop.io
jtraderj
Tourist
3 1 2

https://xxxx.myshopify.com/admin/api/2024-07/graphql.json

 

Works for me.  Thanks for posting.

andrewrobbins
Shopify Partner
26 0 12

Confirmed this works—however, this is for the Admin API, not the Storefront API.

Creator of ShopWP https://wpshop.io

remy727
Shopify Partner
44 2 26

You can use productVendors GraphQL query.

image.png

 

Looking for a Shopify App developer? Please contact me at remy.wang727@gmail.com
UncleBabyKern
Shopify Partner
5 0 1

More than a few people have brought up the `productVendors` query is now available for this exact case, but since the beginning of this thread (evidenced in the original post) that query has existed in the same insufficient form as it does now.

 

As @webxtor showed in option 2 of the original post, yes you can use productVendors; the caveat is that the `productVendor` type has only the `first` parameter and lacks an `after` param that could accept a cursor to facilitate pagination. Without access to pagination, the productVendors query is only useful if you know you're only dealing with 250 vendors or less.

 

Back in July I got in touch with Shopify Partner Support and they confirmed the missing parameter for `productVendors` was an issue, adding it to their internal Github issues backlog for the Admin GraphQL API. I requested an update today, but I expect that they have not begun work to make the change, as there is no evidence of a change in the API's latest release candidate. I'll report back here if/when I do receive any tangible update on their progress.

 

I am still using and recommend option 1 for stores where there are 250+ vendors, in spite of its clunkiness.