Error: Sales order not created for customer with NS ID - [Code=INVALID_KEY_OR_REF] Invalid custbody___ reference key ___.

Error: Sales order not created for customer with NS ID - [Code=INVALID_KEY_OR_REF] Invalid custbody___ reference key ___.

The reason why this or similar orders got rejected by NetSuite

It seems that this "custbody____" NetSuite custom field is not mapped with its correct (reference / source) internal ID, as a result, our app couldn't sync this order to NetSuite.

Example:

Error: Sales order not created for customer with NS ID - 112 [Code=INVALID_KEY_OR_REF] Invalid custbodycustbody_order_source reference key Shopify.

In this above example, field mapping of this "custbodycustbody_order_source" NetSuite custom field is not correct according to its reference key Shopify, as a result, this order got rejected by NetSuite.

How to fix this error:

Step 1:

  1. Open NetSuite and check the internal ID of this Shopify (reference key / order source), and COPY it

Step 2:

  1. Open Robust NetSuite Integrator app, and go to the Fields Mapping page
  2. In the Transaction Custom Fields Mapping section, click on the Add Custom field, further click on the "Add Custom Fields Static" button
  3. In the Custom field box, enter this "custbodycustbody_order_source" NetSuite custom field, and in the Marketplace field box, enter the internal ID of this Shopify (reference key / order source), further hit the Submit button

Step 3:

  1. Go to the Order Log page
  2. In the Order ID field, enter the Order ID of this rejected order, and hit the Search button
  3. In the action tab, click on the Re-submit button
  4. Upon, successful re-submission, you will see the status of this order changed to Accepted by NetSuite
In case, you have any questions OR suggestions, feel free to reach out to us at help@webbeeglobal.com.