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
View original
+12
Hi
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
+3
HI
+1
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.
+3
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
+1
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
HI
This is it! Thank you!
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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
