Skip to main content
Solved

Template Item sync error with Shopify connector : "At Least one option value is duplicated"

  • December 16, 2025
  • 5 replies
  • 48 views
J
Freshman II

Hi 

After many chat with Shopify support and after reviewing the data and considering that all variants are unique in Acumatica.

 

it appears that the error "At least one option value is duplicated" likely stems from a subtlety in how the data is transmitted or interpreted by the Shopify connector integrated into your Acumatica ERP version 2025r1.
 

So , I’am looking for more information ( into the Acumatica log )  

  • Review the data sent via the connector: If possible, obtain a snippet or log of the payload sent to Shopify for product W24J0059 so our technical team can analyze exactly which option combinations are received.

 

Our last sync history was this morning 12/16/2025 11:06am on Entity : Template Item and ERP ID W24j0059 

 

Thanks for your Help 

_jean

Best answer by jlongpre4AC

Eureka 

 

La nouvelle validation de synchronisation des articles modèle depuis le service pack Version 25.100.0054.7 est plus sévère car Shopify ne tolère plus les trop grandes similitudes entre les variants des produits .

Bref, dans les variants COMBO  de type variante , la validation ne tient PAS compte du statut "Actif/Inactif" des valeurs d'attributs. Même une valeur désactivée avec une description identique bloque la synchronisation.

Notre  cas spécifique :

 

Attribut COULEUR (COMBO, Variant) ├─ 07006 : BLACK [INACTIF] ❌ Bloquait la synchro └─ 17006 : BLACK [ACTIF]   ✓

Solution appliquée : Renommer "07006" en "old Black" → ✅ Synchronisation réussie

Recommandations pour éviter ce problème à l'avenir :

1. Convention de nommage pour les valeurs obsolètes :

 

Format suggéré : "OLD-[description]"

5 replies

DipakNilkanth
Pro III
Forum|alt.badge.img+13

Hi ​@jlongpre4AC,

Have you gone through the link below? It might be helpful for your scenario.

 

Dipak Nilkanth || MVP @2025 || https://www.linkedin.com/in/dipak-nilkanth-293591102 || Acumatica Developer
Chris Hackett
kkeating24
J
kkeating24
Varsity III
Forum|alt.badge.img+1
  • kkeating24
  • Varsity III
  • December 16, 2025

I have seen this error where a client had an attribute for color, one called BLK and one BLCK and the description for both was “Black”.   As per the link from ​@DipakNilkanth it should give you some other ideas if that’s not the case. 

--attachment is the great fabricator of illusions; Reality can only be attained by someone who is detached. -s.w.
Chris Hackett
DipakNilkanth
J
mohammadnawaz51
Jr Varsity I
Forum|alt.badge.img+4

​@jlongpre4AC It seems to be the attributes created under template items may be a duplicate.

https://www.acumatica.com/acumatica-marketplace/global-payex-ap-accounts-payable-automation-solution/
Chris Hackett
J
Freshman II
  • jlongpre4AC
  • Author
  • Freshman II
  • Answer
  • December 17, 2025

Eureka 

 

La nouvelle validation de synchronisation des articles modèle depuis le service pack Version 25.100.0054.7 est plus sévère car Shopify ne tolère plus les trop grandes similitudes entre les variants des produits .

Bref, dans les variants COMBO  de type variante , la validation ne tient PAS compte du statut "Actif/Inactif" des valeurs d'attributs. Même une valeur désactivée avec une description identique bloque la synchronisation.

Notre  cas spécifique :

 

Attribut COULEUR (COMBO, Variant) ├─ 07006 : BLACK [INACTIF] ❌ Bloquait la synchro └─ 17006 : BLACK [ACTIF]   ✓

Solution appliquée : Renommer "07006" en "old Black" → ✅ Synchronisation réussie

Recommandations pour éviter ce problème à l'avenir :

1. Convention de nommage pour les valeurs obsolètes :

 

Format suggéré : "OLD-[description]"

Chris Hackett
kkeating24
DipakNilkanth
kkeating24
Varsity III
Forum|alt.badge.img+1
  • kkeating24
  • Varsity III
  • December 17, 2025

Excellent!

--attachment is the great fabricator of illusions; Reality can only be attained by someone who is detached. -s.w.
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