wp_axemit_ipmsseo_suppliers
StaticStores axemit ipmsseo suppliers data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| name | VARCHAR(255) | NO |
| feed_url | TEXT | NO |
| feed_type | VARCHAR(10) | NO |
| local_file | TEXT | NO |
| status | TINYINT(1) | NO |
| sync_interval | VARCHAR(20) | NO |
| sync_hour | VARCHAR(5) | NO |
| missing_action | VARCHAR(20) | NO |
| created_at | DATETIME | NO |
| updated_at | DATETIME | NO |
| last_sync | DATETIME | YES |
| next_sync | DATETIME | YES |
| supplier_id | BIGINT UNSIGNED | NO |
| started_at | DATETIME | NO |
| finished_at | DATETIME | YES |
| duration_sec | INT UNSIGNED | YES |
| products_new | INT UNSIGNED | NO |
| products_updated | INT UNSIGNED | NO |
| products_skipped | INT UNSIGNED | NO |
| products_errors | INT UNSIGNED | NO |
| status | VARCHAR(20) | NO |
| notes | TEXT | NO |
| log_id | BIGINT UNSIGNED | NO |
| sku | VARCHAR(255) | NO |
| message | TEXT | NO |
| created_at | DATETIME | NO |
| supplier_id | BIGINT UNSIGNED | NO |
| feed_category | VARCHAR(500) | NO |
| product_count | INT UNSIGNED | NO |
| seen_at | DATETIME | NO |
| supplier_id | BIGINT UNSIGNED | NO |
| feed_category | VARCHAR(500) | NO |
| wc_term_id | BIGINT UNSIGNED | YES |
| action | VARCHAR(20) | NO |
| supplier_id | BIGINT UNSIGNED | NO |
| feed_brand | VARCHAR(255) | NO |
| seen_at | DATETIME | NO |
| supplier_id | BIGINT UNSIGNED | NO |
| feed_brand | VARCHAR(255) | NO |
| wc_brand | VARCHAR(255) | YES |
| action | VARCHAR(20) | NO |
| supplier_id | BIGINT UNSIGNED | NO |
| wc_product_id | BIGINT UNSIGNED | NO |
| feed_sku | VARCHAR(255) | NO |
| feed_hash | VARCHAR(64) | NO |
| last_seen | DATETIME | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_axemit_ipmsseo_suppliers ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL, feed_url TEXT NOT NULL DEFAULT '', feed_type VARCHAR(10) NOT NULL DEFAULT 'xml', local_file TEXT NOT NULL DEFAULT '', status TINYINT(1) NOT NULL DEFAULT 1, sync_interval VARCHAR(20) NOT NULL DEFAULT 'daily', sync_hour VARCHAR(5) NOT NULL DEFAULT '03:00', missing_action VARCHAR(20) NOT NULL DEFAULT 'stock_zero', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, last_sync DATETIME DEFAULT NULL, next_sync DATETIME DEFAULT NULL, PRIMARY KEY (id) ) $charset;"; $sql[] = "CREATE TABLE IF NOT EXISTS wp_axemit_ipmsseo_logs ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, supplier_id BIGINT UNSIGNED NOT NULL, started_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, finished_at DATETIME DEFAULT NULL, duration_sec INT UNSIGNED DEFAULT NULL, products_new INT UNSIGNED NOT NULL DEFAULT 0, products_updated INT UNSIGNED NOT NULL DEFAULT 0, products_skipped INT UNSIGNED NOT NULL DEFAULT 0, products_errors INT UNSIGNED NOT NULL DEFAULT 0, status VARCHAR(20) NOT NULL DEFAULT 'running', notes TEXT NOT NULL DEFAULT '', PRIMARY KEY (id), KEY supplier_id (supplier_id) ) $charset;"; $sql[] = "CREATE TABLE IF NOT EXISTS wp_axemit_ipmsseo_log_errors ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, log_id BIGINT UNSIGNED NOT NULL, sku VARCHAR(255) NOT NULL DEFAULT '', message TEXT NOT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY log_id (log_id) ) $charset;"; $sql[] = "CREATE TABLE IF NOT EXISTS wp_axemit_ipmsseo_unmapped_categories ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, supplier_id BIGINT UNSIGNED NOT NULL, feed_category VARCHAR(500) NOT NULL, product_count INT UNSIGNED NOT NULL DEFAULT 0, seen_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY supplier_cat (supplier_id, feed_category(255)) ) $charset;"; $sql[] = "CREATE TABLE IF NOT EXISTS wp_axemit_ipmsseo_category_mappings ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, supplier_id BIGINT UNSIGNED NOT NULL, feed_category VARCHAR(500) NOT NULL, wc_term_id BIGINT UNSIGNED DEFAULT NULL, action VARCHAR(20) NOT NULL DEFAULT 'map', PRIMARY KEY (id), UNIQUE KEY supplier_feed (supplier_id, feed_category(255)) ) $charset;"; $sql[] = "CREATE TABLE IF NOT EXISTS wp_axemit_ipmsseo_unmapped_brands ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, supplier_id BIGINT UNSIGNED NOT NULL, feed_brand VARCHAR(255) NOT NULL, seen_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY supplier_brand (supplier_id, feed_brand) ) $charset;"; $sql[] = "CREATE TABLE IF NOT EXISTS wp_axemit_ipmsseo_brand_mappings ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, supplier_id BIGINT UNSIGNED NOT NULL, feed_brand VARCHAR(255) NOT NULL, wc_brand VARCHAR(255) DEFAULT NULL, action VARCHAR(20) NOT NULL DEFAULT 'map', PRIMARY KEY (id), UNIQUE KEY supplier_brand (supplier_id, feed_brand) ) $charset;"; $sql[] = "CREATE TABLE IF NOT EXISTS wp_axemit_ipmsseo_products ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, supplier_id BIGINT UNSIGNED NOT NULL, wc_product_id BIGINT UNSIGNED NOT NULL, feed_sku VARCHAR(255) NOT NULL, feed_hash VARCHAR(64) NOT NULL DEFAULT '', last_seen DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY supplier_sku (supplier_id, feed_sku), KEY wc_product_id (wc_product_id) ) $charset;"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; foreach ( $sql as $query ) { dbDelta( $query );Safe to delete?
If you have uninstalled aXeMit Import Products, Media & SEO Suite for WooCommerce, 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_axemit_ipmsseo_suppliers`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from aXeMit Import Products, Media & SEO Suite for WooCommerce