wp_aieo_store_only_products
StaticStores product records and related data.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑Id | int(11) | NO |
| Soft1Id | bigint(20) unsigned | YES |
| CompanyIds | bigint(20) unsigned | YES |
| Soft1Ids | varchar(120) | YES |
| Soft1ProductName | varchar(930) | YES |
| EshopParentId | bigint(20) unsigned | YES |
| EshopId | bigint(20) unsigned | YES |
| SKU | varchar(230) | YES |
| SKU_norm | varchar(120) | YES |
| Barcode | varchar(60) | YES |
| SupplierId | bigint(20) unsigned | YES |
| regular_price | varchar(10) | YES |
| sale_price | varchar(10) | YES |
| stock | varchar(10) | YES |
| customer_hairdresser_price | varchar(10) | YES |
| customer_makigiaz_price | varchar(10) | YES |
| customer_manicure_price | varchar(10) | YES |
| customer_beautician_price | varchar(10) | YES |
| ContentCreated | datetime | YES |
| ContentLastUpdated | datetime | YES |
| ExcludeFromUpdate | int(11) | YES |
| ProductStatus | int(11) | YES |
| VAT | varchar(10) | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_aieo_store_only_products` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Soft1Id` bigint(20) unsigned DEFAULT NULL, `CompanyIds` bigint(20) unsigned DEFAULT NULL, `Soft1Ids` varchar(120) DEFAULT NULL, `Soft1ProductName` varchar(930) DEFAULT NULL, `EshopParentId` bigint(20) unsigned DEFAULT NULL, `EshopId` bigint(20) unsigned DEFAULT NULL, `SKU` varchar(230) DEFAULT NULL, `SKU_norm` varchar(120) DEFAULT NULL, `Barcode` varchar(60) DEFAULT NULL, `SupplierId` bigint(20) unsigned DEFAULT NULL, `regular_price` varchar(10) DEFAULT NULL, `sale_price` varchar(10) DEFAULT NULL, `stock` varchar(10) DEFAULT NULL, `customer_hairdresser_price` varchar(10) DEFAULT NULL, `customer_makigiaz_price` varchar(10) DEFAULT NULL, `customer_manicure_price` varchar(10) DEFAULT NULL, `customer_beautician_price` varchar(10) DEFAULT NULL, `ContentCreated` datetime DEFAULT current_timestamp(), `ContentLastUpdated` datetime DEFAULT current_timestamp(), `ExcludeFromUpdate` int(11) DEFAULT NULL, `ProductStatus` int(11) DEFAULT NULL, `VAT` varchar(10) DEFAULT NULL, PRIMARY KEY (`Id`), KEY `idx_soft1id` (`Soft1Id`), KEY `idx_eshopid` (`EshopId`), KEY `idx_eshopparentid` (`EshopParentId`), KEY `idx_sku` (`SKU`), KEY `idx_barcode` (`Barcode`), KEY `idx_supplierid` (`SupplierId`), KEY `idx_sku_norm` (`SKU_norm`) ) 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_store_only_products`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from AI eShop Optimizer