SageForum for UK versions of Sage 50- Help and support.

I have been asked to add a shopping cart to an existing website and the company uses Sage Line 50 to hold details of their stock, etc.

I have experience with MySQL and I've been told that sage uses odbc. Can anyone recommend the best way to do this?

Thanks in advance

There is no BEST way, there are lots of ways.

We do integration an service so we can get data in and out of Sage via files on your web server.

Depending on the application and the amount of data this can be done lots of different ways, we have one that uses a csv files that is read by a perl script to make web pages. It would be awful if you had a lot of data.

There are some people doing .net stuff to integrate real time with sage.

Our approach is simple, we take data out of sage eg stock records/details/description and upload them toy your webserver via ftp. Perhaps hit a url to kick a process to update an sql database.
In reverse the site could make emails, or csv files for each order which we would load into sage.