How can I extract variations data from WooCommerce?
In WooCommerce I have two variation attributes for each product; Sizes and Brand. Using Zapier I want to extract the data for the variations so I can use them in my automated flow. I also need to extract stock items per size.
I don’t seem to be able to find any method of extracting these data, so my question is; how do I do that?
As @Troy Tessalone mentioned, if you know the variable product (parent) ID or SKU, you can use the Find Product action to pull all of its data, including a comma-separated list of all the IDs of the defined variations from the “Variations” fields. You can, for example, create a loop and load all of the variations via the same Find Product action step, including stock level and item price.
I can find the product, and all variations data, but I can seem to extract or utilize them in later steps (e.g. extract the brand name) as I cannot select the detail levels (e.g. Attributes.2.name)? I have two attributes for all my products. Attribute 1 is the Size and Attribute 2 is the Brand name. The search product result returns this:
