Fix for Error Unable to create the order in NetSuite for the Shopify order #XXXXX Failed to create, update/transform record because The field custbody_celigo_etail_transaction_ids contained more than the maximum number ( 300 ) of characters allowed.
Update Etail Transaction Id(s) mapping to the following formula:
{{#each transactionData}}{{#contains status "success"}}{{{id}}}{{/contains}}{{/each}}
0
Comments
Why didn't you use an #each with a compare nested inside?
Didn't try that, let me know if that works! Would certainly be shorter. I used some documentation celigo provided for the notes attributes, and formatted it in a similar way to that as well as other formulas I have done in the past that have worked.
David Gollom this works and its much shorter. Thanks for bringing that up!
{{#each transactionData}}{{#contains status "success"}}{{{id}}}{{/contains}}{{/each}}
That's it! Nice job. Much simpler!!
The "id" field is currently mapped to "eTail Order Id (2)", not "Etail Transaction Id(s)".
The "sourceTransactionIds" field is currently mapped to "Etail Transaction Id(s)".
Doesn't your solution map "id" to "Etail Transaction Id(s)"?
(forgive me if I'm a bit too paranoid here... Just don't want to mess things up..)
Johan van Langevelde The Each loop is running on the transaction array. So, the {{id}} field is really transactionData[x].id. It's not the id of the Shopify order.
this is the formula that I am now using for this. I received errors for the old formula with a couple of random orders that had a million failed transactions, could never figure out why it errored but anyhow I have not seen any errors with this formula and I've been using this one for over a month now:
{{#each transactionData}}{{#compare status "==" "success"}}{{{id}}},{{/compare}}{{/each}}
Please sign in to leave a comment.