Return management just got easier! We’ve launched Customer Self-Serve Returns to all Shopify merchants. Click here to learn more!

Getting the list of all vendors - the best method

webxtor
New Member
2 0 1

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. ?

Reply 1 (1)
cfc_webmaster
Excursionist
46 0 37

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.