I was able to sync Acumstica items to existing Shopify items by changing the Acumatica template id to the Shopify product ID and making sure all the variants had the same SKUs. You also need to match the variant values.
Instead of changing the Acumatica product ID as we did for the 2 items we tested, we plan to put them in the legacy ID attribute and remap for the first sync. Once we have the link built, we should be good to remove the remap and allow new products to be created in the usual way.
We’ve run into the exact same issue. Matrix items were created in Shopify and they are migrating from Sage 100. Unfortunately this has become an internal political hot potato between the clients internal teams so all we want to is sync at the stock item level WITHOUT creating new items.
In our case the stock Item IDs of the variants DO match so we hoped to merge the Acumatica stock items with the variants of the Shopify Template items. The good news is that the items did merge, but the Shopify matrix item was entirely replaced by the lone Acumatica stock item.
Is it correct to assume that he ONLY approach is to recreate the matrix items in Acumatica? If so, that brings in another issue of having to match attributes in Shopify for a merge to work.
Any advice?
@dgodsill97 if I understand you right, the problem is that you don’t want to rename one of the variant (default variant) in Shopify. But this is not mandatory, as you can name Template Item differently. In your example (SKU 100 is Granules and 100B is tablets) you can name template item 100Template.
If that does not work, they you can migrate items as a stock items in Acumatica, then run export and export all of them to Shopify. This will create new products for each stock item.
Old product with variants you can simple remove.
they have decided to delete and reload. thanks for your insights.
@dgodsill97 if they don’t use matrix items, how do they manage variants in Acumatica now? Are these variants stored as stock items?
They have a legacy ERP (Sage 100) connected to their store. Each variant, as in Acumatica, is a separate inventory item. We are upgrading them to Acumatica but they don’t want to have to convert their existing SKU’s to Matrix because it would require changing the ID of the inventory item in Acumatica and the SKU in shopify because the default variant does not have suffix. For example, SKU 100 is Granules and 100B is tablets. They are using a space as the variant so they would have to rename 100 to 100G. It’s complicated