Concatstring Revenue Insights for WooCommerce

Muutosloki

1.7.0

• New: Trends & Growth Analytics page (WooCommerce → Revenue Insights → Trends & Growth) with period-over-period comparison for Revenue, Orders, Views, Cart Adds, and Conversion Rate
• New: Five KPI summary cards with colour-coded growth indicators (▲/▼) for the comparison period
• New: Five growth insight spotlight cards — Highest Revenue Growth, Most Improved Product, Highest Conversion Growth, Largest Revenue Decline, and Largest Conversion Decline — for instant identification of winners and losers
• New: Interactive Chart.js trend chart with metric tabs (Revenue, Orders, Views, Cart Adds, Conversion %) and Daily/Weekly/Monthly interval switcher
• New: Growing Products table — lists all products with positive growth in the period, sortable by Revenue, Orders, Views, and Conversion; paginated with Screen Options per-page control
• New: Declining Products table — lists all products with declining metrics, same sorting and pagination
• New: Comparison preset tabs — Last 30 Days, Last 7 Days, Today, This Month, and Custom Range; previous period auto-calculated for all presets
• New: Custom Range comparison input for arbitrary date windows; previous period spans the same number of days immediately before
• New: Growth percentage calculated as ((current − previous) / |previous|) × 100; new-to-period products show +100%
• New: All product data fetched in a single SQL query covering both periods using CASE WHEN expressions — no extra database tables required
• New: Most Worsened Product insight card — sixth spotlight showing the product with the steepest overall decline (worst metric highlighted: revenue, orders, or views)
• New: Count badges on Growing / Declining table toggle buttons — shows live product count for each group at a glance
• Improved: Insight spotlight cards use CSS Grid layout — cards distribute evenly across the row with no orphaned single card
• Improved: Product deduplication across all six insight cards — each product appears in at most one growth card and one decline card
• Improved: Growing Products filter requires positive revenue or orders growth (view-only growth no longer qualifies)
• Improved: Sort tiebreaker on all numeric columns — products with equal growth % are ranked by current-period revenue descending
• Improved: Previous Period chart legend entry is hidden automatically when no previous-period data exists for the selected range
• Improved: Conversion KPI card shows an ⓘ tooltip explaining why conversion rate can exceed 100%
• Improved: Long product names truncate with ellipsis in the table; full name visible on hover via title attribute
• No database schema changes — safe to upgrade from any previous version

👉 See this plugin in context with our other products: https://labs.concatstring.com/products/concatstring-revenue-insights-for-woocommerce

1.6.0

• New: Customer Analytics page (WooCommerce → Revenue Insights → Customer Analytics) showing per-customer Orders, Revenue, Avg Order Value, First Order, Last Order, and New/Returning classification
• New: Customer Analytics table is fully sortable on every column (7 columns total)
• New: Customer Analytics supports all existing date range presets (Today, Yesterday, Last 7 Days, Last 30 Days, This Month, Last Month, Custom Range) and All Time view
• New: Search customers by name or email address with URL-persisted filter state
• New: Customer Type filter — All, New (1 order ever), or Returning (2+ orders ever); classification always uses all-time history regardless of the active date filter
• New: Minimum Orders filter — show only customers with at least N total orders in the period
• New: Minimum Revenue filter — show only customers with at least a given revenue total in the period
• New: Customer Analytics dashboard summary section — 5 KPI cards (Total Customers, New Customers, Returning Customers, Avg Revenue/Customer, Avg Orders/Customer) and 3 insight spotlight cards (Highest Spending, Most Orders, Highest Avg Order Value)
• New: Export customer analytics to CSV or Excel (.xlsx) — respects all active date range, search, customer type, min-orders, and min-revenue filters
• New: Registered customer names link to their WordPress profile in the table and insight cards; guest customers identified by billing email address
• New: Row actions for registered customers — Profile and Orders links (HPOS-aware order admin URL)
• New: Friendly empty-state notice when no customer data exists yet
• No database schema changes — safe to upgrade from any previous version

1.5.0

• New: Category Analytics page (WooCommerce → Revenue Insights → Category Analytics) showing per-category Views, Cart Adds, Orders, Revenue, Conversion %, and Performance Status
• New: Category Analytics table is fully sortable on every column
• New: Category Analytics supports all existing date range presets (Today, Yesterday, Last 7 Days, Last 30 Days, This Month, Last Month, Custom Range) and All Time view
• New: Search categories by name with live URL-persisted filter state
• New: Category Status filter — Hide Empty Categories (default) or Show All Categories; persisted in URL
• New: Active Filter Summary chips with individual × remove links for date range and category filters
• New: Category Analytics dashboard summary section — Best Performing, Highest Revenue, and Highest Conversion insight cards above the table
• New: Export category analytics to CSV or Excel (.xlsx) — respects all active date range, search, and category-status filters
• New: Category export generates meaningful filenames with timestamp
• New: Friendly empty-state notice when no category data exists for the selected period
• No database schema changes — safe to upgrade from any previous version

1.4.0

• New: Product Performance Dashboard — a summary section above the analytics table showing five KPI cards (Total Views, Cart Adds, Orders, Total Revenue, Avg Conversion Rate)
• New: Performance Summary row — counts of Strong, Average, Needs Attention, and No Orders/Refunded products for the current filtered set
• New: Insight Cards — automatically identifies your Best Seller (highest revenue), Most Viewed, Highest Conversion, and Needs Attention product for the current filtered set
• New: Dashboard summary responds to all active filters (date range, search, category, type, status, performance, stock) — no duplicate queries
• No database changes — safe to upgrade

1.3.0

• New: Product Category filter — filter the dashboard and exports by WooCommerce product category
• New: Product Type filter — filter by Simple, Variable, Grouped, or External/Affiliate product type; Downloadable and Virtual shown as sub-options matching WooCommerce’s native product list
• New: Product Status filter — filter by Published, Draft, or Private products
• New: Performance Label filter — filter by Strong Performer, Average Performer, Needs Attention, Fully Refunded, or No Orders Yet
• New: Reset All Filters button — clears all product filters in one click while preserving the active date range
• New: Active Filter Summary — date range and product filter chips appear together below the filter controls, each with an individual × remove link
• New: All filters work together in any combination without resetting each other
• New: All filter selections persist in URL params across pagination, sorting, and page refresh
• New: Clicking a date range preset now preserves active product filters (and vice versa)
• New: CSV and Excel exports respect all new filters (category, type, status, performance) in addition to the existing date range, search, and stock filters
• Enhancement: Category dropdown restricted to categories that contain at least one tracked product — no misleading empty categories shown
• Fix: Category filter correctly matches products assigned only to a child category when a parent category is selected
• Fix: Applying a product filter now preserves the active date range — no longer resets to All Time
• Fix: Category dropdown stays populated when a date range filter is active
• Fix: Stock alert icon (⚠) shown for all out-of-stock products, not only strong performers

1.2.0

• New: Export product analytics table to CSV or Excel (.xlsx) directly from the dashboard
• New: Export respects all active filters — date range, product search, and stock status
• New: Export filenames include a Unix timestamp for easy tracking (e.g. revenue-insights-woocommerce-report-1782841012.csv)
• New: Export button with dropdown (Export CSV / Export Excel) shown inside the date filter box
• Fix: Partial refunds through the WooCommerce refund UI now calculate base-currency amounts correctly — previously each partial refund stored the full order base amount, producing incorrect negative net revenue
• Fix: Date-range exports now correctly deduct refunds and cancellations from revenue and order counts, matching the dashboard exactly
• Fix: Export revenue currency label now matches the per-product currency shown on the dashboard instead of always using the store base currency

1.1.0

• New: Advanced date range filters — Today, Yesterday, Last 7 Days, Last 30 Days, This Month, Last Month, and Custom Range
• New: Custom date range picker with client-side and server-side validation (prevents future dates and invalid ranges)
• Fix: Product view tracking now correctly records views from logged-in administrators when WooCommerce ”Coming Soon” mode is active
• Performance: Added database index on created_at column in the events table for efficient date range queries
• Compatibility: Tested with latest WordPress and WooCommerce versions

1.0.0

• Initial release
• Unique product view tracking with configurable session hours
• WooCommerce-style list table with search, sorting, pagination, and Screen Options
• Configurable conversion thresholds and performance status labels
• Multi-currency revenue support with per-currency breakdowns
• Stock status column with stock alert icon for out-of-stock products
• Settings page under WooCommerce
• Weekly email summary for store administrators