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.

Best answer

WooCommerce to Google Sheets Zap not fetching product category despite its presence in order.

  • 20 September 2023
  • 11 replies
  • 83 views
J

Hi Team,

We need to send specific products data based on their category to google sheet.

However when we check in the trigger “Line Item in an Order in WooCommerce”
the product category is empty even though the category is present for the product.

i have used find product for the next step but if the category is not displayed how will it fetch?

 https://prnt.sc/HFdciX5sn1F8

icon

Best answer by ken.a 25 September 2023, 08:21

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

11 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @jerry_123 

Good question.

Try searching for the category value instead.

Try removing the search value and instead scroll to the variable as there may be nested variables within that contain the actual value.

 

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

Hi,

i did search the category value “crystals” but it did not show.

https://prnt.sc/J3ntBXG3tpam

it only showed the line image source 

Troy Tessalone
Userlevel 7
Badge +14

@jerry_123 

Can you show a screenshot without any search value and scrolled to the category data point?

Try removing the search value and instead scroll to the variable as there may be nested variables within that contain the actual value.

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

https://prnt.sc/VIcaeDpDQoEV

Hi please check.

Troy Tessalone
Userlevel 7
Badge +14

@jerry_123 

Try adding this Zap action: WooCommerce - Find Product

See if that returns the Categories.

 

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

Hi i have already added find product

but it does not show 

SamB
Rank
Userlevel 7
Badge +11

Hi there @jerry_123! 

Sorry to hear the product category isn’t coming through when using that Line Item in an Order trigger. According to WooCommerce’s documentation (here: https://docs.om4.io/woocommerce-zapier/usage/#find-steps) adding a Find Product action is necessary in order to get the product’s category. 

Can you please share a screenshot of all the fields that are output when you test that Find Product action? That’ll help us to get a bit more context on what you’re seeing in the Zap. Please remove/hide any private information from the screenshot before sharing (like names, emails, addresses etc.). 

I look forward to hearing from you!

D
Userlevel 1

Hi, I also don’t see the product category field. I do see it with the Find Product action, but this means it will cost an extra task for the Zap every time it is triggered just to find out information that should be part of the Trigger data.

ken.a
Userlevel 7
Badge +6

Hi there @dans,

Unfortunately, the “Find Product” action is essential to add if you want to pull the product category field. However, we have an existing feature request to return the product category in the trigger data.

I have added you and @jerry_123 to the open feature request. That does a few things:

  • Bring this to the attention of the integration developers
  • Help track interest in this feature being implemented
  • Allows us to notify you via email if this feature becomes available in the future

While I don't have an ETA on when this feature might be implemented, we will notify you via email if it is!

Hopefully, this helps!

J

Hi in the find product i have added the category however in the trigger it is not showing so its not working

https://prnt.sc/JQIcc9ZdaN6v

D
Userlevel 1

Hi in the find product i have added the category however in the trigger it is not showing so its not working

https://prnt.sc/JQIcc9ZdaN6v

You need to add the category ID, not the product name. Hope that helps.

Terms & Conditions