integration of bv commerce shopping cart with Microsoft Dynamics RMS?

Question

I have a BVCommerce website, and i wish to integrate it into my retail locations Inventory system (Microsoft RMS: http://www.microsoft.com/dynamics/rms/default.mspx)

The inventory software is already managing inventory for multiple locations. our task would be to configure the store (very possibly via custom code engineering) to pull the store inventory from the Microsoft RMS system.

" BV Commerce5 software is used to develop online shopping cart web sites"

I need to send orders from the website into RMS and update the website's inventory from RMS. So, there is two-way communication. It's unlikely that i am able to perform an inventory lookup in real-time from the website into my RMS system without negatively impacting site performance. Instead I will probably need to setup some kind of inventory update process that runs at an interval that I feel is reasonable.

If it is possible Please provide the steps to accomplish this problem. because i am new bee to this type of R & D.Then it would be very helpful to me.

Thank you for your quick response.

Answer 1

It appears RMS doesn't come with an API of some sort. But since it does use a regular sql database you could choose to intergrate agains that. There are some very important things to note:

• This might not be allowed by the license
• This might void your support from MS
• This will most likely break on new versions of RMS and might break with small patches and updates
• The schema isn't documented so you would have to reverse engineer it
• You will need to reverse engineer the business logic of RMS. What updates does it make to the DB for each logical opperation

although doable this will take quite a amount of time. You don't seem to be the first personn to be looking into doing this and thus some consultants and product providers have poped up that provide components which abstract these details away into a documented and supported API. One such supplier is http://www.kosmoscentral.com/ecommerce/rms-integration and they offer it at $300/web store. I don't know what your budget and or hourly rate is but it will be cheaper then the amount of time needed to do the work yourself including debugging etc... even if you have a very low hourly rate. They also say they will support uprades to RMS taking one headache away. So I would stronly advice you to go this route (not per se with this supplier).