WP Manifestindependent plugin directory
manifest / ecommerce / user-woocommerce-orders-column

WC User Order Count Column

Adds a column to the Users admin screen showing the total number of WooCommerce orders per user.

by Duelling Pixels · github.com/duellingpixels/user-woocommerce-orders-column

★ 0stars

Install

Download source zip No release zip yet

This is the repository archive. It installs, but the folder name will carry the branch suffix and updates will not flow.

Install straight from GitHub with WP-CLI:

wp plugin install https://github.com/duellingpixels/user-woocommerce-orders-column/archive/refs/heads/main.zip
No built-in updater. New versions won't appear under Dashboard → Updates. Install new releases yourself, or let Git Updater track the repository.
Readme github.com/duellingpixels/user-woocommerce-orders-column ↗

WC User Insights: Orders & Spend Column

WC User Insights is a lightweight, high-performance WordPress plugin that enhances the User admin screen (wp-admin/users.php). It provides store administrators with immediate visibility into customer value by displaying total order counts and lifetime spend directly in the user list.

✨ Features

  • Order Frequency: Displays the total number of "Processing" and "Completed" orders.
  • Lifetime Value (LTV): Shows the total currency amount spent by the user across all successful transactions.
  • Performance First: Uses optimized ids queries and the native WooCommerce get_total_spent() function to ensure zero lag on high-traffic sites.
  • Fully Sortable: Click column headers to instantly find your highest-spending VIP customers.
  • Clean UI: Uses subtle styling for users with no purchase history to keep your interface decluttered.

🛠 Installation

Method 1: The Plugin Folder (Recommended)

  1. Create a folder named wc-user-insights on your computer.
  2. Create a file inside named wc-user-insights.php and paste the provided PHP code into it.
  3. Upload the folder to your server at /wp-content/plugins/.
  4. Navigate to Plugins in your WordPress dashboard and click Activate.

Method 2: WordPress Dashboard Upload

  1. Follow steps 1 and 2 from Method 1.
  2. Compress the wc-user-insights folder into a .zip file.
  3. Go to Plugins > Add New > Upload Plugin.
  4. Choose your .zip file, install, and activate.

🔍 How to Use

Once activated, navigate to Users > All Users. You will see two new columns:

  1. Orders: The count of successful purchases.
  2. Total Spend: The cumulative value of those purchases in your store's currency.

[!TIP] Click on the Total Spend column header twice to sort by descending value. This is the fastest way to identify your top 10% of customers for targeted marketing or loyalty rewards.

⚙️ Technical Details

  • Status Filtering: To ensure data integrity, only orders with processing or completed statuses are calculated.
  • Hooks Used: * manage_users_columns
    • manage_users_custom_column
    • manage_users_sortable_columns
  • Compatibility: Works with WooCommerce 3.0+ and WordPress 5.0+.

📄 License

This project is open-source and available under the MIT License.