1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

php sage integration?

Discussion in 'HTML, Graphics & Programming' started by lookitsjonno, 23 Jul 2006.

  1. lookitsjonno

    Mobster

    Joined: 10 Sep 2003

    Posts: 4,335

    Location: Midlands

    Afternoon,

    I have been asked to research into the possibility of integrating an online store into Sage - i.e when a customer purchases something it is automatically entered into Sage.

    Never ever used sage before - just wondering if anyone has achieved this before or can point me in the right direction? I've done some searching on other forums and people mention some sort of PHP API - however i cannot find any such thing [old post - link didnt work!].

    Any idea what database Sage runs on? SQL Server?

    Thanks,

    Jonno.
     
  2. zetec452

    Sgarrista

    Joined: 15 Sep 2003

    Posts: 9,454

    It will depend on what version of sage your client has. The new sage IIRC runs on a .NET MSSQL platform. The old sage uses lots and lots of files.

    Have you tried calling sage themselves?

    We have a client who has a big sage system which will be developed into there website but im not sure how they are doing it.
     
  3. lookitsjonno

    Mobster

    Joined: 10 Sep 2003

    Posts: 4,335

    Location: Midlands

    Yes calling them is an idea - however they'll probably try and sell me the Sage developer certification for £1500 :o

    Someone here must be experienced with Sage :o

    is there not some sort of import facility allowing you to specify the URL of an XML/CSV file or something?

    Jonno.
     
  4. Beansprout

    Man of Honour

    Joined: 31 Jan 2004

    Posts: 16,319

    Location: Plymouth

    We use Sage & my friend's student union also use it. I've not used any sort of API - I think we have an older version now - but I'll ask him :)
     
  5. zetec452

    Sgarrista

    Joined: 15 Sep 2003

    Posts: 9,454

    I wouldn't be so sure. Sage developers from my experince are just gay. The ones we deal with a just a nightmare.
     
  6. BaJ

    Hitman

    Joined: 19 Oct 2002

    Posts: 781

    Location: The middle bit

    It's been a few years since i've looked at this but as far as i remember you need the Sage development kit to do any kind of proper integration.

    What we ended up doing for a client was allowing them to create CSV files from a web admin system that can be imported into Sage. If you look around the Sage help files it gives you a breakdown of the different imports available with field types etc.
     
  7. cellpack

    Gangster

    Joined: 26 Oct 2003

    Posts: 250

    Hi

    Ive done this for the company I work for what happens is the order is sent through once accepted by worldpay, as a plain text email, then I use a piece of software called importplus (http://www.skyewright.co.uk/downloads/win32/#importplus)

    which then takes our email direct from the pop3 account and puts it into sage, saves us loads of time manually inputting them

    Hope this helps

    if you have any more questions just shout :)

    Thanks Ryan