Sage 100

 View Only
  • 1.  Looking for a solution for a small business - webs

    Posted 09-27-2013 09:42
    Looking for a solution for a small business - webstore intregration with Sage ERP 100... Low cost. Any suggestions?


  • 2.  RE: Looking for a solution for a small business - webs

    Posted 09-27-2013 10:03
    We have successfully integrated Sage 100 with Xcart shopping cart for 2 separate end users. Cost was approximately $6K-$10K for the web design and customization and another $10K-$15K for the integration work depending on the MAS version and database. The MAS user chooses the Web import from a menu and all of the web orders become sales orders.


  • 3.  RE: Looking for a solution for a small business - webs

    Posted 09-27-2013 11:34
    @DougHiggs Does the xcart shopping cart have a direct tie in with Sage 100, or was there another piece to accomplish the integration?


  • 4.  RE: Looking for a solution for a small business - webs

    Posted 09-27-2013 11:37
    We are Sage development partners and we wrote the integration. @AlnoorCassim can provide technical details.


  • 5.  RE: Looking for a solution for a small business - webs

    Posted 09-27-2013 11:38
    OK, thanks.


  • 6.  RE: Looking for a solution for a small business - webs

    Posted 09-29-2013 11:58
    @JohnLeonard it works like this. The X-Cart team creates a MySql database for the customer and sets up their web shopping cart. The integration is a Sage 100 enhancement (mod) that connects directly to the MySql db via ODBC connection. As Doug said you choose the SO Web Import option from the MAS S/O menu and through a download / sync process, the web orders become sales orders. Some specifics: * B2C customers get created from the shopping cart first. When SO Web Import is run it creates the same B2C customers in MAS, then creates their sales orders. * B2B customers are created from MAS. In Customer Maint, those with B2B UDF checked will get auto-created in X-Cart as B2B and assigned a members only (e.g. dealer) price level. These web orders also become sales orders. * MAS items, descriptions, and product lines are sent by client to the X-Cart team (e.g. spreadsheet). This may also include categories, images, thumbnails, etc as well. This ends up in the X-Cart MySql database. Client works directly with X-Cart folks to maintain this list. * In terms of design, features, custom web input fields, and search, the X-Cart Shopping Cart is much stronger than the e-Business Mgr templates.


  • 7.  RE: Looking for a solution for a small business - webs

    Posted 09-30-2013 15:21
    @AlnoorCassim Thanks Alnoor.