Integrating Sage Accounts with website

[Joff]

I'm looking to integrate the Sage Accounts software with a website and wondered if anyone on here has had previous experience?

There are plenty of companies offering to do the work, so it's possible.

[bumfluff]

How do you mean, integrate it? Like hook it up to a shopping cart or something?

[Joff]

Online stock levels is what I'm after. ASP/PHP page displays item details from a data source and then looks to Sage for the stock levels.

[bumfluff]

Not something I have experience with, unfortunately. I had a look around Google, and it seems there are software solutions available for some of the Sage packages, but they vary from around £300-500. The most common seem to be Connect .

However... there may be another way to go about it. I'm not familiar with any Sage products (I HATE accounts!), but if you have the option to import data into your Sage package, maybe as a CSV (comma seperated values) file, it *should* be relatively simple to use PHP to export stock data from a MySQL Database to a CSV file (or another importable format). It wouldn't be as elegant as having a fully integrated solution, but I reckon it'd be cheaper.

[Joff]

Yeah, that's the same conclusion I had. Plenty of companies offering the ability so I'm guessing it might need a few calls to Sage to work out what I need to do. Hopefully I won't need to have a developer license with them...!

[monaghan]

I'd be concerned with potential security if your web app could call out data from the accounts.

I'd suggest perhaps a system where the accounts system pushes the stock level to the site and then you reduce this level within the site when you make a sale. You can always push another update if you make a local sale.

[Joff]

I suppose if Sage can publish an XML file I can then pick up any product info from that.

[bumfluff]

I reckon that's the way to go.. export from Sage to something easily readable like CSV or XML, then use PHP to pull out the info and place it on the site..