Prophet 21 Contact Sync Integration Overview

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

Email

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: 

  1. 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. 
  2. The customer provides Prokeep with their P21 API credentials and other information 
  3. Prokeep sets up and turns on the integration 
  4. 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: 

    1. 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. 
    2. 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
    1. We specifically need read and write access to: Contacts, Customers, and Addresses
    2. We will also need the username associated with these credentials so we can generate the access tokens. Usually admin or Prokeep or something similar
  1. 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.