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
Best answer
WooCommerce to Google Sheets Zap not fetching product category despite its presence in order.
- Beginner
- 4 replies
Best answer by ken.a
Hi there
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
- 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!
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Expert
- 31147 replies
Hi
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.
- Beginner
- 4 replies
Hi,
i did search the category value “crystals” but it did not show.
https://prnt.sc/J3ntBXG3tpam
it only showed the line image source
+14- Zapier Expert
- 31147 replies
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.
+14- Zapier Expert
- 31147 replies
Try adding this Zap action: WooCommerce - Find Product
See if that returns the Categories.
+11- Community Manager
- 7597 replies
Hi there
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!
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.
+6- Zapier Staff
- 6466 replies
- Answer
Hi there
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
- 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!
- Beginner
- 4 replies
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
jerry_123 wrote:
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.