Troubleshooting in Magento 2 - NetSuite Integration App

Diana Badgett

Updated December 04, 2020 11:59

Dataflow impacted	Error Code	Error Message	Likely Reason	Possible Resolution
Magento Order to NetSuite Order Add	missing_static_lookup	Failed to add Magento Order#1234. Could not find mapping in static lookup. { Source: shipmethodLookup} { Key: Free Shipping}'	Magento ship Method "Free Shipping" is not yet mapped to the corresponding ship method in NetSuite.	Configure missing ship method mapping by following the instructions here. Then go back to the Integrator dashboard and view the Error dialog. Click Retry to re-run the Order Import flow successfully.
Magento Order to NetSuite Order Add	missing_static_lookup	Failed to add Magento Order#1234. Could not find mapping in static lookup. { Source: paymentmethodLookup} { Key: direct}'	Magento Payment Method "direct" is not yet mapped to the corresponding payment method in NetSuite.	Configure missing payment method mapping by following the instructions here. Then go back to the Integrator dashboard and view the Error dialog. Click Retry to re-run the Order Import flow successfully.
Magento Order to NetSuite Order Add	value_lookup_failed	Failed to add Magento Order#1234. A mapping error occurred. Could not find "White Tee" in the "Name" field of the record type "item".'	Item with the following SKU "White Tee" not found in NetSuite.	In NetSuite, Navigate to Lists->Accounting->Items->New. Create a new NetSuite Item with “Name” field value as “White Tee” and Save. Go to Integrator.io dashboard and Retry the Order Import flow.
Magento Order to NetSuite Order Add	unique_cust_id_reqd	Failed to add Magento Order#1234. Failed while creating customer, message:A customer record with this ID already exists. You must enter a unique customer ID for each record you create. To correct this record, click back and enter a new customer ID in the Customer field. Then, click Submit.'	A Customer record with the same First and Last Name already exists in NetSuite.	There are multiple ways to resolve this error: One way is to enable NetSuite 'Auto Generate Numbers' feature for Type Customer. In NetSuite, go to Setup > Company > Auto Generate Numbers. Under Type, enable for the type Customer. Go to Integrator.io dashboard and Retry the Order Import flow. Alternate way is to modify the Retry Data & change the First Name & Last Name on the Customer record.
Magento Order to NetSuite Order Add	invalid_key_or_ref	Failed to add Magento Order#1234. Invalid item reference key 1009 for subsidiary 1.	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.
Magento Order to NetSuite Order Add	user_error	Failed to add Magento Order#1234. Failed while creating customer, message:Please enter value(s) for: Subsidiary'	No mappings were found for Subsidary under Customer Mappings section	Go to Integrator.io and navigate to Magento 2 Integration App Tile. Click "Settings" icon to view the Flow settings page. Click Order Sync Settings. Under Flows, go to "Magento Customer to NetSuite Customer Add/Update" and click the Mapping icon to edit the Field mappings. In the Mappings section, look for the 'desired field' in the left column fields and in the right column fields.Click Edit (Gear icon) to view Settings page. Choose 'Field Mapping Type'. - Select 'Options' Click "Save" to save your changes. Now go to the Integrator dashboard and view the Error dialog. Click Retry to re-run the Order Import flow successfully.
Magento Order to NetSuite Order Add	invalid_key_or_ref	Failed to add Magento Order#1234. Invalid shipmethod reference key 4115 for entity 33676.	Subsidary of the Shipmethod does not match with the Subsidary 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.
Magento Order to NetSuite Order Add /Magento Product Id to NetSuite Item Mass Update	value_lookup_failed	A mapping error occurred. Could not find a match for "["itemid","isempty"]" for the record type "item".	SKU field on the corresponding item in Magento is empty.	In your Integrator.io account, click on the "Retry Data" button & locate the SKU field with null value. Populate the correct "SKU" value on the Magento Item record. Also, replace the null value in the JSON with the correct SKU value as entered on Magento Item record. Click on "Retry" button to re-import the data into NetSuite.