{"slug":"invoiceclerk","name":"InvoiceClerk – Manual Settlement for WooCommerce","description":"Generate batch invoices from WooCommerce orders and manage manual settlements with ease. Perfect for B2B or recurring payment arrangements.","author":"rakibulislamshazol","active_installs":0,"version":"0.1.1","wp_org_url":"https://wordpress.org/plugins/invoiceclerk/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"invoiceclerk_invoice_items","full_table_name":"wp_invoiceclerk_invoice_items","description":"Stores invoiceclerk invoice items data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"invoiceclerk_invoice_order_mapping","full_table_name":"wp_invoiceclerk_invoice_order_mapping","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"invoiceclerk_invoices","full_table_name":"wp_invoiceclerk_invoices","description":"Stores invoiceclerk invoices data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"customer_id","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"invoice_number","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"start_date","type":"date","nullable":false,"primary_key":false},{"name":"end_date","type":"date","nullable":false,"primary_key":false},{"name":"subtotal","type":"decimal(26,8)","nullable":false,"primary_key":false},{"name":"tax_total","type":"decimal(26,8)","nullable":false,"primary_key":false},{"name":"total","type":"decimal(26,8)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false},{"name":"invoice_id","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"order_id","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"item_type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"product_id","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"product_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"quantity","type":"int(11)","nullable":false,"primary_key":false},{"name":"price","type":"decimal(26,8)","nullable":false,"primary_key":false},{"name":"line_total","type":"decimal(26,8)","nullable":false,"primary_key":false},{"name":"invoice_id","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"order_id","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_invoiceclerk_invoices ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, customer_id bigint(20) UNSIGNED NOT NULL, invoice_number varchar(50) NOT NULL, start_date date NOT NULL, end_date date NOT NULL, subtotal decimal(26,8) NOT NULL DEFAULT '0.00000000', tax_total decimal(26,8) NOT NULL DEFAULT '0.00000000', total decimal(26,8) NOT NULL DEFAULT '0.00000000', status varchar(20) NOT NULL DEFAULT 'draft', created_at datetime NOT NULL, updated_at datetime NOT NULL, PRIMARY KEY (id), UNIQUE KEY invoice_number (invoice_number) ) $charset_collate;\"; $table2 = \"CREATE TABLE wp_invoiceclerk_invoice_items ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, invoice_id bigint(20) UNSIGNED NOT NULL, order_id bigint(20) UNSIGNED NOT NULL, item_type varchar(20) NOT NULL DEFAULT 'order', product_id bigint(20) UNSIGNED NOT NULL, product_name varchar(255) NOT NULL, quantity int(11) NOT NULL, price decimal(26,8) NOT NULL DEFAULT '0.00000000', line_total decimal(26,8) NOT NULL DEFAULT '0.00000000', PRIMARY KEY (id), KEY invoice_id (invoice_id) ) $charset_collate;\"; $table3 = \"CREATE TABLE wp_invoiceclerk_invoice_order_mapping ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, invoice_id bigint(20) UNSIGNED NOT NULL, order_id bigint(20) UNSIGNED NOT NULL, PRIMARY KEY (id), UNIQUE KEY order_id (order_id), KEY invoice_id (invoice_id) ) $charset_collate;\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $table1 );"}],"table_count":3}