Add product to order automatically (api or sql?)

[LucasV]

Hi!

I'm looking for ways to automate some flows. 
I want to automatically add a specific product to orders with the tool Pabbly (Zapier / integromat like tool).

Now I did not find any API options to add a product to an order so I was thinking to update this in the database. 
I managed by adding a row to the order detail table and order tax table. Now I'm not sure this is sufficient. 

does anyone has experience of adding order by api? (my preferred option) or is the SQL import ok?

thanks

Lucas

[musicmaster]

Export the database. Add a product to an order. Export the database again. Then compare the two exports with a tool like WinMerge.

When you don't use the API functions this is the best approach to make sure that your sql transactions match what the system would do.

[LucasV]

Thanks. Great idea. I managed to do this on mac with Beyond Compare. (since files are very big)

[LucasV]

So, It's not possible to a product on an existing oder by API?

 

[musicmaster]

1 hour ago, LucasV said:

Thanks. Great idea. I managed to do this on mac with Beyond Compare. (since files are very big)

Most likely those are the statistics tables. You can exclude them.

[musicmaster]

1 hour ago, LucasV said:

So, It's not possible to a product on an existing oder by API?

Other people can help you better with that.