I often have Amazon orders that feed into shipping easy where the customer has a middle name or initial. Almost always, searching for these customers comes back with no results. Searching on the last name also comes back blank.
My latest example has a Name "gcarlton G Carlton"
The Ship To printed as "W G Carlton"
I gather that the search is looking for something like "Select * from orders where firstname ='x' or lastname ='x'". Is this correct. And if so, why does it not pull back any results.
It does not look like you're using the like operator (e.g. Select * from orders where name like '%x% -- where x is a piece of the name).
Help me understand how it works. Anytime I have a First Name - Initial - Last Name I get nothing. This is pretty frustrating.
I also recently had an order for the Name "Thomas N". This order ships to Thomas Nickles. A search for "Thomas N" returns nothing. A search for "Thomas" finds "Thomas Nickles".
Why did search fine "Nickles" and not "Carlson".
I'm a web programmer - I get this stuff. But I can't seem to figure out how Shipping Easy search works. Perhaps you're using Solr or Lucene and I'm just not searching correctly.
One more question. How does Name map back to Amazon. Is this the Account Name and does the Ship To in Shipping Easy map back to the Full Name which is the top line of the Amazon Address Book?
Hello David, and thank you for posting to our community.
Unfortunately our global search function is not able to search for middle initials or last names, if the Last Name field includes both the middle initial and last name.
When either the First Name or Last Name field includes a middle initial, the field will become unsearchable.
For cases like your W G Carlton example, we recommend searching by first name (initial in this case), email address or order number.
Searching your account for 'W' should provide several results including orders for W G Carlton.
The article below may also provide some additional help when using the global search feature.
How to: Find orders and shipments using Global Search
Amazon orders are linked by order number from ShippingEasy, and all information contained within the order, including the customer Name is transmitted back to Amazon. Both First, Middle Initial and Last names are transmitted under the Name setting.
How Amazon maps that to the Amazon Address Book is unclear but you may want to contact Amazon support for more information.
Thank you and happy shipping!