wp_botbee_abandoned_carts
StaticStores botbee abandoned carts data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| user_id | BIGINT UNSIGNED | YES |
| session_key | VARCHAR(200) | NO |
| VARCHAR(200) | YES | |
| phone | VARCHAR(50) | YES |
| first_name | VARCHAR(100) | YES |
| last_name | VARCHAR(100) | YES |
| cart_contents | LONGTEXT | NO |
| cart_total | DECIMAL(19,4) | NO |
| currency | VARCHAR(10) | YES |
| applied_coupons | TEXT | YES |
| status | VARCHAR(20) | NO |
| recover_token | VARCHAR(100) | YES |
| coupon_code | VARCHAR(100) | YES |
| last_activity | DATETIME | NO |
| abandoned_at | DATETIME | YES |
| recovered_at | DATETIME | YES |
| notified_at | DATETIME | YES |
| stage | TINYINT | NO |
| created_at | DATETIME | NO |
| updated_at | DATETIME | NO |
CREATE TABLE Statement
CREATE TABLE wp_botbee_abandoned_carts ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT UNSIGNED DEFAULT NULL, session_key VARCHAR(200) NOT NULL DEFAULT '', email VARCHAR(200) DEFAULT NULL, phone VARCHAR(50) DEFAULT NULL, first_name VARCHAR(100) DEFAULT NULL, last_name VARCHAR(100) DEFAULT NULL, cart_contents LONGTEXT NOT NULL, cart_total DECIMAL(19,4) NOT NULL DEFAULT '0.0000', currency VARCHAR(10) DEFAULT NULL, applied_coupons TEXT, status VARCHAR(20) NOT NULL DEFAULT 'active', recover_token VARCHAR(100) DEFAULT NULL, coupon_code VARCHAR(100) DEFAULT NULL, last_activity DATETIME NOT NULL, abandoned_at DATETIME DEFAULT NULL, recovered_at DATETIME DEFAULT NULL, notified_at DATETIME DEFAULT NULL, stage TINYINT NOT NULL DEFAULT 0, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY session_key (session_key), KEY user_id (user_id), KEY email (email), KEY status (status), KEY abandoned_at (abandoned_at) ) $charset;" );
Safe to delete?
If you have uninstalled BotBee Webhook Automation 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_botbee_abandoned_carts`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from BotBee Webhook Automation for WooCommerce