Skip to main content
Solved

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

  • June 1, 2023
  • 44 replies
  • 972 views
  • Translate All

Show first post

44 replies

Forum|alt.badge.img+1
  • Author
  • Semi-Pro III
  • December 20, 2023

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.

 

Translate

Forum|alt.badge.img
  • Acumatica Employee
  • December 20, 2023

@mikeho thank you for the information, we will check and keep you posted

Translate

simonliang91
Acumatica Employee
Forum|alt.badge.img+1
  • Acumatica Employee
  • December 20, 2023

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

Translate

Forum|alt.badge.img+1
  • Author
  • Semi-Pro III
  • December 20, 2023

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

Translate

K2a
Jr Varsity III
Forum|alt.badge.img
  • Jr Varsity III
  • January 18, 2024

@KarthikGajendran @mikeho @StevenRatner 

I just tested pushing a product attribute into Shopify Metafield,  in 23R1 Build 14, it says this was fixed in Build 12 release notes...but still not working for me. 

Translate

Forum|alt.badge.img
  • Acumatica Employee
  • January 18, 2024

@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.

Translate

K2a
Jr Varsity III
Forum|alt.badge.img
  • Jr Varsity III
  • January 18, 2024

@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.

Ah..thanks for the clarification!  

Translate

simonliang91
Acumatica Employee
Forum|alt.badge.img+1

@K2a and @BorisRudi56 , We found there is an issue for getting the value from Template Items -> Matrix -> Attributes in 2023R2, if you want to get a value from matrix item attribute, it may not have the correct value. We are working on it now.

If the field is not an attribute, it should work fine. 

Translate

nathantrauscht
Semi-Pro II
Forum|alt.badge.img

We are on 23R2 Build 23.207.0025 and the options are there for mapping - but they do not work. After mapping, we get no errors, but it does not update the variant metafields.

 

 

Are we doing something wrong? Or is this an issue with Shopify still?

Translate

Forum|alt.badge.img
  • Acumatica Employee
  • January 31, 2024

@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.

Translate

nathantrauscht
Semi-Pro II
Forum|alt.badge.img

@BorisRudi56 thank you for the update - looking forward to the fix!

Translate

Forum|alt.badge.img+1
  • Author
  • Semi-Pro III
  • February 26, 2024

@BorisRudi56 - I see that build 23.208.0026 is now available. Can you confirm that this issue was fixed in this build? I didn’t see any mention of it in the release notes. And if it has not yet been fixed, can you advise when it will be fixed?

Translate

simonliang91
Acumatica Employee
Forum|alt.badge.img+1
  • Acumatica Employee
  • February 27, 2024

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

Translate

Forum|alt.badge.img+1
  • Author
  • Semi-Pro III
  • February 27, 2024

@simonliang91 - we’ve been preparing to upgrade from 23R1 to 23R208 for this specific fix. Do you have any general idea when 23R209 will be released?

Translate

simonliang91
Acumatica Employee
Forum|alt.badge.img+1
  • Acumatica Employee
  • February 27, 2024

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

Translate

Forum|alt.badge.img+1
  • Author
  • Semi-Pro III
  • February 27, 2024

Great! Thanks, @simonliang91 

Translate

Forum|alt.badge.img+1
  • Author
  • Semi-Pro III
  • March 23, 2024

Confirming this is working in 23.210.0017!

Translate

simonliang91
Acumatica Employee
Forum|alt.badge.img+1

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

Translate

Forum|alt.badge.img+1
  • Author
  • Semi-Pro III
  • March 23, 2024

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

Translate