How to add multiple product categories from Airtable to WooCommerce?

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!

Page 1 / 1

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.

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.