Skip to main content
Solved

Key to Sync Acumatica Stock Item to Shopify


I can sync stock items to Shopify; however, it always creates a new item instead of updating an item that already exists. I have tried using the SKU and/or description/title but I cannot update a product origionally created in Shopify. The integration will only update products created from the sync. Any ideas?

Best answer by estebanperalta54

HI @matt hoss you should also be able to tie it to an existing item in shopify by navigating to the sync history screen and edit sync. Note you can find the external ID on the URL when you are viewing the item setup on shopify:

 

View original
Did this topic help you find an answer to your question?

7 replies

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+12

Hi @matt hoss 

In Acumatica we have an option to sync the Item information from the Acumatica.

Please create a stock Item in Acm Instead of shopify which gives the erp transaction ID ( link between the systems), Now if the user updates the item it will populates the data from Acm->Shopify

  • Export: Data is exported from Acumatica ERP to the external e-commerce system.

estebanperalta54
Captain II
Forum|alt.badge.img+4

HI @matt hoss you should also be able to tie it to an existing item in shopify by navigating to the sync history screen and edit sync. Note you can find the external ID on the URL when you are viewing the item setup on shopify:

 


brendan91
Semi-Pro III
Forum|alt.badge.img+1
  • Semi-Pro III
  • 92 replies
  • April 10, 2023

Are you exporting data from non-matrix items in Acumatica to a Shopify listing with variants? I think I had this issue before and that was the cause. If so, you will need to convert your stock items in Acumatica to matrix items to have a functioning data export.


smarenich
Acumatica Moderator
Forum|alt.badge.img+3
  • Acumatica Commerce Edition Team Lead
  • 227 replies
  • April 10, 2023

@matt hoss Acumatica Shopify connector performs automatic duplicates merge by matching Shopify SKU to Inventory ID fields. This means, that on the first sync, connector will check if there is an item in Shopify with the same SKU as InventoryID in Acumatica, and if the item is found, then it will link the items instead of creating a new one.

Please note, that this duplicates merge is performed only on the first sync on an item. If link is stablished already, then this deduplication won’t happen anymore. Also, it does not work with product variants, matching is designed to work with products only.

Please refer to the documentation - https://help.acumatica.com/(W(17))/Help?ScreenId=ShowWiki&pageid=5ecd0d16-a869-4ccb-bf09-7ffb05f25a4e


brendan91
Semi-Pro III
Forum|alt.badge.img+1
  • Semi-Pro III
  • 92 replies
  • April 10, 2023
smarenich wrote:

Also, it does not work with product variants, matching is designed to work with products only.

We have a lot of items with variants in Shopify that are normal stock items in Acumatica (not matrix) and we have found that order import and order export works fine if the SKU in Shopify matches the inventory ID in Acumatica. 

So if all you need is order communication, you don’t have to convert your stock items in Acumatica to matrix items. In this scenario, you can still manually control inventory levels for each variant in Shopify.

If you need inventory and listing data sync between your stock items in Acumatica and variants in Shopify, you will need to convert your items to matrix items in Acumatica


  • Author
  • Freshman II
  • 5 replies
  • April 18, 2023
estebanperalta54 wrote:

HI @matt hoss you should also be able to tie it to an existing item in shopify by navigating to the sync history screen and edit sync. Note you can find the external ID on the URL when you are viewing the item setup on shopify:

 

 

This is it! Thank you!


Forum|alt.badge.img
  • Freshman I
  • 20 replies
  • July 17, 2023

We are upgrading to 23.1 and I am having the same issue in our test scenario. And even worse all the replies to the OP suggest manually editing the product ID in sync history but the edit option has been taken away from us.  We can no longer manually switch a current item in the ERP to a new item in Shopify or back to an old item already on Shopify if Acumatica has created a new item for that.

This is happening in Product Availability entity.


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