Hello!
I am building a php eCommerce system for a client, and they would like to have inventory and product data synced from Sage 100 ERP 2016 to the eCommerce store.
They were previously using MAS90 when we had first looked into it, but between that version not having any sort of API and the database being a Local Windows Database, it seemed not very doable.
However, from what I can tell of Sage 100 ERP 2016, it appears it has an API (callled: Business Object Interface?) as well as an updated data format.
So in short, my questions are three fold:
1) Will it be possible and doable to read and write inventory data, as well as submit purchase orders and maintain customer information through the new database structure or API?
2) I am familiar with networking, and firewalls etc, but is there any pitfalls I should be aware of in making the database or API publicly accessible to the eCommerce store? On MAS90 it used a Local Windows Database which seemed like the only remote way to access it was mounting it as a network drive. I want to make sure that either the use of the API or the new datastructure will allow me to connect via a more conventional solution (i.e IP and Service port)
3) After contacting Sage 100 support and also googling around, they recommended I post these questions here. I am willing to do the work myself and an avid learner, but is there any resources or documentation that I should know about in the process of familiarizing and developing this?