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
0forks

Install

No release zip yet. The repository archive installs, but the folder name will carry the branch suffix and updates will not flow:

wp plugin install https://github.com/duellingpixels/user-woocommerce-orders-column/archive/refs/heads/main.zip
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.