global $wpdb; if (isset($_POST['offset']) && !empty($_POST['offset'])) { //sleep(10); $offset = $_POST['offset'] - 1; // start from 0 $query_with_limit = "SELECT ID,post_status,post_title,post_content,post_type FROM `" . $wpdb->prefix . "posts` WHERE post_type = 'product' AND post_status!='auto-draft' ORDER BY ID ASC LIMIT " . $offset . ",1"; $product_details = mysql_query($query_with_limit) or die(mysql_error()); $product_wc = mysql_fetch_assoc($product_details); if ($product_wc['post_status'] != 'trash') { $taxsetup = false; $product = array(); $post_detail = get_post_meta($product_wc['ID']); if (@empty($post_detail['_sku'][0])) { $post_detail['_sku'][0] = 'sku_' . $product_wc['ID']; } $post_detail['_sku'][0] = linksync_removespaces_sku($post_detail['_sku'][0]); update_post_meta($product_wc['ID'], '_sku', $post_detail['_sku'][0]); $product['sku'] = html_entity_decode($post_detail['_sku'][0]); $product['active'] = isset($product_wc['post_status']) && $product_wc['post_status'] == 'publish' ? 1 : 0; if (get_option('ps_price') == 'on') { if (isset($post_detail['_tax_status'][0]) && $post_detail['_tax_status'][0] == 'taxable') { $taxname = empty($post_detail['_tax_class'][0]) ? 'standard-tax' : $post_detail['_tax_class'][0]; $response_taxes = linksyn_get_tax_details_syncall_QBO($taxname); if ($response_taxes['result'] == 'success') { $product['tax_name'] = html_entity_decode($response_taxes['data']['tax_name']); $product['tax_rate'] = $response_taxes['data']['tax_rate']; $taxsetup = true; } } if (get_option('excluding_tax') == 'on') { if ($taxsetup) {
$product['brands'] = $brands; } //To free an array to use futher unset($brands); } $variants_data = mysql_query("SELECT ID,post_title FROM `" . $wpdb->prefix . "posts` WHERE post_type = 'product_variation' AND post_parent ='" . $product_wc['ID'] . "' AND post_status!='auto-draft'"); // $variants_data = mysql_query("SELECT ID,post_title FROM `" . $wpdb->prefix . "posts` WHERE post_type = 'product_variation' AND post_parent ='" . $product_wc['ID'] . "'"); if (mysql_num_rows($variants_data) != 0) { $total_var_product = 0; while ($variant_data = mysql_fetch_assoc($variants_data)) { $option = array(1 => 'one', 2 => 'two', 3 => 'three', 4 => 'four', 5 => 'five', 6 => 'six', 7 => 'seven', 8 => 'eight', 9 => 'nine', 10 => 'ten'); $variants_detail = get_post_meta($variant_data['ID']); if (@empty($variants_detail['_sku'][0])) { $variants_detail['_sku'][0] = 'sku_' . $variant_data['ID']; } $variants_detail['_sku'][0] = linksync_removespaces_sku($variants_detail['_sku'][0]); update_post_meta($variant_data['ID'], '_sku', $variants_detail['_sku'][0]); $variant['sku'] = html_entity_decode($variants_detail['_sku'][0]); //SKU(unique Key) #Name/Title Check if (get_option('ps_name_title') == 'on') { $variant['name'] = html_entity_decode($variant_data['post_title']); } #quantity if (@$variants_detail['_stock_status'][0] == 'instock') { $variant['quantity'] = @$variants_detail['_stock'][0]; } // Price with Tax if (get_option('ps_price') == 'on') { if (isset($variants_detail['_tax_status'][0]) && $variants_detail['_tax_status'][0] == 'taxable') { # Product with TAX