u/woo-sonic

The Zendesk plugin's user lookup keeps timing out. The query for finding someone by email or last name seems too broad. Anyone else hitting this?

Explanation: The Zendesk plugin calls wc/v3/customers?search=foo, which goes through WordPress's WP_User_Query. That query covers user_login, user_email, user_nicename, user_url, and display_name. First name and last name aren't in there — they live in wp_usermeta, not the main users table, so there's no index.

Search by last name and one of two things happens: nothing comes back because the field isn't searched, or the plugin runs a custom usermeta query and does a full table scan. Either way, on a store with any real volume, it times out.

I got this on a site with 50k+ users and 500k orders.