{"slug":"fin-accounting-for-woocommerce","name":"Finpose – Accounting for WooCommerce","description":"Accounting and financial tracking tool for online stores. Track your costs, expenses, taxes and sales for timeframes you can choose.","author":"Ozgur","active_installs":400,"version":"4.5.2","wp_org_url":"https://wordpress.org/plugins/fin-accounting-for-woocommerce/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":true},"tables":[{"table_name":"fin_costs","full_table_name":"wp_fin_costs","description":"Stores fin costs data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"coid","type":"varchar(8)","nullable":false,"primary_key":false},{"name":"siteid","type":"tinyint(4)","nullable":false,"primary_key":false},{"name":"vid","type":"int(11)","nullable":false,"primary_key":false},{"name":"poid","type":"int(11)","nullable":false,"primary_key":false},{"name":"type","type":"enum('cost', 'expense', 'acquisition')","nullable":false,"primary_key":false},{"name":"cat","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"paidwith","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"items","type":"varchar(512)","nullable":false,"primary_key":false},{"name":"amount","type":"float(11,2)","nullable":false,"primary_key":false},{"name":"tr","type":"float(11,2)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(128)","nullable":false,"primary_key":false},{"name":"notes","type":"varchar(512)","nullable":false,"primary_key":false},{"name":"datepaid","type":"int(11)","nullable":false,"primary_key":false},{"name":"timecr","type":"int(11)","nullable":false,"primary_key":false},{"name":"attfile","type":"varchar(512)","nullable":true,"primary_key":false},{"name":"siteid","type":"tinyint(4)","nullable":false,"primary_key":false},{"name":"vid","type":"int(11)","nullable":false,"primary_key":false},{"name":"pid","type":"int(11)","nullable":false,"primary_key":false},{"name":"is_sold","type":"enum('0', '1')","nullable":false,"primary_key":false},{"name":"cost","type":"float(11,2)","nullable":false,"primary_key":false},{"name":"soldprice","type":"float(11,2)","nullable":false,"primary_key":false},{"name":"timecr","type":"int(11)","nullable":false,"primary_key":false},{"name":"timesold","type":"int(11)","nullable":false,"primary_key":false},{"name":"data","type":"text","nullable":false,"primary_key":false},{"name":"siteid","type":"tinyint(4)","nullable":false,"primary_key":false},{"name":"tfrom","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"tto","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"amount","type":"float(11,2)","nullable":false,"primary_key":false},{"name":"notes","type":"varchar(256)","nullable":false,"primary_key":false},{"name":"datetransfer","type":"int(11)","nullable":false,"primary_key":false},{"name":"timecr","type":"int(11)","nullable":false,"primary_key":false},{"name":"siteid","type":"tinyint(4)","nullable":false,"primary_key":false},{"name":"payid","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"amount","type":"float(11,2)","nullable":false,"primary_key":false},{"name":"notes","type":"varchar(256)","nullable":false,"primary_key":false},{"name":"datepaid","type":"int(11)","nullable":false,"primary_key":false},{"name":"timecr","type":"int(11)","nullable":false,"primary_key":false},{"name":"siteid","type":"tinyint","nullable":false,"primary_key":false},{"name":"vname","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"timecr","type":"int","nullable":false,"primary_key":true},{"name":"vid","type":"int","nullable":false,"primary_key":false},{"name":"siteid","type":"tinyint","nullable":false,"primary_key":false},{"name":"title","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"status","type":"enum('paid','unpaid','partial')","nullable":false,"primary_key":false},{"name":"stype","type":"varchar(16)","nullable":false,"primary_key":false},{"name":"scat","type":"varchar(16)","nullable":false,"primary_key":false},{"name":"amount","type":"float(11,2)","nullable":false,"primary_key":false},{"name":"timecr","type":"int","nullable":false,"primary_key":false},{"name":"timedue","type":"int","nullable":false,"primary_key":false},{"name":"attfile","type":"varchar(512)","nullable":false,"primary_key":false},{"name":"notes","type":"varchar(512)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `fin_costs` ( `coid` varchar(8) NOT NULL, `siteid` tinyint(4) NOT NULL DEFAULT '0', `vid` int(11) NOT NULL DEFAULT '0', `poid` int(11) NOT NULL DEFAULT '0', `type` enum('cost', 'expense', 'acquisition') NOT NULL, `cat` varchar(32) NOT NULL, `paidwith` varchar(32) NOT NULL, `items` varchar(512) NOT NULL DEFAULT '.', `amount` float(11,2) NOT NULL, `tr` float(11,2) NOT NULL DEFAULT '0.00', `name` varchar(128) NOT NULL, `notes` varchar(512) NOT NULL DEFAULT '', `datepaid` int(11) NOT NULL, `timecr` int(11) NOT NULL, `attfile` varchar(512) DEFAULT NULL, UNIQUE KEY coid (coid) ) $charset_collate;\"; $sql .= \"CREATE TABLE `fin_inventory` ( `iid` varchar(8) NOT NULL, `siteid` tinyint(4) NOT NULL DEFAULT '0', `vid` int(11) NOT NULL DEFAULT '0', `pid` int(11) NOT NULL, `is_sold` enum('0', '1') NOT NULL DEFAULT '0', `cost` float(11,2) NOT NULL, `soldprice` float(11,2) NOT NULL, `timecr` int(11) NOT NULL, `timesold` int(11) NOT NULL, `data` text NOT NULL, UNIQUE KEY iid (iid) ) $charset_collate;\"; $sql .= \"CREATE TABLE `fin_transfers` ( `trid` varchar(8) NOT NULL, `siteid` tinyint(4) NOT NULL DEFAULT '0', `tfrom` varchar(32) NOT NULL, `tto` varchar(32) NOT NULL, `amount` float(11,2) NOT NULL, `notes` varchar(256) NOT NULL, `datetransfer` int(11) NOT NULL, `timecr` int(11) NOT NULL, UNIQUE KEY trid (trid) ) $charset_collate;\"; $sql .= \"CREATE TABLE `fin_taxpaid` ( `tid` varchar(8) NOT NULL, `siteid` tinyint(4) NOT NULL DEFAULT '0', `payid` varchar(64) NOT NULL, `amount` float(11,2) NOT NULL, `notes` varchar(256) NOT NULL, `datepaid` int(11) NOT NULL, `timecr` int(11) NOT NULL, UNIQUE KEY tid (tid) ) $charset_collate;\"; $sql .= \"CREATE TABLE `fin_vendors` ( `vid` int NOT NULL AUTO_INCREMENT PRIMARY KEY, `siteid` tinyint NOT NULL DEFAULT '0', `vname` varchar(64) NOT NULL, `timecr` int NOT NULL ) $charset_collate;\"; $sql .= \"CREATE TABLE `fin_purchase_orders` ( `poid` int NOT NULL AUTO_INCREMENT PRIMARY KEY, `vid` int NOT NULL, `siteid` tinyint NOT NULL DEFAULT '0', `title` varchar(64) NOT NULL, `status` enum('paid','unpaid','partial') NOT NULL DEFAULT 'unpaid', `stype` varchar(16) NOT NULL, `scat` varchar(16) NOT NULL, `amount` float(11,2) NOT NULL, `timecr` int NOT NULL, `timedue` int NOT NULL, `attfile` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `notes` varchar(512) NOT NULL ) $charset_collate;\"; if ( ! function_exists('dbDelta') ) { require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );"}],"table_count":1}