wp_invoiceclerk_invoices

Static

Stores invoiceclerk invoices data created by this plugin.

Column Definitions

Column	Type	Nullable
🔑id	bigint(20) UNSIGNED	NO
customer_id	bigint(20) UNSIGNED	NO
invoice_number	varchar(50)	NO
start_date	date	NO
end_date	date	NO
subtotal	decimal(26,8)	NO
tax_total	decimal(26,8)	NO
total	decimal(26,8)	NO
status	varchar(20)	NO
created_at	datetime	NO
updated_at	datetime	NO
invoice_id	bigint(20) UNSIGNED	NO
order_id	bigint(20) UNSIGNED	NO
item_type	varchar(20)	NO
product_id	bigint(20) UNSIGNED	NO
product_name	varchar(255)	NO
quantity	int(11)	NO
price	decimal(26,8)	NO
line_total	decimal(26,8)	NO
invoice_id	bigint(20) UNSIGNED	NO
order_id	bigint(20) UNSIGNED	NO

CREATE TABLE Statement

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 );

Safe to delete?

If you have uninstalled InvoiceClerk – Manual Settlement for WooCommerce, 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_invoiceclerk_invoices`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from InvoiceClerk – Manual Settlement for WooCommerce

wp_invoiceclerk_invoice_items wp_invoiceclerk_invoice_order_mapping