Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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

Sending Data from MYSQL to Zoho books

  • June 24, 2021
  • 1 reply
  • 13 views
E

Hello,

 

I want to integrate zoho books with my database which is in MySQL. I tried using zapier. First suggest me that i’m thinking in a right way or not. My approach is I created a function in my database which will create an item in my DB and I also added a trigger in zap for the same table and i configured an action for zoho books to create an item. When i’m inserting a new row into my table then the error ocurrs that SKU is not returned. I understand the zoho book items require a new SKU for each item. I’m stuck at how i’ll create a new SKU for each and every item whenever i’m inserting in my database.

 

Please help

 

THanks in advance

Best answer by MarinaH

Hi @evnorg,

Thanks for the question!

Available triggers for MySQL here: https://zapier.com/apps/mysql/integrations#triggers-and-actions and Zoho Books actions here: https://zapier.com/apps/zoho-books/integrations#triggers-and-actions 

Looks like you reviewed this question with the Zapier Support team, and identified that the SKU field is a custom field for the Create Item in Zoho Books action - we’ve added you to an open feature request to let you know if/when custom fields becomes available for that integration.

Sorry to not have better news here! 

 

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

M
Forum|alt.badge.img+9
  • MarinaHZapier Staff
  • Zapier Staff
  • June 28, 2021

Hi @evnorg,

Thanks for the question!

Available triggers for MySQL here: https://zapier.com/apps/mysql/integrations#triggers-and-actions and Zoho Books actions here: https://zapier.com/apps/zoho-books/integrations#triggers-and-actions 

Looks like you reviewed this question with the Zapier Support team, and identified that the SKU field is a custom field for the Create Item in Zoho Books action - we’ve added you to an open feature request to let you know if/when custom fields becomes available for that integration.

Sorry to not have better news here! 

 

Terms & Conditions