Configure Acumatica-Shopify Connector to Save Customers with name as ShopifyID

  • 11 January 2021
  • 3 replies

Userlevel 7
Badge +3
  • Acumatica Commerce Edition Team Lead
  • 227 replies

Hi All, 

By default, Acumatica commerce edition require Auto-Numbering for Customers and Customer Locations. This is done due to a number of reasons:

  • During the export customers from Acumatica, we don’t have a Shopify ID, so if customer is created in Acumatica it will have a different name.
  • Acumatica can be connected to multiple stores and there is no guarantee that customer ID is unique accords multiple stores and connectors.
  • Naming convention in Acumatica may be different from Shopify customer.

In any case, Acumatica Commerce Edition will follow Auto-Numbering of customer and locations.

However this can be changed with the simple customization.  Please do the following:


Step 1: Extend the Segmented Key for BIZACCT and CUSTOMER to 13 or 14 characters. Customers ID in Shopify are very long.


Step 2: Publish the attached customization . The customization package does 2 things: 

  • Disabling mandatory auto-numbering on customer record
  • Assigning Acuamtica CustomerID to the Shopify ID.


Step 3: Test the synchronization.


Note: Customization is tested and compatible with Acumatica 2020r2.


3 replies

Userlevel 5
Badge +1

In a normal process, if new customer comes from Shopify and there is not sync status record, system will try to search Customer in Acumatica by Email or Phone(if Email not provided).

After customer applied this project to Acumatica, system should search Customer by Shopify ID, if Shopify ID is empty, system will search by Email or Phone instead.   

Based on this customization project, I added this changes and attached the customization project for your reference.



Userlevel 3

Would this work for Big Commerce too with 2021R!?

Userlevel 7
Badge +3

Hi @dennisgodsill36  we haven’t really tested it on 2021r1, but I expect it to work. Please let us know if it does not.


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved