Enabling End-to-End Automation Across Internal and External Systems
About The Company
Mills Office Productivity is a well-established family-owned business and one of the leading office supply providers in British Columbia. The company operates with a strong focus on sustainability, social responsibility, and community impact, embedding environmentally conscious practices into its core operations. Guided by its core principle of “Delivering Community Goods,” Mills aims to support and empower its stakeholders including customers, employees, partners, and the wider community while providing quality products and creating meaningful value through its business.
Why Integration Became a Priority
A significant portion of data particularly between its EvolutionX ecommerce platform and Acumatica ERP was being handled manually, resulting in time-consuming processes, a higher risk of errors, and limitations in operational efficiency. Some other prominent challenges included:
- High-volume data transfers revealed infrastructure constraints, requiring enhancements to the integration framework.
- Real-time processing demands led to system strain, making it necessary to introduce staging (waiting) areas and control mechanisms.
- Performance limitations within Acumatica affected its ability to efficiently process large volumes of data.
To better support its growth and improve data accuracy, Mills recognized the need for a more integrated and automated approach.
Beyond internal systems, Mills also sought to strengthen collaboration with its trading partners through EDI integration. The goal was to seamlessly connect external partner systems with their own ERP, enabling automated, real-time data exchange without manual intervention.
Integration Strategy
As a solution to its growing integration needs, Mills chose DCKAP Integrator, purpose-built for ERP integrations in distribution and manufacturing environments. Positioned between Acumatica and EvolutionX, it enabled seamless communication between the systems, automating data movement and simplifying previously manual and fragmented processes.
The following integration pipelines were established to streamline internal operations:
Customer & Contact Sync ( Acumatica → EvolutionX):
Customer information stays aligned across both systems, which helps avoid duplication issues and keeps records accurate without constant manual updates.
Customer Product Codes ( Acumatica → EvolutionX):
Customers can easily identify and order the right products on the ecommerce platform, as their specific product mappings and codes are already reflected correctly.
Inventory Sync (Acumatica → EvolutionX)
Stock levels on the website reflect actual availability, giving both customers and internal teams better visibility and reducing the chances of overselling or confusion.
Order Sync (EvolutionX → Acumatica)
Online orders flow directly into the ERP, cutting down delays and making the order fulfillment process much faster and more reliable.
Order Processing Updates (Acumatica → EvolutionX)
Order statuses are continuously updated, so teams and customers always have a clear view of where things stand and can quickly respond if something needs attention.
Product Sync: (Acumatica → EvolutionX)
Product information on the site remains current and consistent which helps maintain accuracy and avoids issues caused by outdated listings.
EDI Integration with Trading Partner
To improve external operations, an EDI integration was implemented with Mills’ trading partner, Grand & Toy, enabling automated and standardized document exchange:
Purchase Orders (850): Grand & Toy → Acumatica
Incoming purchase orders were automatically received and processed within Acumatica.
Advanced Shipping Notice (856): Acumatica → Grand & Toy
Shipment details were sent from Acumatica to keep the trading partner informed in real time.
Invoices (810): Acumatica → Grand & Toy
Invoice data was electronically transmitted, ensuring faster and more accurate billing processes.
What This Meant for Their Operations
Key outcomes included:
- Reduced manual effort and operational delays.
- Improved data accuracy and consistency across platforms.
- Faster order processing and better inventory visibility.
- Enhanced system performance to handle high-volume data transfers.
- Streamlined communication with trading partners through automated EDI transactions.
As a result, Mills now operates on a more scalable and reliable system, enabling smoother day-to-day operations and supporting future growth without added complexity.
Final Words
Mills’ journey shows how the right integration approach can turn disconnected systems into a streamlined, efficient ecosystem. By automating processes and enabling seamless data flow, they’ve set a strong foundation for continued growth.
If your business is dealing with fragmented systems or looking to ensure improved EDI management, DCKAP Integrator is a powerful solution worth exploring.
