Skip to main content

Hi all,

Sorry if this question has been asked before, but I couldn’t find any related topics so if it does exist, please can someone point me to that :)

 

I have a question related to the implementation best practice for customers who have existing stores. From what I can see, both BigCommerce and Shopify only support “Export” operation from ERP > Store. Let’s say in their stores, they already have a number of products. These products are exported to excel, provided to the implementer to import into Acumatica using an import scenario. Then, we set up a sync to export these products again to the stores:

  • Wouldn’t this duplicate their product list?
  • In relation to the above question, if it doesn’t, how does the system know a product in ERP is the same product in the store?
  • Similarly, for customers, how to link an existing customer record in the ERP with an existing customer record in the store? this can be important to some businesses if they want to reserve the past/historical orders information that’s linked to an existing customer. I can see that there’s an “External ID” that we can edit. but where to find them in Shopify/BigCommerce?
  • I can see we can edit the external ID one by one through the Sync History screen. How do we do this in bulk?

 

@leonchau80 

  • Wouldn’t this duplicate their product list?
    • lSM] nope, connector will merge items by SKU.
  • In relation to the above question, if it doesn’t, how does the system know a product in ERP is the same product in the store?
    • >SM] Make sure that SKU matches Acumatica InventoryID
  • Similarly, for customers, how to link an existing customer record in the ERP with an existing customer record in the store? this can be important to some businesses if they want to reserve the past/historical orders information that’s linked to an existing customer. I can see that there’s an “External ID” that we can edit. but where to find them in Shopify/BigCommerce?
    • eSM] Connector will attempt to merge customers by email as well. So if you have already a customer with the same email, it will be merged
  • I can see we can edit the external ID one by one through the Sync History screen. How do we do this in bulk?
    • bSM] We have plans to allow buck edit in the future, but so far there is no way to do so.

Hi @Andy Smith , @leonchau80 

Maybe this will give you some kind of answer to your questions. There is an mechanism in the commerce Framwork that prevents duplicates...

 

https://help.acumatica.com/(W(70))/Help?ScreenId=ShowWiki&pageid=5ecd0d16-a869-4ccb-bf09-7ffb05f25a4e

 


I have a different twist on the same question.  What if the customer wants to build out a new BigCommerce store, syncing it with a sandbox Acumatica tenant.  This is both to get ahead on the storefront design while the ‘live’ Acumatica tenant is being designed, and to test syncing of sales orders etc.

The end result is similar to @leonchau80 ‘s situation and question.  When we transition to the “live” Acumatica tenant, will it duplicate the product list, etc.

What is the best practice here?

 


Thank you @PatrickSchlenker90  and @smarenich , I will have a look into this.


@smarenich 

Just email huh?
Does it support email domain matching?

B2B example… 10 different people with emails at @goodcoffee.com are placing orders online.

If one customer record existing with joe@goodcoffee.com, and then sue@goodcoffee.com places an order would that create a new customer?

 

-Chad
 

 


Reply