{"slug":"ai-eshop-optimizer","name":"AI eShop Optimizer","description":"AI chat & recommendations with Claude/GPT/Voyage. Works with WooCommerce or standalone. Perfect for e-commerce & corporate sites.","author":"Oxford Metadata Ltd","active_installs":30,"version":"4.2","wp_org_url":"https://wordpress.org/plugins/ai-eshop-optimizer/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"aieo_","full_table_name":"wp_aieo_","description":"Stores aieo  data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_adv_stats_orders_rn","full_table_name":"wp_aieo_adv_stats_orders_rn","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[{"name":"EponymousId","type":"INT","nullable":true,"primary_key":false},{"name":"OrderId","type":"BIGINT","nullable":true,"primary_key":false},{"name":"OrderDate","type":"DATETIME","nullable":true,"primary_key":false},{"name":"OrderItemsTotal","type":"DECIMAL(10,2)","nullable":true,"primary_key":false},{"name":"rn","type":"INT","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_aieo_adv_stats_orders_rn ( EponymousId INT, OrderId BIGINT, OrderDate DATETIME, OrderItemsTotal DECIMAL(10,2), rn INT, INDEX idx_eponymous (EponymousId), INDEX idx_eponymous_rn (EponymousId, rn) ) ENGINE"},{"table_name":"aieo_adv_stats_orders_rn_copy","full_table_name":"wp_aieo_adv_stats_orders_rn_copy","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[{"name":"EponymousId","type":"INT","nullable":true,"primary_key":false},{"name":"OrderId","type":"BIGINT","nullable":true,"primary_key":false},{"name":"OrderDate","type":"DATETIME","nullable":true,"primary_key":false},{"name":"OrderItemsTotal","type":"DECIMAL(10,2)","nullable":true,"primary_key":false},{"name":"rn","type":"INT","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_aieo_adv_stats_orders_rn_copy ( EponymousId INT, OrderId BIGINT, OrderDate DATETIME, OrderItemsTotal DECIMAL(10,2), rn INT, INDEX idx_eponymous (EponymousId), INDEX idx_eponymous_rn (EponymousId, rn) ) ENGINE"},{"table_name":"aieo_ai_models","full_table_name":"wp_aieo_ai_models","description":"Stores aieo ai models data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_base_order_stats","full_table_name":"wp_aieo_base_order_stats","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_chat_business_info","full_table_name":"wp_aieo_chat_business_info","description":"Stores aieo chat business info data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_chat_embeddings","full_table_name":"wp_aieo_chat_embeddings","description":"Stores aieo chat embeddings data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_chat_history","full_table_name":"wp_aieo_chat_history","description":"Stores aieo chat history data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_core_category_brand_popularity","full_table_name":"wp_aieo_core_category_brand_popularity","description":"Stores aieo core category brand popularity data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_core_product_attributes","full_table_name":"wp_aieo_core_product_attributes","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_core_product_category_hierarchy","full_table_name":"wp_aieo_core_product_category_hierarchy","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_core_product_vitals","full_table_name":"wp_aieo_core_product_vitals","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_core_reciprocal_products","full_table_name":"wp_aieo_core_reciprocal_products","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_core_variation_vitals","full_table_name":"wp_aieo_core_variation_vitals","description":"Stores aieo core variation vitals data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_cumulative_customer_stats","full_table_name":"wp_aieo_cumulative_customer_stats","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_customer_stats_progress","full_table_name":"wp_aieo_customer_stats_progress","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_performance_tuning","full_table_name":"wp_aieo_performance_tuning","description":"Stores aieo performance tuning data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INT(11) UNSIGNED","nullable":false,"primary_key":true},{"name":"batch_size","type":"INT(11) UNSIGNED","nullable":false,"primary_key":false},{"name":"processing_time","type":"FLOAT","nullable":false,"primary_key":false},{"name":"total_processing_time","type":"FLOAT","nullable":false,"primary_key":false},{"name":"date_recorded","type":"TIMESTAMP","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_aieo_performance_tuning ( id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, batch_size INT(11) UNSIGNED NOT NULL, processing_time FLOAT NOT NULL, total_processing_time FLOAT NOT NULL, date_recorded TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) )\");"},{"table_name":"aieo_product_need_suggestions","full_table_name":"wp_aieo_product_need_suggestions","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_product_recommendations","full_table_name":"wp_aieo_product_recommendations","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_product_stats_temp","full_table_name":"wp_aieo_product_stats_temp","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_sessions","full_table_name":"wp_aieo_sessions","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_sessions_archive","full_table_name":"wp_aieo_sessions_archive","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_sessions_statics","full_table_name":"wp_aieo_sessions_statics","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_sessions_statics_archive","full_table_name":"wp_aieo_sessions_statics_archive","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_temp_orders","full_table_name":"wp_aieo_temp_orders","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_temp_product_catalogue","full_table_name":"wp_aieo_temp_product_catalogue","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aieo_temp_store_orders","full_table_name":"wp_aieo_temp_store_orders","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"woocommerce_shipping_table_rates","full_table_name":"wp_woocommerce_shipping_table_rates","description":"Stores woocommerce shipping table rates data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":28}