Questudio Integrates Medical Supplier’s ERP System with its Web Catalog Software WebStudio
Having a website with up-to-date information and synchronized key data is vital for the success of any online business.
Being a major medical equipments supplier, Diamond Medical Supply stores hundreds of products and has the capability to source and deliver anywhere within the United States. Keeping this in mind, they wanted to have an online ordering system wherein institutions would be able to place orders and track them.
The question of how to cater to the needs of different medical institutions online piqued Diamond Medical Supply to approach Questudio. Questudio’s expertise in the content management and web implementations arena found a sure-shot solution to meet Diamond’s requirements.
The customers of Diamond Medical Supply belonged to different categories ranging from Institutions, Staff Nurses, and patients themselves. To manage all of them, they needed to create custom users group with restricted permission levels. The reasoning behind this was that staff nurses take care of many patients in different medical institutions and need the ability to login and place orders irrespective of the institution they belonged to. To address this, Questudio created hierarchical user groups with predefined restrictions to access the website and place orders online.
Integration of ERP system with WebStudio
Diamond Medical Supply used Pacware software to manage users and product information offline. The requirement was that users should be able to place orders online, and soon after that the order should be sent over to Pacware for processing. Once an order is processed in Pacware, a confirmation would need to be transmitted back to Questudio’s WebStudio which would display the status of the order in real-time. On a run-time basis, constant interaction takes place between Pacware and WebStudio to see if any orders are placed or processed and displays the information in the website accordingly. Integrating Pacware with WebStudio was done effortlessly with the coordination of the project management team at Questudio and the IT team at Diamond Medical Supply.
The integration of Pacware and WebStudio was done with a series of database scripts written to call for action when there is a related activity in the website and vice versa. Certain tables from WebStudio’s database were directly mapped with that of Pacware to establish a connection between both systems. The point here was to map only the required fields and not all the fields, as others contain confidential data. Complex stored procedures were written to pull pricing logic and group discounts targeted for each user/institution based on which pricing would be displayed when a user logs in.
Apart from integrating the data system, Diamond Medical Supply wanted to have a powerful search implemented in their new online catalog wherein users would be able to drill down to get what they are actually looking for. To address this, Questudio implemented the parametric search, which is part of the array of inbuilt features in WebStudio.
By assigning the right skills and expertise to fully integrate different modules; Questudio’s web implementation team fully matched the expectations of what Diamond Medical Supply’s new dynamic website should do.