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

**URL:** <https://connective.celigo.com/t/shopify-order-edit-fails-with-customer-1-although-valid-entity-is-mapped/6506>\
**Category:** Integrator.io\
**Created:** [September 28, 2026, 3:01pm UTC](https://connective.celigo.com/t/shopify-order-edit-fails-with-customer-1-although-valid-entity-is-mapped/6506 "2026-09-28T15:01:08Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![ERP\_Buddies](https://avatars.discourse-cdn.com/v4/letter/e/779978/32.png) [@ERP\_Buddies](https://connective.celigo.com/u/ERP_Buddies)\
**Post date:** [September 28, 2026, 3:01pm UTC](https://connective.celigo.com/t/shopify-order-edit-fails-with-customer-1-although-valid-entity-is-mapped/6506/1 "2026-09-28T15:01:08Z")

</div>

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](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/6/66c3dfd05e9c0acbf7c6b8fb49ed87835557a58a.png)

 ![image](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/7/7e775b3e9ab49ef9fd04680acdf9aca7f470aef9.png)

 ![image](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/b/befe4da8bc352927a81f31f092d60dd846efc88f.png)

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);