Woocommerce-admin: Customers: Shows only one customer even when there are many; search does not return any result

[arunsathiya]

Describe the bug

The Customers tab under WooCommerce Admin sidebar menu does not load all the customers. It shows only one customer, but the total count is much higher.

When searching for customers by their name, no results appear.

To Reproduce

• Start with a WooCommerce site with 2+ customers.
• Run the Import Historical Data option under Settings.
• Visit the Customers tab on the Analytics menu on the left.
• Note that only one customer is shown (mostly the site owner account), even though the total count is much higher.
• Searching for customers does not show any results either.

Expected behavior

• All customers are shown properly.
• When searching, all results should appear as well.

Screenshots

This is when searching for the customer by their name:

Desktop (please complete the following information):

• OS: macOS 10.14.5 - Mac OS Mojave
• Browser: Google Chrome
• Version: Google Chrome Version 74.0.3729.169 (Official Build) (64-bit)

Additional context

@warrendholmes was able to see this behaviour as well on their test site - p1561003973155500-slack-wc-admin

[psealock]

I was able to replicate this on another test site using 0.13.2. Only two customers are shown, but the count is much higher.

I deleted historical data, updated to master branch, and re-imported historical data. There is now a customers count equal to the number of rows in the customers lookup table.

I'll double check this later tonight, but signs are pointing to this being resolved and out in 0.14.0.

[psealock]

I just re-confirmed to be sure. This problem will be resolved by 0.14.0, which is scheduled to go out before end of next week.

These two PRs by @joshuatf seemed to have addressed the issue:
https://github.com/woocommerce/woocommerce-admin/pull/2428
https://github.com/woocommerce/woocommerce-admin/pull/2418

I'm going to close this one, but if updating doesn't work, we can reopen.

[joshuatf]

Also confirmed with @arunsathiya's dataset. Looks like I'm getting all customers and guest orders as well on the latest master.

[arunsathiya]

So glad to hear this! Thanks for verifying!

[joshuatf]

No problem, @arunsathiya 😄

If you run into any more problems with this, feel free to post back here and we can reopen.

[timmyc]

Thanks @joshuatf for the fixes and @psealock for helping verify. And again thanks @arunsathiya for relaying the bug reports.