The Challenge

This client had been running Epicor P21 for over a decade. It handled their inventory, orders, purchasing, and accounting without major issues. Two years ago, they implemented Salesforce to give their sales team better tools for managing opportunities and customer relationships.

The problem was that P21 and Salesforce didn't know each other existed. Sales reps had to log into P21 to check inventory availability before quoting customers. Customer service couldn't see order status in Salesforce without switching to P21. When a new customer was added in Salesforce, someone had to manually create the same customer in P21.

The disconnection created real costs. The sales team estimated they spent 3-4 hours per day per rep just checking information across systems. Customer service frequently gave customers outdated information because they were looking at stale data. New customer setup took 2-3 days because of the manual handoff between systems.

The company had three people whose primary job had become data reconciliation—exporting from one system, reformatting in Excel, and importing to the other. They were spending over 25 hours per week just keeping the two systems somewhat in sync, and they were still finding discrepancies regularly.

The Solution

We built a bi-directional integration between P21 and Salesforce that synchronized the data both teams needed without requiring anyone to change how they worked.

The integration included:

Customer Master Sync: When a customer is created or updated in either system, the change automatically flows to the other. Sales can add a new prospect in Salesforce and it appears in P21 within minutes, ready for order entry.

Real-Time Inventory Visibility: Salesforce now displays current inventory levels pulled directly from P21. Sales reps can see what's available across all three warehouses without leaving Salesforce. The data updates every 15 minutes during business hours.

Order History and Status: All orders from P21 appear in Salesforce, attached to the right customer and opportunity records. Customer service can see order status, shipment tracking, and invoice history without touching P21.

Pricing Integration: Customer-specific pricing from P21 flows into Salesforce so quotes reflect the actual pricing the customer will see on their invoice. No more "let me check on that price" calls.

We used P21's REST API and Salesforce's standard integration capabilities, with a middleware layer handling the data transformation and sync logic. The middleware runs on Azure and includes monitoring that alerts our team if any sync fails.

The Implementation

The project took six weeks from kickoff to go-live:

Weeks 1-2: Discovery and mapping. We documented every field that needed to sync, identified data quality issues that needed cleaning first, and mapped out the business rules for handling conflicts.

Weeks 3-4: Development and testing. We built the integration in a sandbox environment and ran it against copies of their production data. The sales team validated that inventory and pricing data matched what they saw in P21.

Week 5: Data cleanup and preparation. We worked with their team to clean up 1,200+ duplicate customer records and standardize the data formats that would be syncing.

Week 6: Deployment and go-live. We deployed on a Saturday, ran a full initial sync, and monitored closely for the first week. The team was fully operational on Monday with both systems connected.

The Results

The impact was immediate and measurable:

25+ hours per week saved in manual data entry and reconciliation. The three employees who had been doing data reconciliation were reassigned to customer-facing work.

92% reduction in data errors. Before the integration, they found an average of 12 data discrepancies per week. After integration, that dropped to less than one per week—and those were usually edge cases in the business logic that we refined over the first month.

Same-day customer setup. New customers added in Salesforce are available in P21 within 15 minutes. What used to take 2-3 days now happens automatically.

Sales productivity increase. Reps reported saving 2-3 hours per day they previously spent checking inventory and pricing. That time now goes to customer calls and prospecting.

4-month payback. The integration project cost approximately $18,000. Between the staff time freed up and the reduction in order errors, the client estimated they recouped the investment in about four months.

Key Takeaways

This project reinforced several principles we see in successful integrations:

Start with the pain. We focused first on the data that was causing the most manual work—customer records and inventory. We added order history and pricing in phase two once the foundation was solid.

Data quality matters. A week of the project was dedicated to cleaning up duplicate and inconsistent data. Integrating dirty data just moves the mess faster.

Plan for maintenance. The integration has been running for 18 months now. We've made minor updates when P21 released new versions, but the core integration has been stable because we built it with long-term maintenance in mind.

---

Is your P21 disconnected from your CRM? Learn about our integration services or contact us to discuss your situation.