integrate website with Sage100

Hello, we are looking to integrate our website with Sage 100. We want to save website orders to Sage 100. What would be the correct approach? We already have visual integrator. But we want to be able to do it automatically. When order comes in, it will be automatically saved into Sage. Should we continue use visual integrator or there is API in Sage we can use to directly complete the job of saving orders? TIA.

  • You really should be reaching out to your Sage partner for this discussion.  Website integration is not something you can DIY with online general tips.  VI may be OK for a small number of orders, but is not a proper integration.  Yes, there is an API, and a number of options beyond custom programming everything yourself.

    Search these forums and you will find multiple threads on website integration.  There are not quick and easy, one-size-fits-all answers to your question.

  • in reply to Kevin M

    We have in-house developer. So we want to know what does it take to do it in-house. Can you point to the general direction of doing it from scratch? 

  • in reply to Kevin M

    can our developer call the APIs? are there documentation available?

  • in reply to Mikeywinz

    Look into the Business Objects Interface (forum here on Sage City).  The learning curve is very high, the API is largely undocumented, and reinventing the wheel can be more expensive than consulting with specialists.  I understand Sage University has a beginner course.

  • Our company has a custom website. When we get orders, they download every 15 minutes and get imported using Business Objects Interface. This is a programming interface. You have to really study examples online because the documentation can be hard to read/interpret. However, there are several examples on this forum about how to import a sales order so in theory, this could be somewhat simple if you've got a good developer on staff.

  • in reply to Sage100User

    Hi Sage100User, thank you sharing your project experience. It sounds very encouraging. 

    Business Objects Interface is a module we need to purchase, right? Is Business Object Interface the only way to automatically import orders into Sage?

    Thank you!

  • in reply to Mikeywinz

    BOI is not a module, it is direct access to the backbone of the software.  The reason I say the learning curve is high is because you really need to know how Sage 100 business objects work behind the scenes... how they relate to each other... what is required at each step.  If you can find examples that fit your situation: great.  If not, finding answers is not easy.

    eBusinessWebServices is a module / option too, with a less complex (but limited) interface.