Monthly Overview Metrics
New Products (9) – Count of newly added products from dokan_products table where post_date falls within the current month.
Active Vendors (0) – Count of active vendor accounts from dokan_vendors table where status = ‘active’.
New Vendor Registrations (2) – Count of new vendor entries created in dokan_vendors table during the current month.
New Customers (1) – Count of unique customer IDs from wc_orders table created during the current month.
Recurring Customers (0) – Count of customers with more than one order in the current month from wc_orders table.
Refunds ($0.00) – Sum of refund amounts from dokan_refund table for the current month.
Reviews (0) – Count of product reviews from wp_comments table where comment_type = ‘review’ and comment_date is within the current month.
Order Cancellation Rate (0.00%) – Percentage of orders marked as cancelled in wc_orders table within the current month.
Support Tickets (0) – Count of open support tickets from Dokan Support Module for the current month.
Abuse Reports (0) – Count of abuse reports submitted by vendors or customers from dokan_reports table for the current month.
Analytics Metrics
Sales Overview – Summarized view of total, net, and commission sales data aggregated from wc_order_stats table.
Revenue Insight – Detailed reporting of revenue growth, commissions, and trends from dokan_orders and wc_order_stats.
Vendor Metrics
Verified Vendors (0) – Count of vendors with verification status approved in dokan_verifications table.
Subscribed Vendors (0) – Count of vendors with active subscriptions in dokan_subscriptions table where status = ‘active’.
Vendors on Vacation (0) – Count of vendors with vacation mode enabled in dokan_vendor_settings table where is_vacation = 1.
All-Time Marketplace Stats
Total Products (18) – Total count of published products from dokan_products table where post_status = ‘publish’.
Total Vendors (3) – Count of all registered vendors from dokan_vendors table.
Total Customers (1) – Count of distinct customer IDs found in wc_orders table.
Total Orders (5) – Count of all completed orders from wc_orders table.
Total Sales ($0.00) – Sum of total_sales value from dokan_orders table.
Total Commissions ($0.00) – Sum of admin commission amounts calculated from dokan_commissions table.
Daily Sales Chart
Total Sales – Daily total sales sum from wc_order_stats.
Net Sales – Daily sales after deducting refunds and commission from wc_order_stats.
Commissions – Admin commission earned per day calculated from dokan_commissions.
Top Performing Vendors
Rank, Vendor Name, Total Earning, Total Orders, Total Commission – Calculated based on data from dokan_commissions and wc_order_stats, ordered by highest earnings within the selected date range.
Most Reviewed Products
Rank, Product Name, Review Count – Count of approved product reviews from wp_comments table grouped by comment_post_ID and ordered by review count (descending).
Most Reported Vendors
Rank, Vendor Name, Abuse Reports – Count of reports from dokan_reports table grouped by vendor ID where type = ‘vendor’ and ordered by total report count.