WooCommerce Better Customer List improves on the existing customer list provided by WooCommerce (under Reports) which is painfully slow loading when your customer database gets large. This plugin is fast loading and allows you to view order history by customer.
- Customer Name – The customer’s full name
- Customer Status – Displays if the customer has been active during a period of time. See below on how to change this time period.
- Customer Email – The customer’s email address
- Avg Order Rate – Gives an average of how often the customer orders from the website
- Last Order – The last order made by the customer with a link to the order
- Total Orders – The number of orders the customer has made since the beginning
- Total Spend – The total spent by the customer since the beginning
Order the results by column on Full Name, Average Order Rate, Total Orders, and Total Spend. Further refine the results by filtering customers by Active/Inactive (for your specified last order time period), Average Order Rate Set/Not Set and Ordered/Not Ordered.
The Total Orders and Total Spend fields are calculated after page load via AJAX to ensure the table loads quickly. This is essential for websites with large customer databases. This has been tested on sites with over 25,000 customers and is capable of handling more.
Set customer status time period
The Customer List states whether the customer is Active or Inactive based on their last order made. The default time period used to set this status is 31 days. You can change this period by:
- From the WordPress Admin Dashboard go to WooCommerce -> Settings
- Click the Better Customer List tab.
- Type in the number of days for the system to check against and save the settings. Leave the field blank to use the default setting.