We’re encountering this issue frequently, but there’s no clear pattern or apparent cause. Some template items sync successfully, while others, seemingly identical in structure, fail with the same error.
The issue occurs with both new and existing template items, regardless of whether they have one or multiple attributes. We've seen it affect items with just two matrix variants, even when those variants have only a single attribute (e.g., color). After thoroughly reviewing each item, we’ve confirmed that there are no duplicate attributes across variants that would justify this error, particularly since many of these items have been in the system for a long time without issue.
Is anyone else experiencing this? Any insights or suggestions would be appreciated.
Best answer by malaniz
@KarthikGajendran
Acumatica Support confirmed this is an issue with Attribute Description duplicates—
Acumatica Attribute - Duplicate Descriptions
Once we went through all Description Duplicates on the SIZE attribute we were able to sync Template Items that used the corresponding Item Class.
Commerce Connector will refuse to sync the Template Item even if the item doesn’t use one of the duplicate attribute values… see the example below:
Shopify Variant Values for SIZE Attribute
The above Shopify Item only uses sizes Large, Medium, X-Large. None of those values were duplicated on the attribute descriptions, yet Acumatica refused to sync the Template item since it used the SIZE attribute that contained unused duplicate descriptions.
This wasn’t an issue for us in 23R2, not sure if this is due to changes in Acumatica Commerce Connector validation or something from recent Shopify API updates.
The Solution:
Dedupe your attribute value descriptions before attempting to sync template items in 25R1.
@malaniz Could you please create a case with Acumatica? We would like to analyze the issue. Also, could you provide us the screenshot of the Attribute values for the Attribute option color. Would like to option if the duplicated happens because of some truncation.
Also, is any other matrix item with this Attribute option color that synced successfully?
Acumatica Support confirmed this is an issue with Attribute Description duplicates—
Acumatica Attribute - Duplicate Descriptions
Once we went through all Description Duplicates on the SIZE attribute we were able to sync Template Items that used the corresponding Item Class.
Commerce Connector will refuse to sync the Template Item even if the item doesn’t use one of the duplicate attribute values… see the example below:
Shopify Variant Values for SIZE Attribute
The above Shopify Item only uses sizes Large, Medium, X-Large. None of those values were duplicated on the attribute descriptions, yet Acumatica refused to sync the Template item since it used the SIZE attribute that contained unused duplicate descriptions.
This wasn’t an issue for us in 23R2, not sure if this is due to changes in Acumatica Commerce Connector validation or something from recent Shopify API updates.
The Solution:
Dedupe your attribute value descriptions before attempting to sync template items in 25R1.
