wp_aieo_sales_predictor
StaticStores aieo sales predictor data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint unsigned | NO |
| grain | varchar(12) | NO |
| product_id | bigint | YES |
| parent_product_id | bigint | YES |
| prediction_date | date | NO |
| current_stock | bigint | YES |
| out_of_stock_days | bigint | YES |
| out_of_stock_repetitions | bigint | YES |
| reorder_date | datetime | YES |
| reorder_quantity | decimal(20,7) | YES |
| price | decimal(20,2) | YES |
| price_before_adjustment | decimal(20,2) | YES |
| price_adjustment_percentage | decimal(20,7) | YES |
| latest_price_adjustment_date | datetime | YES |
| price_update_repetitions | bigint | YES |
| total_product_sales | decimal(20,7) | YES |
| total_product_turnover | decimal(20,7) | YES |
| quantity_sold_yesterday | decimal(20,7) | YES |
| turnover_yesterday | decimal(20,7) | YES |
| quantity_last_7_days | decimal(20,7) | YES |
| quantity_last_14_days | decimal(20,7) | YES |
| quantity_last_28_days | decimal(20,7) | YES |
| quantity_last_56_days | decimal(20,7) | YES |
| quantity_last_175_days | decimal(20,7) | YES |
| quantity_next_7_days | decimal(20,7) | YES |
| quantity_next_14_days | decimal(20,7) | YES |
| quantity_next_28_days | decimal(20,7) | YES |
| quantity_next_56_days | decimal(20,7) | YES |
| quantity_next_175_days | decimal(20,7) | YES |
| turnover_last_7_days | decimal(20,7) | YES |
| turnover_last_14_days | decimal(20,7) | YES |
| turnover_last_28_days | decimal(20,7) | YES |
| turnover_last_56_days | decimal(20,7) | YES |
| turnover_last_175_days | decimal(20,7) | YES |
| turnover_next_7_days | decimal(20,7) | YES |
| turnover_next_14_days | decimal(20,7) | YES |
| turnover_next_28_days | decimal(20,7) | YES |
| turnover_next_56_days | decimal(20,7) | YES |
| turnover_next_175_days | decimal(20,7) | YES |
| items_per_day_last_7_days | decimal(20,7) | YES |
| items_per_day_last_14_days | decimal(20,7) | YES |
| items_per_day_last_28_days | decimal(20,7) | YES |
| items_per_day_last_56_days | decimal(20,7) | YES |
| items_per_day_last_175_days | decimal(20,7) | YES |
| items_per_day_next_7_days | decimal(20,7) | YES |
| items_per_day_next_14_days | decimal(20,7) | YES |
| items_per_day_next_28_days | decimal(20,7) | YES |
| items_per_day_next_56_days | decimal(20,7) | YES |
| items_per_day_next_175_days | decimal(20,7) | YES |
| turnover_per_day_last_7_days | decimal(20,7) | YES |
| turnover_per_day_last_14_days | decimal(20,7) | YES |
| turnover_per_day_last_28_days | decimal(20,7) | YES |
| turnover_per_day_last_56_days | decimal(20,7) | YES |
| turnover_per_day_last_175_days | decimal(20,7) | YES |
| turnover_per_day_next_7_days | decimal(20,7) | YES |
| turnover_per_day_next_14_days | decimal(20,7) | YES |
| turnover_per_day_next_28_days | decimal(20,7) | YES |
| turnover_per_day_next_56_days | decimal(20,7) | YES |
| turnover_per_day_next_175_days | decimal(20,7) | YES |
| product_availability_last_year_7 | tinyint | YES |
| product_availability_last_year_14 | tinyint | YES |
| product_availability_last_year_28 | tinyint | YES |
| product_availability_last_year_56 | tinyint | YES |
| product_availability_last_year_175 | tinyint | YES |
| linear_items_per_day | decimal(20,7) | YES |
| ewma_items_per_day | decimal(20,7) | YES |
| optimistic_estimator_value | decimal(20,7) | YES |
| optimistic_estimator_name | varchar(40) | YES |
| pessimistic_estimator_value | decimal(20,7) | YES |
| pessimistic_estimator_name | varchar(40) | YES |
| average_estimator_value | decimal(20,7) | YES |
| linear_estimator_value | decimal(20,7) | YES |
| ewma_estimator_value | decimal(20,7) | YES |
| days_until_stock_run_out_linear | decimal(20,7) | YES |
| days_until_stock_run_out_ewma | decimal(20,7) | YES |
| estimated_zero_stock_date | datetime | YES |
| days_to_sell_10_units_linear | decimal(20,7) | YES |
| days_to_sell_10_units_ewma | decimal(20,7) | YES |
| estimated_date_to_sell_10_units | datetime | YES |
| optimistic_cost | decimal(20,7) | YES |
| pessimistic_cost | decimal(20,7) | YES |
| average_cost | decimal(20,7) | YES |
| chosen_method | varchar(40) | YES |
| chosen_items_per_day | decimal(20,7) | YES |
| chosen_days_until_runout | decimal(20,7) | YES |
| chosen_zero_stock_date | datetime | YES |
| chosen_estimator_value | decimal(20,7) | YES |
| prediction_confidence | decimal(6,4) | YES |
| reliability_score | decimal(6,4) | YES |
| transactions_total | bigint | YES |
| variation_share_of_parent | decimal(6,4) | YES |
| uses_parent_signal | tinyint | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_aieo_sales_predictor` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `grain` varchar(12) NOT NULL DEFAULT 'variation', `product_id` bigint DEFAULT NULL, `parent_product_id` bigint DEFAULT NULL, `prediction_date` date NOT NULL, `current_stock` bigint DEFAULT NULL, `out_of_stock_days` bigint DEFAULT NULL, `out_of_stock_repetitions` bigint DEFAULT 0, `reorder_date` datetime DEFAULT NULL, `reorder_quantity` decimal(20,7) DEFAULT NULL, `price` decimal(20,2) DEFAULT NULL, `price_before_adjustment` decimal(20,2) DEFAULT NULL, `price_adjustment_percentage` decimal(20,7) DEFAULT NULL, `latest_price_adjustment_date` datetime DEFAULT NULL, `price_update_repetitions` bigint DEFAULT 0, `total_product_sales` decimal(20,7) DEFAULT NULL, `total_product_turnover` decimal(20,7) DEFAULT NULL, `quantity_sold_yesterday` decimal(20,7) DEFAULT NULL, `turnover_yesterday` decimal(20,7) DEFAULT NULL, `quantity_last_7_days` decimal(20,7) DEFAULT NULL, `quantity_last_14_days` decimal(20,7) DEFAULT NULL, `quantity_last_28_days` decimal(20,7) DEFAULT NULL, `quantity_last_56_days` decimal(20,7) DEFAULT NULL, `quantity_last_175_days` decimal(20,7) DEFAULT NULL, `quantity_next_7_days` decimal(20,7) DEFAULT NULL, `quantity_next_14_days` decimal(20,7) DEFAULT NULL, `quantity_next_28_days` decimal(20,7) DEFAULT NULL, `quantity_next_56_days` decimal(20,7) DEFAULT NULL, `quantity_next_175_days` decimal(20,7) DEFAULT NULL, `turnover_last_7_days` decimal(20,7) DEFAULT NULL, `turnover_last_14_days` decimal(20,7) DEFAULT NULL, `turnover_last_28_days` decimal(20,7) DEFAULT NULL, `turnover_last_56_days` decimal(20,7) DEFAULT NULL, `turnover_last_175_days` decimal(20,7) DEFAULT NULL, `turnover_next_7_days` decimal(20,7) DEFAULT NULL, `turnover_next_14_days` decimal(20,7) DEFAULT NULL, `turnover_next_28_days` decimal(20,7) DEFAULT NULL, `turnover_next_56_days` decimal(20,7) DEFAULT NULL, `turnover_next_175_days` decimal(20,7) DEFAULT NULL, `items_per_day_last_7_days` decimal(20,7) DEFAULT NULL, `items_per_day_last_14_days` decimal(20,7) DEFAULT NULL, `items_per_day_last_28_days` decimal(20,7) DEFAULT NULL, `items_per_day_last_56_days` decimal(20,7) DEFAULT NULL, `items_per_day_last_175_days` decimal(20,7) DEFAULT NULL, `items_per_day_next_7_days` decimal(20,7) DEFAULT NULL, `items_per_day_next_14_days` decimal(20,7) DEFAULT NULL, `items_per_day_next_28_days` decimal(20,7) DEFAULT NULL, `items_per_day_next_56_days` decimal(20,7) DEFAULT NULL, `items_per_day_next_175_days` decimal(20,7) DEFAULT NULL, `turnover_per_day_last_7_days` decimal(20,7) DEFAULT NULL, `turnover_per_day_last_14_days` decimal(20,7) DEFAULT NULL, `turnover_per_day_last_28_days` decimal(20,7) DEFAULT NULL, `turnover_per_day_last_56_days` decimal(20,7) DEFAULT NULL, `turnover_per_day_last_175_days` decimal(20,7) DEFAULT NULL, `turnover_per_day_next_7_days` decimal(20,7) DEFAULT NULL, `turnover_per_day_next_14_days` decimal(20,7) DEFAULT NULL, `turnover_per_day_next_28_days` decimal(20,7) DEFAULT NULL, `turnover_per_day_next_56_days` decimal(20,7) DEFAULT NULL, `turnover_per_day_next_175_days` decimal(20,7) DEFAULT NULL, `product_availability_last_year_7` tinyint DEFAULT NULL, `product_availability_last_year_14` tinyint DEFAULT NULL, `product_availability_last_year_28` tinyint DEFAULT NULL, `product_availability_last_year_56` tinyint DEFAULT NULL, `product_availability_last_year_175` tinyint DEFAULT NULL, `linear_items_per_day` decimal(20,7) DEFAULT NULL, `ewma_items_per_day` decimal(20,7) DEFAULT NULL, `optimistic_estimator_value` decimal(20,7) DEFAULT NULL, `optimistic_estimator_name` varchar(40) DEFAULT NULL, `pessimistic_estimator_value` decimal(20,7) DEFAULT NULL, `pessimistic_estimator_name` varchar(40) DEFAULT NULL, `average_estimator_value` decimal(20,7) DEFAULT NULL, `linear_estimator_value` decimal(20,7) DEFAULT NULL, `ewma_estimator_value` decimal(20,7) DEFAULT NULL, `days_until_stock_run_out_linear` decimal(20,7) DEFAULT NULL, `days_until_stock_run_out_ewma` decimal(20,7) DEFAULT NULL, `estimated_zero_stock_date` datetime DEFAULT NULL, `days_to_sell_10_units_linear` decimal(20,7) DEFAULT NULL, `days_to_sell_10_units_ewma` decimal(20,7) DEFAULT NULL, `estimated_date_to_sell_10_units` datetime DEFAULT NULL, `optimistic_cost` decimal(20,7) DEFAULT NULL, `pessimistic_cost` decimal(20,7) DEFAULT NULL, `average_cost` decimal(20,7) DEFAULT NULL, `chosen_method` varchar(40) DEFAULT NULL, `chosen_items_per_day` decimal(20,7) DEFAULT NULL, `chosen_days_until_runout` decimal(20,7) DEFAULT NULL, `chosen_zero_stock_date` datetime DEFAULT NULL, `chosen_estimator_value` decimal(20,7) DEFAULT NULL, `prediction_confidence` decimal(6,4) DEFAULT NULL, `reliability_score` decimal(6,4) DEFAULT NULL, `transactions_total` bigint DEFAULT 0, `variation_share_of_parent` decimal(6,4) DEFAULT NULL, `uses_parent_signal` tinyint DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `uq_grain_product_date` (`grain`,`product_id`,`prediction_date`), KEY `idx_grain_date` (`grain`,`prediction_date`), KEY `idx_current_stock` (`current_stock`), KEY `idx_parent` (`parent_product_id`), KEY `idx_reorder_date` (`reorder_date`) ) ENGINE
Safe to delete?
If you have uninstalled AI eShop Optimizer, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_aieo_sales_predictor`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from AI eShop Optimizer