Using this handlebar (below) to map order_number to Netsuite PO# field. Works fine. If Shopify order 12345 is created for shipment to Canada, this changes it to CAN12345 for NS PO# field.
{{#compare $.shipping_address.country_code "===" "CA"}}CAN{{$.order_number}}
{{else}}{{$.order_number}}{{/compare}}
But what we really want is to change the Order # field - the one NetSuite uses to save the number. It doesn't work. I applied the same handlebar to that field to no effect. Integrator app continues to post as Order# 12345. I don't believe the problem is with NetSuite. Our settings allow override of the Order# and I can edit the newly-arrived order in the NetSuite UI and change it to CAN12345, save it, and good-to-go.
So I'm assuming it's hard-wired somewhere in the internals of the Shopify-NetSuite IA. The mapping of Shopify's order_number field ito NetSuite's "Shopify Order Number" is protected (grayed out) but I don't see how this could affect a totally separate mapping to the Order # field.
My workaround will be a simple script in NS to revise the order# as soon as the record is created in NS.
Still, if anyone can provide insight as to why it doesn't work in the Integrator App, I would be happy to hear about it!