AI eShop Optimizer

AI suite for WooCommerce & WordPress: chat, recommendations, SEO, attribution, merchandising, fulfilment. Anthropic & Voyage AI.

147 database tables

Table Name	Description	Method
wp_aieo_	Stores aieo data created by this plugin.	Static
wp_aieo_ab_impressions	Stores aieo ab impressions data created by this plugin.	Static
wp_aieo_addcart_events	Stores aieo addcart events data created by this plugin.	Static
wp_aieo_addcart_events_archive	Stores aieo addcart events archive 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_cart_items	Stores aieo cart items data created by this plugin.	Static
wp_aieo_carts	Stores aieo carts data created by this plugin.	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_checkout_timing	Stores aieo checkout timing data created by this plugin.	Static
wp_aieo_competition_participants	Stores aieo competition participants data created by this plugin.	Static
wp_aieo_consent_cookies	Stores aieo consent cookies data created by this plugin.	Static
wp_aieo_core_brand_vitals	Stores aieo core brand vitals 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_cumulative_order_stats	Stores order records and related transaction data.	Static
wp_aieo_customer_intelligence	Stores aieo customer intelligence data created by this plugin.	Static
wp_aieo_customer_stats_progress	Stores analytics or statistics data.	Static
wp_aieo_dmm_branch_scan_log	A logging table that records activity, events, or audit history.	Static
wp_aieo_dmm_branches	Stores aieo dmm branches data created by this plugin.	Static
wp_aieo_dmm_brand_discounts	Stores aieo dmm brand discounts data created by this plugin.	Static
wp_aieo_dmm_brand_extras	Stores aieo dmm brand extras data created by this plugin.	Static
wp_aieo_dmm_brand_gift_offers	Stores aieo dmm brand gift offers data created by this plugin.	Static
wp_aieo_dmm_campaigns	Stores aieo dmm campaigns data created by this plugin.	Static
wp_aieo_dmm_cancellation_reasons	Stores aieo dmm cancellation reasons data created by this plugin.	Static
wp_aieo_dmm_category_extras	Stores aieo dmm category extras data created by this plugin.	Static
wp_aieo_dmm_color_attributes	Stores aieo dmm color attributes data created by this plugin.	Static
wp_aieo_dmm_complementary	Stores aieo dmm complementary data created by this plugin.	Static
wp_aieo_dmm_custom_tabs	Stores aieo dmm custom tabs data created by this plugin.	Static
wp_aieo_dmm_discount_schedules	Stores aieo dmm discount schedules data created by this plugin.	Static
wp_aieo_dmm_exchanger_feeds	Stores aieo dmm exchanger feeds data created by this plugin.	Static
wp_aieo_dmm_exchanger_imports	Stores aieo dmm exchanger imports data created by this plugin.	Static
wp_aieo_dmm_exchanger_run_log	A logging table that records activity, events, or audit history.	Static
wp_aieo_dmm_export_jobs	A job queue table for managing background tasks and scheduled operations.	Static
wp_aieo_dmm_feed_configs	Stores aieo dmm feed configs data created by this plugin.	Static
wp_aieo_dmm_fulfillment_checkpoints	Stores aieo dmm fulfillment checkpoints data created by this plugin.	Static
wp_aieo_dmm_fulfillment_closings	Stores aieo dmm fulfillment closings data created by this plugin.	Static
wp_aieo_dmm_fulfillment_documents	Stores aieo dmm fulfillment documents data created by this plugin.	Static
wp_aieo_dmm_fulfillment_sequences	Stores aieo dmm fulfillment sequences data created by this plugin.	Static
wp_aieo_dmm_fulfillment_settings	Stores aieo dmm fulfillment settings data created by this plugin.	Static
wp_aieo_dmm_fulfillment_vouchers	Stores aieo dmm fulfillment vouchers data created by this plugin.	Static
wp_aieo_dmm_loyalty_assignments	Stores aieo dmm loyalty assignments data created by this plugin.	Static
wp_aieo_dmm_loyalty_classes	Stores aieo dmm loyalty classes data created by this plugin.	Static
wp_aieo_dmm_loyalty_points	Stores aieo dmm loyalty points data created by this plugin.	Static
wp_aieo_dmm_need_extras	Stores aieo dmm need extras data created by this plugin.	Static
wp_aieo_dmm_no_free_shipping	Stores aieo dmm no free shipping data created by this plugin.	Static
wp_aieo_dmm_offer_attributions	Stores aieo dmm offer attributions data created by this plugin.	Static
wp_aieo_dmm_offers	Stores aieo dmm offers data created by this plugin.	Static
wp_aieo_dmm_order_cancellations	Stores order records and related transaction data.	Static
wp_aieo_dmm_order_line_refunds	Stores order records and related transaction data.	Static
wp_aieo_dmm_product_behavior_metrics	Stores product records and related data.	Static
wp_aieo_dmm_product_fp	Stores product records and related data.	Static
wp_aieo_dmm_product_needs	Stores product records and related data.	Static
wp_aieo_dmm_promo_slots	Stores aieo dmm promo slots data created by this plugin.	Static
wp_aieo_dmm_promo_surfaces	Stores aieo dmm promo surfaces data created by this plugin.	Static
wp_aieo_dmm_role_prices	Stores aieo dmm role prices data created by this plugin.	Static
wp_aieo_dmm_shipping_rates	Stores aieo dmm shipping rates data created by this plugin.	Static
wp_aieo_dmm_store_order_log	A logging table that records activity, events, or audit history.	Static
wp_aieo_dmm_supplier_extras	Stores aieo dmm supplier extras data created by this plugin.	Static
wp_aieo_dmm_supplier_preorders	Stores aieo dmm supplier preorders data created by this plugin.	Static
wp_aieo_dmm_swatches_cache	A cache table that stores temporary computed or fetched data.	Static
wp_aieo_dmm_swatches_variation_map	Stores aieo dmm swatches variation map data created by this plugin.	Static
wp_aieo_dmm_term_relations	Stores aieo dmm term relations data created by this plugin.	Static
wp_aieo_dmm_user_behavior_metrics	Stores aieo dmm user behavior metrics data created by this plugin.	Static
wp_aieo_dmm_user_fp	Stores aieo dmm user fp data created by this plugin.	Static
wp_aieo_erp_store_customers	Stores aieo erp store customers data created by this plugin.	Static
wp_aieo_erp_store_orders	Stores order records and related transaction data.	Static
wp_aieo_erp_store_products	Stores product records and related data.	Static
wp_aieo_event_participants	Stores aieo event participants data created by this plugin.	Static
wp_aieo_google_locations	Stores aieo google locations data created by this plugin.	Static
wp_aieo_google_reviews	Stores aieo google reviews data created by this plugin.	Static
wp_aieo_google_user_journey	Stores aieo google user journey data created by this plugin.	Static
wp_aieo_moi_inbound_log	A logging table that records activity, events, or audit history.	Static
wp_aieo_moi_order_links	Stores order records and related transaction data.	Static
wp_aieo_moi_vendors	Stores aieo moi vendors data created by this plugin.	Static
wp_aieo_newsletter_sync_log	A logging table that records activity, events, or audit history.	Static
wp_aieo_option_groups	Stores aieo option groups data created by this plugin.	Static
wp_aieo_option_prices	Stores aieo option prices data created by this plugin.	Static
wp_aieo_options	Stores aieo options data created by this plugin.	Static
wp_aieo_order_attribution	Stores order records and related transaction data.	Static
wp_aieo_order_invoice_match_report	Stores order records and related transaction data.	Static
wp_aieo_order_invoice_match_report_current_month	Stores order records and related transaction data.	Static
wp_aieo_order_products_analytics	Stores order records and related transaction data.	Static
wp_aieo_order_stats	Stores order records and related transaction data.	Static
wp_aieo_performance_tuning	Stores aieo performance tuning data created by this plugin.	Static
wp_aieo_price_history	Stores aieo price history data created by this plugin.	Static
wp_aieo_product_need_suggestions	Stores product records and related data.	Static
wp_aieo_product_option_groups	Stores product records and related data.	Static
wp_aieo_product_recommendations	Stores product records and related data.	Static
wp_aieo_product_session_metrics	Stores session data for tracking user or visitor state.	Static
wp_aieo_product_stats_temp	Stores product records and related data.	Static
wp_aieo_push_campaigns	Stores aieo push campaigns data created by this plugin.	Static
wp_aieo_push_caps	Stores aieo push caps data created by this plugin.	Static
wp_aieo_push_dispatch	Stores aieo push dispatch data created by this plugin.	Static
wp_aieo_push_subscriptions	Stores aieo push subscriptions data created by this plugin.	Static
wp_aieo_push_templates	Stores aieo push templates data created by this plugin.	Static
wp_aieo_reciprocal_ids	Stores aieo reciprocal ids data created by this plugin.	Static
wp_aieo_reco_events	Stores aieo reco events data created by this plugin.	Static
wp_aieo_reco_events_archive	Stores aieo reco events archive data created by this plugin.	Static
wp_aieo_reco_reverse_refs	Stores aieo reco reverse refs data created by this plugin.	Static
wp_aieo_recommendations_cache	A cache table that stores temporary computed or fetched data.	Static
wp_aieo_remote_export_state	Stores analytics or statistics data.	Static
wp_aieo_sales_predictor	Stores aieo sales predictor data created by this plugin.	Static
wp_aieo_sales_predictor_accuracy	Stores aieo sales predictor accuracy data created by this plugin.	Static
wp_aieo_sales_predictor_history	Stores aieo sales predictor history data created by this plugin.	Static
wp_aieo_seo_404_log	A logging table that records activity, events, or audit history.	Static
wp_aieo_seo_head_cache	A cache table that stores temporary computed or fetched data.	Static
wp_aieo_seo_opportunities	Stores aieo seo opportunities data created by this plugin.	Static
wp_aieo_seo_posts	Stores aieo seo posts data created by this plugin.	Static
wp_aieo_seo_redirects	Stores aieo seo redirects data created by this plugin.	Static
wp_aieo_seo_scores	Stores aieo seo scores data created by this plugin.	Static
wp_aieo_session_journeys	Stores session data for tracking user or visitor state.	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_sp_queue	A job queue table for managing background tasks and scheduled operations.	Static
wp_aieo_sp_run	Stores aieo sp run data created by this plugin.	Static
wp_aieo_store_only_products	Stores product records and related data.	Static
wp_aieo_survey_intelligence	Stores aieo survey intelligence data created by this plugin.	Static
wp_aieo_survey_responses	Stores aieo survey responses data created by this plugin.	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_aieo_user_vitals	Stores aieo user vitals data created by this plugin.	Static
wp_aieo_waitlist	Stores aieo waitlist data created by this plugin.	Static
wp_aieo_wishlist	Stores aieo wishlist data created by this plugin.	Static
wp_om_no_free_shipping	Stores om no free shipping data created by this plugin.	Static
wp_om_ppe_waitlist	Stores om ppe waitlist data created by this plugin.	Static
wp_om_ppe_wishlist	Stores om ppe wishlist data created by this plugin.	Static
wp_om_role_based_pricing	Stores om role based pricing data created by this plugin.	Static
wp_pods_product_need	Stores product records and related data.	Static
wp_store_board_	Stores store board data created by this plugin.	Static
wp_store_order_status_lookup	Stores order records and related transaction data.	Static
wp_wc_order_operational_data	Stores order records and related transaction data.	Static
wp_wc_orders	Stores order records and related transaction data.	Static
wp_wc_orders_meta	Stores additional metadata (key-value pairs) for wc orders records.	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_commentmeta

Comment meta

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_brand_vitals_tableOption 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_termmeta

Term meta

wp_terms

Custom taxonomy:supplier

wp_usermeta

User meta