Complex integrations and customizations simplified with DCKAP Integrator.
About JSI Cabinetry
JSI Cabinetry specialises in crafting premium wood cabinetry that combines durability, timeless detail, and on-trend finishes. Their catalogue features a broad range of styles and colours, thoughtfully designed to complement modern home aesthetics and suit a variety of lifestyles.
Their Magento-powered online catalog allows businesses to configure cabinets by selecting from a range of parts and features, creating made-to-order solutions that meet precise project requirements. With a growing customer base and a commitment to exceptional service, JSI Cabinetry has continued to evolve balancing complexity and customisation at scale.
Challenges: Custom Orders, Manual Work, and Room for Error
When JSI Cabinetry first approached us, their operations were pretty critical. Every custom order placed online needed to be translated into a complete product structure in Epicor P21, their ERP, a process that involved multiple touchpoints, manual follow-ups, and switching between platforms.
Given the nature of their business, where customers configure products by combining various parts, the backend workload was immense. Product creation in Epicor P21 had to be precise, as any error could delay manufacturing or fulfillment. With the increasing volume of custom orders, the risk of manual mistakes grew, and the need for more staff to manage the workload became unavoidable.
They also lacked real-time connectivity between systems, meaning updates in one platform didn’t automatically reflect in another. Inventory visibility, order statuses, and product syncs had to be handled manually, which slowed down operations and left room for delays and inconsistencies.
In short, their systems weren’t keeping up with their pace of growth and that’s when they chose DCKAP Integrator to help untangle the complexities and streamline their operations.
Solutions Provided
Given the scale and complexity of JSI Cabinetry’s operations, their integration requirements went far beyond standard workflows. DCKAP Integrator was responsible to streamline their digital infrastructure by building powerful, customised pipelines between Magento and Epicor Prophet 21. Each integration was designed to minimise manual intervention, reduce errors, and improve real-time visibility across their business systems. Here’s how:.
1. Real-Time Product Validation and Creation in P21
One of the standout features of this project was the ability to validate and create products dynamically in real time. When a customer adds items to their Magento cart, be it a single product or a customized kit made up of multiple components, the system instantly checks P21 to verify whether those items already exist. If not, DCKAP Integrator automatically creates them in P21, pulls in inventory data and product details, and syncs it back to Magento, seamlessly and in real time. This eliminated the need for manual product setup and ensured that all catalog and inventory data was always accurate and up to date.
2. Available Ship Dates Based on Live Warehouse and Customer Data
To enhance delivery transparency, we built a custom logic that calculates available ship dates based on real-time inventory levels, customer-specific information, and warehouse availability. This integration meant customers could see accurate delivery timelines during checkout, no guesswork, no delays, and far fewer support queries. It also supported better planning on JSI Cabinetry’s end by aligning supply with actual demand.
3. Real-Time Order Cancellation Sync
Order cancellations especially for B2B can create major back-office issues if not handled properly. To avoid such complications, we implemented a real-time cancellation sync. When an order is cancelled in Magento, the same cancellation reflects instantly in P21. This bi-directional sync helped eliminate discrepancies, prevented erroneous fulfilments, and reduced the load on their customer support teams.
4. Customer Credit Validation Before Checkout
Before an order can be placed, the system now automatically checks the customer’s credit status from P21. This real-time validation ensures that only eligible customers can proceed with their purchases, keeping JSI’s payment terms in check and reducing credit risk. It also saves time that would otherwise be spent on manual credit reviews.
5. Customer-Specific Pricing Display and Application
JSI Cabinetry’s B2B customers often have negotiated pricing and unique agreements. To honour this, we integrated customer-specific pricing rules from P21 directly into Magento. This means every customer sees their correct price while shopping, no surprises at checkout, no back-and-forth. The integration strengthened customer relationships and increased pricing transparency.
Integration Pipelines
JSI Cabinetry’s business operations required more than just out-of-the-box connectors, they needed flexible, real-time, and reliable integrations to manage high-volume, high-customisation B2B workflows. Here’s a breakdown of the integration pipelines we implemented through DCKAP Integrator to support and scale their operations:
Magento to P21 – Real-Time and Dynamic Syncs
Create Product in P21
When a user selects custom components to build a product in Magento, our system dynamically checks and creates the item in P21 if it doesn’t exist.
Customer Special Pricing
Pulls customer-specific pricing from P21 and displays it directly in Magento, maintaining B2B pricing accuracy in real time.
Customer Credit Status
Verifies the customer’s credit eligibility from P21 before allowing order placement, reducing financial risk.
Get Available Ship Dates
Based on warehouse stock and customer info, the system calculates and returns available ship dates during checkout.
PO Number Uniqueness Check
Prevents duplicate purchase orders by validating uniqueness directly from P21 during order placement.
Cancel P21 Order / Check Order Cancel
If an order is cancelled in Magento, it’s instantly cancelled in P21, ensuring accurate order management across systems.
Contact Sync (Magento to P21)
New or updated contacts added via Magento are automatically synced to P21, streamlining CRM and communication.
Check Contact by Email
Verifies if a contact already exists in P21 using email as a key identifier before creating or syncing a new one.
Create Customer / Get Customer by Email
Customers can be created in P21 from Magento, and existing records can be fetched based on their email address, ensuring a unified customer profile.
Order Sync / Order Process / Offline Order Sync
Orders placed on Magento are pushed into P21 in real time, along with support for syncing offline or manually created orders for consistent order tracking.
Create RMA
Enables return requests to be generated in Magento and synced with P21, closing the loop on post-sale support.
Get Sales Rep
Pulls the assigned sales representative from P21 for each customer, allowing tailored engagement and reporting.
P21 to Magento 2 (Batch Integrations)
While real-time updates manage customer-facing interactions, batch integrations ensure that background operations and reference data stay aligned. For JS International, these P21-to-Magento syncs played a vital role in keeping systems consistent, accurate, and ready to scale.
Freight Program Sync
Freight details from P21 are synced regularly to Magento, ensuring that shipping options, rates, and programs available to customers are always up to date—without needing manual updates.
Customer Sync
Any customer records added or modified in P21 are pushed to Magento in batches, making sure customer accounts, contact details, and preferences are reflected across both platforms.
Order Process
This integration supports backend order processing—bringing status updates, tracking details, and fulfilment info from P21 into Magento. It helps the frontend team stay informed without switching systems.
Offline Order Sync
For orders taken manually or outside the regular online flow (such as phone orders or sales rep entries), this integration ensures they are still captured and reflected in Magento, keeping reporting and customer histories complete.
Magento to P21 (Batch Sync)
Batch Order Sync
Orders placed on Magento are periodically synced to P21 in batches when real-time push isn’t necessary or if offline systems are in use.
The Impact
The integration work done for JSI Cabinetry transformed their day-to-day operations and set them up for long-term success. Here’s how:
1. Less Manual Work, More Efficiency
Before the integration, JSI’s team had to manually manage product data, customer information, and order tracking across platforms. Now, everything flows automatically between Magento and P21. This has reduced manual data entry, eliminated human errors, and saved a significant amount of time for their internal teams.
2. Faster and Accurate Shipping Estimates
With real-time shipping and freight data syncing to Magento, customers now see accurate delivery dates and shipping charges before they place an order. This has not only improved the customer experience but also helped JSI avoid undercharging or overcharging for freight, saving them from revenue leaks and costly corrections.
3. Reliable and Consistent Data Across Teams
Thanks to the real-time and batch syncs, different departments: sales, finance, warehouse, and support are now working with the same, accurate data. This has improved communication across teams, reduced confusion, and allowed for faster decision-making.
4. Fewer Order Issues and Returns
With credit checks and cancellation syncs in place, orders that don’t meet the required criteria are blocked early. This means fewer incorrect or problematic orders go through, helping JSI cut down on returns, customer complaints, and wasted resources.
5. Better Customer Relationships
The integration of customer-specific pricing, contact syncs, and sales rep data means JSI can now offer a more personalized experience. Sales reps respond faster and more accurately, making the buying process smoother for every customer.
6. A Scalable System Built for Growth
What JSI has now is not just a solution for their current problems, it’s a flexible system that can grow with them. Whether they want to add new products, enter new markets, or expand to more platforms, their integrated system is ready to support them without extra manual work.
Final Words
JSI Cabinetry is a shining example of what’s possible when a growing business embraces system automation and intelligent integration. With complex workflows, customer-specific product configurations, and a large volume of daily operations, they needed more than a plug-and-play solution, they needed a partner who could adapt, scale, and build around their evolving needs. That’s exactly where DCKAP Integrator stepped in.
From automating real-time product creation and inventory validation to enabling order visibility, credit checks, and customer-specific pricing, every piece of this integration was tailored to eliminate manual errors and support growth. What started as a need for operational efficiency has grown into a long-standing partnership built on trust, flexibility, and a shared vision for the future.
If you’re looking to streamline your processes and reduce dependency on manual tasks, explore how DCKAP Integrator can support your business.
