Synchronise customers


When you import an order from a webshopy, getting the information about the customer is essential for further processing the document in Business Central. There are two main options for doing so, and several combinations:

  • Use a generic Customer No. for all orders.
  • Import the actual customer information from the webshop. 

Important settings when importing customers from the webshop

Whether you import customers from the webshop in bulk when linking an existing webshop or when you import orders, use the following settings to manage the process, you can find them E-Commerce Setup | Customers


In the auto numbering fields you can choose the appropriate no. serie when creating customer cards in BC.

The fields in Apply Customer template are relevant for BC versions lower than 21. New versions are using the settings in the tab 'Customer Templates'.


Field  Description
Priority E-mail Check

Define in which table the match should be done:

  • Customer: table 18
  • Contact: table 5050
  • Both: Search in Customer & Contact
  • Member: This is a LS Retail table, only applicable if you have installed and use the LS Retail app.
  • Member + Customer
Check E-mail New Customers Define if you want to match new imported web customers with existing customers in BC
Match New Customer

Define how you want to perform the match:

  • E-mail: if you want to match the imported web customers to an existing customer in Business Central using e-mail
  • E-mail and global Dimension: if you want to match the imported web customers to an existing customer in Business Central using e-mail & global dimension
  • Custom Field: if you want to match on any field in table 18 Customer
Field No. Customer (18)

If the match is done on Custom Field, choose on which field in table 18 Customer you want to match.

Field No. TINX Customer Define in which field in the TINX Customer table the value is stored for the match on Custom Field

No. of Address Checks


Define how many times a new web customer without any addresses should be imported from the web, to check if new addresses are entered.


Assign Customer Templates

Some settings can be defined at the country/regional level or a state/province level. The settings can be configured in the Extended Customer Template Setup.


Export customers to the webshop

You can export existing customers to the webshop in bulk. In each case, a customer and one default billing address are created. Some webshops are accepting also multiple shipping addresses. You can manage the process using the following settings:

The following are requirements for exporting a customer:

  • The customer must have a valid email address, first name / last name and a phone number.
  • A country/region is selected on the customer card, for local customers, with blank country/region the country/region specified in the Company Information page must have an ISO Code defined.

The requirements below are only applicable for Shopify.

  • If the customer has a phone number, the number must be unique because Shopify won't accept a second customer with the same phone number.
  • If the customer has a phone number, it must be in the E.164 format. Different formats are supported if they represent a number that can be dialed from anywhere in the world. The following formats are valid:
    • xxxxxxxxxx
    • +xxxxxxxxxxx
    • (xxx)xxx-xxxx
    • +x xxx-xxx-xxxx
    • After you've created the customers in Shopify, you can send them direct invitations to encourage them to activate their accounts.

Sync customers

To actually send the customer over check the field 'Publish to Webshop' on the Customer Card.

You can schedule the task to be performed in an automated manner. Learn more at Schedule recurring tasks.

Guest Customers

If it is allowed to order as a guest customer in the webshop (without registering an account), you can define a Customer No. for these guest orders. You can define the Webshop Guest Customer No. in the E-commerce Integration Setup. All web orders with Customer ID = zero or empty will be assigned to this Guest Customer No.

Blocked customer

If the customer is blocked in the Customers table, the customer will be automatically blocked in the Webshop Orders table, and then the Webshop order will be blocked from being created until the customer is unblocked in BC.