Skip to main content
Solved

Is it possible to sync related items to Shopify as a list type metafield

  • January 25, 2023
  • 6 replies
  • 168 views
M
Semi-Pro II
Forum|alt.badge.img

Does anyone know if it is possible to sync related items under a product in Acumatica to a single, list-type metafield?

Example:

  1. Product A has Products B and C selected as Related items in Acumatica. 
  2. Product B and Product C are synced together to a single list metafield as “Product B, Product C” (or something along those lines).
  3. Later, Product C is removed as a related item in Acumatica and replaced by Product D.
  4. Now, Product B and Product D are synced together to the single list metafield.

Best answer by smarenich

Hi @mikeho unfortunately the standard Shopify Connector does no sync related items. It is also not possible to convert an array of items to a single metafield using mapping.

So the only way I can suggest you is a relatively small customization to select related Items from Acumatica database, concatenate them and push to Shopify metafield. 

6 replies

smarenich
Acumatica Moderator
Forum|alt.badge.img+3
  • smarenich
  • Acumatica Commerce Edition Team Lead
  • Answer
  • January 25, 2023

Hi @mikeho unfortunately the standard Shopify Connector does no sync related items. It is also not possible to convert an array of items to a single metafield using mapping.

So the only way I can suggest you is a relatively small customization to select related Items from Acumatica database, concatenate them and push to Shopify metafield. 

M
K
M
Semi-Pro II
Forum|alt.badge.img
  • michaelho
  • Author
  • Semi-Pro II
  • January 25, 2023

Thank you, @smarenich.

K
Freshman I
  • kyrenmearr
  • Freshman I
  • July 16, 2024

Hi @smarenich Can you point me how to do that? Which part of the guide?

dgodsill97
Varsity I
Forum|alt.badge.img+3
  • dgodsill97
  • Varsity I
  • May 20, 2025

Any updates on this feature?

M
Semi-Pro II
Forum|alt.badge.img
  • michaelho
  • Author
  • Semi-Pro II
  • May 20, 2025

​@dgodsill97 we ended up solving for this with a customization that concatenated the External IDs (essentially, the Product IDs of the items in Shopify) of the related items into a JSON string in a custom field, and then mapped that to a product list metafield in Shopify.

I doubt anything like this will become a native feature in Acumatica, for what it’s worth.

Chris Hackett
dgodsill97
Varsity I
Forum|alt.badge.img+3
  • dgodsill97
  • Varsity I
  • May 20, 2025

Thanks, already got a quote from our development staff.  Apparently Big Commerce handled this.

Chris Hackett
Terms & ConditionsCookie settingsAccessibility statement
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