AI eShop Optimizer

AI chat & recommendations with Claude/GPT/Voyage. Works with WooCommerce or standalone. Perfect for e-commerce & corporate sites.

28 database tables

Table Name	Description	Method
wp_aieo_	Stores aieo data created by this plugin.	Static
wp_aieo_adv_stats_orders_rn	Stores order records and related transaction data.	Static
wp_aieo_adv_stats_orders_rn_copy	Stores order records and related transaction data.	Static
wp_aieo_ai_models	Stores aieo ai models data created by this plugin.	Static
wp_aieo_base_order_stats	Stores order records and related transaction data.	Static
wp_aieo_chat_business_info	Stores aieo chat business info data created by this plugin.	Static
wp_aieo_chat_embeddings	Stores aieo chat embeddings data created by this plugin.	Static
wp_aieo_chat_history	Stores aieo chat history data created by this plugin.	Static
wp_aieo_core_category_brand_popularity	Stores aieo core category brand popularity data created by this plugin.	Static
wp_aieo_core_product_attributes	Stores product records and related data.	Static
wp_aieo_core_product_category_hierarchy	Stores product records and related data.	Static
wp_aieo_core_product_vitals	Stores product records and related data.	Static
wp_aieo_core_reciprocal_products	Stores product records and related data.	Static
wp_aieo_core_variation_vitals	Stores aieo core variation vitals data created by this plugin.	Static
wp_aieo_cumulative_customer_stats	Stores analytics or statistics data.	Static
wp_aieo_customer_stats_progress	Stores analytics or statistics data.	Static
wp_aieo_performance_tuning	Stores aieo performance tuning data created by this plugin.	Static
wp_aieo_product_need_suggestions	Stores product records and related data.	Static
wp_aieo_product_recommendations	Stores product records and related data.	Static
wp_aieo_product_stats_temp	Stores product records and related data.	Static
wp_aieo_sessions	Stores session data for tracking user or visitor state.	Static
wp_aieo_sessions_archive	Stores session data for tracking user or visitor state.	Static
wp_aieo_sessions_statics	Stores session data for tracking user or visitor state.	Static
wp_aieo_sessions_statics_archive	Stores session data for tracking user or visitor state.	Static
wp_aieo_temp_orders	Stores order records and related transaction data.	Static
wp_aieo_temp_product_catalogue	Stores product records and related data.	Static
wp_aieo_temp_store_orders	Stores order records and related transaction data.	Static
wp_woocommerce_shipping_table_rates	Stores woocommerce shipping table rates data created by this plugin.	Static

Core Table Usage

This plugin stores data in WordPress core tables rather than creating its own. These records may become orphaned if the plugin is uninstalled without a proper cleanup routine.

wp_options

Option key:aieo_analytics_eponymous_id_fieldOption key:aieo_batch_sizeOption key:aieo_batch_sleepOption key:aieo_core_attribute_brandsOption key:aieo_core_attribute_colorOption key:aieo_core_attribute_needOption key:aieo_core_attribute_sizeOption key:aieo_core_category_brand_popularity_tableOption key:aieo_core_product_attributes_tableOption key:aieo_core_product_category_hierarchy_tableOption key:aieo_core_product_vitals_tableOption key:aieo_core_reciprocal_products_tableOption key:aieo_core_variation_vitals_tableOption key:aieo_create_attributesOption key:aieo_create_catalogueOption key:aieo_create_exportOption key:aieo_create_need_suggestionsOption key:aieo_create_needsOption key:aieo_create_ordersOption key:aieo_create_uuidsOption key:aieo_erp_consolidationOption key:aieo_erp_merge_ordersOption key:aieo_erp_store_customers_tableOption key:aieo_erp_store_orders_tableOption key:aieo_erp_store_products_tableOption key:aieo_google_user_journey_tableOption key:aieo_include_aggregate_category_brand_statsOption key:aieo_include_aggregate_cust_adv_statsOption key:aieo_include_aggregate_cust_std_statsOption key:aieo_include_aggregate_statsOption key:aieo_include_attributesOption key:aieo_include_eponymousOption key:aieo_include_full_textOption key:aieo_include_priceOption key:aieo_include_reciprocityOption key:aieo_include_restricted_seasonalityOption key:aieo_include_seasonalityOption key:aieo_include_textOption key:aieo_include_unsoldOption key:aieo_max_recordsOption key:aieo_offline_ordersOption key:aieo_order_idOption key:aieo_season_days_afterOption key:aieo_season_days_pastOption key:aieo_site_orders_tableOption key:aieo_site_prefixOption key:aieo_site_products_tableOption key:aieo_store_orders_tableOption key:aieo_variations_choiceOption key:aieo_version

wp_postmeta

Post meta

wp_usermeta

User meta