Question

How to add multiple product categories from Airtable to WooCommerce?

  • 4 December 2023
  • 3 replies
  • 36 views

Userlevel 1

I am trying to add a WooCommerce product in either single or multiple categories. There is the following post, but it does not help.

I am using Airtable to pull the data and the product category is in dropdown. As you can see, there is a single or multiple categories.

 

This is my setup for creating a product. I use Formatter by Zapier for Attributes. 

 

The categories look like this on WooCommerce. 

 

So, how do I add multiple categories in Create a Product in WooCommerce? 

I am sorry to say this, but this is terrible for users. There is no such an example at all. 0. How are we supposed to find how to do things? I have been struggling for days to figure this out.

Thanks in advance!


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

3 replies

Userlevel 7
Badge +14

Hi @ddwc 

Good question.

The Categories field expects the Category ID, which is a number as indicated by the 123 icon.

You may need to add the Category IDs from WooCommerce to Airtable.

You may want to convert the dropdown field in Airtable to a linked field and use a lookup field to pull over the Category ID.

 

Userlevel 1

I created another Formatter by Zapier step and added the IDs from WooCommerce. The values are coming from Airtable. Now, when the product is created, the category is also selected, but all the categories are included even though the product has one category only. Airtable data is a dropdown. So, I am not sure how to get the values of only that cell.

 

Thanks for help!

Userlevel 7
Badge +14

@ddwc 

You may want to convert the dropdown field in Airtable to a linked field and use a lookup field to pull over the Category ID.

https://support.airtable.com/docs/linking-records-in-airtable

https://support.airtable.com/docs/lookup-field-overview