Create web sites to sell products to retail customer or institutional customers as well as update order and inventory data between the multiple web sites and the accounting application from locations across the country.
MMI maintains a large volume of inventory with multiple pricing levels for different types of customers and even restricted items that would not be sold to certain customers.
MMI needed an Internet storefront to allow their customers to view the products offered by MMI for their class and to display the correct pricing for the customer. Furthermore, MMI needed an efficient system of order fulfillment that would allow them to keep their promise of quick delivery and needed to keep inventory updated including quantities that would sell out.
Bit-Wizards architected a solution that included two web sites that would talk to MMI’s Great Plains accounting system through a web service that was controlled by a windows service on the accounting application server.
MMI already had a contractor start a retail web site and Bit-Wizards took over the first web site. The 4Gearheadz web site was a store front to the general public. The products offered were limited and the web site had the all the features you would expect from an e-commerce store front for product display, searches, checkout, and order tracking. The web site was built using ASP.NET, C#, SQL Server 2000, and .NET Commerce Cart, and a few other third party components.
Bit-Wizards also built the second store front MMI-FED.com. This web site was specifically created for institutional customers where prices were negotiated into some general categories. Customers had to log on before being able to shop and their prices would be displayed during their session with the web site. While users were logged on all the web site had the all the features you would expect from an e-commerce store front for product display, searches, checkout, and order tracking. The web site was built using ASP.NET, C#, SQL Server 2000, and .NET Commerce Cart, and a few other third party components.
Both web sites were hosted on a dedicated server in Dallas Texas. Bit-Wizards built a secured web service with functions that allowed order information to be sent out and accepted inventory information to update the web sites. A windows service on the accounting server called the web service and to exchange the order and inventory information through eConnect between the web site databases and the Great plains Database. The application MMISynchService worked on a configurable timer or in an on demand basis. The application was built using Windows Forms, C#, eConnect, and SQL Server 2000.
The solution accomplished MMI’s goals for single data entry and quick communication from servers across the country.
- Public Website for Retail Customers
- Secure Website for Institutional Customers
- Real time data transfer of orders
- Real time data transfer of inventory updates
- No duplicate entry for data for accounting and web site