We have Sage300 on premise. We want to be able to synchronize the orders placed through web store to Sage. What is the best approach?  The options I have read about are

1) write directly to database. Seems high risk.

2) Using Macro.

3) Export web orders to a CSV file and run cron task from Sage to import it?

Any other options? What are you opinions about the pros and cons?

Thank you. Stay safe!