wp_sr_woo_order_items
StaticStores order records and related transaction data.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| product_id | bigint(20) unsigned | NO |
| order_id | bigint(20) unsigned | NO |
| order_date | datetime | NO |
| order_status | text | NO |
| product_name | text | NO |
| sku | text | NO |
| category | text | NO |
| quantity | int(10) unsigned | NO |
| sales | decimal(11,2) | NO |
| discount | decimal(11,2) | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_sr_woo_order_items` ( `product_id` bigint(20) unsigned NOT NULL default '0', `order_id` bigint(20) unsigned NOT NULL default '0', `order_date` datetime NOT NULL default '0000-00-00 00:00:00', `order_status` text NOT NULL, `product_name` text NOT NULL, `sku` text NOT NULL, `category` text NOT NULL, `quantity` int(10) unsigned NOT NULL default '0', `sales` decimal(11,2) NOT NULL default '0.00', `discount` decimal(11,2) NOT NULL default '0.00', KEY `product_id` (`product_id`), KEY `order_id` (`order_id`) ) $collate;"; $wpdb->query($query);
Safe to delete?
If you have uninstalled Smart Reporter For WooCommerce and WP eCommerce, 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_sr_woo_order_items`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Smart Reporter For WooCommerce and WP eCommerce