Accessing a secondary DB from ERP

[bobrichter]

I have a client who may purchase Miva but needs to know if it has a certain capability. Can the shopping cart be made, by thier web developer, to access a database populated by thier internal ERP system? The databse will be local to the cart, and can be MySQL or MS SQL database. The cart will need to access Pricing, Quantities, order history, invoice history, etc. Thier ERP system controls all of the mentioned information and will replicate all current data to the mysql or MS sql database. The Miva cart would then need to look at the item qty levels, ERP pricing tabls, sales order history, invoice history, etc and generate the infomation for the online user. Thier ERP system will also be createing orders from phone ins, etc. Is this possible? Miva support directed me here.

[Vic - WolfPaw Computers]

In all likelihood, you would need a programmer talented in MIVA and PHP to create both a front end and a custom MIVA Module to accomplish this.

The PHP front end would handle the data input and formulate the needed MySQL queries to retrieve data from the ERP system, and either cross reference this with the MIVA MySQL database to find the correct product(s) or create them on the fly - as well as populate any needed customer information and other information that would need to be sync'ed across both databases.

While challenging, I believe it can be accomplished.

[bobrichter]

Vic,
Thanks you for the information. I am curious about the effort needed to accomplish that. Would you know a ball park number of hours to do this type of work? Lets say they needed to Export orders taken, import pricing, import product qty, import order and invoice history.
Bob