Shopify order edit fails with customer -1 although valid entity is mapped

Integrator.io
1

Flow: Shopify order to NetSuite order (cash sale or sales order)

I am encountering an error when trying to edit an order in NetSuite using the standard Celigo Shopify-NetSuite integration. The order creation flow works perfectly, and I have verified that all relevant settings are configured correctly. Could you help me understand what might be causing this issue with the edit sync?

image
image1166×179 22.1 KB

image
image1267×127 13.1 KB

image
image671×485 20.1 KB

Thanks,

Dipali

Below is the order Edit request

importing record:
{"nlobjRecordType":"salesorder","nlobjFieldIds":{"celigo_recordmode_dynamic":"true","entity":2823849,"subsidiary":2,"orderstatus":"Pending Fulfillment","billaddr1":"7 Meadow Vale Close","billaddr2":null,"billaddressee":"Victoria Grief","billattention":null,"billcity":"YARM","billstate":"ENG","billzip":"TS15 9WG","billphone":"+447736765264","billcountry":"GB","shipaddr1":"7 Meadow Vale Close","shipaddr2":null,"shipaddressee":"Victoria Grief","shipattention":null,"shipcity":"YARM","shipstate":"ENG","shipzip":"TS15 9WG","shipphone":"+447736765264","shipcountry":"GB","shipmethod":10472,"custbody_celigo_shopify_giftcard_id":"","custbody_celigo_etail_risk_rating":"","custbody_celigo_etail_risk_analysis":"","custbody_celigo_shpfy_transaction_ids":"8784302375168,8784309649664","custbody_celigo_shpfy_updatedtime":"2026-09-28T10:20:45-04:00","custbody_celigo_etail_channel":"Shopify","custbody_celigo_etail_order_id":"7215516680448","custbody_celigo_shopify_order_no":"1003","custbody_celigo_shopify_discountcode":"","otherrefnum":"#1003","custbody_celigo_etail_transaction_ids":"rhbQDow9WNXRH3ZlsIn5ypCZI,#1003.1","custbody_celigo_shpfy_ispickup":"","currency":1,"custbody_eb_shopify_tags":"","custbody_eb_customer_tags":"","memo":"crc-test-r10ey0i9","terms":9,"department":1,"class":24,"custbody_cseg_sales_type":4,"custbody_shopify_notes":null,"custbody42":1,"celigo_ignore_mandatory_fields":"true","trandate":"09/28/2026 10:17:59 pm","celigo_write_log":"true","celigo_replaceAllLines_item":"true","celigo_persist_new_line_insertion_order":"true","internalid":6848857,"custbody_celigo_shopify_store":201,"shippingcost":0,"externalid":"SHPF-86161850624-7215516680448","custbody_celigo_pre_order_submit_data":"{"items":{"16968102936832":{"taxAmount":"0","taxrate1":0,"taxcode":11},"16968102969600":{"taxAmount":"0","taxrate1":0,"taxcode":11}},"taxes_included":true}","custbody_celigo_etail_bill_exp":true},"nlobjSublistIds":{"item":{"lines":[{"quantity":2,"price":-1,"rate":"140.00","custcol_celigo_etail_order_line_id":"16968102936832","custcol_celigo_etail_fulfillment_serv":"manual","class":24,"department":1,"custcol_customer_type":1,"custcol_sales_channel":1,"line":"1","taxAmount":"0","custcol_celigo_etail_order_line_tax":"0"},{"quantity":1,"price":-1,"rate":"0.00","custcol_celigo_etail_order_line_id":"16968102969600","custcol_celigo_etail_fulfillment_serv":"manual","class":24,"department":1,"custcol_customer_type":1,"custcol_sales_channel":1,"line":"7","taxAmount":"0","custcol_celigo_etail_order_line_tax":"0"}]}},"documentIndex":0,"eTailCache":{"preSubmitOrderTaxData":{"items":{"16968102936832":{"taxAmount":"0","taxrate1":0,"taxcode":11},"16968102969600":{"taxAmount":"0","taxrate1":0,"taxcode":11}},"taxes_included":true},"preSubmitVarianceData":{"orderTotal":280,"shippingTotal":0,"taxTotal":0,"discountTotal":0},"reSubmittableNegativeLines":{}},"INTEGRATOR_IO_MAPPER":true}
nlapi calls registered for $R:
r = nlapiLoadRecord("salesorder", 6848857, {"recordmode":"dynamic"});
r.setFieldValue("subsidiary", 2);
r.setFieldText("orderstatus", "Pending Fulfillment");
r.setFieldValue("billaddr1", "7 Meadow Vale Close");
r.setFieldValue("billaddr2", null);
r.setFieldValue("billaddressee", "Victoria Grief");
r.setFieldValue("billattention", null);
r.setFieldValue("billcity", "YARM");
r.setFieldValue("billstate", "ENG");
r.setFieldValue("billzip", "TS15 9WG");
r.setFieldValue("billphone", "+447736765264");
r.setFieldValue("billcountry", "GB");
r.setFieldValue("shipaddr1", "7 Meadow Vale Close");
r.setFieldValue("shipaddr2", null);
r.setFieldValue("shipaddressee", "Victoria Grief");
r.setFieldValue("shipattention", null);
r.setFieldValue("shipcity", "YARM");
r.setFieldValue("shipstate", "ENG");
r.setFieldValue("shipzip", "TS15 9WG");
r.setFieldValue("shipphone", "+447736765264");
r.setFieldValue("shipcountry", "GB");
r.setFieldValue("shipmethod", 10472);
r.setFieldValue("custbody_celigo_shopify_giftcard_id", null);
r.setFieldValue("custbody_celigo_etail_risk_rating", null);
r.setFieldValue("custbody_celigo_etail_risk_analysis", null);
r.setFieldValue("custbody_celigo_shpfy_transaction_ids", "8784302375168,8784309649664");
r.setFieldValue("custbody_celigo_shpfy_updatedtime", "2026-09-28T10:20:45-04:00");
r.setFieldText("custbody_celigo_etail_channel", "Shopify");
r.setFieldValue("custbody_celigo_etail_order_id", "7215516680448");
r.setFieldValue("custbody_celigo_shopify_order_no", "1003");
r.setFieldValue("custbody_celigo_shopify_discountcode", null);
r.setFieldValue("otherrefnum", "#1003");
r.setFieldValue("custbody_celigo_etail_transaction_ids", "rhbQDow9WNXRH3ZlsIn5ypCZI,#1003.1");
r.setFieldValue("custbody_celigo_shpfy_ispickup", "F");
r.setFieldValue("currency", 1);
r.setFieldValue("custbody_eb_shopify_tags", null);
r.setFieldValue("custbody_eb_customer_tags", null);
r.setFieldValue("memo", "crc-test-r10ey0i9");
r.setFieldValue("terms", 9);
r.setFieldValue("department", 1);
r.setFieldValue("class", 24);
r.setFieldValue("custbody_cseg_sales_type", 4);
r.setFieldValue("custbody_shopify_notes", null);
r.setFieldValue("custbody42", 1);
r.setFieldValue("trandate", "09/28/2026");
r.setFieldValue("custbody_celigo_shopify_store", 201);
r.setFieldValue("shippingcost", 0);
r.setFieldValue("externalid", "SHPF-86161850624-7215516680448");
r.setFieldValue("custbody_celigo_pre_order_submit_data", "{"items":{"16968102936832":{"taxAmount":"0","taxrate1":0,"taxcode":11},"16968102969600":{"taxAmount":"0","taxrate1":0,"taxcode":11}},"taxes_included":true}");
r.setFieldValue("custbody_celigo_etail_bill_exp", "T");
r.selectLineItem("item", 1);
r.setCurrentLineItemValue("item", "quantity", 2);
r.setCurrentLineItemValue("item", "price", -1);
r.setCurrentLineItemValue("item", "rate", "140.00");
r.setCurrentLineItemValue("item", "custcol_celigo_etail_order_line_id", "16968102936832");
r.setCurrentLineItemValue("item", "custcol_celigo_etail_fulfillment_serv", "manual");
r.setCurrentLineItemValue("item", "class", 24);
r.setCurrentLineItemValue("item", "department", 1);
r.setCurrentLineItemValue("item", "custcol_customer_type", 1);
r.setCurrentLineItemValue("item", "custcol_sales_channel", 1);
r.setCurrentLineItemValue("item", "line", "1");
r.setCurrentLineItemValue("item", "custcol_celigo_etail_order_line_tax", "0");
r.commitLineItem("item");
r.selectLineItem("item", 2);
r.setCurrentLineItemValue("item", "quantity", 1);
r.setCurrentLineItemValue("item", "price", -1);
r.setCurrentLineItemValue("item", "rate", "0.00");
r.setCurrentLineItemValue("item", "custcol_celigo_etail_order_line_id", "16968102969600");
r.setCurrentLineItemValue("item", "custcol_celigo_etail_fulfillment_serv", "manual");
r.setCurrentLineItemValue("item", "class", 24);
r.setCurrentLineItemValue("item", "department", 1);
r.setCurrentLineItemValue("item", "custcol_customer_type", 1);
r.setCurrentLineItemValue("item", "custcol_sales_channel", 1);
r.setCurrentLineItemValue("item", "line", "7");
r.setCurrentLineItemValue("item", "custcol_celigo_etail_order_line_tax", "0");
r.commitLineItem("item");
nlapiSubmitRecord(r, false, true);

2

Hi there! Just wanted to put the resolution back here in case anyone encounters the same. :slight_smile: As discussed in the support ticket, a hard-coded Subsidiary mapping didn’t account for edited orders and caused the issue. Updating it to a conditional handlebar expression resolved the problem.