Unable to Export a Template Item Attribute Conditionally to Shopify

Question

We are using the Acumatica Shopify Commerce Connector to synchronize item information from Acumatica to Shopify.

A template item in Acumatica contains an attribute named TEMPCLOSEO. The attribute value can be either TRUE or FALSE.

We want to configure an export entity mapping with the following logic:

When TEMPCLOSEO is TRUE, export the value Closeout to Shopify.
When TEMPCLOSEO is FALSE, export a blank value.

We attempted to use the following formula in the Shopify export entity mapping:

=IIf([[TemplateItems -> Attributes.TEMPCLOSEO]] = 'TRUE', 'Closeout', '')

Data is syncing fine when the SKU has true value but it is failing false information

(field: input.metafields.0.value) Value can't be blank. Acumatica returns this following error:

Expected Result

The export mapping should return:

Closeout

when the TEMPCLOSEO attribute is set to TRUE.

When the attribute is set to FALSE, the export mapping should return a blank value.

jinin · Answer

Hi ​@AdcirruserpShopify does not accept empty strings ('') for metafields. The metafield must have a value or be skipped.Option 1: Skip the fieldAdd a condition in BC202000 → Mapping:Condition: TEMPCLOSEO = TRUEFormula: 'Closeout'Option 2: Use a default value (Recommended)=IIf([[TemplateItems -> Attributes.TEMPCLOSEO]]='TRUE','Closeout','None')Try using Null instead of ''. In some connector versions, this skips the metafield in the Shopify payload.

Expected Result

Sign up

Social Login

Login to the community

Social Login