Skip to main content
Solved

Best practice to implement Acumatica with existing Shopify/BigCommerce stores?


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?

 

Best answer by smarenich

@leonchau80 

  • Wouldn’t this duplicate their product list?
    • [SM] 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?
    • [SM] 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?
    • [SM] We have plans to allow buck edit in the future, but so far there is no way to do so.
View original
Did this topic help you find an answer to your question?

5 replies

Forum|alt.badge.img
  • Varsity I
  • 39 replies
  • June 23, 2022

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?

 


PatrickSchlenker90
Jr Varsity II
Forum|alt.badge.img+1

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

 


smarenich
Acumatica Moderator
Forum|alt.badge.img+3
  • Acumatica Commerce Edition Team Lead
  • 227 replies
  • Answer
  • June 23, 2022

@leonchau80 

  • Wouldn’t this duplicate their product list?
    • [SM] 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?
    • [SM] 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?
    • [SM] We have plans to allow buck edit in the future, but so far there is no way to do so.

  • Author
  • Freshman I
  • 5 replies
  • June 23, 2022

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


Forum|alt.badge.img
  • Jr Varsity II
  • 58 replies
  • August 23, 2024

@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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings