wp_dokan_order_stats
StaticStores order records and related transaction data.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| order_id | bigint UNSIGNED | NO |
| vendor_id | bigint UNSIGNED | NO |
| order_type | tinyint(1) | NO |
| vendor_earning | double | NO |
| vendor_gateway_fee | double | NO |
| vendor_shipping_fee | double | NO |
| vendor_discount | double | NO |
| admin_commission | double | NO |
| admin_gateway_fee | double | NO |
| admin_shipping_fee | double | NO |
| admin_discount | double | NO |
| admin_subsidy | double | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_dokan_order_stats` ( `order_id` bigint UNSIGNED NOT NULL, `vendor_id` bigint UNSIGNED NOT NULL DEFAULT '0', `order_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0 = Dokan Parent Order, 1 = Dokan Single Vendor Order, 2 = Dokan Suborder, 3 = Refund of Dokan Parent Order, 4 = Refund of Dokan Suborder, 5 = Refund of Dokan Single Order', `vendor_earning` double NOT NULL DEFAULT '0', `vendor_gateway_fee` double NOT NULL DEFAULT '0', `vendor_shipping_fee` double NOT NULL DEFAULT '0', `vendor_discount` double NOT NULL DEFAULT '0', `admin_commission` double NOT NULL DEFAULT '0', `admin_gateway_fee` double NOT NULL DEFAULT '0', `admin_shipping_fee` double NOT NULL DEFAULT '0', `admin_discount` double NOT NULL DEFAULT '0', `admin_subsidy` double NOT NULL DEFAULT '0', PRIMARY KEY (order_id), KEY vendor_id (vendor_id), KEY order_type (order_type) ) ENGINE
Safe to delete?
If you have uninstalled Dokan: AI Powered WooCommerce Multivendor Marketplace Solution – Build Your Own Amazon, eBay, Etsy, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_dokan_order_stats`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Dokan: AI Powered WooCommerce Multivendor Marketplace Solution – Build Your Own Amazon, eBay, Etsy