Resolve your Shopify error with code "invalid reference key"

Gogula R Bhavana

Updated December 21, 2023 09:45

Error code: "invalid_key_or_ref"

Flow impacted	`Error code`/ Message	Likely cause	Resolution
Shopify Order to NetSuite Order Add	`invalid_key_or_ref` Failed to add Shopify Order #1011. Invalid entity reference key 35007	This error indicates that the particular customer that is referencing, reference key 35007, is no longer an Active Customer.	In NetSuite, mark the customer as "active". Re-run the order flow.
Shopify Order to NetSuite Order Add	`invalid_key_or_ref` Failed to add Shopify Order #1234. Invalid item reference key 1009 for subsidiary 1.	A subsidiary of the Item record in NetSuite does not match with the Subsidiary on the Customer record.	In NetSuite, Navigate to Lists -> Accounting -> Items. Find the Item record with internal id "1009". Edit the Item Record & set the Subsidiary with internal id "1" & Save the Item Record. To find the Subsidiary Internal IDs in NetSuite, navigate to Setup > Company > Subsidiaries.
Shopify Order to NetSuite Order Add	`invalid_key_or_ref` Failed to add Shopify Order #1234. Invalid shipmethod reference key 4115 for entity 33676.	A subsidiary of the shipping method does not match with the Subsidiary of the Customer.	In NetSuite, Navigate to Lists -> Accounting -> Shipping Items. Find the Ship Method record with internal id "4115". Edit the record & set the Subsidiary value to the value set on the Customer record with Internal Id "33676" & Save the record.
Shopify Transaction to NetSuite Customer Deposit Add	`invalid_key_or_ref` Failed to create Customer Deposit for Shopify Order XXXXXX due to Invalid reference key of Order XXXXXX for Customer XXXXXX.	If you map the payment method on the sales order, NetSuite restricts to a create customer deposit.	Remove the payment method mappings on the Shopify Order to NetSuite Order Add flow. Create the mappings on the Shopify Transaction to NetSuite Customer Deposit Add flow. Remove the existing payment record on the NetSuite sales order. Retry the error.
Shopify order to NetSuite order (cash sale or sales order)	Failed to add/update customer for Shopify order T******T. Failed to save record because Invalid custrecord_celigo_shopify_store reference key 1. (OR) Failed to save record because Invalid custrecord_celigo_shopify_store reference key 1.	The error indicates that the flow is not detecting the store ID or the store sync did not update the new store ID if there had been changes.	Make sure that the store ID is matched between the Shopify, Netsuite, and the one set in integrator.io. To find store ID in integrator.io: Go to integrator.io and navigate to the Shopify - NetSuite integration app tile. Go to Flows > Order. Next to the Shopify customer to NetSuite customer (add or update flow, click Mappings to edit the Field mappings. In the Post customers to NetSuite mappings section, look for the 'Shopify store (internal ID) field' in the left column fields and in the right column fields. Click Edit (Gear icon) to view the Settings page. You will find the store ID in the filters field. Match the Shopify store ID in NetSuite, integration.io, and make the required changes. Save the changes. Now, go to the integrator dashboard and view the Error dialog. Click Retry to re-run the Order Import flow successfully.