Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 8 of 8

Thread: Integrate with Sage 50

  1. #1
    nihon is offline Senior Member
    Join Date
    May 2008
    Posts
    150

    Default Integrate with Sage 50

    Hi has anybody managed to connect ML to Sage 50? I really would like to talk to somebody about this.
    Thank you
    Version (Code/DB):
    AspDotNetStorefront ML 8.1.2.0/8.1.2.0

  2. #2
    mikemurphy is offline Senior Member
    Join Date
    Mar 2006
    Location
    United Kingdom
    Posts
    207

    Default

    we'd like to know this too
    8.0.1.4 W2008R2 64-bit MSSQL2005

  3. #3
    Mike The Last Boyscout is offline User
    Join Date
    Nov 2008
    Posts
    254

    Default

    You may want to contact eBridge as they have done an integration with Sage Line 50 (UK). If you click that link and fill out the query form, a representative from eBridge will be in contact with you!

  4. #4
    esedirect is offline Senior Member
    Join Date
    Feb 2010
    Location
    Norfolk, UK
    Posts
    343

    Default

    We run ML 8.0.1.2 and Sage MMS 3.5.26 and Sage CRM MME 5.8. I have written a custom app that posts customers orders directly into MMS. You need detailed knowledge of the db structure. The app also queries to see whether the customer already exists on the MMS/MME dbs, and creates one if it doesn't.

  5. #5
    nihon is offline Senior Member
    Join Date
    May 2008
    Posts
    150

    Default

    esedirect, how is the data transferred from the Web to Sage?
    Version (Code/DB):
    AspDotNetStorefront ML 8.1.2.0/8.1.2.0

  6. #6
    esedirect is offline Senior Member
    Join Date
    Feb 2010
    Location
    Norfolk, UK
    Posts
    343

    Default

    I used ASP with XML to match postcodes with the CRM/MMS to offer our user a list of matched companies. They could either choose a matched customer or create another. Then, either direct SQL inserts or Stored Procs to post the data into Sage.

    You can, of course, use other languages, like PHP, ASP.NET or Adobe Flex to achieve the same.

  7. #7
    nihon is offline Senior Member
    Join Date
    May 2008
    Posts
    150

    Default

    esedirect, when you setup the system did all the data from the Web transfer to Sage with out any changes in SKU or any other data. Did all past orders, stock levels, client names, address etc .. transfer to Sage..
    Thanks
    Gordon
    Version (Code/DB):
    AspDotNetStorefront ML 8.1.2.0/8.1.2.0

  8. #8
    esedirect is offline Senior Member
    Join Date
    Feb 2010
    Location
    Norfolk, UK
    Posts
    343

    Default

    No, obviously not. You'll need to transfer whatever data you need.