About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

How to add WooCommerce product attributes from Airtable using Zapier?

  • 1 December 2023
  • 5 replies
  • 87 views
D
Userlevel 1

Hello everyone. I have created my first zap to create a product on WooCommerce from Airtable. The first step is “New Record in Airtable” and the next step is “Create a Product in WooCommerce. I am stuck with Attributes. I have the following question:

  • Do I have to create attributes and terms on WooCommerce manually? How do we add the attribute from Airtable table?

I used Formatter by Zapier and it seems like the product will have attributes, but when the product is created on WooCommerce, attributes are not created or picked up. I have added a screenshot below.

The following documentation does not help either. I am missing something but I could not figure out yet.

https://docs.om4.io/woocommerce-zapier/usage/?h=attributes#an-example-adding-multiple-product-attributes-to-a-product

 

 

Thanks.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @ddwc 

Good question.

Looks like the WooCommerce Zap action step supports line items for the Attributes section. (can’t tell based on the cutoff screenshot)

That means data needs to be structured as an array for multiple options.

Help article about line items: https://zapier.com/help/create/basics/use-line-items-in-zaps

Check out these Zap options: Formatter > Utilities > Text to Line Items

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
D
Userlevel 1

Thanks for the answer, but do you know if we need to create the terms for attributes on WooCommerce manually? Or, the setup will automatically create those terms for the attributes selected?

Troy Tessalone
Userlevel 7
Badge +14

@ddwc 

Unsure.

When in doubt, test it out.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
D
Userlevel 1

I tried and I will tell here, so others can understand too. We first need to create the attributes and at least one term for each attribute initially on WooCommerce. Then, on Formatter by Zapier, we add the as following:

 

However, there is a small issue and I don’t know how to solve. From the following screenshot, as you can see the values are displayed correctly, but on Create Product in WooCommerce step, these are counted as separate options where it should be only one as 375 ML (Half). 

 

Can someone tell me what I am doing wrong?

Thanks!

Troy Tessalone
Userlevel 7
Badge +14

@ddwc 

It looks like each value after a space is being created as an option.

You may have to explore using the WooCommerce API:

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Terms & Conditions