MacGregors Online Meat Ordering: Vestra Inet's Seamless Supply Solution for Superior Efficiency and Automated Operations.
MacGregors is the single largest meat supplier in Ontario. They have operations that supply supermarkets, stores, and distributors throughout the province. MacGregors has been in the business for decades, and is now the most recognized name in the industry. They have a reputation for high quality meat that is precooked to perfection, clean, and made to order.
- Complete online ordering system tied into current ERP system
- Real-time inventory and client information exchange using the new portal communicating with ERP
- Dedicated client login spaces to view order history and place orders
- Automatic invoicing based on multiple factors
- Custom shipment scheduling for customers; date selector
- Tied into the accounting system to generate invoices and quote information
All ordering at MacGregors was done manually. Customers would have to call in and specify their order details. Orders would be processed through manual data entry. Their existing ERP, while very effective, was incapable of providing information efficiently on request. There was also no way for customers to log into the system and view their previous orders or track their orders.
Online Ordering System
- Live inventory updates
- Custom price margins
- Quantity discounts
Development and implementation of these online ordering systems leads to seamless end-to-end order placement that significantly improves the ease of the process. Additionally, the elimination of human involvement in the ordering process reduces staffing costs, eradicates the risk of human errors, and makes the ordering systems available 24/7. Special calculator integration also drastically boosts the speed with which large, complex orders are placed and processed. The automation of this system helps reduce supply chain complexity while allowing multi-stage customizations with ease.
Price Calculator
- Real-time complex calculations
- Multi-system integration
- Custom price margins
Price calculators with advanced capabilities met unique situations where complicated calculations involving multiple variables were required. The functionality of the calculators varied based on client needs, with features like quantity-based discounts, price margin management, additional options, and real-time updates to the displayed price. These calculator tools were implemented into various client systems including product builders, online ordering systems, and assembly selection. Depending on requirements, additional functionality to set custom price margins was programmed. Additionally, personalized pricing information was displayed to individual users based on order history and other predetermined factors.
Each pricing calculator was designed to meet specific criteria for each client. These custom systems were designed to adapt to the unique needs of each business and its specialized operations, with the ability to adapt to multiple complex variables in real-time. This greatly improved user satisfaction due to immediate results when making item selections or building products online. Designed to be integrated into multiple client systems, these calculators met exact requirements in terms of customizability and functionality. Custom price margins enabled users with administrative access to define parameters such as quantity-based discounts, promotional offers, individual product price margins, and more. This resulted in a more personalized pricing information display for users.
Database Synchronization
- Multiple languages programmed
- Real-time database updates
- Synchronization with external databases
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.
E-commerce System
- CRM and ERP connection
- Quantity discount and special rate calculations
- Multiple shipping and merchant integrations
Currently, there are various commercially available software applications to facilitate e-commerce functionality such as Shopify. These have a fixed set of features that are meant to work with straightforward e-commerce operations. However, in more complicated scenarios, these lack features to meet the unique needs of individual businesses.
Complex e-commerce solutions were designed and tailored to meet specialized requirements such as customizable price margins, connectivity to product builder tools, quantity-based discount calculations and connection to CRM and ERP systems. Order placement features included support for QR codes or scanner guns. Additionally, special rate calculators and communication with multiple shipping carrier databases were designed. These features were implemented based on client needs in order to improve the specific capabilities of e-commerce systems unique to each client.