Get product variant data flow for ALL products - 100 limit?

Topic summary

A user is trying to run a Shopify Flow on all product variants in their store but encounters a 100-item limit on the “Get product variant data” action.

Key Challenge:
Unlike products, variants cannot be tagged with markers like “processed” to track which items have been handled, making batch processing more complex.

Proposed Solutions:

  1. Use metafields for tracking - Similar to tagging products, apply metafields to variants to mark them as processed and filter accordingly.

  2. Third-party app approach - The Flow Companion app can increase the limit to 250 items via its “Execute GraphQL request” action, with results parsed through a “Run code” action.

  3. Two-workflow method - Select products first (unlimited via Flow Companion’s “Start custom workflow for list of products”), then iterate through variants within each product. Since products are limited to 100 variants each, this avoids exceeding the 1000-item limit for “For each” actions.

The discussion includes screenshots showing workflow configurations but remains open, with the original poster not yet confirming which approach they’ll implement.

Summarized with AI on October 26. AI used: claude-sonnet-4-5-20250929.

How does one manage to run a flow on all their store’s product variants?
If I understand correctly there is a 100 limit on the action?

Variants is more tricky than products because they don’t have tags (where you can add a tag after running like “processed” and then use “tag_not:processed” in the query). For variants you would have to do the same with metafields.

1 Like

Please clarify what you want to do with the selected variants.

If it’s sufficient to you to increase the 100-item limit to 250 items and don’t mind using third-party apps, you can use the Execute GraphQL request action from the Flow Companion app to select the necessary variants, then parse the result in a Run code action and iterate through the array of variants.

Alternative approach: select products first, and then select variants from those products. Since a product can’t have more than 100 variants, you won’t exceed the 1000-item limit for the For each action. Products, in turn, can be selected without a limit on the number of items using the Start custom workflow for list of products action provided by Flow Companion. This will look like two connected workflows: