Shopify POS transactions failing to interface with NetSuite
Hi,
I have the realitime flow "Shopify order to NetSuite sales order (add)" enabled. And as per my knowledge, the Shopify NetSuite integration product still treats POS orders as cash sale as long as "Sync POS orders into NetSuite as sales orders" is unchecked in Settings > Order.
We went live yesterday. Since then, all our POS orders are failing. The error is very apparent - it simply says the "Unable to create the order in NetSuite ... because 236 is an invalid custom form". And that is correct - 236 is our internal id for Sales order form. The real time flow has 236 as the internal id. For Cash Sale, the internal id is something else. Do I need to put a Compare statement for the Form (InternalId) field in the real time mapping. The cash sale form has the right form name; but I am not sure if that is being called.
Any ideas would be appreciated.
Thanks!
Comments
Two updates (if anyone else encounters this issue):
{{#if source_name}}{{#compare source_name '===' 'pos'}}210{{else}}236{{/compare}}{{/if}}
I resolved it by improvising the above compare logic. For POS orders that require shipping; the fulfillment status is null; for the rest its fulfilled. I inserted that else logic as another compare statement since traditional if...else is not supported by handlebar.
You'll also notice that I used a simplified compare instead of the earlier if & compare model. This is courtesy of the Celigo agent who attended to my ticket and suggested this from on his knowledge bases.
Please sign in to leave a comment.