Solved

Can the ecommerce connector sync a stock item attribute to product variant metafield in Shopify?

M
Rank
Userlevel 5
Badge +1

Just need to clarify - does the ecommerce connector support syncing a stock item attribute to a product variant metafield in Shopify? Or does it only support syncing to a product metafield? 

icon

Best answer by KarthikGajendran 6 September 2023, 17:57

View original

44 replies

KarthikGajendran
Rank
Userlevel 7
Badge +2

@mikeho You can sync metafields to variants as well. 

 

Technical Product Manager- Retail Commerce
K2a
Rank
Userlevel 4
Badge +1

@mikeho  @K2a 

Sorry for the delay. We had this in 21R2 and 22R2 and then we removed it because of some bugs in the Shopify API for metafields. We were waiting for Shopify to fix it. 

Now we are pushing Shopify to fix it and they promised that they will. 

We are now planning to fix it in 23R2 but if you also need it in 23R1, then please let me know. 

 

Thanks Karthik, it’s not a burning need for us we can manage, based on ACU support’s previous comments to us, we’ve mentally staged it until next summer. 

KarthikGajendran
Rank
Userlevel 7
Badge +2

@StevenRatner  @mikeho Yes, it would be released in 23R113 version. Here is a screenshot.

 

 

Technical Product Manager- Retail Commerce
simonliang91
Rank
Userlevel 5
Badge +1

@mikeho, according to the plan, the 2023R209 will be released on March 1st. 

KarthikGajendran
Rank
Userlevel 7
Badge +2

@StevenRatner  @mikeho I have asked the team to check this again. Seems like the existing erp fields are exporting fine as metafields but  not the attributes.  We suspect something has changed in the Shopify APIs. We are looking into right now. We will get back to you with more info. Please give us some time. 

CC @BorisRudi56 

Technical Product Manager- Retail Commerce
M
Rank
Userlevel 5
Badge +1

@simonliang91 - I updated my comment right after I posted it; just had to tweak the mapping and then it worked. Thanks!

M
Rank
Userlevel 5
Badge +1

@StevenRatner - I have been told that this issue has been scheduled to be fixed in 2023R113, which is currently planned to be released the last week of November.

KarthikGajendran
Rank
Userlevel 7
Badge +2

@mikeho  @K2a 

Sorry for the delay. We had this in 21R2 and 22R2 and then we removed it because of some bugs in the Shopify API for metafields. We were waiting for Shopify to fix it. 

Now we are pushing Shopify to fix it and they promised that they will. 

We are now planning to fix it in 23R2 but if you also need it in 23R1, then please let me know. 

 

Technical Product Manager- Retail Commerce
M
Rank
Userlevel 5
Badge +1

Hi @BorisRudi56 - I tested syncing a Template attribute to Product -> Product Variants -> Metafields in Shopify and it worked; the value from the Template attribute synced to the same variant metafield for the multiple matrix items underneath that Template.

However, that is not what we’re looking for - what we really need is to be able to map Matrix item attributes to Product Variant metafields. (This would be a one-to-one sync of data.)

It appears this is available in 23R2, based on the below from the release notes (page 219) - the hope was this would be brought to 23R1 in a minor update, but this has not been the case.

 

M
Rank
Userlevel 5
Badge +1

Hi @KarthikGajendran - I’m looking in our 23R1 upgrade sandbox and I don’t see that option:

Am I missing something?

B
Rank
Userlevel 3

@K2a , with 23R1 Build 14 it became possible to export fields from Template items or standard fields of Matrix items to variants metafields. 

Later with  2023R2 the ERP object Template Items -> Matrix -> Attributes was added to allow export of attributes from matrix items.

simonliang91
Rank
Userlevel 5
Badge +1

@mikeho, we changed the approach to get the Matrix item in 2023R2, so we can support the variant level mapping. 

M
Rank
Userlevel 5
Badge +1

@simonliang91 thanks for the additional details. Sounds like the only way to get the mapping we need is to upgrade to 23R2.

KarthikGajendran
Rank
Userlevel 7
Badge +2

@mikeho @lawsont  May you are in an old version. 

Please refer to this article. https://help-2021r2.acumatica.com/Help?ScreenId=ShowWiki&pageid=77f74ccd-beff-4e2b-81e2-6a70f2a3c6f2 

 

Technical Product Manager- Retail Commerce
simonliang91
Rank
Userlevel 5
Badge +1

@mikeho , the issue has been fixed, it will be released in 2023R209. 

K2a
Rank
Userlevel 4
Badge +1

Hi @KarthikGajendran - I’m looking in our 23R1 upgrade sandbox and I don’t see that option:

Am I missing something?

Confirmed, I also DO NOT see the variant>Metafield in 23R1

 

B
Rank
Userlevel 3

@nathantrauscht , the Build 23.207.0025 still has the issue with getting values from the ERP object Template Items -> Matrix -> Attributes, that was mentioned by @simonliang91 previously. We plan to fix it in 23.208.

StevenRatner
Rank
Userlevel 5
Badge

@KarthikGajendran - Thanks for the update.  Please keep me updated on when this is planned to be fixed.  The sooner the better 😉

Steve - Klear Systems
K2a
Rank
Userlevel 4
Badge +1

I was told by ACumatica that you cannot export Metafields to Shopify. 

Here is the quote: 

Unfortunately in this version (22R1) we support only export from Template Item attributes, but not Matrix Item Attributes.  We implemented export of Matrix Items Attributes in 23r2  

 

M
Rank
Userlevel 5
Badge +1

Thank you, @KarthikGajendran. I have tested and can get the Template Items -> Attributes to sync to the Product -> Product Variants -> Metafields, but this is a one to many sync of data. We have different attribute values in each matrix item and need those to sync to the corresponding Product Variants -> Metafields in Shopify.

M
Rank
Userlevel 5
Badge +1

Confirming this is working in 23.210.0017!

simonliang91
Rank
Userlevel 5
Badge +1

@mikeho , could you share your mapping? We have fixed it in 2023r209.

M
Rank
Userlevel 5
Badge +1

@Chris Hackett I have not heard anything official yet from Acumatica. I do have a case open.

 

@K2a if true, that’s disappointing. It’s been demonstrated in the documentation for a few versions now.

B
Rank
Userlevel 3

@mikeho , could you please share an example of mapping that you used for the one-to-many sync of data ? We will check if there is any workaround possible for different attribute values. 

M
Rank
Userlevel 5
Badge +1

Hi @KarthikGajendran - Yes, we just completed our upgrade to 23R1 and would be using this feature heavily if it were available. If there is any way to also fix this for 23R1 it would be greatly appreciated.

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved