get_charset_collate(); require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta("CREATE TABLE {$wpdb->prefix}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};"); dbDelta("CREATE TABLE {$wpdb->prefix}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};"); dbDelta("CREATE TABLE {$wpdb->prefix}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};"); dbDelta("CREATE TABLE {$wpdb->prefix}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};"); dbDelta("CREATE TABLE {$wpdb->prefix}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};"); dbDelta("CREATE TABLE {$wpdb->prefix}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};"); // Schedule cron if (!wp_next_scheduled('isarud_auto_sync_hook')) { wp_schedule_event(time(), 'hourly', 'isarud_auto_sync_hook'); } }); register_deactivation_hook(__FILE__, function() { wp_clear_scheduled_hook('isarud_auto_sync_hook'); wp_clear_scheduled_hook('isarud_cloud_sync_hook'); wp_clear_scheduled_hook('isarud_order_import_cron'); }); // ─── CRON INTERVALS ───────────────────────────── add_filter('cron_schedules', function($schedules) { $schedules['every_15min'] = ['interval' => 900, 'display' => 'Every 15 Minutes']; $schedules['every_6hours'] = ['interval' => 21600, 'display' => 'Every 6 Hours']; return $schedules; }); // ─── AUTO SYNC CRON HANDLER ───────────────────── add_action('isarud_auto_sync_hook', function() { global $wpdb; $mps = $wpdb->get_results("SELECT marketplace, sync_interval, last_sync FROM {$wpdb->prefix}isarud_credentials WHERE auto_sync=1 AND is_active=1"); if (!$mps || !class_exists('WooCommerce')) return; foreach ($mps as $mp) { $interval_seconds = match($mp->sync_interval) { '15min' => 900, 'hourly' => 3600, '6hours' => 21600, 'daily' => 86400, default => 86400, }; if ($mp->last_sync && (time() - strtotime($mp->last_sync)) < $interval_seconds) continue; // Sync all published products with stock management $products = wc_get_products(['status' => 'publish', 'manage_stock' => true, 'limit' => 100]); $plugin = Isarud_Plugin::instance(); foreach ($products as $product) { $plugin->sync_product_smart($product, $mp->marketplace); } $wpdb->update($wpdb->prefix . 'isarud_credentials', ['last_sync' => current_time('mysql')], ['marketplace' => $mp->marketplace]); } }); // ─── MAIN PLUGIN CLASS ────────────────────────── add_action('plugins_loaded', function() { Isarud_Plugin::instance(); Isarud_Cloud_Sync::instance(); Isarud_Webhook::instance(); Isarud_Order_Import::instance(); Isarud_Product_Import::instance(); Isarud_Variation_Sync::instance(); Isarud_Category_Map::instance(); Isarud_Product_Export::instance(); Isarud_Attribute_Map::instance(); Isarud_Excel_Import::instance(); Isarud_Order_Management::instance(); Isarud_Returns::instance(); Isarud_Invoice::instance(); Isarud_Customer_Questions::instance(); Isarud_Brand_Lookup::instance(); }); class Isarud_Plugin { private static $inst = null; public static function instance() { if (!self::$inst) self::$inst = new self(); return self::$inst; } public function __construct() { add_action('admin_menu', [$this, 'admin_menu']); // WP Dashboard Widget add_action('wp_dashboard_setup', function() { wp_add_dashboard_widget('isarud_dashboard_widget', 'Isarud Trade Compliance', function() { global $wpdb; $t = $wpdb->prefix . 'isarud_'; $since = date("Y-m-d H:i:s", strtotime("-24 hours")); $screenings = (int)$wpdb->get_var("SELECT COUNT(*) FROM {$t}screening_log"); $screen_24h = (int)$wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM {$t}screening_log WHERE created_at >= %s", $since)); $matches_24h = (int)$wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM {$t}screening_log WHERE has_match=1 AND created_at >= %s", $since)); $syncs_24h = (int)$wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM {$t}sync_log WHERE status='success' AND created_at >= %s", $since)); $errors_24h = (int)$wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM {$t}sync_log WHERE status='error' AND created_at >= %s", $since)); $active_mp = (int)$wpdb->get_var("SELECT COUNT(*) FROM {$t}credentials WHERE is_active=1"); ?>
0): ?>
get_results($wpdb->prepare( "(SELECT 'screening' as type, entity_name as detail, has_match as status_val, created_at FROM {$t}screening_log WHERE created_at >= %s ORDER BY created_at DESC LIMIT 5) UNION ALL (SELECT 'sync' as type, CONCAT(marketplace, ': ', COALESCE(message,'')) as detail, IF(status='success',1,0) as status_val, created_at FROM {$t}sync_log WHERE created_at >= %s ORDER BY created_at DESC LIMIT 5) ORDER BY created_at DESC LIMIT 5", $since, $since )); if (!empty($recent)): ?>
type === 'screening' ? '' : '') . esc_html(mb_substr($r->detail, 0, 30)); ?> created_at)) . ' ' . __('önce', 'api-isarud'); ?>

admin_url('admin-ajax.php'), 'nonce' => wp_create_nonce('isarud_nonce')]); } // ─── DASHBOARD ────────────────────────────── public function page_dashboard() { global $wpdb; $screenings = (int)$wpdb->get_var("SELECT COUNT(*) FROM {$wpdb->prefix}isarud_screening_log"); $matches = (int)$wpdb->get_var("SELECT COUNT(*) FROM {$wpdb->prefix}isarud_screening_log WHERE has_match=1"); $syncs = (int)$wpdb->get_var("SELECT COUNT(*) FROM {$wpdb->prefix}isarud_sync_log WHERE status='success'"); $errors = (int)$wpdb->get_var("SELECT COUNT(*) FROM {$wpdb->prefix}isarud_sync_log WHERE status='error'"); $creds = $wpdb->get_results("SELECT marketplace, is_active, last_test, test_status, auto_sync, sync_interval, last_sync, price_margin, price_margin_type FROM {$wpdb->prefix}isarud_credentials"); $has_woo = class_exists('WooCommerce'); $has_api_key = !empty(get_option('isarud_api_key')); $cloud_connected = class_exists('Isarud_Cloud_Sync') && Isarud_Cloud_Sync::instance()->is_enabled(); $has_creds = !empty($creds); ?>

Test
marketplace)); ?> is_active ? '● ' . __('Aktif', 'api-isarud') . '' : '○ ' . __('Pasif', 'api-isarud') . ''; ?> auto_sync ? '' . esc_html($c->sync_interval) . '' : '—'; ?> price_margin != 0 ? ($c->price_margin_type === 'percent' ? '%' . $c->price_margin : '$' . $c->price_margin) : '—'; ?> last_sync ? esc_html(human_time_diff(strtotime($c->last_sync))) . ' ' . __('önce', 'api-isarud') : '—'; ?> test_status === 'success' ? '✓' : ($c->test_status === 'error' ? '✗' : '—'); ?>
→
get_status(); ?>

→

→

📱 iOS / macOS App Store ↗ 🖥️ Windows Microsoft Store ↗ 🧩 Chrome Extension Chrome Web Store ↗
🤖 Android
🌐 Web isarud.com ↗

' . __('Ayarlar kaydedildi.', 'api-isarud') . '

'; } ?>

is_enabled(); ?>
Isarud API Key🟢

→

Isarud API Key

→ | →

prefix . 'isarud_credentials'; if (isset($_POST['isarud_save_marketplace']) && wp_verify_nonce($_POST['_wpnonce'], 'isarud_mp')) { $mp = sanitize_text_field($_POST['marketplace']); $creds = []; foreach ($_POST['cred'] ?? [] as $k => $v) $creds[sanitize_text_field($k)] = sanitize_text_field($v); $margin = floatval($_POST['price_margin'] ?? 0); $margin_type = in_array($_POST['price_margin_type'] ?? '', ['percent','fixed']) ? $_POST['price_margin_type'] : 'percent'; $auto_sync = intval($_POST['auto_sync'] ?? 0); $sync_interval = sanitize_text_field($_POST['sync_interval'] ?? 'daily'); $exists = $wpdb->get_var($wpdb->prepare("SELECT id FROM {$table} public function page_etsy() { require ISARUD_DIR . 'includes/etsy-html.php'; } WHERE marketplace=%s", $mp)); $data = ['credentials' => wp_json_encode($creds), 'is_active' => 1, 'price_margin' => $margin, 'price_margin_type' => $margin_type, 'auto_sync' => $auto_sync, 'sync_interval' => $sync_interval]; if ($exists) { $wpdb->update($table, $data, ['marketplace' => $mp]); } else { $data['marketplace'] = $mp; $wpdb->insert($table, $data); } echo '

' . esc_html(ucfirst($mp)) . ' ' . __('kaydedildi.', 'api-isarud') . '

'; } $saved = []; foreach ($wpdb->get_results("SELECT * FROM {$table}") as $r) $saved[$r->marketplace] = $r; $marketplaces = $this->get_marketplace_config(); include ISARUD_DIR . 'includes/marketplaces-html.php'; } // ─── ETSY PAGE ───────────────────────────── public function page_etsy() { require ISARUD_DIR . 'includes/etsy-html.php'; } // ─── BULK SYNC PAGE ───────────────────────── public function page_bulk_sync() { global $wpdb; $mps = $wpdb->get_results("SELECT marketplace FROM {$wpdb->prefix}isarud_credentials WHERE is_active=1"); ?>

→



insert($wpdb->prefix . 'isarud_dropship_suppliers', [ 'name' => sanitize_text_field($_POST['name']), 'email' => sanitize_email($_POST['email']), 'api_url' => esc_url_raw($_POST['api_url'] ?? ''), 'api_key' => sanitize_text_field($_POST['api_key'] ?? ''), 'auto_forward' => intval($_POST['auto_forward'] ?? 0), 'commission_rate' => floatval($_POST['commission_rate'] ?? 0), ]); echo '

' . __('Tedarikçi eklendi.', 'api-isarud') . '

'; } $suppliers = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}isarud_dropship_suppliers ORDER BY id DESC"); ?>

E-posta
name); ?>email); ?>auto_forward ? '✓' : '—'; ?>%commission_rate); ?>






insert($wpdb->prefix . 'isarud_affiliates', [ 'name' => sanitize_text_field($_POST['name']), 'email' => sanitize_email($_POST['email']), 'code' => $code, 'commission_rate' => floatval($_POST['commission_rate'] ?? 10), ]); echo '

' . __('Affiliate eklendi. Kod:', 'api-isarud') . ' ' . esc_html($code) . '

'; } $affiliates = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}isarud_affiliates ORDER BY total_commission DESC"); ?>

KodLink
name); ?>code); ?>%commission_rate); ?>$total_sales, 2); ?>$total_commission, 2); ?>code)); ?>





get_results("SELECT * FROM {$wpdb->prefix}isarud_sync_log ORDER BY created_at DESC LIMIT 100"); ?>

created_at); ?>#product_id); ?>marketplace)); ?>action); ?>status); ?>message, 15)); ?>
['name' => 'Trendyol', 'docs' => 'partner.trendyol.com → Hesap Bilgilerim → Entegrasyon Bilgileri', 'base_url' => 'https://api.trendyol.com/sapigw/', 'auth_type' => 'basic', 'fields' => ['api_key' => ['label' => 'API Key', 'type' => 'text'], 'api_secret' => ['label' => 'API Secret', 'type' => 'password'], 'seller_id' => ['label' => 'Supplier ID', 'type' => 'text']]], 'hepsiburada' => ['name' => 'Hepsiburada', 'docs' => 'merchant.hepsiburada.com → Bilgilerim → Entegrasyon → Entegratör Bilgileri', 'base_url' => 'https://listing-external.hepsiburada.com/', 'auth_type' => 'basic', 'fields' => ['merchant_id' => ['label' => 'Merchant ID', 'type' => 'text'], 'service_key' => ['label' => 'Servis Anahtarı (Service Key)', 'type' => 'password']]], 'n11' => ['name' => 'N11', 'docs' => 'uye.n11.com → Mağazam → API Ayarları', 'base_url' => 'https://api.n11.com/ws/', 'auth_type' => 'soap', 'fields' => ['api_key' => ['label' => 'API Key', 'type' => 'text'], 'api_secret' => ['label' => 'API Secret', 'type' => 'password']]], 'amazon' => ['name' => 'Amazon SP-API', 'docs' => 'sellercentral.amazon.com → Apps & Services → Develop Apps', 'base_url' => 'https://sellingpartnerapi-eu.amazon.com/', 'auth_type' => 'sp-api', 'fields' => ['client_id' => ['label' => 'Client ID', 'type' => 'text'], 'client_secret' => ['label' => 'Client Secret', 'type' => 'password'], 'refresh_token' => ['label' => 'Refresh Token', 'type' => 'password'], 'marketplace_id' => ['label' => 'Marketplace ID', 'type' => 'text']]], 'pazarama' => ['name' => 'Pazarama', 'docs' => 'merchant.pazarama.com → Entegrasyon Bilgileri', 'base_url' => 'https://api.pazarama.com/', 'auth_type' => 'bearer', 'fields' => ['api_key' => ['label' => 'API Key', 'type' => 'text'], 'api_secret' => ['label' => 'API Secret', 'type' => 'password'], 'seller_id' => ['label' => 'Seller ID', 'type' => 'text']]], 'etsy' => ['name' => 'Etsy', 'docs' => 'etsy.com/developers → Manage Your Apps → Create App', 'base_url' => 'https://openapi.etsy.com/v3/', 'auth_type' => 'oauth2', 'fields' => ['api_key' => ['label' => 'API Key', 'type' => 'text'], 'access_token' => ['label' => 'Access Token', 'type' => 'password'], 'shop_id' => ['label' => 'Shop ID', 'type' => 'text']]], ]; } // ─── API HELPER ───────────────────────────── private function marketplace_request(string $mp, string $endpoint, string $method = 'GET', $data = null): array { global $wpdb; // is_active=1 şartı kaldırıldı (v6.2.5) — credentials kaydedilmişse test edebilmeli $row = $wpdb->get_row($wpdb->prepare("SELECT credentials, is_active FROM {$wpdb->prefix}isarud_credentials WHERE marketplace=%s", $mp)); if (!$row) { $this->isarud_log($mp, 'ERROR', 'Credentials not found in DB (marketplace row missing)'); return ['error' => $mp . ' için kayıtlı API bilgisi bulunamadı. Lütfen önce API Key/Secret bilgilerini kaydedin.']; } $creds = json_decode($row->credentials, true); if (!is_array($creds) || empty($creds)) { $this->isarud_log($mp, 'ERROR', 'Credentials JSON parse failed or empty'); return ['error' => 'Credentials okunamadı (JSON parse hatası). Lütfen API bilgilerini yeniden girip kaydedin.']; } $config = $this->get_marketplace_config()[$mp] ?? null; if (!$config) return ['error' => 'Unknown marketplace']; $url = $config['base_url'] . $endpoint; $user_agent = ($mp === 'trendyol' ? ($creds['seller_id'] ?? '') . ' - SelfIntegration' : 'Isarud/' . ISARUD_VERSION); $headers = ['Content-Type' => 'application/json', 'User-Agent' => $user_agent]; switch ($config['auth_type']) { case 'basic': $headers['Authorization'] = 'Basic ' . base64_encode(($creds['api_key'] ?? $creds['merchant_id'] ?? '') . ':' . ($creds['api_secret'] ?? $creds['service_key'] ?? '')); break; case 'bearer': $headers['Authorization'] = 'Bearer ' . ($creds['access_token'] ?? $creds['api_key'] ?? ''); break; case 'oauth2': $headers['x-api-key'] = $creds['api_key'] ?? ''; $headers['Authorization'] = 'Bearer ' . ($creds['access_token'] ?? ''); break; case 'sp-api': $token = $this->amazon_token($creds); if (isset($token['error'])) return $token; $headers['x-amz-access-token'] = $token['access_token']; break; } $args = ['headers' => $headers, 'method' => $method, 'timeout' => 30, 'sslverify' => true]; if ($data && in_array($method, ['POST', 'PUT'])) $args['body'] = wp_json_encode($data); // Debug log — request detayları (Authorization sansürlü) $log_headers = $headers; if (isset($log_headers['Authorization'])) $log_headers['Authorization'] = substr($log_headers['Authorization'], 0, 12) . '***'; $this->isarud_log($mp, 'REQUEST', sprintf("%s %s | UA: %s | Headers: %s", $method, $url, $user_agent, wp_json_encode($log_headers))); $response = wp_remote_request($url, $args); if (is_wp_error($response)) { $err = $response->get_error_message(); $this->isarud_log($mp, 'WP_ERROR', $err); return ['error' => 'Bağlantı kurulamadı: ' . $err . ' — Sunucu güvenlik duvarı Trendyol IP\'sini engellemiyor olmalı.']; } $code = wp_remote_retrieve_response_code($response); $body = wp_remote_retrieve_body($response); $body_preview = substr($body, 0, 500); $this->isarud_log($mp, 'RESPONSE', sprintf("HTTP %d | Body: %s", $code, $body_preview)); if ($code >= 400) { // Detaylı hata mesajı $friendly = $this->interpret_api_error($mp, $code, $body); return ['error' => $friendly, 'http_code' => $code, 'body' => $body_preview]; } return array_merge(json_decode($body, true) ?: [], ['http_code' => $code]); } /** * Hata koduna göre insan-okur mesaj üretir (v6.2.5) */ private function interpret_api_error(string $mp, int $code, string $body): string { $body_lc = strtolower($body); $is_cf = strpos($body_lc, 'cloudflare') !== false || strpos($body_lc, 'attention required') !== false; if ($mp === 'trendyol') { if ($code === 401) return "Trendyol: API Key veya Secret yanlış (HTTP 401). Partner panelinden (partner.trendyol.com → Hesap Bilgilerim → Entegrasyon Bilgileri) bilgileri tekrar kopyalayın."; if ($code === 403) { if ($is_cf) return "Trendyol Cloudflare'a takıldı (HTTP 403). Seller ID (Supplier ID) doğru girilmemiş olabilir — User-Agent header Seller ID bekliyor. Partner panelindeki Seller ID'yi kontrol edin."; return "Trendyol: Erişim reddedildi (HTTP 403). API Key, IP whitelist veya hesap durumu kontrol edilmeli."; } if ($code === 404) return "Trendyol: Seller ID bulunamadı (HTTP 404). Supplier ID format olarak sadece sayı olmalı (örn: 123456), başka karakter içermemeli."; if ($code === 429) return "Trendyol: Çok fazla istek atıldı (HTTP 429 rate limit). Birkaç dakika bekleyip tekrar deneyin."; if ($code >= 500) return "Trendyol sunucusu şu an yanıt vermiyor (HTTP {$code}). Trendyol tarafında geçici bir sorun var, 5-10 dk sonra tekrar deneyin."; } return sprintf("%s API hatası (HTTP %d): %s", ucfirst($mp), $code, substr($body, 0, 200)); } /** * Dahili log — wp-content/uploads/isarud-logs/trendyol-YYYY-MM-DD.log (v6.2.5) * WP_DEBUG kapalı olsa bile çalışır, sadece bu plugin için */ private function isarud_log(string $mp, string $type, string $message): void { $upload = wp_upload_dir(); $log_dir = $upload['basedir'] . '/isarud-logs'; if (!file_exists($log_dir)) @mkdir($log_dir, 0755, true); if (!is_writable($log_dir)) return; $file = $log_dir . '/' . $mp . '-' . date('Y-m-d') . '.log'; $line = sprintf("[%s] [%s] %s\n", date('H:i:s'), $type, $message); @file_put_contents($file, $line, FILE_APPEND); // .htaccess ile access koruması (ilk çağrıda yaz) $ht = $log_dir . '/.htaccess'; if (!file_exists($ht)) @file_put_contents($ht, "Deny from all\n"); } private function amazon_token(array $c): array { $r = wp_remote_post('https://api.amazon.com/auth/o2/token', ['body' => ['grant_type' => 'refresh_token', 'refresh_token' => $c['refresh_token'] ?? '', 'client_id' => $c['client_id'] ?? '', 'client_secret' => $c['client_secret'] ?? '']]); if (is_wp_error($r)) return ['error' => $r->get_error_message()]; $d = json_decode(wp_remote_retrieve_body($r), true); return empty($d['access_token']) ? ['error' => 'Amazon auth failed'] : $d; } private function get_cred(string $mp, string $key): string { global $wpdb; $r = $wpdb->get_var($wpdb->prepare("SELECT credentials FROM {$wpdb->prefix}isarud_credentials WHERE marketplace=%s", $mp)); return $r ? (json_decode($r, true)[$key] ?? '') : ''; } private function get_margin(string $mp): array { global $wpdb; $r = $wpdb->get_row($wpdb->prepare("SELECT price_margin, price_margin_type FROM {$wpdb->prefix}isarud_credentials WHERE marketplace=%s", $mp)); return ['amount' => floatval($r->price_margin ?? 0), 'type' => $r->price_margin_type ?? 'percent']; } private function apply_margin(float $price, string $mp): float { $m = $this->get_margin($mp); if ($m['amount'] == 0) return $price; return $m['type'] === 'percent' ? round($price * (1 + $m['amount'] / 100), 2) : round($price + $m['amount'], 2); } // ─── AJAX HANDLERS ────────────────────────── public function ajax_test_connection() { check_ajax_referer('isarud_nonce', 'nonce'); if (!current_user_can('manage_options')) wp_send_json_error('Unauthorized'); global $wpdb; $mp = sanitize_text_field($_POST['marketplace'] ?? ''); $result = match($mp) { 'trendyol' => $this->marketplace_request('trendyol', 'suppliers/' . $this->get_cred($mp, 'seller_id') . '/products?page=0&size=1'), 'hepsiburada' => $this->marketplace_request('hepsiburada', 'listings/merchantid/' . $this->get_cred($mp, 'merchant_id') . '?limit=1'), 'n11' => $this->test_n11(), 'amazon' => $this->marketplace_request('amazon', 'sellers/v1/marketplaceParticipations'), 'pazarama' => $this->marketplace_request('pazarama', 'product/products?page=0&size=1'), 'etsy' => $this->marketplace_request('etsy', 'application/shops/' . $this->get_cred($mp, 'shop_id')), default => ['error' => 'Unknown'], }; $ok = !isset($result['error']); $wpdb->update($wpdb->prefix . 'isarud_credentials', ['last_test' => current_time('mysql'), 'test_status' => $ok ? 'success' : 'error'], ['marketplace' => $mp]); if ($ok) { $extra = ''; if ($mp === 'trendyol' && isset($result['totalElements'])) { $extra = ' (' . intval($result['totalElements']) . ' ürün bulundu)'; } wp_send_json_success(['message' => ucfirst($mp) . ' bağlantısı başarılı!' . $extra]); } else { // Error durumunda detaylı hata ver $msg = $result['error'] ?? 'Bilinmeyen hata'; if (isset($result['http_code'])) $msg .= ' [HTTP ' . $result['http_code'] . ']'; wp_send_json_error(['message' => $msg, 'details' => $result]); } } private function test_n11(): array { global $wpdb; $c = json_decode($wpdb->get_var("SELECT credentials FROM {$wpdb->prefix}isarud_credentials WHERE marketplace='n11'"), true); if (!$c) return ['error' => 'N11 credentials not found']; $xml = '' . esc_xml($c['api_key'] ?? '') . '' . esc_xml($c['api_secret'] ?? '') . '01'; $r = wp_remote_post('https://api.n11.com/ws/ProductService/', ['headers' => ['Content-Type' => 'text/xml; charset=utf-8'], 'body' => $xml, 'timeout' => 30]); if (is_wp_error($r)) return ['error' => $r->get_error_message()]; return ['success' => true]; } // ─── VARIATION AWARE SYNC ─────────────────── public function sync_product_smart($product, string $mp): array { if ($product->is_type('variable')) { return Isarud_Variation_Sync::instance()->sync_variable_product($product, $mp); } return $this->sync_stock($product, $mp); } // ─── STOCK SYNC (public for cron) ─────────── public function sync_stock_public($product, string $mp): array { return $this->sync_stock($product, $mp); } private function sync_stock($product, string $mp): array { $sku = $product->get_sku(); $stock = $product->get_stock_quantity() ?? 0; $price = $this->apply_margin((float)$product->get_price(), $mp); $barcode = get_post_meta($product->get_id(), '_isarud_barcode', true) ?: $sku; if (empty($barcode)) return ['error' => 'No barcode/SKU']; $result = match($mp) { 'trendyol' => $this->marketplace_request('trendyol', 'suppliers/' . $this->get_cred('trendyol', 'seller_id') . '/products/price-and-inventory', 'PUT', ['items' => [['barcode' => $barcode, 'quantity' => $stock, 'salePrice' => $price, 'listPrice' => $price]]]), 'hepsiburada' => $this->marketplace_request('hepsiburada', 'listings/merchantid/' . $this->get_cred('hepsiburada', 'merchant_id') . '/stock-uploads', 'POST', ['listings' => [['hepsiburadaSku' => $barcode, 'merchantSku' => $barcode, 'availableStock' => $stock, 'price' => $price]]]), 'pazarama' => $this->marketplace_request('pazarama', 'product/products/price-and-inventory', 'PUT', ['items' => [['barcode' => $barcode, 'quantity' => $stock, 'salePrice' => $price]]]), default => ['error' => 'Not implemented for ' . $mp], }; global $wpdb; $wpdb->insert($wpdb->prefix . 'isarud_sync_log', ['product_id' => $product->get_id(), 'marketplace' => $mp, 'action' => 'stock_price_update', 'status' => isset($result['error']) ? 'error' : 'success', 'message' => $result['error'] ?? "Stock: {$stock}, Price: {$price}", 'created_at' => current_time('mysql')]); return $result; } public function ajax_sync_product() { check_ajax_referer('isarud_nonce', 'nonce'); if (!current_user_can('manage_woocommerce')) wp_send_json_error('Unauthorized'); $mp = sanitize_text_field($_POST['marketplace'] ?? ''); $p = wc_get_product(intval($_POST['product_id'] ?? 0)); if (!$p || !$mp) wp_send_json_error('Invalid'); $r = $this->sync_stock($p, $mp); isset($r['error']) ? wp_send_json_error($r['error']) : wp_send_json_success($r); } public function ajax_bulk_sync() { check_ajax_referer('isarud_nonce', 'nonce'); if (!current_user_can('manage_woocommerce')) wp_send_json_error('Unauthorized'); $mp = sanitize_text_field($_POST['marketplace'] ?? ''); $page = intval($_POST['page'] ?? 0); $products = wc_get_products(['status' => 'publish', 'manage_stock' => true, 'limit' => 10, 'offset' => $page * 10]); $total = wc_get_products(['status' => 'publish', 'manage_stock' => true, 'limit' => 1, 'return' => 'ids', 'paginate' => true])->total ?? 0; $ok = 0; $err = 0; foreach ($products as $p) { $r = $this->sync_stock($p, $mp); isset($r['error']) ? $err++ : $ok++; } wp_send_json_success(['ok' => $ok, 'err' => $err, 'total' => $total, 'done' => count($products) < 10]); } // ─── SANCTIONS SCREENING ──────────────────── public function auto_screen_order(int $oid): void { if (get_option('isarud_auto_screen', 'yes') !== 'yes') return; $key = get_option('isarud_api_key'); if (!$key) return; $o = wc_get_order($oid); if (!$o) return; $names = array_filter([trim($o->get_billing_first_name() . ' ' . $o->get_billing_last_name()), $o->get_billing_company(), trim($o->get_shipping_first_name() . ' ' . $o->get_shipping_last_name())]); $names = array_unique(array_filter($names)); $results = []; $match = false; foreach ($names as $n) { $r = wp_remote_post('https://isarud.com/api/v1/screen', ['timeout' => 15, 'headers' => ['Authorization' => 'Bearer ' . $key, 'Content-Type' => 'application/json'], 'body' => wp_json_encode(['name' => $n])]); $d = is_wp_error($r) ? ['status' => 'error'] : (json_decode(wp_remote_retrieve_body($r), true) ?: ['status' => 'error']); $results[] = array_merge($d, ['query' => $n]); if (in_array($d['status'] ?? '', ['match', 'possible_match'])) $match = true; } global $wpdb; $wpdb->insert($wpdb->prefix . 'isarud_screening_log', ['order_id' => $oid, 'names_screened' => wp_json_encode($names), 'has_match' => $match ? 1 : 0, 'results' => wp_json_encode($results), 'created_at' => current_time('mysql')]); $o->add_order_note($match ? 'Isarud: YAPTIRIM EŞLEŞMESİ: ' . implode(', ', $names) : 'Isarud: Temiz — eşleşme yok'); if ($match) { wp_mail(get_option('isarud_alert_email', get_option('admin_email')), '[Isarud] Eşleşme — Sipariş #' . $oid, 'Eşleşme: ' . implode(', ', $names)); if (get_option('isarud_block_match', 'no') === 'yes') $o->update_status('on-hold', 'Isarud tarafından bekletildi'); } } public function ajax_screen_order() { check_ajax_referer('isarud_nonce', 'nonce'); if (!current_user_can('manage_woocommerce')) wp_send_json_error('Unauthorized'); $this->auto_screen_order(intval($_POST['order_id'] ?? 0)); wp_send_json_success('Tarandı'); } // ─── DROPSHIPPING AUTO-FORWARD ────────────── public function forward_to_supplier(int $oid): void { global $wpdb; $o = wc_get_order($oid); if (!$o) return; $suppliers = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}isarud_dropship_suppliers WHERE auto_forward=1 AND is_active=1"); foreach ($suppliers as $s) { if (!empty($s->api_url)) { wp_remote_post($s->api_url, ['timeout' => 15, 'headers' => ['Authorization' => 'Bearer ' . $s->api_key, 'Content-Type' => 'application/json'], 'body' => wp_json_encode(['order_id' => $oid, 'items' => $o->get_items(), 'shipping' => $o->get_address('shipping')])]); } if (!empty($s->email)) { wp_mail($s->email, 'Yeni Sipariş #' . $oid, 'Sipariş detayları: ' . $o->get_edit_order_url()); } $o->add_order_note('Isarud: Tedarikçiye iletildi → ' . $s->name); } } // ─── AFFILIATE TRACKING ───────────────────── public function track_affiliate_click(): void { if (isset($_GET['ref'])) { $code = sanitize_text_field($_GET['ref']); setcookie('isarud_ref', $code, time() + (30 * 86400), '/'); } } public function track_affiliate(int $oid): void { $code = $_COOKIE['isarud_ref'] ?? ''; if (!$code) return; global $wpdb; $aff = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->prefix}isarud_affiliates WHERE code=%s AND is_active=1", $code)); if (!$aff) return; $o = wc_get_order($oid); if (!$o) return; $total = (float)$o->get_total(); $commission = round($total * $aff->commission_rate / 100, 2); $wpdb->insert($wpdb->prefix . 'isarud_affiliate_log', ['affiliate_id' => $aff->id, 'order_id' => $oid, 'order_total' => $total, 'commission' => $commission]); $wpdb->query($wpdb->prepare("UPDATE {$wpdb->prefix}isarud_affiliates SET total_sales=total_sales+%f, total_commission=total_commission+%f WHERE id=%d", $total, $commission, $aff->id)); $o->add_order_note("Isarud Affiliate: {$aff->name} ({$aff->code}) — Komisyon: \${$commission}"); } // ─── ORDER META BOX ───────────────────────── public function order_meta_box() { $screen = class_exists('\Automattic\WooCommerce\Internal\DataStores\Orders\CustomOrdersTableController') ? wc_get_page_screen_id('shop-order') : 'shop_order'; add_meta_box('isarud_compliance', 'Isarud', [$this, 'render_order_box'], $screen, 'side', 'high'); } public function render_order_box($p) { $o = ($p instanceof \WP_Post) ? wc_get_order($p->ID) : $p; if (!$o) return; global $wpdb; $log = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->prefix}isarud_screening_log WHERE order_id=%d ORDER BY id DESC LIMIT 1", $o->get_id())); if (!$log) { echo '

' . __('Taranmadı', 'api-isarud') . '

'; return; } echo $log->has_match ? '

🔴 ' . __('Eşleşme Bulundu', 'api-isarud') . '

' : '

🟢 ' . __('Temiz', 'api-isarud') . '

'; } // ─── PRODUCT FIELDS ───────────────────────── public function product_fields() { echo '

Isarud

'; woocommerce_wp_text_input(['id' => '_isarud_barcode', 'label' => 'Barkod / EAN']); woocommerce_wp_text_input(['id' => '_isarud_n11_id', 'label' => 'N11 Ürün ID']); woocommerce_wp_text_input(['id' => '_isarud_etsy_listing_id', 'label' => 'Etsy Listing ID']); woocommerce_wp_text_input(['id' => '_isarud_supplier_id', 'label' => __('Tedarikçi ID', 'api-isarud')]); echo '
'; } public function save_product_fields(int $id): void { foreach (['_isarud_barcode', '_isarud_n11_id', '_isarud_etsy_listing_id', '_isarud_supplier_id'] as $f) { if (isset($_POST[$f])) update_post_meta($id, $f, sanitize_text_field($_POST[$f])); } } // ─── PRODUCT EXPORT PAGE ──────────────────── public function page_product_export() { global $wpdb; $mps = $wpdb->get_results("SELECT marketplace FROM {$wpdb->prefix}isarud_credentials WHERE is_active=1"); $products = wc_get_products(['status' => 'publish', 'limit' => 100]); ?>

SKU
get_sku() ?: '-'); ?> get_name()); ?> get_price()); ?> get_stock_quantity() ?? '-'; ?>

render_mapping_ui(); ?>

prefix . 'isarud_'; $period = sanitize_text_field($_GET['period'] ?? '24h'); $since = match($period) { '1h' => date("Y-m-d H:i:s", strtotime("-1 hour")), '24h' => date("Y-m-d H:i:s", strtotime("-24 hours")), '7d' => date("Y-m-d H:i:s", strtotime("-7 days")), '30d' => date("Y-m-d H:i:s", strtotime("-30 days")), 'all' => '2000-01-01 00:00:00', default => date("Y-m-d H:i:s", strtotime("-24 hours")), }; $screen_count = (int)$wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM {$t}screening_log WHERE created_at >= %s", $since)); $match_count = (int)$wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM {$t}screening_log WHERE has_match=1 AND created_at >= %s", $since)); $sync_ok = (int)$wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM {$t}sync_log WHERE status='success' AND created_at >= %s", $since)); $sync_err = (int)$wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM {$t}sync_log WHERE status='error' AND created_at >= %s", $since)); $active_mp = (int)$wpdb->get_var("SELECT COUNT(*) FROM {$t}credentials WHERE is_active=1"); // Birleşik aktivite listesi $all_activities = $wpdb->get_results($wpdb->prepare( "(SELECT 'screening' as type, entity_name as detail, IF(has_match=1,'match','clean') as status, created_at FROM {$t}screening_log WHERE created_at >= %s) UNION ALL (SELECT 'sync' as type, CONCAT(marketplace, ': ', COALESCE(message,'')) as detail, status, created_at FROM {$t}sync_log WHERE created_at >= %s) ORDER BY created_at DESC LIMIT 100", $since, $since )); $page_url = admin_url('admin.php?page=isarud-statistics'); ?>

__( '1 Saat', 'api-isarud'), '24h' => __( '24 Saat', 'api-isarud'), '7d' => __( '7 Gün', 'api-isarud'), '30d' => __( '30 Gün', 'api-isarud'), 'all' => __( 'Tümü', 'api-isarud')] as $k => $label): ?>

type === 'screening' ? '🛡️' : '🔄'; $type_label = $act->type === 'screening' ? __( 'Tarama', 'api-isarud') : __( 'Sync', 'api-isarud'); $sc = match($act->status) { 'match' => '#d63638', 'error' => '#dba617', 'clean','success' => '#00a32a', default => '#999' }; $sl = match($act->status) { 'match' => '⚠️ ' . __( 'Eşleşme', 'api-isarud'), 'clean' => '✓ ' . __( 'Temiz', 'api-isarud'), 'success' => '✓ ' . __( 'Başarılı', 'api-isarud'), 'error' => '✗ ' . __( 'Hata', 'api-isarud'), default => $act->status }; ?>
created_at)); ?>
created_at)) . ' ' . __( 'önce', 'api-isarud'); ?> 		detail, 0, 80)); ?>

get_results("SELECT marketplace FROM {$wpdb->prefix}isarud_credentials WHERE is_active=1"); ?>

→

get_results("SELECT marketplace FROM {$wpdb->prefix}isarud_credentials WHERE is_active=1"); ?>



render_mapping_ui(); ?>

' . __('Kaydedildi.', 'api-isarud') . '

'; } $urls = Isarud_Webhook::get_webhook_urls(); $secret = get_option('isarud_webhook_secret', ''); ?>

Trendyol
partner.trendyol.com → Entegrasyon → Webhook Ayarları
Hepsiburada
merchant.hepsiburada.com → Entegrasyon → Webhook
N11
uye.n11.com → API Ayarları → Webhook
Generic

Webhook Secret

get_status(); if (isset($_POST['isarud_save_cloud']) && wp_verify_nonce($_POST['_wpnonce'], 'isarud_cloud')) { $enabled = sanitize_text_field($_POST['cloud_enabled'] ?? 'no'); update_option('isarud_cloud_enabled', $enabled); if ($enabled === 'no') { $cloud->disconnect(); echo '

' . __('Cloud sync devre dışı bırakıldı.', 'api-isarud') . '

'; } $status = $cloud->get_status(); } ?>

🟢

API Key

  1. isarud.com\'a giriş yapın', 'api-isarud'); ?>

'Token gerekli']); $cloud = Isarud_Cloud_Sync::instance(); $result = $cloud->connect_site($token); if (!empty($result['success'])) { wp_send_json_success(['message' => 'isarud.com\'a bağlandı! Sayfa yenileniyor...']); } else { wp_send_json_error(['message' => $result['error'] ?? 'Bağlantı başarısız']); } } public function ajax_cloud_sync_now() { check_ajax_referer('isarud_nonce', 'nonce'); if (!current_user_can('manage_options')) wp_send_json_error('Unauthorized'); $cloud = Isarud_Cloud_Sync::instance(); if (!$cloud->is_enabled()) wp_send_json_error(['message' => 'Cloud sync aktif değil']); $products = $cloud->sync_products(); $orders = $cloud->sync_orders(); wp_send_json_success([ 'products' => $products, 'orders' => $orders, ]); } public function ajax_cloud_disconnect() { check_ajax_referer('isarud_nonce', 'nonce'); if (!current_user_can('manage_options')) wp_send_json_error('Unauthorized'); Isarud_Cloud_Sync::instance()->disconnect(); wp_send_json_success('Disconnected'); } public function page_ecosystem() { include ISARUD_DIR . 'includes/ecosystem-html.php'; } public function page_currency() { include ISARUD_DIR . 'includes/currency-html.php'; } public function page_b2b() { include ISARUD_DIR . 'includes/b2b-html.php'; } public function page_segments() { include ISARUD_DIR . 'includes/segments-html.php'; } public function page_cart_recovery() { include ISARUD_DIR . 'includes/cart-recovery-html.php'; } public function page_popup() { include ISARUD_DIR . 'includes/popup-html.php'; } public function page_email_marketing() { include ISARUD_DIR . 'includes/email-marketing-html.php'; } public function page_einvoice() { include ISARUD_DIR . 'includes/einvoice-html.php'; } public function page_upsell() { include ISARUD_DIR . 'includes/upsell-html.php'; } public function page_welcome() { include ISARUD_DIR . 'includes/welcome-html.php'; } } if (!function_exists('esc_xml')) { function esc_xml(string $s): string { return htmlspecialchars($s, ENT_XML1, 'UTF-8'); } }