Source ERP · 6 of 27

CRMPro → Zoho CRM — GlobalShop: 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/globalshop". 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/globalshop-zoho-crm/.

CRMPro → Zoho CRM — GlobalShop: 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/globalshop (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
UsersThe templates push users to Zoho CRM. New records are created and existing ones updated; none are deleted.users—
Global Shop TermThe templates push Commercient Global Shop terms object to Zoho CRM. New records are created and existing ones updated; none are deleted.Commercient Global Shop terms objectAR terms
Global Shop SalespersonThe templates push Commercient Global Shop salesperson object to Zoho CRM. New records are created and existing ones updated; none are deleted.Commercient Global Shop salesperson objectsalespeople
AccountThe templates push Accounts to Zoho CRM. New records are created and existing ones updated; none are deleted.Accountscustomer master records, multiple shipping addresses
Global Shop CustomerThe templates push Commercient Global Shop customer object to Zoho CRM. New records are created and existing ones updated; none are deleted.Commercient Global Shop customer objectcustomer master records
ContactsThe templates push Contacts to Zoho CRM. New records are created and existing ones updated; none are deleted.Contactscontacts
Global Shop Ship toThe templates push Commercient Global Shop shipping address object to Zoho CRM. New records are created and existing ones updated; none are deleted.Commercient Global Shop shipping address objectmultiple shipping addresses
ProductsThe templates push Products to Zoho CRM. New records are created and existing ones updated; none are deleted.Productsinventory master items
Global Shop ItemThe templates push Commercient Global Shop item master object to Zoho CRM. New records are created and existing ones updated; none are deleted.Commercient Global Shop item master objectinventory master items
Global Shop Sales orderThe templates push Commercient Global Shop sales order header object to Zoho CRM. New records are created and existing ones updated; none are deleted.Commercient Global Shop sales order header objectorder headers
Global Shop Item listThe templates push Commercient Global Shop item list object to Zoho CRM. New records are created and existing ones updated; none are deleted.Commercient Global Shop item list objectitem master records
Global Shop Sales order lineThe templates push Commercient Global Shop sales order line object to Zoho CRM. New records are created and existing ones updated; none are deleted.Commercient Global Shop sales order line objectorder lines
Global Shop InvoiceThe templates push Commercient Global Shop invoice header object to Zoho CRM. New records are created and existing ones updated; none are deleted.Commercient Global Shop invoice header objectorder history headers
Global Shop invoice lineThe templates push Commercient Global Shop invoice line object to Zoho CRM. New records are created and existing ones updated; none are deleted.Commercient Global Shop invoice line objectorder history lines

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
UsersusersCommercient external key column0
Global Shop TermCommercient Global Shop terms objectCommercient Global Shop external key1
Global Shop SalespersonCommercient Global Shop salesperson objectCommercient Global Shop external key2
AccountAccountsCommercient external key column3
Global Shop CustomerCommercient Global Shop customer objectCommercient Global Shop external key4
ContactsContactsCommercient external key column4
Global Shop Ship toCommercient Global Shop shipping address objectCommercient Global Shop external key5
ProductsProductsCommercient external key column6
Global Shop ItemCommercient Global Shop item master objectCommercient Global Shop external key7
Global Shop Sales orderCommercient Global Shop sales order header objectCommercient Global Shop external key8
Global Shop Item listCommercient Global Shop item list objectCommercient Global Shop external key8
Global Shop Sales order lineCommercient Global Shop sales order line objectCommercient Global Shop external key9
Global Shop InvoiceCommercient Global Shop invoice header objectCommercient Global Shop external key10
Global Shop invoice lineCommercient Global Shop invoice line objectCommercient Global Shop external key11

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 onlyAR terms
salesperson feedinsert onlysalespeople
account feedinsert onlycustomer master records, multiple shipping addresses
customer feedinsert + updatecustomer master records
contact feedinsert onlycontacts
shipping address feedinsert + updatemultiple shipping addresses
product feedinsert + updateinventory master items
item feedinsert + updateinventory master items
sales order feedinsert + updateorder headers
item list feedinsert + updateitem master records
sales order line feedinsert + updateorder lines
invoice feedinsert + updateorder history headers
invoice line feedinsert + updateorder history lines

4. Order of work

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

  • 0 — Users
  • 1 — Global Shop Term
  • 2 — Global Shop Salesperson
  • 3 — Account
  • 4 — Global Shop Customer, Contacts
  • 5 — Global Shop Ship to
  • 6 — Products
  • 7 — Global Shop Item
  • 8 — Global Shop Sales order, Global Shop Item list
  • 9 — Global Shop Sales order line
  • 10 — Global Shop Invoice
  • 11 — Global Shop invoice line

Several of these rows share a run sequence value: each template group carries its own numbering, so give the imported processes an order across the whole set rather than taking the template values as one.

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 account sync output; no template in this set writes account sync output
  • customer feed reads account sync output, customer sync output; no template in this set writes account sync output, customer sync output
  • contact feed reads account sync output, contact sync output; no template in this set writes account sync output, contact sync output
  • shipping address feed reads account sync output, customer sync output, shipping address sync output; no template in this set writes account sync output, customer sync output, shipping address sync output
  • product feed reads item sync output, product sync output; no template in this set writes item sync output, product sync output
  • item feed reads product sync output, item sync output; no template in this set writes product sync output, item 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
  • item list feed reads product sync output, item sync output, item list sync output; no template in this set writes product sync output, item sync output, item list sync output
  • sales order line feed reads sales order sync output, product sync output, item sync output, sales order line sync output; no template in this set writes sales order sync output, product sync output, item sync output, sales order line sync output
  • invoice feed reads account sync output, customer sync output, invoice sync output; no template in this set writes account sync output, customer sync output, invoice sync output
  • invoice line feed reads invoice sync output, product sync output, item sync output, invoice line sync output; no template in this set writes invoice sync output, product sync output, item sync output, invoice line sync output

5. Field mapping

Each template carries its intended mapping in field mapping.

TemplateObjectMapped fieldsFirst ERP → Zoho CRM pairs
Global Shop TermCommercient Global Shop terms object14Commercient terms code, → Commercient external key column, Commercient terms code, → Name, Commercient terms code → Commercient terms code, Terms discount days → Terms discount days, Terms discount percent → Terms discount percent
Global Shop SalespersonCommercient Global Shop salesperson object9Key 1,Key 2,Salesperson code,Filler → Commercient external key column, Buyer shipping → Buyer shipping, Filler → Filler, Filler 3 → Filler 3, Salesperson → Name
AccountAccounts13Customer → Commercient external key column, Name of customer → Account name, Telephone number → Phone, Address 1, Address 2 → Billing street (Zoho field), City → Billing city (Zoho field)
Global Shop CustomerCommercient Global Shop customer object30Customer → Commercient external key column, Name of customer → Name, Address 1 → Address 1, Address 2 → Address 2, Assigned user group → Commercient assign user group
ContactsContacts11Customer code,Contact type,record identifier → Commercient external key column, Customer code → Account name, Job title → Title, Contact last name,Name,Customer code,Contact type,record identifier → Last name, Contact first name → First name
Global Shop Ship toCommercient Global Shop shipping address object74Customer,Shipping address sequence → Commercient external key column, Customer name,Shipping address sequence → Name, →, Customer → Customer, Customer name → Customer name
ProductsProducts10Part, location → Commercient external key (custom field), Part → Product name (Zoho field), Part → ERP product code, the linked Salesforce record → Global Shop inventory (related record), Quantity on hand → Quantity in stock (Zoho field)
Global Shop ItemCommercient Global Shop item master object78Part, location → Commercient external key column, Part → Name, ABC classification code → Commercient ABC classification code, Alternate cost amount → Commercient alternate cost amount, Back order counter → Commercient back order counter
Global Shop Sales orderCommercient Global Shop sales order header object97Order number → Commercient external key column, Order number → Name, Customer → Account, Always discount flag → Commercient always use discount indicator, Area → Area
Global Shop Item listCommercient Global Shop item list object50Allocation type → Allocation type, Allocated → Allocated, Bin → Bin, Certification code → Commercient cart code, Certification date → Commercient certification date
Global Shop Sales order lineCommercient Global Shop sales order line object100Order number,Record number → Commercient external key column, Order number,Record number → Name, Order number → Commercient Global Shop sales order header (related record), Part,location → Product, Part,location → Commercient Global Shop item master (related record)
Global Shop InvoiceCommercient Global Shop invoice header object99invoice record sync output (generic name), Order number, Order suffix → Commercient external key column, invoice record sync output (generic name), Order number, Order suffix → Name, Customer → Account, Customer → Commercient Global Shop customer (related record), Address 1 → Commercient invoice address line 1
Global Shop invoice lineCommercient Global Shop invoice line object70invoice record sync output (generic name), Order number, Order suffix, Order line number → Commercient external key column, invoice record sync output (generic name) → the linked GlobalShop invoice header, Part, location → Product, Part, location → Commercient Global Shop item master (related record), Shipping country → Commercient shipping country

6. 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/globalshop.

7. 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 GlobalShop → 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/globalshop, 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.