# Failed to save record because This record already exists getting this error on add or update option

**URL:** <https://connective.celigo.com/t/failed-to-save-record-because-this-record-already-exists-getting-this-error-on-add-or-update-option/5939>\
**Category:** Integrator.io\
**Created:** [December 11, 2025, 8:40am UTC](https://connective.celigo.com/t/failed-to-save-record-because-this-record-already-exists-getting-this-error-on-add-or-update-option/5939 "2025-12-11T08:40:03Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ajay\_Sankar\_J](https://avatars.discourse-cdn.com/v4/letter/a/a9a28c/32.png) [@Ajay\_Sankar\_J](https://connective.celigo.com/u/Ajay_Sankar_J)\
**Post date:** [December 11, 2025, 8:40am UTC](https://connective.celigo.com/t/failed-to-save-record-because-this-record-already-exists-getting-this-error-on-add-or-update-option/5939/1 "2025-12-11T08:40:04Z")

</div>

Why I’m getting sales order import even though I set Add or update option in settings and added proper lookup criteria. I created a similar search on Netsuite and I get exactly one record but why celigo throwing error anyone check

-uploaded images go here-

 ![record_already_error](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/c/c0d09430a3f426dc0ae763d2b50d61dd1213e296.png)

 ![lookup_crit_existing](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/3/350e848ec712d1304bc56e3f51c7fbfb084b8e90.png)

 ![add or update](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/6/6d6c489e40f746c29972639f2a71384123162115.png)

---

<div class="post-metadata">

**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\
**Post date:** [December 11, 2025, 7:45pm UTC](https://connective.celigo.com/t/failed-to-save-record-because-this-record-already-exists-getting-this-error-on-add-or-update-option/5939/2 "2025-12-11T19:45:25Z")

</div>

Try using the `External ID (Text)` field.

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

---

<div class="post-metadata">

**Author:** ![Ajay\_Sankar\_J](https://avatars.discourse-cdn.com/v4/letter/a/a9a28c/32.png) [@Ajay\_Sankar\_J](https://connective.celigo.com/u/Ajay_Sankar_J)\
**Post date:** [December 12, 2025, 2:36am UTC](https://connective.celigo.com/t/failed-to-save-record-because-this-record-already-exists-getting-this-error-on-add-or-update-option/5939/3 "2025-12-12T02:36:25Z")

</div>

Getting same error even after using external id text field

---

<div class="post-metadata">

**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\
**Post date:** [December 16, 2025, 3:29am UTC](https://connective.celigo.com/t/failed-to-save-record-because-this-record-already-exists-getting-this-error-on-add-or-update-option/5939/4 "2025-12-16T03:29:51Z")

</div>

Can you enable debug logs on the connection and then check the logs to see what results are being returned?