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

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!

simonliang91
Rank
Userlevel 5
Badge +1

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

M
Rank
Userlevel 5
Badge +1

Confirming this is working in 23.210.0017!

M
Rank
Userlevel 5
Badge +1

Great! Thanks, @simonliang91 

simonliang91
Rank
Userlevel 5
Badge +1

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

M
Rank
Userlevel 5
Badge +1

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

simonliang91
Rank
Userlevel 5
Badge +1

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

M
Rank
Userlevel 5
Badge +1

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

nathantrauscht
Rank
Userlevel 5
Badge +1

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

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.

nathantrauscht
Rank
Userlevel 5
Badge +1

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?

simonliang91
Rank
Userlevel 5
Badge +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. 

K2a
Rank
Userlevel 4
Badge +1

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

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.

K2a
Rank
Userlevel 4
Badge +1

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

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.

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. 

B
Rank
Userlevel 3

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

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.

 

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

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.

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

@KarthikGajendran - we have upgraded to 23R113 and I see the ability to map to Product -> Product Variants -> Metafields, however it appears you can only sync from the Template Item to the Product Variants -> Metafield.

We are specifically trying to sync data from the matrix item to the Product -> Product Variants -> Metafields, including the matrix item attributes. It does not appear that is currently possible, is it? I only see Template Items -> Matrix under the ERP Object, but that only has a handful of field options available.

If not possible, do we know if that is on the road map for the future? Something along the lines of ERP Object = Template Items -> Matrix -> Attributes would be ideal.

StevenRatner
Rank
Userlevel 5
Badge

@KarthikGajendran - I have tried to configure a template item which has stock items to the Product→ Product Variants → Metafields. The sync doesn’t provide an error and shows processed in ACU, but doesn’t update the Shopify-Product-Variant-Metafields in Shopify.  Is there still something wrong in the connector.

 

 

Steve - Klear Systems

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