Best answer

Sending Data from MYSQL to Zoho books

  • 24 June 2021
  • 1 reply
  • 13 views

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

icon

Best answer by MarinaH 28 June 2021, 20:44

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.

1 reply

Userlevel 4
Badge +9

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!