Connecting One Shopify Store to Multiple Acumatica Tenants

​@ericmack94 , it should work no problem. What is the issue that you client experience?

​@Yuri Karpenko  Hi Yuri, they have one dev environment tenant connected to their dev Shopify site as they are currently testing, and we are at the point where we are trying to now connect the second tenant to the store for another country. The issue we are seeing is actually at the point of connecting the second tenant in Shopify with the Acumatica app. Not sure if the second connection can be in the same Acumatica app on the Shopify side or if it needs to be in an additional custom app? We are using the exact same URL, just with a different tenant login name and getting an error indicating an invalid ERP URL and tenant login name.

Can you confirm if you are using the value from the Login Name field on the Tenants screen. This is what Acumatica expects by default.

Alternatively, instead of using the Shopify App to connect from Shopify to Acumatica, you can create two different Private Apps in Shopify and use them in the different tenants on Acumatica. 

Please note that by default, Shopify does not have SKU validation. The connector goes by product names primarily. So, if you can use different SKUs with different names, that will be best so that it does not conflict or overwrite the External IDs.

Hi ​@ragedupudi, yes I was using the Login Name value from the tenants screen. From what I have been able to gather, it doesn’t seem possible to connect one Shopify instance to multiple Acumatica tenants with the actual Acumatica app in Shopify.

What I did was create a separate, custom app, and connect that to the second tenant, which did work.

The SKU issue you mention is also something we are dealing with. My client has the same item in different markets, with the same product name, but potentially different SKUS, and Shopify does not seem to allow you to have multiple variants under a parent item that have the same name even if the SKUs are different.

Has anyone dealt with this or handled it a particular way?

​@ericmack94 You are correct that you cannot use the Acumatica app for this, and you are on the right track with the separate custom app.

On the products, unless the product is created as a Template item in Acumatica, the Variant logic will not kick in.  The default variant that you see in Shopify is just a reference SKU.  

The best option I see for your client would be the following: For the other products, you can ask them to setup the product with a different SKU but the same Product name in Shopify directly first.  When the product sync runs it will look by the name but also respects the SKU.

The issue originates mainly when product is going out of Acumatica, but in this scenario since the same product name but different SKU is present already, it should create the reference links properly.

If you need more technical assistance specific to this customer, please feel free to DM me.