How to get all product variants metafields

[tien-luckyfor]

Hi everyone, I'm new here..

So I've just research how to get all product metafields via grapql. And my new task is get all product variants metafields.

I trying to replace "product" in these commands to "variant" but still doesn't work anymore.

Can you help me to give great solution, Thanks for read my question.

// get all product metafields

query allProductsMetafields($cursor: String) {
  products(first: 30, after: $cursor) {
    edges {
      cursor
      node {
        legacyResourceId
        metafields(first: 30) {
          edges {
            node {
              namespace
              value
              key
            }
          }
        }
      }
      cursor
    }
    pageInfo {
      hasNextPage
      hasPreviousPage
    }
  }
}

[Greg_Kujawa]

If you are looking for any metafields at the variant level then you need to iterate through products, and then drill into the variants to get to them. Like this stripped-down example below. I just pull the first 5 products, iterate through each product's first 5 variants, and finally iterate through each variant's first 5 metafields. Does this work for you?

{
  products(first: 5) {
    edges {
      node {
        id
        title        
        variants(first: 5) {
          edges {
            node {
              id
              title
              metafields(first: 5) {
                edges {
                  node {
                    description
                    value
                    valueType
                  }
                }
              }
            }
          }
        }
      }
    }
  }
}

[srdjan · Accepted solution]

An alternative to @Greg_Kujawa's solution, which is perfectly fine, is to query product variants from the root level.

{
  productVariants(first: 10) {
    edges {
      node {
        metafields(first: 10) {
          edges {
            node {
              namespace
              key
              value
            }
          }
        }
      }
    }
  }
}

[tien-luckyfor]

@Greg_Kujawa 

THanks for your helping, 

This work for me!

[tien-luckyfor]

Hi @srdjan ,

As screen record it's response empty, Is that right?

https://youtu.be/_NcPX0r3NNk

[Greg_Kujawa]

I haven't defined any product variant metafields, so I didn't see anything coming back in the response. If I get a chance today I'll add some metafield values and see what comes back...

[Greg_Kujawa]

Just ran a quick test in the GraphiQL app. Added a metafield value to a product variant and then queried against it. It seemed to work fine. Specifics below!

[tien-luckyfor]

Hi @Greg_Kujawa 

I have 100 products variants with only 10 products variants have metafields.

How can I get these metafields in that? thanks.

[Greg_Kujawa]

I don't think you can query for only those product variants that have a specific (or any) metafield value defined. See https://community.shopify.com/c/Shopify-Discussion/Query-all-products-with-a-given-metafield-value/t... for details. 

[tien-luckyfor]

@Greg_Kujawa 
Thank you so much for your response! 
If I loop all products variants to get metafields that not good about performance  and limit "requestedQueryCost". Right?