wp_ec_abandoned_cart
StaticStores ec abandoned cart data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑abandoned_cart_id | int(11) | NO |
| session_id | varchar(191) | NO |
| varchar(255) | NO | |
| first_name | varchar(255) | NO |
| last_name | varchar(255) | NO |
| user_id | int(11) | NO |
| phone | varchar(64) | NO |
| status | varchar(20) | NO |
| stage | varchar(20) | NO |
| items_json | longtext | YES |
| item_count | int(11) | NO |
| subtotal | decimal(12,2) | NO |
| currency | varchar(8) | NO |
| coupon_code | varchar(64) | NO |
| shipping_country | varchar(8) | NO |
| locale | varchar(16) | NO |
| card_error | varchar(255) | NO |
| first_seen | datetime | YES |
| last_activity | datetime | YES |
| abandoned_at | datetime | YES |
| recovered_at | datetime | YES |
| recovered_order_id | int(11) | NO |
| recovered_total | decimal(12,2) | NO |
| sequence_step | int(11) | NO |
| next_send_at | datetime | YES |
| offer_code_id | int(11) | NO |
| offer_code | varchar(64) | NO |
| offer_code_expires | datetime | YES |
| admin_notes | text | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS ec_abandoned_cart ( abandoned_cart_id int(11) NOT NULL AUTO_INCREMENT, session_id varchar(191) NOT NULL DEFAULT '', email varchar(255) NOT NULL DEFAULT '', first_name varchar(255) NOT NULL DEFAULT '', last_name varchar(255) NOT NULL DEFAULT '', user_id int(11) NOT NULL DEFAULT '0', phone varchar(64) NOT NULL DEFAULT '', status varchar(20) NOT NULL DEFAULT 'active', stage varchar(20) NOT NULL DEFAULT 'cart', items_json longtext, item_count int(11) NOT NULL DEFAULT '0', subtotal decimal(12,2) NOT NULL DEFAULT '0.00', currency varchar(8) NOT NULL DEFAULT '', coupon_code varchar(64) NOT NULL DEFAULT '', shipping_country varchar(8) NOT NULL DEFAULT '', locale varchar(16) NOT NULL DEFAULT '', card_error varchar(255) NOT NULL DEFAULT '', first_seen datetime DEFAULT NULL, last_activity datetime DEFAULT NULL, abandoned_at datetime DEFAULT NULL, recovered_at datetime DEFAULT NULL, recovered_order_id int(11) NOT NULL DEFAULT '0', recovered_total decimal(12,2) NOT NULL DEFAULT '0.00', sequence_step int(11) NOT NULL DEFAULT '0', next_send_at datetime DEFAULT NULL, offer_code_id int(11) NOT NULL DEFAULT '0', offer_code varchar(64) NOT NULL DEFAULT '', offer_code_expires datetime DEFAULT NULL, admin_notes text, PRIMARY KEY (abandoned_cart_id), UNIQUE KEY session_id (session_id), KEY status_next (status, next_send_at), KEY email (email(100)), KEY last_activity (last_activity), KEY first_seen (first_seen) ) $collate;" );
Safe to delete?
If you have uninstalled WP EasyCart: Shopping Cart and eCommerce Store, 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_ec_abandoned_cart`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from WP EasyCart: Shopping Cart and eCommerce Store