{"slug":"dokan-lite","name":"Dokan: AI Powered WooCommerce Multivendor Marketplace Solution – Build Your Own Amazon, eBay, Etsy","description":"Transform your WooCommerce site into a multivendor marketplace with Dokan – an AI powered & advanced WooCommerce marketplace solution","author":"Dokan, Inc.","active_installs":40000,"version":"4.3.3","wp_org_url":"https://wordpress.org/plugins/dokan-lite/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"dokan_announcement","full_table_name":"wp_dokan_announcement","description":"Stores dokan announcement data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"post_id","type":"bigint(11)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(30)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_dokan_announcement` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned NOT NULL, `post_id` bigint(11) NOT NULL, `status` varchar(30) NOT NULL, PRIMARY KEY (id) ) ENGINE"},{"table_name":"dokan_order_stats","full_table_name":"wp_dokan_order_stats","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","columns":[{"name":"order_id","type":"bigint UNSIGNED","nullable":false,"primary_key":false},{"name":"vendor_id","type":"bigint UNSIGNED","nullable":false,"primary_key":false},{"name":"order_type","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"vendor_earning","type":"double","nullable":false,"primary_key":false},{"name":"vendor_gateway_fee","type":"double","nullable":false,"primary_key":false},{"name":"vendor_shipping_fee","type":"double","nullable":false,"primary_key":false},{"name":"vendor_discount","type":"double","nullable":false,"primary_key":false},{"name":"admin_commission","type":"double","nullable":false,"primary_key":false},{"name":"admin_gateway_fee","type":"double","nullable":false,"primary_key":false},{"name":"admin_shipping_fee","type":"double","nullable":false,"primary_key":false},{"name":"admin_discount","type":"double","nullable":false,"primary_key":false},{"name":"admin_subsidy","type":"double","nullable":false,"primary_key":false}],"create_sql":"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"},{"table_name":"dokan_orders","full_table_name":"wp_dokan_orders","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"order_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"seller_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"order_total","type":"decimal(19,4)","nullable":true,"primary_key":false},{"name":"net_amount","type":"decimal(19,4)","nullable":true,"primary_key":false},{"name":"order_status","type":"varchar(30)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_dokan_orders` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `order_id` bigint(20) DEFAULT NULL, `seller_id` bigint(20) DEFAULT NULL, `order_total` decimal(19,4) DEFAULT NULL, `net_amount` decimal(19,4) DEFAULT NULL, `order_status` varchar(30) DEFAULT NULL, PRIMARY KEY (`id`), KEY `order_id` (`order_id`), KEY `seller_id` (`seller_id`) ) ENGINE"},{"table_name":"dokan_product_map","full_table_name":"wp_dokan_product_map","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"dokan_refund","full_table_name":"wp_dokan_refund","description":"Stores dokan refund data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"order_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"seller_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"refund_amount","type":"decimal(19,4)","nullable":false,"primary_key":false},{"name":"refund_reason","type":"text","nullable":true,"primary_key":false},{"name":"item_qtys","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"item_totals","type":"text","nullable":true,"primary_key":false},{"name":"item_tax_totals","type":"text","nullable":true,"primary_key":false},{"name":"restock_items","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"date","type":"timestamp","nullable":false,"primary_key":false},{"name":"status","type":"int(1)","nullable":false,"primary_key":false},{"name":"method","type":"varchar(30)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_dokan_refund` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `order_id` bigint(20) unsigned NOT NULL, `seller_id` bigint(20) NOT NULL, `refund_amount` decimal(19,4) NOT NULL, `refund_reason` text NULL, `item_qtys` varchar(200) NULL, `item_totals` text NULL, `item_tax_totals` text NULL, `restock_items` varchar(10) NULL, `date` timestamp NOT NULL, `status` int(1) NOT NULL, `method` varchar(30) NOT NULL, PRIMARY KEY (id) ) ENGINE"},{"table_name":"dokan_reverse_withdrawal","full_table_name":"wp_dokan_reverse_withdrawal","description":"Stores dokan reverse withdrawal data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"trn_id","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"trn_type","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"vendor_id","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"note","type":"mediumtext","nullable":true,"primary_key":false},{"name":"debit","type":"decimal(19,4)","nullable":false,"primary_key":false},{"name":"credit","type":"decimal(19,4)","nullable":false,"primary_key":false},{"name":"trn_date","type":"int(11) UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_dokan_reverse_withdrawal` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `trn_id` bigint(20) UNSIGNED NOT NULL, `trn_type` varchar(200) NOT NULL DEFAULT 'order_commission', `vendor_id` bigint(20) UNSIGNED NOT NULL, `note` mediumtext DEFAULT NULL, `debit` decimal(19,4) NOT NULL DEFAULT '0.0000', `credit` decimal(19,4) NOT NULL DEFAULT '0.0000', `trn_date` int(11) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `trn_date` (`trn_date`), KEY `vendor_id_trn_date` (`vendor_id`,`trn_date`), KEY `vendor_id` (`vendor_id`), KEY `trn_id_type` (`trn_id`,`trn_type`(191)), KEY `vendor_id_trn_date_type` (`vendor_id`,`trn_date`,`trn_type`(191)) ) ENGINE"},{"table_name":"dokan_vendor_balance","full_table_name":"wp_dokan_vendor_balance","description":"Stores dokan vendor balance data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"vendor_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"trn_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"trn_type","type":"varchar(30)","nullable":false,"primary_key":false},{"name":"perticulars","type":"text","nullable":false,"primary_key":false},{"name":"debit","type":"decimal(19,4)","nullable":false,"primary_key":false},{"name":"credit","type":"decimal(19,4)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(30)","nullable":true,"primary_key":false},{"name":"trn_date","type":"timestamp","nullable":false,"primary_key":false},{"name":"balance_date","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_dokan_vendor_balance` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `vendor_id` bigint(20) unsigned NOT NULL, `trn_id` bigint(20) unsigned NOT NULL, `trn_type` varchar(30) NOT NULL, `perticulars` text NOT NULL, `debit` decimal(19,4) NOT NULL, `credit` decimal(19,4) NOT NULL, `status` varchar(30) DEFAULT NULL, `trn_date` timestamp NOT NULL, `balance_date` timestamp NOT NULL, PRIMARY KEY (id) ) ENGINE"},{"table_name":"dokan_withdraw","full_table_name":"wp_dokan_withdraw","description":"Stores dokan withdraw data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"amount","type":"decimal(19,4)","nullable":false,"primary_key":false},{"name":"date","type":"timestamp","nullable":false,"primary_key":false},{"name":"status","type":"int(1)","nullable":false,"primary_key":false},{"name":"method","type":"varchar(30)","nullable":false,"primary_key":false},{"name":"note","type":"text","nullable":false,"primary_key":false},{"name":"details","type":"longtext","nullable":true,"primary_key":false},{"name":"ip","type":"varchar(50)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_dokan_withdraw` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned NOT NULL, `amount` decimal(19,4) NOT NULL, `date` timestamp NOT NULL, `status` int(1) NOT NULL, `method` varchar(30) NOT NULL, `note` text NOT NULL, `details` longtext DEFAULT NULL, `ip` varchar(50) NOT NULL, PRIMARY KEY (id) ) ENGINE"}],"table_count":8}