{"slug":"keskintech-marketplaces","name":"Keskintech Marketplaces","description":"Sync WooCommerce products, orders and stock with online marketplaces via real-time API or XLSX/CSV template export — all from one panel.","author":"Keskintech","active_installs":0,"version":"1.4","wp_org_url":"https://wordpress.org/plugins/keskintech-marketplaces/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"ktmp_cron_jobs","full_table_name":"wp_ktmp_cron_jobs","description":"A job queue table for managing background tasks and scheduled operations.","detection_method":"static","confidence":"medium","columns":[{"name":"cron_id","type":"INT","nullable":false,"primary_key":true},{"name":"statu","type":"ENUM('active','paused','expired')","nullable":false,"primary_key":false},{"name":"cron_type","type":"ENUM('update','order')","nullable":false,"primary_key":false},{"name":"interval_time","type":"ENUM('ten_minutes','twenty_minutes','thirty_minutes','one_hour','four_hours','twelve_hours','twenty_four_hours')","nullable":false,"primary_key":false},{"name":"marketplace_id","type":"INT","nullable":false,"primary_key":false},{"name":"file_name","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"role","type":"ENUM('amazon','ebay','alibaba','etsy','walmart','trendyol','n11','hepsiburada','pazarama','ciceksepeti','pttavm')","nullable":false,"primary_key":false},{"name":"cron_name","type":"VARCHAR(100)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_ktmp_cron_jobs ( cron_id INT NOT NULL AUTO_INCREMENT, statu ENUM('active','paused','expired') NOT NULL, cron_type ENUM('update','order') NOT NULL, interval_time ENUM('ten_minutes','twenty_minutes','thirty_minutes','one_hour','four_hours','twelve_hours','twenty_four_hours') NOT NULL, marketplace_id INT NOT NULL, file_name VARCHAR(100) NOT NULL, role ENUM('amazon','ebay','alibaba','etsy','walmart','trendyol','n11','hepsiburada','pazarama','ciceksepeti','pttavm') NOT NULL, cron_name VARCHAR(100) NOT NULL, PRIMARY KEY (cron_id), INDEX idx_full (statu, marketplace_id) ) ENGINE"},{"table_name":"ktmp_logs","full_table_name":"wp_ktmp_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"MEDIUMINT(9)","nullable":false,"primary_key":true},{"name":"task_id","type":"MEDIUMINT(9)","nullable":true,"primary_key":false},{"name":"error_message","type":"TEXT","nullable":false,"primary_key":false},{"name":"error_code","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"error_time","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_ktmp_logs ( id MEDIUMINT(9) NOT NULL AUTO_INCREMENT, task_id MEDIUMINT(9) DEFAULT NULL, error_message TEXT NOT NULL, error_code VARCHAR(100) DEFAULT NULL, error_time DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, PRIMARY KEY (id) ) ENGINE"},{"table_name":"ktmp_marketplace_meta","full_table_name":"wp_ktmp_marketplace_meta","description":"Stores additional metadata (key-value pairs) for ktmp marketplace records.","detection_method":"static","confidence":"medium","columns":[{"name":"meta_id","type":"INT","nullable":false,"primary_key":true},{"name":"marketplace_id","type":"INT","nullable":false,"primary_key":false},{"name":"meta_key","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"meta_value","type":"VARCHAR(100)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_ktmp_marketplace_meta ( meta_id INT NOT NULL AUTO_INCREMENT, marketplace_id INT NOT NULL, meta_key VARCHAR(100) NOT NULL, meta_value VARCHAR(100) NOT NULL, PRIMARY KEY (meta_id), UNIQUE KEY unique_marketplace_meta (marketplace_id, meta_key) ) ENGINE"},{"table_name":"ktmp_marketplaces","full_table_name":"wp_ktmp_marketplaces","description":"Stores ktmp marketplaces data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"marketplace_id","type":"INT","nullable":false,"primary_key":true},{"name":"market_name","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"role","type":"ENUM('base','amazon','ebay','alibaba','etsy','walmart','trendyol','n11','hepsiburada','pazarama','ciceksepeti','pttavm')","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_ktmp_marketplaces ( marketplace_id INT NOT NULL AUTO_INCREMENT, market_name VARCHAR(100) NOT NULL, role ENUM('base','amazon','ebay','alibaba','etsy','walmart','trendyol','n11','hepsiburada','pazarama','ciceksepeti','pttavm') DEFAULT NULL, PRIMARY KEY (marketplace_id), UNIQUE KEY unique_role (role) ) ENGINE"},{"table_name":"ktmp_matching","full_table_name":"wp_ktmp_matching","description":"Stores ktmp matching data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"match_id","type":"INT","nullable":false,"primary_key":true},{"name":"marketplace_id","type":"INT","nullable":false,"primary_key":false},{"name":"meta_key","type":"ENUM('term','brand','category','att_taxonomy')","nullable":false,"primary_key":false},{"name":"filter","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"valid_categories","type":"TEXT","nullable":true,"primary_key":false},{"name":"parent_mp_attribute","type":"VARCHAR(100)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_ktmp_matching ( match_id INT NOT NULL AUTO_INCREMENT, key_1 VARCHAR(100) NOT NULL, marketplace_id INT NOT NULL, meta_key ENUM('term','brand','category','att_taxonomy') NOT NULL, filter VARCHAR(100) DEFAULT NULL, key_2 VARCHAR(100) NOT NULL, key_2_value VARCHAR(100) DEFAULT NULL, valid_categories TEXT DEFAULT NULL, parent_mp_attribute VARCHAR(100) DEFAULT NULL, PRIMARY KEY (match_id), INDEX idx_marketplace_meta (marketplace_id, meta_key) ) ENGINE"},{"table_name":"ktmp_price_rules","full_table_name":"wp_ktmp_price_rules","description":"Stores ktmp price rules data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"rule_id","type":"INT","nullable":false,"primary_key":true},{"name":"rule_name","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"marketplace_id","type":"INT","nullable":false,"primary_key":false},{"name":"filter_type","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"filter_value","type":"JSON","nullable":true,"primary_key":false},{"name":"sorting_order","type":"INT","nullable":true,"primary_key":false},{"name":"operation_type","type":"ENUM('addition', 'subtraction', 'multiplication', 'division')","nullable":true,"primary_key":false},{"name":"value","type":"DECIMAL(10, 2)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_ktmp_price_rules ( rule_id INT NOT NULL AUTO_INCREMENT, rule_name VARCHAR(100), marketplace_id INT NOT NULL, filter_type VARCHAR(100), filter_value JSON, sorting_order INT, operation_type ENUM('addition', 'subtraction', 'multiplication', 'division'), value DECIMAL(10, 2) NOT NULL, PRIMARY KEY (rule_id), INDEX idx_marketplace_order (marketplace_id, sorting_order) ) ENGINE"},{"table_name":"ktmp_product_prices","full_table_name":"wp_ktmp_product_prices","description":"Stores product records and related data.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT","nullable":false,"primary_key":true},{"name":"product_id","type":"INT","nullable":false,"primary_key":false},{"name":"marketplace_id","type":"INT","nullable":false,"primary_key":false},{"name":"price","type":"DECIMAL(10, 2)","nullable":true,"primary_key":false},{"name":"old_price","type":"DECIMAL(10, 2)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_ktmp_product_prices ( id INT NOT NULL AUTO_INCREMENT, product_id INT NOT NULL, marketplace_id INT NOT NULL, price DECIMAL(10, 2), old_price DECIMAL(10, 2), PRIMARY KEY (id), INDEX idx_marketplace_id (marketplace_id), UNIQUE KEY unique_product_marketplace (product_id, marketplace_id) ) ENGINE"},{"table_name":"ktmp_tax_meta","full_table_name":"wp_ktmp_tax_meta","description":"Stores additional metadata (key-value pairs) for ktmp tax records.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT","nullable":false,"primary_key":true},{"name":"tax_id","type":"INT","nullable":false,"primary_key":false},{"name":"marketplace_id","type":"INT","nullable":false,"primary_key":false},{"name":"tax_rate","type":"DECIMAL(6,3)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_ktmp_tax_meta ( id INT NOT NULL AUTO_INCREMENT, tax_id INT NOT NULL, marketplace_id INT NOT NULL, tax_rate DECIMAL(6,3) NOT NULL, PRIMARY KEY (id), UNIQUE KEY unique_tax_marketplace (tax_id, marketplace_id) ) ENGINE"},{"table_name":"ktmp_taxes","full_table_name":"wp_ktmp_taxes","description":"Stores ktmp taxes data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT","nullable":false,"primary_key":true},{"name":"name","type":"VARCHAR(100)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_ktmp_taxes ( id INT NOT NULL AUTO_INCREMENT, name VARCHAR(100) NOT NULL, PRIMARY KEY (id) ) ENGINE"},{"table_name":"ktmp_templates","full_table_name":"wp_ktmp_templates","description":"Stores ktmp templates data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT","nullable":false,"primary_key":true},{"name":"template_name","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"file_name","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"marketplace_id","type":"INT","nullable":false,"primary_key":false},{"name":"sheet_name","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"template_date","type":"DATETIME","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_ktmp_templates ( id INT NOT NULL AUTO_INCREMENT, template_name VARCHAR(100) NOT NULL, file_name VARCHAR(100) NOT NULL, marketplace_id INT NOT NULL, sheet_name VARCHAR(100) NOT NULL, template_date DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), INDEX idx_marketplace_id (marketplace_id) ) ENGINE"},{"table_name":"ktmp_transactions","full_table_name":"wp_ktmp_transactions","description":"Stores ktmp transactions data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT","nullable":false,"primary_key":true},{"name":"cron_id","type":"INT","nullable":true,"primary_key":false},{"name":"statu","type":"ENUM('created','processing','failed','awaiting_response','completed_no_response','completed')","nullable":false,"primary_key":false},{"name":"type","type":"ENUM('update','order','send')","nullable":false,"primary_key":false},{"name":"file_name","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"transaction_date","type":"DATETIME","nullable":false,"primary_key":false},{"name":"role","type":"ENUM('amazon','ebay','alibaba','etsy','walmart','trendyol','n11','hepsiburada','pazarama','ciceksepeti','pttavm')","nullable":false,"primary_key":false},{"name":"tracking_token","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"retry_count","type":"TINYINT UNSIGNED","nullable":false,"primary_key":false},{"name":"max_retries","type":"TINYINT UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_ktmp_transactions ( id INT NOT NULL AUTO_INCREMENT, cron_id INT DEFAULT NULL, statu ENUM('created','processing','failed','awaiting_response','completed_no_response','completed') NOT NULL, type ENUM('update','order','send') NOT NULL, file_name VARCHAR(100) NOT NULL, transaction_date DATETIME NOT NULL, role ENUM('amazon','ebay','alibaba','etsy','walmart','trendyol','n11','hepsiburada','pazarama','ciceksepeti','pttavm') NOT NULL, tracking_token VARCHAR(100) DEFAULT NULL, retry_count TINYINT UNSIGNED NOT NULL DEFAULT 0, max_retries TINYINT UNSIGNED NOT NULL DEFAULT 5, PRIMARY KEY (id), INDEX idx_statu_id (statu, id) ) ENGINE"}],"table_count":11}