{"slug":"cartvai-ecommerce","name":"Cartvai – Ecommerce Checkout, Funnel Builder & Shop Manager","description":"WordPress ecommerce plugin with one-page checkout, sales funnels, Gutenberg blocks, products, orders, customers, and analytics. No WooCommerce.","author":"cartvai","active_installs":0,"version":"2.7.14","wp_org_url":"https://wordpress.org/plugins/cartvai-ecommerce/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"cartvai_courier_lookups","full_table_name":"wp_cartvai_courier_lookups","description":"Stores cartvai courier lookups data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"cartvai_fraud_events","full_table_name":"wp_cartvai_fraud_events","description":"Stores cartvai fraud events data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"cartvai_funnel_products","full_table_name":"wp_cartvai_funnel_products","description":"Stores product records and related data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"cartvai_funnels","full_table_name":"wp_cartvai_funnels","description":"Stores cartvai funnels data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"title","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"slug","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"settings_json","type":"longtext","nullable":true,"primary_key":false},{"name":"views","type":"bigint(20) UNSIGNED","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},{"name":"funnel_id","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"product_id","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"variation_id","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"sort_order","type":"int(11)","nullable":false,"primary_key":false},{"name":"customer_id","type":"bigint(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"order_number","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"customer_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"phone","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"email","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"address","type":"text","nullable":true,"primary_key":false},{"name":"district","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"weight","type":"decimal(8,3)","nullable":true,"primary_key":false},{"name":"dimensions","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"notes","type":"text","nullable":true,"primary_key":false},{"name":"subtotal","type":"decimal(12,2)","nullable":false,"primary_key":false},{"name":"shipping","type":"decimal(12,2)","nullable":false,"primary_key":false},{"name":"discount","type":"decimal(12,2)","nullable":false,"primary_key":false},{"name":"total","type":"decimal(12,2)","nullable":false,"primary_key":false},{"name":"paid_amount","type":"decimal(12,2)","nullable":false,"primary_key":false},{"name":"due_amount","type":"decimal(12,2)","nullable":false,"primary_key":false},{"name":"transaction_id","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"payment_method","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"source","type":"text","nullable":true,"primary_key":false},{"name":"ip_address","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"device_fingerprint","type":"varchar(64)","nullable":true,"primary_key":false},{"name":"user_agent","type":"text","nullable":true,"primary_key":false},{"name":"funnel_id","type":"bigint(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"thank_you_token","type":"varchar(64)","nullable":true,"primary_key":false},{"name":"verification_status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"verified_at","type":"datetime","nullable":true,"primary_key":false},{"name":"verified_by","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"attribution","type":"longtext","nullable":true,"primary_key":false},{"name":"deleted_at","type":"datetime","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false},{"name":"order_id","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"product_id","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"product_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"variation_id","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"attributes","type":"text","nullable":true,"primary_key":false},{"name":"price","type":"decimal(12,2)","nullable":false,"primary_key":false},{"name":"quantity","type":"int(11)","nullable":false,"primary_key":false},{"name":"subtotal","type":"decimal(12,2)","nullable":false,"primary_key":false},{"name":"order_id","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"note","type":"text","nullable":false,"primary_key":false},{"name":"author","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"rate","type":"decimal(12,2)","nullable":false,"primary_key":false},{"name":"districts","type":"longtext","nullable":true,"primary_key":false},{"name":"conditions","type":"longtext","nullable":true,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"sort_order","type":"int(11)","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},{"name":"method_key","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"sort_order","type":"int(11)","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},{"name":"order_id","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"gateway_id","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"transaction_id","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"amount","type":"decimal(12,2)","nullable":false,"primary_key":false},{"name":"currency","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(30)","nullable":false,"primary_key":false},{"name":"payment_type","type":"varchar(30)","nullable":false,"primary_key":false},{"name":"raw_response","type":"text","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"gateway_id","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"event_id","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"current_value","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_cartvai_funnels ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, title varchar(255) NOT NULL, slug varchar(255) NOT NULL, settings_json longtext, views bigint(20) UNSIGNED 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 slug (slug) ) $charset_collate;\"; $sql[] = \"CREATE TABLE wp_cartvai_funnel_products ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, funnel_id bigint(20) UNSIGNED NOT NULL, product_id bigint(20) UNSIGNED NOT NULL, variation_id bigint(20) UNSIGNED NOT NULL DEFAULT 0, sort_order int(11) NOT NULL DEFAULT 0, PRIMARY KEY (id), KEY funnel_id (funnel_id), KEY product_id (product_id) ) $charset_collate;\"; $sql[] = \"CREATE TABLE wp_cartvai_orders ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, customer_id bigint(20) UNSIGNED DEFAULT NULL, order_number varchar(50) NOT NULL, customer_name varchar(255) NOT NULL, phone varchar(50) NOT NULL, email varchar(255) DEFAULT NULL, address text, district varchar(100) DEFAULT NULL, weight decimal(8,3) DEFAULT NULL, dimensions varchar(100) DEFAULT NULL, notes text, subtotal decimal(12,2) NOT NULL DEFAULT 0, shipping decimal(12,2) NOT NULL DEFAULT 0, discount decimal(12,2) NOT NULL DEFAULT 0, total decimal(12,2) NOT NULL DEFAULT 0, paid_amount decimal(12,2) NOT NULL DEFAULT 0.00, due_amount decimal(12,2) NOT NULL DEFAULT 0.00, transaction_id varchar(100) DEFAULT NULL, payment_method varchar(50) NOT NULL DEFAULT 'cod', status varchar(50) NOT NULL DEFAULT 'pending', source text DEFAULT NULL, ip_address varchar(45) DEFAULT NULL, device_fingerprint varchar(64) DEFAULT NULL, user_agent text DEFAULT NULL, funnel_id bigint(20) UNSIGNED DEFAULT NULL, thank_you_token varchar(64) DEFAULT NULL, verification_status varchar(20) NOT NULL DEFAULT 'pending', verified_at datetime DEFAULT NULL, verified_by bigint(20) unsigned DEFAULT NULL, attribution longtext NULL, deleted_at datetime DEFAULT NULL, 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 order_number (order_number), KEY customer_id (customer_id), KEY status (status), KEY created_at (created_at), KEY funnel_id (funnel_id), KEY phone (phone), KEY ip_address (ip_address), KEY device_fingerprint (device_fingerprint), KEY thank_you_token (thank_you_token), KEY transaction_id (transaction_id) ) $charset_collate;\"; $sql[] = \"CREATE TABLE wp_cartvai_order_items ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, order_id bigint(20) UNSIGNED NOT NULL, product_id bigint(20) UNSIGNED NOT NULL, product_name varchar(255) NOT NULL, variation_id bigint(20) UNSIGNED NOT NULL DEFAULT 0, attributes text NULL, price decimal(12,2) NOT NULL DEFAULT 0, quantity int(11) NOT NULL DEFAULT 1, subtotal decimal(12,2) NOT NULL DEFAULT 0, PRIMARY KEY (id), KEY order_id (order_id), KEY product_id (product_id) ) $charset_collate;\"; $sql[] = \"CREATE TABLE wp_cartvai_order_notes ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, order_id bigint(20) UNSIGNED NOT NULL, note text NOT NULL, author varchar(255) DEFAULT 'system', created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY order_id (order_id) ) $charset_collate;\"; $sql[] = \"CREATE TABLE wp_cartvai_shipping_zones ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, name varchar(255) NOT NULL, rate decimal(12,2) NOT NULL DEFAULT 0, districts longtext, conditions longtext, status tinyint(1) NOT NULL DEFAULT 1, sort_order int(11) 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 status (status), KEY sort_order (sort_order) ) $charset_collate;\"; $sql[] = \"CREATE TABLE wp_cartvai_payment_methods ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, method_key varchar(50) NOT NULL, name varchar(255) NOT NULL, description text, status tinyint(1) NOT NULL DEFAULT 1, sort_order int(11) 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 method_key (method_key), KEY status (status), KEY sort_order (sort_order) ) $charset_collate;\"; $sql[] = \"CREATE TABLE wp_cartvai_payment_transactions ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, order_id bigint(20) UNSIGNED NOT NULL, gateway_id varchar(50) NOT NULL, transaction_id varchar(100) NOT NULL, amount decimal(12,2) NOT NULL DEFAULT 0.00, currency varchar(10) NOT NULL DEFAULT '', status varchar(30) NOT NULL DEFAULT 'pending', payment_type varchar(30) NOT NULL DEFAULT 'full', raw_response text DEFAULT NULL, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY gateway_transaction (gateway_id, transaction_id), KEY order_id (order_id), KEY gateway_id (gateway_id), KEY status (status) ) $charset_collate;\"; $sql[] = \"CREATE TABLE wp_cartvai_payment_events ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, gateway_id varchar(50) NOT NULL, event_id varchar(100) NOT NULL, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY gateway_event (gateway_id, event_id), KEY created_at (created_at) ) $charset_collate;\"; $sql[] = \"CREATE TABLE wp_cartvai_sequences ( sequence_key varchar(50) NOT NULL, current_value bigint(20) UNSIGNED NOT NULL, updated_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (sequence_key) ) $charset_collate;\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; foreach ( $sql as $query ) { dbDelta( $query );"},{"table_name":"cartvai_order_items","full_table_name":"wp_cartvai_order_items","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"cartvai_order_notes","full_table_name":"wp_cartvai_order_notes","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"cartvai_orders","full_table_name":"wp_cartvai_orders","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"cartvai_payment_events","full_table_name":"wp_cartvai_payment_events","description":"Stores cartvai payment events data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"cartvai_payment_methods","full_table_name":"wp_cartvai_payment_methods","description":"Stores cartvai payment methods data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"cartvai_payment_transactions","full_table_name":"wp_cartvai_payment_transactions","description":"Stores cartvai payment transactions data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"cartvai_pro_courier_lookups","full_table_name":"wp_cartvai_pro_courier_lookups","description":"Stores cartvai pro courier lookups data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"cartvai_sequences","full_table_name":"wp_cartvai_sequences","description":"Stores cartvai sequences data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"cartvai_shipping_zones","full_table_name":"wp_cartvai_shipping_zones","description":"Stores cartvai shipping zones data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null}],"table_count":13}