Walker Machinery is a Canadian company that has been in the business for over 20 years. It is a company that specializes in selling used and new metal cutting tools and machines. They are experienced in selling milling and cutting equipment. The company is also known for a high level of customer service and a wide range of products.
- Multi-database synchronization
- Complete inventory control system
- Online order placement
- Quotation generator
- Information sharing with supply networks
- Synchronization between master database and new database
- Inventory control system with real-time changes
- Complete online order placement system
- Automatic quote generation for products in cart
The problem facing Walker Machinery was that there was no online ordering or customer interaction tool to speak of. Customers were unable to request quotes, and they were unable to place orders for products online. There was also a very limited database because of communication issues with other supply networks.
Type of Systems Used in Project
Having large inventories consisting of thousands of items with different variants and combinations leads to organizational issues. One of the obstacles faced by clients is the presentation of these listings to customers. Appropriate relationships between items of different compatibility settings are critical to a smooth user experience when navigating the product listings. Additionally, identification of unique items and combinations is essential where products are modified with infinite combinations of components. Effective search functionality within such an inventory is crucial to ensure user satisfaction.
Based on individual requirements, online catalogues were implemented for various clients. These systems were implemented alongside multiple systems and databases. Integration was supported with existing systems such as inventory control, production management, e-commerce platforms, and more. Various complex relationships were defined between items and their components to ensure compatibility. Additionally, online product builders were designed and implemented as required. In these cases, every uniquely designed item variant could be automatically added to the existing catalogue with a unique automatically assigned SKU number, creating self-propagating catalogues. Other features such as table builders (one product - multiple SKUs) and compatibility filters were also designed.Learn More
Often, important information is located in multiple systems or spread over multiple locations. It is essential to communicate specific data among these locations as required. Identifying relevant data, transferring it to a centralized database, and synchronizing the data among various sources is a major issue.
Specialized bridges were programmed for clients with multiple databases, locations, and sources of information to facilitate the synchronization of data between these. These bridges were built to translate data between various types of databases including relational and non-relational or sequential and non-sequential. Additionally, transference of data between sources written in various languages such as MySQL, MS-SQL, Oracle, etc. was established.Learn More