Skip to main content
Solved

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

  • Jun 1, 2023 9:27 PM UTC
  • 44 replies
  • 978 views
  • Translate All

Show first post

44 replies

michaelho
Semi-Pro III
Forum|alt.badge.img+1
  • Author
  • Semi-Pro III
  • Dec 20, 2023 4:47 PM UTC

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
  • Dec 20, 2023 5:22 PM UTC

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

Translate

simonliang91
Acumatica Employee
Forum|alt.badge.img+1
  • Acumatica Employee
  • Dec 20, 2023 8:39 PM UTC

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

Translate

michaelho
Semi-Pro III
Forum|alt.badge.img+1
  • Author
  • Semi-Pro III
  • Dec 20, 2023 9:54 PM UTC

@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
  • Jan 18, 2024 7:23 PM UTC

@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
  • Jan 18, 2024 7:44 PM UTC

@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
  • Jan 18, 2024 8:00 PM UTC

@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
  • Acumatica Employee
  • Jan 18, 2024 8:31 PM UTC

@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
  • Jan 31, 2024 9:51 PM UTC

@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

michaelho
Semi-Pro III
Forum|alt.badge.img+1
  • Author
  • Semi-Pro III
  • Feb 26, 2024 5:44 PM UTC

@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
  • Feb 27, 2024 8:21 AM UTC

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

Translate

michaelho
Semi-Pro III
Forum|alt.badge.img+1
  • Author
  • Semi-Pro III
  • Feb 27, 2024 3:47 PM UTC

@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
  • Feb 27, 2024 9:16 PM UTC

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

Translate

michaelho
Semi-Pro III
Forum|alt.badge.img+1
  • Author
  • Semi-Pro III
  • Feb 27, 2024 10:10 PM UTC

Great! Thanks, @simonliang91 

Translate

michaelho
Semi-Pro III
Forum|alt.badge.img+1
  • Author
  • Semi-Pro III
  • Mar 23, 2024 3:11 AM UTC

Confirming this is working in 23.210.0017!

Translate

simonliang91
Acumatica Employee
Forum|alt.badge.img+1
  • Acumatica Employee
  • Mar 23, 2024 3:15 AM UTC

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

Translate

michaelho
Semi-Pro III
Forum|alt.badge.img+1
  • Author
  • Semi-Pro III
  • Mar 23, 2024 3:17 AM UTC

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

Translate