Question

How to add WooCommerce product attributes from Airtable using Zapier?

  • 1 December 2023
  • 5 replies
  • 81 views

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

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

 

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?

Userlevel 7
Badge +14

@ddwc 

Unsure.

When in doubt, test it out.

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!

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: