wp_azm_woo_abandoned_carts

Static

Stores azm woo abandoned carts data created by this plugin.

Column Definitions

Column	Type	Nullable
visitor_id	varchar(32)	NO
abandoned_timestamp	int(11) unsigned	NO
recovered_timestamp	int(11) unsigned	YES
order_id	int(11) unsigned	YES
user_id	int(11) unsigned	YES
cart_contents	text	NO
cart_total	decimal(10,2) unsigned	YES
status	varchar(20)	YES

CREATE TABLE Statement

CREATE TABLE IF NOT EXISTS wp_azm_woo_abandoned_carts ( visitor_id varchar(32) NOT NULL, abandoned_timestamp int(11) unsigned NOT NULL, recovered_timestamp int(11) unsigned, order_id int(11) unsigned, user_id int(11) unsigned, cart_contents text NOT NULL, cart_total decimal(10,2) unsigned, status varchar(20), PRIMARY KEY abandoned_cart (visitor_id, abandoned_timestamp), KEY user (user_id) ) $collate;");

Safe to delete?

If you have uninstalled Recover Abandoned Cart 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_azm_woo_abandoned_carts`;

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

Other tables from Recover Abandoned Cart for WooCommerce

wp_azm_woo_abandoned_carts_rules