Note attribute fields in Shopify – Celigo Help Center

Issue:

We are attempting to solve the Note Attribute Fields. Because these fields are not required in Shopify, the Note Attribute number may differ for each order. We are trying to solve that with the following (see the example for poFile:

{{#contains $.[note_attributes[0\]].name "poFile"}} $.[note_attributes[0\]].value
{{else}}{{#contains $.[note_attributes[1\]].name "poFile"}} $.[note_attributes[1\]].value
{{else}}{{#contains $.[note_attributes[2\]].name "poFile"}} $.[note_attributes[2\]].value
{{else}}{{#contains $.[note_attributes[3\]].name "poFile"}} $.[note_attributes[3\]].value
{{else}}{{#contains $.[note_attributes[4\]].name "poFile"}} $.[note_attributes[4\]].value
{{else}}{{#contains $.[note_attributes[5\]].name "poFile"}} $.[note_attributes[5\]].value
{{else}}{{#contains $.[note_attributes[6\]].name "poFile"}} $.[note_attributes[6\]].value
{{else}}{{#contains $.[note_attributes[7\]].name "poFile"}} $.[note_attributes[7\]].value
{{else}}{{#contains $.[note_attributes[8\]].name "poFile"}} $.[note_attributes[8\]].value
{{else}}{{#contains $.[note_attributes[9\]].name "poFile"}} $.[note_attributes[9\]].value
{{else}}{{#contains $.[note_attributes[10\]].name "poFile"}} $.[note_attributes[10\]].value
{{else}}{{#contains $.[note_attributes[11\]].name "poFile"}} $.[note_attributes[11\]].value

{{else}} undefined {{/contains}} {{/contains}}{{/contains}} {{/contains}} {{/contains}} {{/contains}} {{/contains}} {{/contains}} {{/contains}} {{/contains}} {{/contains}} {{/contains}} "

The error we are getting speaks to a NetSuite field explained below.

Source	Code	Message
netsuite	exceeded_max_field_length	"Unable to create the order in NetSuite for the Shopify order #********* Failed to create, update/transform record because The field custbody_celigo_etail_transaction_ids contained more than the maximum number (300) of characters allowed."

Resolution:

This is the formula that should be used:

Here is another alternative solution to resolve the error "Failed to create, update/transform record because The field custbody_celigo_etail_transaction_ids contained more than the maximum number ( 300 ) of characters allowed." You can accept until 300 characters and cut off the rest. This resolution would not affect anything in your order.

To resolve this error, create a handlebar expression in the order flow mapping:

In the Shopify - Netsuite integration app, go to the Flows > Order >Shopify order to NetSuite sales order (add) flow.
Click the mapping icon as shown as a sample in the screenshot.
Set the handlebar expression below on the export field (Shopify) of the Etail Transaction Id(s). See the sample screenshot below.
{{substring sourceTransactionIds "0" "300"}}
Click Save and Close.
Go to the integration.io Dashboard and retry the error message to resolve the issue.

Related articles