Source ERP · 3 of 27

CRMPro → Zoho CRM — Epicor Eagle: what the shipped templates set up

This is the capability summary the dlake CLI repository publishes; whitelisted customers fetch the operational skill with "dlake admin get_skill dlake-crmpro-zohocrm/erps/epicor-eagle". It extends the dlake-crmpro-zohocrm skill, which holds what is true whatever the source ERP. Both directions for this pair are summarised at /integrations/epicor-eagle-zoho-crm/.

CRMPro → Zoho CRM — Epicor Eagle: what the shipped templates set up

This is a capability summary, not an operating guide. To receive the operational skill you must be a registered, whitelisted Commercient customer. Whitelisted customers fetch it with dlake admin get_skill dlake-crmpro-zohocrm/erps/epicor-eagle (or list_skills) against the Commercient admin plane. Existing customers who need access or help: contact support@commercient.com. New customers: contact sales@commercient.com to become a customer and be whitelisted.

dlake-crmpro is the parent skill and the authority for everything general: the CRMPro tools, process configuration and field list, the sync history, how source data is selected, and what a run that finds nothing does. Read it first; this page does not repeat it. dlake-crmpro-zohocrm is the destination skill this page is a child of, and the authority for the Zoho CRM conventions that hold across every ERP: read it first, then come back here for what this source’s own templates set. This page grows as the catalogue does.

1. What the templates deliver

GroupBusiness outcomeObjectsSource tables and views
Epicor Eagle TermsThe templates push Commercient Epicor Eagle terms code object to Zoho CRM.Commercient Epicor Eagle terms code objectterms codes
Epicor Eagle SalespersonThe templates push Commercient Epicor Eagle salesperson object to Zoho CRM.Commercient Epicor Eagle salesperson objectsalespeople
AccountThe templates push Accounts to Zoho CRM.Accountscustomers, customer shipping addresses
Epicor Eagle CustomerThe templates push Commercient Epicor Eagle customer object to Zoho CRM.Commercient Epicor Eagle customer objectcustomers
Epicor Eagle StoreThe templates push Commercient Epicor Eagle inventory store object to Zoho CRM.Commercient Epicor Eagle inventory store objectstores
ProductThe templates push Products to Zoho CRM.Productsinventory records
Epicor Eagle InventoryThe templates push Commercient Epicor Eagle inventory object to Zoho CRM.Commercient Epicor Eagle inventory objectinventory records
Epicor Eagle Sales order headerThe templates push Commercient Epicor Eagle sales order header object to Zoho CRM.Commercient Epicor Eagle sales order header objectpoint of sale order headers
Epicor Eagle Sales order detailThe templates push Commercient Epicor Eagle sales order detail object to Zoho CRM.Commercient Epicor Eagle sales order detail objectpoint of sale order lines
Epicor Eagle Invoice headerThe templates push Commercient Epicor Eagle invoice header object to Zoho CRM.Commercient Epicor Eagle invoice header objectpoint of sale transaction headers
Epicor Eagle Invoice detailThe templates push Commercient Epicor Eagle invoice detail object to Zoho CRM.Commercient Epicor Eagle invoice detail objectpoint of sale transaction lines
Epicor Eagle open invoice sync outputThe templates push Commercient Epicor Eagle open invoice header object to Zoho CRM.Commercient Epicor Eagle open invoice header objectAR documents
Epicor Eagle Open invoice detailThe templates push Commercient Epicor Eagle open invoice detail object to Zoho CRM.Commercient Epicor Eagle open invoice detail objectarchived AR documents
Epicor Eagle Serial numberThe templates push Epicor Eagle serial number (custom object) to Zoho CRM.Epicor Eagle serial number (custom object)serial numbers
PricebookThe templates push Zoho price books to Zoho CRM.Zoho price booksprice plan headers
Product PricebookThe templates push Zoho product price book relation to Zoho CRM.Zoho product price book relationprice plan details
Sales ordersThe templates push Sales orders to Zoho CRM.Sales orderspoint of sale order lines, point of sale order headers, customers, customer shipping addresses, x
InvoicesThe templates push Invoices to Zoho CRM.Invoicespoint of sale transaction lines, point of sale transaction headers, customers, customer shipping addresses, x

2. The process rows the templates create

Each template’s setup writes one process configuration row. These are the values it sets; a column the inserts never set is not listed.

Display nameDestination objectMatching keyRun sequence
Epicor Eagle TermsCommercient Epicor Eagle terms code objectCommercient external key column1
Epicor Eagle SalespersonCommercient Epicor Eagle salesperson objectCommercient external key column2
AccountAccountsCommercient AR customer code (Zoho field)3
Epicor Eagle CustomerCommercient Epicor Eagle customer objectCommercient external key column4
Epicor Eagle StoreCommercient Epicor Eagle inventory store objectCommercient external key column5
ProductProductsCommercient external key column6
Epicor Eagle InventoryCommercient Epicor Eagle inventory objectCommercient external key column7
Epicor Eagle Sales order headerCommercient Epicor Eagle sales order header objectCommercient external key column8
Epicor Eagle Sales order detailCommercient Epicor Eagle sales order detail objectCommercient external key column9
Epicor Eagle Invoice headerCommercient Epicor Eagle invoice header objectCommercient external key column10
Epicor Eagle Invoice detailCommercient Epicor Eagle invoice detail objectCommercient external key column11
Epicor Eagle open invoice sync outputCommercient Epicor Eagle open invoice header objectCommercient external key column12
Epicor Eagle Open invoice detailCommercient Epicor Eagle open invoice detail objectCommercient external key column13
Epicor Eagle Serial numberEpicor Eagle serial number (custom object)Commercient external key column14
PricebookZoho price booksCommercient external key column15
Product PricebookZoho product price book relationCommercient external key column16
Sales ordersSales ordersCommercient external key column17
InvoicesInvoicesCommercient external key column18

Every one of these inserts the active setting as 0, so an imported process is inactive until an operator activates it.

3. The views

“Change detection” names which of the three kinds dlake-crmpro defines the view’s own filter makes it; where a view’s shape is not one of those three the column is left empty and the view’s own filter is the authority.

ViewChange detectionSource tables
terms feedinsert onlyterms codes
salesperson feedinsert onlysalespeople
account feedinsert + updatecustomers, customer shipping addresses
customer feedinsert onlycustomers
store feedinsert onlystores
product feedinsert onlyinventory records
inventory feedinsert onlyinventory records
sales order feedinsert onlypoint of sale order headers
sales order line feedinsert onlypoint of sale order lines
invoice feed (Commercient objects)insert onlypoint of sale transaction headers
invoice line feed (Commercient objects)insert onlypoint of sale transaction lines
open invoice feedinsert onlyAR documents
open invoice line feedinsert onlyarchived AR documents
serial number feedinsert onlyserial numbers
price book feedinsert onlyprice plan headers
product price book feedinsert onlyprice plan details
Zoho sales order feedinsert onlypoint of sale order lines, point of sale order headers, customers, customer shipping addresses, x
Zoho invoice feedinsert onlypoint of sale transaction lines, point of sale transaction headers, customers, customer shipping addresses, x

4. Order of work

The templates set run sequence from 1 to 18. A run processes active rows in ascending run sequence, which is the order the templates put them in:

  • 1 — Epicor Eagle Terms
  • 2 — Epicor Eagle Salesperson
  • 3 — Account
  • 4 — Epicor Eagle Customer
  • 5 — Epicor Eagle Store
  • 6 — Product
  • 7 — Epicor Eagle Inventory
  • 8 — Epicor Eagle Sales order header
  • 9 — Epicor Eagle Sales order detail
  • 10 — Epicor Eagle Invoice header
  • 11 — Epicor Eagle Invoice detail
  • 12 — Epicor Eagle open invoice sync output
  • 13 — Epicor Eagle Open invoice detail
  • 14 — Epicor Eagle Serial number
  • 15 — Pricebook
  • 16 — Product Pricebook
  • 17 — Sales orders
  • 18 — Invoices

These views read another process’s sync output, which is what makes the order a dependency order: the row appears in the view only once the process that writes that sync output has run, so a parent flows on one run and its children on the next.

  • terms feed reads terms sync output; no template in this set writes terms sync output
  • salesperson feed reads salesperson sync output; no template in this set writes salesperson sync output
  • account feed reads terms sync output, salesperson sync output, account sync output; no template in this set writes terms sync output, salesperson sync output, account sync output
  • customer feed reads account sync output, terms sync output, customer sync output; no template in this set writes account sync output, terms sync output, customer sync output
  • store feed reads store sync output; no template in this set writes store sync output
  • product feed reads store sync output, product sync output; no template in this set writes store sync output, product sync output
  • inventory feed reads store sync output, inventory sync output; no template in this set writes store sync output, inventory sync output
  • sales order feed reads account sync output, customer sync output, sales order sync output; no template in this set writes account sync output, customer sync output, sales order sync output
  • sales order line feed reads sales order sync output, product sync output, sales order line sync output; no template in this set writes sales order sync output, product sync output, sales order line sync output
  • invoice feed (Commercient objects) reads account sync output, customer sync output, invoice sync output (Commercient objects); no template in this set writes account sync output, customer sync output, invoice sync output (Commercient objects)
  • invoice line feed (Commercient objects) reads invoice sync output (Commercient objects), product sync output, invoice line sync output (Commercient objects); no template in this set writes invoice sync output (Commercient objects), product sync output, invoice line sync output (Commercient objects)
  • open invoice feed reads account sync output, customer sync output, open invoice sync output; no template in this set writes account sync output, customer sync output, open invoice sync output
  • open invoice line feed reads open invoice sync output, open invoice line sync output; no template in this set writes open invoice sync output, open invoice line sync output
  • serial number feed reads serial number sync output; no template in this set writes serial number sync output
  • price book feed reads price book sync output; no template in this set writes price book sync output
  • product price book feed reads product sync output, price book sync output, product price book sync output; no template in this set writes product sync output, price book sync output, product price book sync output
  • Zoho sales order feed reads product sync output, account sync output, Zoho sales order sync output; no template in this set writes product sync output, account sync output, Zoho sales order sync output
  • Zoho invoice feed reads product sync output, account sync output, Zoho invoice sync output; no template in this set writes product sync output, account sync output, Zoho invoice sync output

5. Field mapping

Each template carries its intended mapping in field mapping.

TemplateObjectMapped fieldsFirst ERP → Zoho CRM pairs
Epicor Eagle TermsCommercient Epicor Eagle terms code object25Terms code → Commercient external key (custom field), Description 1 → Name, Terms code → Commercient terms code, Terms due days → Commercient due days, Due date → Due date
Epicor Eagle SalespersonCommercient Epicor Eagle salesperson object14Salesperson → Commercient external key (custom field), Salesperson name → Name, Salesperson → Salesperson, Salesperson name → Salesperson name, Territory → Territory
AccountAccounts17Customer, Job number → Commercient AR customer code (Zoho field), Name, Customer, Job number → Account name, Phone number → Phone, Address 1, Address 2 → Billing street (Zoho field), City → Billing city (Zoho field)
Epicor Eagle CustomerCommercient Epicor Eagle customer object169Customer, Job number → Commercient external key (custom field), the linked Salesforce record → Account, the linked Salesforce record → Terms, Customer → Customer, Job number → Job number
Epicor Eagle StoreCommercient Epicor Eagle inventory store object146Store → Commercient external key (custom field), Store name → Name, Additional charges → Commercient additional charges, Address line 1 → Commercient address line 1, Address line 2 → Commercient address line 2
ProductProducts3Stock keeping unit → Commercient external key (custom field), Description → Product name (Zoho field), Store → Epicor Eagle store (related record)
Epicor Eagle InventoryCommercient Epicor Eagle inventory object173Stock keeping unit, Store → Commercient external key (custom field), Description, Store → Name, the linked store record → Commercient Epicor Eagle inventory store (related record), Alternate conversion factor → Commercient alternate conversion factor, Alternate decimal places → Commercient alternate decimal places
Epicor Eagle Sales order headerCommercient Epicor Eagle sales order header object85Document number (Epicor Eagle), Store → Commercient external key (custom field), Document number (Epicor Eagle), Store → Name, Customer → Account, Customer → Commercient Epicor Eagle customer (related record), Document number (Epicor Eagle) → Commercient order document number
Epicor Eagle Sales order detailCommercient Epicor Eagle sales order detail object65Document number (Epicor Eagle), Store, Source line number → Commercient external key (custom field), Document number (Epicor Eagle), Store, Source line number → Name, the linked Salesforce record → Commercient Epicor Eagle sales order header (related record), the linked Salesforce record → Product, Document number (Epicor Eagle) → Document number
Epicor Eagle Invoice headerCommercient Epicor Eagle invoice header object85Document number (Epicor Eagle), Store → Commercient external key (custom field), Document number (Epicor Eagle), Store → Name, Customer → Account, Customer → Commercient Epicor Eagle customer (related record), Document number (Epicor Eagle) → Document number
Epicor Eagle Invoice detailCommercient Epicor Eagle invoice detail object67Document number (Epicor Eagle), Store, Source line number → Commercient external key (custom field), Document number (Epicor Eagle), Store, Source line number → Name, the linked Salesforce record → Commercient Epicor Eagle invoice header (related record), the linked Salesforce record → Product, Document number (Epicor Eagle) → Document number
Epicor Eagle open invoice sync outputCommercient Epicor Eagle open invoice header object91Document number, Store → Commercient external key (custom field), Document number, Store → Name, Customer, Job number → Account, Customer, Job number → Commercient Epicor Eagle customer (related record), Store → Store
Epicor Eagle Open invoice detailCommercient Epicor Eagle open invoice detail object66Archive time, Archive sequence → Commercient external key (custom field), Archive time, Archive sequence → Name, the linked Salesforce record → Commercient Epicor Eagle open invoice header (related record), Alternate tender 1 amount → Commercient alternate tender 1 amount, Alternate tender 1 type → Commercient alternate tender 1 type
Epicor Eagle Serial numberEpicor Eagle serial number (custom object)9Serial number,Item number → Commercient external key column, Serial number,Item number → Name, Serial number → Serial number (Zoho field), Item number → Item number, Store → Store
PricebookZoho price books4Category plan → Commercient external key column, Category plan → Price book name (Zoho field), Plan description → Description
Product PricebookZoho product price book relation4Category plan, Category type, Category, Core plan → Commercient external key column, the linked Salesforce record → Product lookup (Zoho field), the linked Salesforce record → Price book lookup (Zoho field), Category price → List price
Sales ordersSales orders18Document number (Epicor Eagle), Store → Commercient external key (custom field), Customer, Job number → Account name, Document number (Epicor Eagle) → Name, Document number (Epicor Eagle) → Sales order number (Zoho field), Document date → ERP created date (custom field)
InvoicesInvoices19Document number (Epicor Eagle), Store → Commercient external key (custom field), Customer, Job number → Account name, Document number (Epicor Eagle) → Name, Document number (Epicor Eagle) → Invoice number (Zoho field), Document date → Invoice date

6. Community templates

The catalogue carries 19 community templates for this pair. A community template is authored in a tenant rather than shipped with the product, and it imports the same way as any other. Its own names, notes, field mapping and SQL are tenant content, so what this section states is what the set amounts to: how many templates there are, what they default to doing, which destination objects they write and which groups they fall in. They are not part of the shipped set described above.

  • Templates: 19
  • Default operations: insert on 19, update on 19, delete on 19
  • Marked as circular sync: 0
  • Licence groups they span: 4
  • Destination objects: Accounts, Commercient Epicor Eagle customer object, Commercient Epicor Eagle inventory object, Commercient Epicor Eagle invoice detail object, Commercient Epicor Eagle invoice header object, Commercient Epicor Eagle inventory store object, Commercient Epicor Eagle salesperson object, Commercient Epicor Eagle sales order detail object, Commercient Epicor Eagle sales order header object, Commercient Epicor Eagle terms code object, Contacts, Epicor Eagle serial number (custom object), Invoices, Zoho price books, Products, Sales orders and 3 custom objects
  • Object display names: Account, Contacts, Epicor Eagle Customer, Epicor Eagle Inventory, Epicor Eagle Invoice detail, Epicor Eagle Invoice header, Epicor Eagle open invoice sync output, Epicor Eagle Open invoice detail, Epicor Eagle Sales order detail, Epicor Eagle Sales order header, Epicor Eagle Salesperson, Epicor Eagle Serial number and 7 more
  • Template groups: Account, CRM Order and Line

7. Verifying

The detail of this section is part of the operational skill. Whitelisted customers fetch it with dlake admin get_skill dlake-crmpro-zohocrm/erps/epicor-eagle.

8. Where this sits

dlake-crmpro is the general operating surface — the CRMPro tools, the setup and transaction tables, field mapping, and the source view contract that applies to every destination. This page adds what the shipped Epicor Eagle → Zoho CRM templates set up. dlake-crmpro-zohocrm is the destination skill this page sits under: its own text is the authority for the Zoho CRM conventions that hold across every ERP, and its ERP table lists this page alongside every sibling ERP page for this destination. For the extract leg that fills the source data, see dlake-normalsync; for the on-premises agent that runs it, dlake-syncagent; for the writeback leg, dlake-txdownloaderpro; for standing an integration up, dlake-integration-setup.

How to get started

  • Already a customer: the operational skill tells you how to connect, choose what to sync and run it. Fetch it with dlake admin get_skill dlake-crmpro-zohocrm/erps/epicor-eagle, or ask support@commercient.com.
  • New to Commercient: contact sales@commercient.com. Becoming a customer includes registration and whitelisting, after which the operational skills and tools are available to you.