We need a link between Interspire shopping cart and Microsoft Point of Sale (RMS).
Build Import feature for RMS " Microsoft Retail Management" active inventory.
There is a database field "webitem" for active web items that is set to 1 if active and 0 if not..
The utility should look at this field to determine if the item should be uploaded to the cart.
The utility should update all relevant fields with the most current information every few minutes.
If the items database field "webitem" shows inactive the utility should remove this item from the cart database.
If the item being removed from the cart is the only item in the catagory the catagory should be removed as well.
Build export feature to take all orders and import them to RMS as a work order that can be later filled manually.
additional programming needed
Determine a way to sync the customer database between the interspire cart and RMS to avoid duplicated records.