Any Celigo users connecting to Shopify encountered this error? This is in the flow Shopify order to NetSuite order (cash sale or sales order). This field is added to NetSuite by the Celigo integration, and it's locked so I can't change it there.

Failed to create, update/transform record because The field custbody_celigo_shopify_giftcard_id contained more than the maximum number ( 300 ) of characters allowed."

And I can't alter the mapping at all, it's also locked in the IA. Just stuck with this order we can't get into NS.

@Stephanie Hughes I’m with Celigo and would like to help. Has the gift card id actually exceeded 300 characters, or is the problem that it’s being misreported? If you’ve raised a Support ticket already (which I highly recommend), please let me know here or via DM so we can look into it properly.

@matt.graney No, I haven't opened a ticket, I was seeing if there was any way to skirt around this! The problem is that there were 27 gift cards used, so the concatenated list of gift card IDs was something like 351 characters long. It doesn't seem as though anyone planned for someone to use that many gift cards, though Shopify doesn't impose a limit.

Definitely an odd scenario, but it comes down to being a field type problem. Netsuite is the field that is restricted to 300. Personally, I’d carved out the extra digits to atleast get the order in place.

We manually keyed the order. There's no way to truncate it in Shopify or in the flow since it's a locked mapping. And the (locked) field in NetSuite was created by the Celigo integration installation, so that's ultimately what I'd want to have changed.

Right. Not going to get that resolved here. They may push back on the edge case of 27 gift cards, but you shall see. I personally wouldn’t expect any resolution quickly for this.

@Stephanie Hughes so in an ideal world, you’d want the integration app to just truncate at 300 chars? Will that mess up your reporting/auditing in NetSuite?

@matt.graney Truncate would be fine! Won't mess anything up in NetSuite, if we needed to see the 27 gift card IDs we can go to Shopify.

@Stephanie Hughes, in the error data within Celigo, can you see all the gift card transaction ids under "transactions.gift_card.receipt.gift_card_id?" Could you have edited the retry data to manually truncate and then retry the error?

@Tyler Lamparter It's not part of the Edit Retry Data. It's part of the transactions.json subrecord that you can't edit in the Celigo UI.

@Stephanie Hughes, based on the retry data, you could probably remove some characters from a few of the gift card ids that are in the transaction array and then retry the error. I know it's not ideal, but probably would work for if this ever happens again.

@Tyler Lamparter Great! It will happen again... I will try that. Thanks!