FN-FORUM: Sage integration with php/MySQL

date posted 14th June 2007 11:52

Good Morning all,

I am building an ads campaign management tool for a publishing
company, who would like to manage their advertisers, the adverts, the
issues, etc.. and ultimately the orders (=money) taken.
They only wish to have certain financial on the system so I can write
custom reporting scripts for them, but still wish to use Sage Line 50
Accounts to send out the invoices and track their payments.
I therefore need a way of synchronising the customer entries in sage
with those in the web app. What i plan to do is make a "synchronise
customers" button which will create a CSV tailored to be imported for
the customers entries in Sage, so they can update Sage that way.
Problem is, what about synchronising back the other way? In case a new
customer is added to Sage and not the web app?
Also, how hard will it be to pass over the order info from the web app
to sage so it generates the invoices?

Any advice from anyone who has been there greatly appreciated. This is
all being developed using PHP/MySQL. Maybe there are some
bridging/synchronising programs out there worth getting to save
re-inventing the wheel?

All the best,
Duncan Glendinning