Skip to main content
Question

Can Company ID in Shopify be the same as Customer ID in Acumatica?

  • May 20, 2026
  • 2 replies
  • 21 views
P
Freshman I

I’m currently testing exporting Customers from Acumatica to Shopify (as Companies for B2B) and had a couple of questions:

  1. Is there a way to have the Company ID in Shopify match the Customer ID from Acumatica? Ideally, I’d like to keep them aligned for easier tracking and reconciliation.
  2. I enabled “Import Company Contacts as Customers” along with bidirectional sync. This successfully creates customers in Acumatica when they’re assigned to company locations in Shopify.

However, I’m running into an issue with phone numbers:

  • Shopify always includes the country code (e.g., +1)
  • Acumatica’s phone input mask doesn’t accept this format
  • This results in an error during import: “Object reference not set to an instance of an object”

Has anyone dealt with this before?

    2 replies

    T
    Acumatica Employee
    Forum|alt.badge.img+1

    Hi ​@petar2903k:

    Do you have a phone mask  for the company that you are using? If yes, does the phone number format match that?
     

    Can you try to remove the mask and see if the issue still exists? 

      Yuri Karpenko
      Captain II
      Forum|alt.badge.img+7

      ​@petar2903k ,

      1. No, you cannot change that mapping. Company ID is populated by the integration, and consists of 2 parts: first part is an integer (and I can’t figure out what it is) and the second part is the Ref Note ID from Acumatica. So, apparently, Acumatica populates that field, but with some technical data. I suppose you need to keep that data in place for future syncs.
      2. Agree with ​@tusharpandita74  on his note. However, I doubt the issue is tied to the phone number. If you say that you create those customers in Shopify by exporting from Acumatica Contacts, it implies that you already have those contacts in Acumatica with phone numbers. If so, the phone numbers are presumably correct (conforming to Acumatica mask). It’s a speculation at this time, but I think the error you’re getting on the import is something else, not the phone number format.

      Let us know if we can help further.

      Yuri Karpenko | DM me if you need help building e-Commerce for your business or connecting it to Acumatica ERP
      Terms & ConditionsAccessibility statement
      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