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.

Question

The module entry could not be sent to Zoho CRM.

  • 21 February 2022
  • 8 replies
  • 252 views
Y

I’m trying to parse information from Gmail to Zoho CRM - Sales Orders module and get this error:

Unable to create entry in module: Sales_Orders. Error : Invalid data for the field product. Detail : expected_data_type long, index 0, parent_api_name Product_Details

I tried different combinations but failed. The screenshots are below. 

All works fine when I switch to Deals module. But it shows errors when I use Sales Orders, and the error is always about the product no matter what information I use there. 

Is there anyone who faced the same problem? Is there a way to solve it? Thanks.

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

8 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @yuliia 

Please post the mentioned screenshots, thanks.

 

For the field returning the error, check the dropdown list of values.

Zoho expects the smaller gray values for a given product, instead of the friendly name.

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

hi @Troy Tessalone , thanks for your reply. please check the screenshots. as for the Product field - I just put some random information in there. But I also tried the actual product from Zoho and I tried to keep it empty (as it should be). I needs to be empty because I have the actual order in the body of the email I parse. And I can’t parse the product from the email to the Product field, so I have to parse the body to Description field. Something like that. 

Troy Tessalone
Userlevel 7
Badge +14

@yuliia 

You have an email address mapped as a dynamic variable for this field, which is unlikely to be the proper value.

 

Try this…

Remove the mapped value.

Then click on the field to show the list of dropdown value.

Please provide a screenshot of those.

 

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

@Troy Tessalone thanks, I tried with different values and this was a random one. so now I removed all values and I get 

Unable to create entry in module: Sales_Orders. Error : required field not found. Detail : api_name Product_Details

But when I fill the fields I get errors anyway. 

2 Attachments
Y

 @Troy Tessalone so I tested it again and it worked with the test item added as a value + quantity (custom). However, that’s not what I expect because the quantity and the item names are in email’s body and we can’t separate this data from the email. and it doesn’t parse an email body at all for some reason. so basically Zapier forces me to add Product name and quantity even if I do not want to. Is there a way to avoid it? The idea is that our manager needs to add products to Sales Order manually since we can’t separate them from the email text automatically. 

 

Troy Tessalone
Userlevel 7
Badge +14

@yuliia 

The Product field expects the smaller gray numerical values.

Trying to use other values will result in an error.

In Zoho, you may need to update the list of options in order for there to be additional options to select in the Zap.

OR you would need to use more Zap steps to add logic to find/create the Products you are trying to map dynamically.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Troy Tessalone
Userlevel 7
Badge +14

@yuliia 

Emails can be parsed by doing email parsing, with apps like Mailparser: https://zapier.com/apps/mailparser/integrations#triggers-and-actions

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
GetUWired
Userlevel 7
Badge +12

@yuliia 

Generally, the behavior of what fields are required would be set in Zoho. Can you create Sales Orders manually in Zoho without linking to a product? If not, check the field set up in the Sales Order Module in Zoho to see if you can remove any requirements. 

Terms & Conditions