{"slug":"botbee-webhook-automation","name":"BotBee Webhook Automation for WooCommerce","description":"Connect WooCommerce with WhatsApp, AI agents, CRMs, and advanced webhook automations using BotBee.","author":"BotBee AI Labs","active_installs":0,"version":"1.3.0","wp_org_url":"https://wordpress.org/plugins/botbee-webhook-automation/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"botbee_abandoned_carts","full_table_name":"wp_botbee_abandoned_carts","description":"Stores botbee abandoned carts data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"user_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"session_key","type":"VARCHAR(200)","nullable":false,"primary_key":false},{"name":"email","type":"VARCHAR(200)","nullable":true,"primary_key":false},{"name":"phone","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"first_name","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"last_name","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"cart_contents","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"cart_total","type":"DECIMAL(19,4)","nullable":false,"primary_key":false},{"name":"currency","type":"VARCHAR(10)","nullable":true,"primary_key":false},{"name":"applied_coupons","type":"TEXT","nullable":true,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"recover_token","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"coupon_code","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"last_activity","type":"DATETIME","nullable":false,"primary_key":false},{"name":"abandoned_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"recovered_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"notified_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"stage","type":"TINYINT","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"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;\" );"},{"table_name":"botbee_logs","full_table_name":"wp_botbee_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"webhook_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"event_key","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"event_id","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"request_url","type":"TEXT","nullable":false,"primary_key":false},{"name":"request_headers","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"request_body","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"response_code","type":"SMALLINT","nullable":true,"primary_key":false},{"name":"response_body","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"duration_ms","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"retry_num","type":"TINYINT","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_botbee_logs ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, webhook_id BIGINT UNSIGNED NOT NULL, event_key VARCHAR(100) NOT NULL, event_id VARCHAR(100) NOT NULL DEFAULT '', request_url TEXT NOT NULL, request_headers LONGTEXT, request_body LONGTEXT, response_code SMALLINT DEFAULT NULL, response_body LONGTEXT, duration_ms INT UNSIGNED DEFAULT NULL, status VARCHAR(20) NOT NULL DEFAULT 'pending', retry_num TINYINT NOT NULL DEFAULT 0, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY webhook_id (webhook_id), KEY event_key (event_key), KEY status (status), KEY created_at (created_at) ) $charset;\" );"},{"table_name":"botbee_queue","full_table_name":"wp_botbee_queue","description":"A job queue table for managing background tasks and scheduled operations.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"webhook_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"event_key","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"event_id","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"payload","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"headers","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"run_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_botbee_queue ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, webhook_id BIGINT UNSIGNED NOT NULL, event_key VARCHAR(100) NOT NULL, event_id VARCHAR(100) NOT NULL DEFAULT '', payload LONGTEXT NOT NULL, headers LONGTEXT, run_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, status VARCHAR(20) NOT NULL DEFAULT 'pending', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY run_at_status (run_at, status), KEY webhook_id (webhook_id) ) $charset;\" );"},{"table_name":"botbee_retry_jobs","full_table_name":"wp_botbee_retry_jobs","description":"A job queue table for managing background tasks and scheduled operations.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"log_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"webhook_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"attempt","type":"TINYINT","nullable":false,"primary_key":false},{"name":"max_attempts","type":"TINYINT","nullable":false,"primary_key":false},{"name":"run_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_botbee_retry_jobs ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, log_id BIGINT UNSIGNED NOT NULL, webhook_id BIGINT UNSIGNED NOT NULL, attempt TINYINT NOT NULL DEFAULT 1, max_attempts TINYINT NOT NULL DEFAULT 3, run_at DATETIME NOT NULL, status VARCHAR(20) NOT NULL DEFAULT 'pending', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY run_at_status (run_at, status), KEY log_id (log_id) ) $charset;\" );"},{"table_name":"botbee_review_requests","full_table_name":"wp_botbee_review_requests","description":"Stores botbee review requests data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"order_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"token","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"trigger_status","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"scheduled_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"sent_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"used_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_botbee_review_requests ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, order_id BIGINT UNSIGNED NOT NULL, status VARCHAR(20) NOT NULL DEFAULT 'pending', token VARCHAR(100) DEFAULT NULL, trigger_status VARCHAR(50) NOT NULL DEFAULT 'completed', scheduled_at DATETIME NOT NULL, sent_at DATETIME DEFAULT NULL, used_at DATETIME DEFAULT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY order_id (order_id), KEY status (status), KEY token (token), KEY scheduled_at (scheduled_at) ) $charset;\" );"},{"table_name":"botbee_shipments","full_table_name":"wp_botbee_shipments","description":"Stores botbee shipments data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"order_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"tracking_number","type":"VARCHAR(200)","nullable":false,"primary_key":false},{"name":"carrier","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"carrier_label","type":"VARCHAR(200)","nullable":false,"primary_key":false},{"name":"shipped_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"shipped_by","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"notes","type":"TEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_botbee_shipments ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, order_id BIGINT UNSIGNED NOT NULL, tracking_number VARCHAR(200) NOT NULL DEFAULT '', carrier VARCHAR(100) NOT NULL DEFAULT '', carrier_label VARCHAR(200) NOT NULL DEFAULT '', shipped_at DATETIME NOT NULL, shipped_by BIGINT UNSIGNED DEFAULT NULL, notes TEXT DEFAULT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY order_id (order_id), KEY carrier (carrier), KEY shipped_at (shipped_at) ) $charset;\" );"},{"table_name":"botbee_webhooks","full_table_name":"wp_botbee_webhooks","description":"Stores botbee webhooks data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"name","type":"VARCHAR(200)","nullable":false,"primary_key":false},{"name":"event_key","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"status","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"url","type":"TEXT","nullable":false,"primary_key":false},{"name":"http_method","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"headers","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"secret","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"payload_tpl","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"conditions","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"delay_secs","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"retry_count","type":"TINYINT","nullable":false,"primary_key":false},{"name":"retry_intervals","type":"TEXT","nullable":true,"primary_key":false},{"name":"sort_order","type":"INT","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_botbee_webhooks ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(200) NOT NULL DEFAULT '', event_key VARCHAR(100) NOT NULL, status TINYINT(1) NOT NULL DEFAULT 1, url TEXT NOT NULL, http_method VARCHAR(10) NOT NULL DEFAULT 'POST', headers LONGTEXT, secret VARCHAR(255) DEFAULT '', payload_tpl LONGTEXT, conditions LONGTEXT, delay_secs INT UNSIGNED NOT NULL DEFAULT 0, retry_count TINYINT NOT NULL DEFAULT 3, retry_intervals TEXT, sort_order INT 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), KEY event_key (event_key), KEY status (status) ) $charset;\" );"}],"table_count":7}