{"slug":"axemit-import-products-media-seo","name":"aXeMit Import Products, Media & SEO Suite for WooCommerce","description":"Automatic import and synchronization of WooCommerce products from XML and CSV supplier feeds — with Google Shopping support and flexible price rules.","author":"axemit","active_installs":10,"version":"1.3.15","wp_org_url":"https://wordpress.org/plugins/axemit-import-products-media-seo/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"axemit_ipmsseo_brand_mappings","full_table_name":"wp_axemit_ipmsseo_brand_mappings","description":"Stores axemit ipmsseo brand mappings data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"axemit_ipmsseo_category_mappings","full_table_name":"wp_axemit_ipmsseo_category_mappings","description":"Stores axemit ipmsseo category mappings data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"axemit_ipmsseo_image_queue","full_table_name":"wp_axemit_ipmsseo_image_queue","description":"A job queue table for managing background tasks and scheduled operations.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"product_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"supplier_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"image_url","type":"TEXT","nullable":false,"primary_key":false},{"name":"position","type":"TINYINT UNSIGNED","nullable":false,"primary_key":false},{"name":"attempts","type":"TINYINT UNSIGNED","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_axemit_ipmsseo_image_queue ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, product_id BIGINT UNSIGNED NOT NULL, supplier_id BIGINT UNSIGNED NOT NULL, image_url TEXT NOT NULL, position TINYINT UNSIGNED NOT NULL DEFAULT 0, attempts TINYINT UNSIGNED NOT NULL DEFAULT 0, status VARCHAR(20) NOT NULL DEFAULT 'pending', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY product_id (product_id), KEY status_position (status, position), KEY supplier_id (supplier_id) ) $charset;\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql );"},{"table_name":"axemit_ipmsseo_log_errors","full_table_name":"wp_axemit_ipmsseo_log_errors","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"axemit_ipmsseo_logs","full_table_name":"wp_axemit_ipmsseo_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"axemit_ipmsseo_products","full_table_name":"wp_axemit_ipmsseo_products","description":"Stores product records and related data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"axemit_ipmsseo_suppliers","full_table_name":"wp_axemit_ipmsseo_suppliers","description":"Stores axemit ipmsseo suppliers data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"feed_url","type":"TEXT","nullable":false,"primary_key":false},{"name":"feed_type","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"local_file","type":"TEXT","nullable":false,"primary_key":false},{"name":"status","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"sync_interval","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"sync_hour","type":"VARCHAR(5)","nullable":false,"primary_key":false},{"name":"missing_action","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"last_sync","type":"DATETIME","nullable":true,"primary_key":false},{"name":"next_sync","type":"DATETIME","nullable":true,"primary_key":false},{"name":"supplier_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"started_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"finished_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"duration_sec","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"products_new","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"products_updated","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"products_skipped","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"products_errors","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"notes","type":"TEXT","nullable":false,"primary_key":false},{"name":"log_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"sku","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"message","type":"TEXT","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"supplier_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"feed_category","type":"VARCHAR(500)","nullable":false,"primary_key":false},{"name":"product_count","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"seen_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"supplier_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"feed_category","type":"VARCHAR(500)","nullable":false,"primary_key":false},{"name":"wc_term_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"action","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"supplier_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"feed_brand","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"seen_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"supplier_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"feed_brand","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"wc_brand","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"action","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"supplier_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"wc_product_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"feed_sku","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"feed_hash","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"last_seen","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"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 );"},{"table_name":"axemit_ipmsseo_unmapped_brands","full_table_name":"wp_axemit_ipmsseo_unmapped_brands","description":"Stores axemit ipmsseo unmapped brands data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"axemit_ipmsseo_unmapped_categories","full_table_name":"wp_axemit_ipmsseo_unmapped_categories","description":"Stores axemit ipmsseo unmapped categories data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null}],"table_count":9}