{"slug":"api-isarud","name":"API Isarud Tüm Pazar Yerleri Ticaret Entegrasyonu","description":"Trendyol, Etsy, Hepsiburada, N11, Amazon ve Pazarama için tek çatı altında pazaryeri entegrasyonu. WooCommerce'i 6 pazaryeri ile bağlayın, otomat …","author":"Seçkin Sefa Durası","active_installs":10,"version":"6.6.8","wp_org_url":"https://wordpress.org/plugins/api-isarud/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"isarud_","full_table_name":"wp_isarud_","description":"Stores isarud  data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"isarud_abandoned_carts","full_table_name":"wp_isarud_abandoned_carts","description":"Stores isarud abandoned carts data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"isarud_affiliate_log","full_table_name":"wp_isarud_affiliate_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"affiliate_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"order_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"order_total","type":"decimal(14,2)","nullable":true,"primary_key":false},{"name":"commission","type":"decimal(14,2)","nullable":true,"primary_key":false},{"name":"status","type":"enum('pending','approved','paid')","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_isarud_affiliate_log ( id int(11) NOT NULL AUTO_INCREMENT, affiliate_id int(11) NOT NULL, order_id bigint(20) NOT NULL, order_total decimal(14,2) DEFAULT 0, commission decimal(14,2) DEFAULT 0, status enum('pending','approved','paid') DEFAULT 'pending', created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY affiliate_id (affiliate_id) ) {$charset};\");"},{"table_name":"isarud_affiliates","full_table_name":"wp_isarud_affiliates","description":"Stores isarud affiliates data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"email","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"code","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"commission_rate","type":"decimal(5,2)","nullable":true,"primary_key":false},{"name":"total_sales","type":"decimal(14,2)","nullable":true,"primary_key":false},{"name":"total_commission","type":"decimal(14,2)","nullable":true,"primary_key":false},{"name":"is_active","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_isarud_affiliates ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(255) NOT NULL, email varchar(255) NOT NULL, code varchar(50) NOT NULL, commission_rate decimal(5,2) DEFAULT 10, total_sales decimal(14,2) DEFAULT 0, total_commission decimal(14,2) DEFAULT 0, is_active tinyint(1) DEFAULT 1, created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY code (code) ) {$charset};\");"},{"table_name":"isarud_api_credentials","full_table_name":"wp_isarud_api_credentials","description":"Stores isarud api credentials data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"isarud_credentials","full_table_name":"wp_isarud_credentials","description":"Stores isarud credentials data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"marketplace","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"credentials","type":"text","nullable":false,"primary_key":false},{"name":"is_active","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"price_margin","type":"decimal(5,2)","nullable":true,"primary_key":false},{"name":"price_margin_type","type":"enum('percent','fixed')","nullable":true,"primary_key":false},{"name":"auto_sync","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"sync_interval","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"last_test","type":"datetime","nullable":true,"primary_key":false},{"name":"test_status","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"last_sync","type":"datetime","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_isarud_credentials ( id int(11) NOT NULL AUTO_INCREMENT, marketplace varchar(50) NOT NULL, credentials text NOT NULL, is_active tinyint(1) DEFAULT 1, price_margin decimal(5,2) DEFAULT 0, price_margin_type enum('percent','fixed') DEFAULT 'percent', auto_sync tinyint(1) DEFAULT 0, sync_interval varchar(20) DEFAULT 'daily', last_test datetime DEFAULT NULL, test_status varchar(20) DEFAULT NULL, last_sync datetime DEFAULT NULL, created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY marketplace (marketplace) ) {$charset};\");"},{"table_name":"isarud_dropship_suppliers","full_table_name":"wp_isarud_dropship_suppliers","description":"Stores isarud dropship suppliers data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"email","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"api_url","type":"varchar(500)","nullable":true,"primary_key":false},{"name":"api_key","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"auto_forward","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"commission_rate","type":"decimal(5,2)","nullable":true,"primary_key":false},{"name":"is_active","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_isarud_dropship_suppliers ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(255) NOT NULL, email varchar(255), api_url varchar(500), api_key varchar(255), auto_forward tinyint(1) DEFAULT 0, commission_rate decimal(5,2) DEFAULT 0, is_active tinyint(1) DEFAULT 1, created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) {$charset};\");"},{"table_name":"isarud_product_mapping","full_table_name":"wp_isarud_product_mapping","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"isarud_screening_log","full_table_name":"wp_isarud_screening_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"order_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"names_screened","type":"text","nullable":true,"primary_key":false},{"name":"has_match","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"results","type":"text","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_isarud_screening_log ( id int(11) NOT NULL AUTO_INCREMENT, order_id bigint(20) NOT NULL, names_screened text, has_match tinyint(1) DEFAULT 0, results text, created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY order_id (order_id) ) {$charset};\");"},{"table_name":"isarud_sync_log","full_table_name":"wp_isarud_sync_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"product_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"marketplace","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"action","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"message","type":"text","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_isarud_sync_log ( id int(11) NOT NULL AUTO_INCREMENT, product_id bigint(20) NOT NULL, marketplace varchar(50) NOT NULL, action varchar(50) NOT NULL, status varchar(20) NOT NULL, message text, created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY product_marketplace (product_id, marketplace) ) {$charset};\");"}],"table_count":10}