This document provides setup instructions and an overview of the Epicor Prophet 21 (P21) contact sync integration with Prokeep.
About the Integration:
Target System: Epicor Prophet 21 (P21) – API enabled
Directionality: Bi-directional (P21 <-> Prokeep)
Functionality: Sync Contact and Company Information between the systems
System Requirements: API access to the Entity API, oData API, External Access to P21 endpoint
⚠️ Note: If your organization does not currently have P21 APIs enabled, we recommend not pursuing this integration. The APIs can be expensive, and we do not advise enabling them solely for the purpose of this sync.
Overview:
- The P21 to Prokeep Integration is not instantaneous, as it runs on a 15-timer. Every 15 min, the integration will scan for new contact information and port that information over to Prokeep.
- The Prokeep to P21 integration is instantaneous. As soon as a contact is created or updated in Prokeep, that information will be ported down to P21.
- Requires configuring and testing with the Prokeep team. We will work with customer IT to set up and test.
- There is room for configurability on the directionality, and the wish to sync Companies or Contacts or Both. Talk to your Prokeep Technical Account Manager during setup for more information.
Integration Key
What information is passed along in the integration and where does it end up?
Contact Fields
The following is the field key for contacts
Prokeep Field |
P21 Fields |
First Name |
FirstName |
Last Name |
LastName |
Phone |
Cellular |
Company |
AddressId → CustomerId ->Company |
Fax |
DirectFax |
|
EmailAddress |
Group |
Set by Integration |
Account Rep |
Does not Sync |
Notes |
Does not Sync |
Preferences |
Does not Sync |
Contact Labels |
Does not Sync |
ExternalID (not in UI) |
ID |
PRKP* |
client_id |
*Groups are applied globally to all contacts during setup and cannot currently be dynamically assigned by branch or other criteria.
Company Fields
The following is the field key for Companies (Customers in Prophet 21)
⚠️Note: There are two items we have to account for in the customer creation portion of this sync. They are the Customer and Address in P21. This is how they map.
Customers
Prokeep Field |
P21 Fields |
Company Name |
CustomerName |
Company Account # |
CustomerID |
ExternalID |
CustomerId* |
Company Phone |
Does not Sync |
Company Email |
Does not Sync |
Set during Config |
CompanyID |
*Used later to update the related address object.
Address
Prokeep Field |
P21 Fields |
Company Name |
Name |
Company Account # |
Does Not Sync |
ExternalID |
AddressID, CorpAddressID |
Company Phone |
CentralPhoneNumber |
Company Email |
EmailAddress |
Setting up the integration:
Most of the setup for this integration will be done on the Prokeep side, but there are some critical pieces of information that we will need from the customer in order to set up the integration properly.
The general setup process is:
- The customer provides Prokeep with an export of their contact and customer data from P21. Prokeep will use this to update existing contact records with their P21 unique identifiers and to import any records that don’t already exist.
- The customer provides Prokeep with their P21 API credentials and other information
- Prokeep sets up and turns on the integration
- Verify integration works
Getting the proper credentials for the P21 API is the most critical step in setting up the integration, and is something that we rely on P21 Admins for. There are some other key pieces of information we need from customers, but credential issues are the number one reason why integrations get delayed.
The following is a list of the information we need from the customer:
- Bi-directional or Uni-directional - We need to know if the integration should be set up to sync records back and forth between Prokeep and P21 or only from P21 into Prokeep.
- API endpoint URL - this should include the port we can call, and should look something like https://p21.prokeepelectrical.com:484 (port with access to middleware is probably your best bet). Please ensure the endpoint is either publicly accessible or whitelist our IP address of 52.32.60.21.
- Credentials for the P21 REST and oData APIs
- We specifically need read and write access to: Contacts, Customers, and Addresses
- We will also need the username associated with these credentials so we can generate the access tokens. Usually admin or Prokeep or something similar
- Default Sales Rep ID - Contacts and companies in P21 must have an associated sales rep. Currently, Prokeep cannot match its users to external system users. Therefore, a default sales rep ID (e.g., an admin or dummy account) needs to be set for all P21 contacts.
For more detailed information or assistance during the setup process, please contact Support at support@prokeep.com. We're here to help ensure a smooth integration tailored to your needs.