Troubleshooting Missing Last Name Errors in NetSuite Connector

TL;DR

This article provides solutions for resolving missing last name errors encountered in NetSuite Connector during order synchronization. These errors occur when customer information is incomplete, preventing the creation of customer records in NetSuite.

What Causes the Missing Last Name Error?

The missing last name error appears when NetSuite Connector tries to sync a customer for an order but finds the Last Name field empty. This can happen for various reasons depending on the connector in use. Here are some common scenarios:

1. Amazon Fulfillment By Amazon (FBA) Orders

FBA orders typically do not include comprehensive customer information as Amazon manages the order shipment. As a workaround, configure a fixed customer in NetSuite to associate with your FBA orders. This will facilitate the syncing process. For detailed guidance, refer to the section on Creating an Amazon Fixed Customer.

2. Pending Order Configuration for Amazon

If your NetSuite Connector is set to import Amazon orders in a pending state, ensure that all pending orders are assigned to a fixed customer. Pending orders may initially lack complete information, triggering this error. If errors persist, contact NetSuite Customer Support with the internal ID of the fixed customer.

Note: Please be aware that configuring pending order sync is no longer supported.

3. Revoked Customer Information Privileges

Sometimes, the error may arise if customer information privileges for your Amazon credentials have been revoked. To troubleshoot this, consult the article on Troubleshooting Incomplete Customer Information From Amazon MFN Orders.

4. Shopify POS Orders

Shopify POS orders may also lack complete customer details. In this case, assign default name values to ensure proper syncing. For instructions, refer to the section on Assigning Default Values to Shopify Point-of-Sale (POS) Orders in NetSuite Connector.

5. Other Connectors

For any other connectors failing to provide complete customer information, set your NetSuite Connector to consistently import orders to the same fixed customer, as explained in the article on Assigning a Fixed Customer to All Orders in NetSuite Connector.

Key Takeaways

• Missing last name errors can block customer sync; ensure required fields are populated.
• Use fixed customers for syncing FBA and pending orders to avoid incomplete data issues.
• Regularly verify customer information privileges for your connected accounts to prevent errors.

Source: This article is based on Oracle's official NetSuite documentation.