What field name is customer’s full name like “John Smith”

  • Hi,

    Mike Jolley had mentioned that in 3.0 “we added a new search index which actually saves the name string “John Doe” to a new field which is then searchable without so much performance impact. The downside is this cannot be applied retrospectively to past orders. So when doing these types of search, only new and updated orders will be shown.”

    Is the searchable full name like “John Doe” that you referred to in WooCommerce 3.0 now placed in the “display_name” column in “wp_users”?

    And is that column built from the wp_postmeta table of the columns _billing_first_name + “ “ + _billing_last_name?

    This can help us write some PHP to retroactively scans past orders and updates their display_name field.

    Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor Mike Jolley

    (@mikejolley)

    > Is the searchable full name like “John Doe” that you referred to in WooCommerce 3.0 now placed in the “display_name” column in “wp_users”?

    It’s not placed there purposely. display_name can be set but it’s not that reliable, plus it still requires a join between orders + users tables, so it cannot search things like guest orders.

    Thread Starter ScottCodes

    (@scottlush)

    Thanks.

    Can you please tell us what is the field name and in what table that WooCommerce 3.0 now uses for the “John Doe” searchable name, please?

    We are trying to fill that field in for all our previous orders so that we can search by full name and see all orders both pre- and post-Woocommerce 3.0

    Scott

    Plugin Contributor Mike Jolley

    (@mikejolley)

    _billing_address_index and _shipping_address_index

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘What field name is customer’s full name like “John Smith”’ is closed to new replies.