Skip to main content

Hello everyone,

In the documentation, there is mentioned External ID for Customer Locations, and I assume it will also be populated when we synced a Customer location originally from Acumatica, in a bidrectional sync.
 


But I can’t see such External Id on the Customer Location screen. We want to find a common ID between Shopify and Acumatica for Customer location, and this location is for Customer Organization (B2B) synced as Shopify Company.

Do you have idea how to achieve that, if the External ID in location screen is not yet available?

We are in 24R1.​​​​​​​

I’ve noticed two things about the connector related to this:

  1. The customer location syncs for locations under a B2B customer (organization) or company do not have a corresponding BC sync history line. In contrast, customer locations for individual customers do have a history line, complete with external IDs for both the customer and location.
  2. Both Acumatica and Shopify allow duplicates for location names. For example, if I have a location named "MAIN" that was synced to Shopify previously, and I create a new location with the same name (with a unique ID, of course), the connector replaces the address information of the first "MAIN" synced in Shopify with the details of the new "MAIN." It doesn't create a new location with the same name.

Based on these observations, I’m guessing that locations for B2B customers (companies) don’t have external IDs. Instead, it seems the connector identifies the location to be updated based on the name. I hope I’m wrong about this, but could someone please confirm?

Thank you!


@jib87 , hi!  Let me first address the two comments you made above.

  1. How to find BC Sync record for company locations. Head to the Sync History screen, select Company as the entity (not Customer Location), then select any line that you’re interested in, then click the three dots on top of the form (next to the SYNC button, Excel export, funnel, etc.), and then select the View Details action. It will open a pop-up window with the company + company contacts + company locations + role assignments entities, and you will see corresponding Shopify IDs there).
  2. As far as duplicates for locations, you cannot create 2 locations in Acumatica with the same Location ID (MAIN, for example). You can have location MAIN and SECONDARY both with the Location Name of “Primary Location”, but not with the same Location ID. On the Shopify side though, Location Name is a key field, so if you create 2 locations in Acumatica, both titled “Primary Location”, you will get an error on the export.

Back to your original post - do you have a link to that documentation? I’ve never seen it before, and I didn’t see that field (External ID) on the Customer Locations screen (either through UI or DAC). It seems to be a new feature. Maybe, you’re looking at the 24R2 docs? If you’re inspecting help.acumatica.com, it will naturally have the documentation for the latest available version, which is 24R2, and which (after my subsequent investigation) does have this new field included (in the UI).


Hello ​@Yuri Karpenko 

  1. Awesome! Thank you for sharing that; it’s very helpful.
  2. Yes, I was referring to the Location Name, not the ID. Thank you for clarifying that.

Also, I believe you’re right. I am looking at help.acumatica.com, which describes what’s in 24R2. My mistake, but I’m glad to hear that it’s already available!


Reply