public function process_xml($type = "FOR_INSERT") { global $logger, $db; $this->store_products = $this->get_imported($this->name); $this->import_settings = Settings::get_import_settings($this->name); $fh = @fopen(FEED_PATH . "dealerpricelist.csv", "r"); $art = fgetcsv($fh, null, ","); $i = 0; $bz = 0; $this->all = 0; return array(); while (($art = fgetcsv($fh, null, ",")) !== false) { $sku = (string) trim($art[1]); $store_product_id = @$this->store_products[$sku]; $this->all++; if ($type == "FOR_INSERT" && $store_product_id) { continue; } if ($type == "FOR_UPDATE" && !$store_product_id) { continue; } $item = new stdClass(); $item->sku = $sku; $catname = ($art[8] != "" ? $art[8] : "") . ($art[9] != "" ? " > " . $art[9] : "") . ($art[10] != "" ? " > " . $art[10] : ""); $catnametext = str_replace("\"", "``", $catname); $catnametext = str_replace("\"", "``", $catnametext); $catnametext = str_replace("'", "`", $catnametext); $item->category_XML = $catnametext; if (@$this->category_mapping[$item->category_XML]) { foreach ($this->category_mapping[$item->category_XML] as $catstore) { // $d = $this->get_ps_category_ancestors($catstore); // dump($d);exit; // $item->category_ids[] = $this->get_ps_category_ancestors($catstore); $item->category_ids[] = (int) $catstore; } } if (@count($item->category_ids) == 0) { // echo $bz++ . ". {$sku} NO CATEGORY ({$item->category_XML}) <Br>"; continue; } //$item->category_ids = array_unique($item->category_ids); // dump($item->category_ids) ;exit; // part number // dump(explode(",",$this->import_settings['NOT_IMPORT_NAME']));exit; //if (in_array($item->sku, explode(",",$this->import_settings['NOT_IMPORT_SKU']))) continue; // 33,34 $item->quantity = (int) $art[7]; if (!$item->quantity) { // echo $bz2++ . ". {$sku} QTY=0<Br>"; continue; } // if ($item->quantity < 10 ) continue; // if ($item->quantity < 10) continue; $item->title = $art[2]; $item->desc_short = ImpLib::limitString($art[3]); $item->meta_desc = ImpLib::limitString($art[3]); $item->tags = ""; $item->meta_keywords = ""; $item->desc_long = $art[3]; $item->vendor = $art[0]; $item->plant = $art[0]; $item->manufacturer = $art[0]; $item->manufacturer_sku = $art[1]; //$item->supplier_reference = $art[3]; $item->manufacturer_sku_2 = $art[4]; $item->store_product_id = $store_product_id; $item->supplier = "Dove"; // if ($type=="FOR_INSERT") { // $item->id_manufacturer = $this->get_manufacturer_id($item->manufacturer); // $item->manufacturer_id = $item->id_manufacturer; // } $item->ean_upc = (string) $art[13]; $item->price = (double) $art[6]; // $item->rrp = (float) (str_replace("$", "", $art[3]));; $item->raw_price = $item->price; if ($item->price < 0.1) { continue; } // echo Settings::get_margin_from_price($item->price);exit; $margin = @$this->import_settings['MARGIN'][$item->category_XML]; // dump($this->import_settings['MARGIN']);exit; //dump($this->import_settings); $item->margin = $margin > 0 ? $margin : (int) $this->import_settings['GLOBALPROFITMARGIN']; // dump($item);exit; /// $item->margin = ($margin !="") ? $margin : Settings::get_margin_from_price($item->price); $item->price_raw = $item->price; $item->price = $item->price * (1 + $item->margin / 100); $item->price = $item->price; $item->wholesale_price = $item->price_raw; $item->weight = ""; $item->length = ""; $item->width = ""; $item->height = ""; $item->active = 1; $item->_regular_price = $item->price; $item->_sale_price = ""; $item->status = 1; $item->images = array(); if ($art[11] != "") { $item->images[] = $art[11]; } else { continue; } if ($sku == "PTH-851-K1-CX") { dump($item); dump($art); // exit; } echo "{$item->sku} | {$item->category_XML} | {$item->price_raw} + {$item->margin}% => {$item->price}<br>"; $articles_final[$sku] = $item; $i++; } // dump($articles_final);exit; return @$articles_final; }
public function process_xml($type = "FOR_INSERT") { global $logger, $db; $this->store_products = $this->get_imported($this->name); $this->updatedIceCatItems = IceCat::getUpdatedIceCatItemsOK(); $this->import_settings = Settings::get_import_settings($this->name); $fh = @fopen(FEED_PATH . $this->name . ".csv", "r"); $art = fgetcsv($fh, null, "|"); // dump($art) ; $i = 0; $bz = 0; $this->all = 0; while (($art = fgetcsv($fh, null, "|")) !== false) { $sku = (string) trim($art[1]); // 0 $store_product_id = @$this->store_products[$sku]; $this->all++; if ($type == "FOR_INSERT" && $store_product_id) { continue; } if ($type == "FOR_UPDATE" && !$store_product_id) { continue; } // continue; $item = new stdClass(); $item->sku = $sku; $item->category_XML = $art[10]; // 4 // $logger-> if (@$this->category_mapping[$item->category_XML]) { foreach ($this->category_mapping[$item->category_XML] as $catstore) { $d = $this->get_category_ancestors($catstore); // dump($d);exit; if ($d != 0) { //dump($d); foreach ($d as $cc) { $item->category_ids[] = (int) $cc; } } $item->category_ids[] = (int) $catstore; } } if (@count($item->category_ids) == 0) { //echo $bz++ . ". {$sku} NO CATEGORY ({$item->category_XML}) <Br>"; continue; } //$item->category_ids = array_unique($item->category_ids); // dump($item->category_ids) ;exit; // part number // dump(explode(",",$this->import_settings['NOT_IMPORT_NAME']));exit; //if (in_array($item->sku, explode(",",$this->import_settings['NOT_IMPORT_SKU']))) continue; // 33,34 $item->quantity = (int) $art[11]; // 7 if (!$item->quantity) { continue; } if ($item->quantity < 10) { continue; } // if ($item->quantity < 10) continue; $item->title = $art[4]; // 3 $item->desc_short = ImpLib::limitString($art[4]); // 3 $item->meta_desc = ImpLib::limitString($art[4]); // 3 $item->meta_keywords = ImpLib::limitString($art[4]); $item->tags = ImpLib::limitString($art[4]); $item->desc_long = $art[4]; $item->vendor = $art[2]; $item->plant = $art[2]; $item->manufacturer = $art[2]; // 1 $item->manufacturer_sku = $art[3]; // 2 //$item->supplier_reference = $art[3]; $item->manufacturer_sku_2 = $art[0]; $item->store_product_id = $store_product_id; $item->supplier = "SY"; // if ($type=="FOR_INSERT") { $item->manufacturer_id = $this->get_manufacturer_id($item->manufacturer); // } $item->ean_upc = ""; $item->price = (double) str_replace("\$", "", $art[7]); $item->rrp = (double) str_replace("\$", "", $art[7]); $item->raw_price = $item->price; if ($item->price < 0.1) { continue; } // echo Settings::get_margin_from_price($item->price);exit; $margin = @$this->import_settings['MARGIN'][$item->category_XML]; // dump($this->import_settings['MARGIN']);exit; //dump($this->import_settings); $item->margin = $margin > 0 ? $margin : (int) $this->import_settings['GLOBALPROFITMARGIN']; // dump($item);exit; /// $item->margin = ($margin !="") ? $margin : Settings::get_margin_from_price($item->price); $item->price_raw = $item->price; $item->price = $item->price * (1 + $item->margin / 100); // $item->price = $item->price ; // dump($item); dump($art);exit; $item->wholesale_price = $item->price_raw; $item->weight = ""; $item->length = ""; $item->width = ""; $item->height = ""; $item->active = 1; $item->status = 1; $item->images = array(); if ($sku == "66016") { // dump($art); // dump($item); // exit; } if ($item->title == "Microsoft") { die("Bad feed. Contact support"); } // dump($art); // dump($item); // exit; // echo "{$item->sku} | {$item->category_XML} | {$item->price_raw} + {$item->margin}% => {$item->price}<br>"; $articles_final[$sku] = $item; $i++; } // dump($articles_final);; return @$articles_final; }
public function process_xml($type = "FOR_INSERT") { global $logger, $db; $this->store_products = $this->get_imported($this->name); $this->import_settings = Settings::get_import_settings($this->name); $fh = @fopen(FEED_PATH . "CDL EPricefile.csv", "r"); $art = fgetcsv($fh, null, ","); $i = 0; $bz = 0; $this->all = 0; // dump($art); while (($art = fgetcsv($fh, null, ",")) !== false) { $sku = (string) trim($art[0]); $sku = str_replace("\\", "-", $sku); // dump($art);exit; $store_product_id = @$this->store_products[$sku]; $this->all++; if ($type == "FOR_INSERT" && $store_product_id) { continue; } if ($type == "FOR_UPDATE" && !$store_product_id) { continue; } $item = new stdClass(); $item->sku = $sku; $item->category_XML = $art[3]; if (@$this->category_mapping[$item->category_XML]) { foreach ($this->category_mapping[$item->category_XML] as $catstore) { // $d = $this->get_ps_category_ancestors($catstore); // dump($d);exit; // $item->category_ids[] = $this->get_ps_category_ancestors($catstore); $item->category_ids[] = (int) $catstore; } } if (@count($item->category_ids) == 0) { // echo $bz++ . ". {$sku} NO CATEGORY ({$item->category_XML}) <Br>"; continue; } $item->quantity = (int) $art[10]; if (!$item->quantity) { // echo $bz2++ . ". {$sku} QTY=0<Br>"; continue; } // if ($item->quantity < 10 ) continue; // if ($item->quantity < 10) continue; $item->title = $art[2]; $item->desc_short = ImpLib::limitString($art[2]); $item->meta_desc = ImpLib::limitString($art[2]); $item->tags = ""; $item->meta_keywords = ""; $item->desc_long = $art[2]; $item->vendor = $art[4]; $item->plant = $art[4]; $item->manufacturer = $art[4]; $item->manufacturer_sku = $art[0]; //$item->supplier_reference = $art[3]; $item->manufacturer_sku_2 = $art[0]; $item->store_product_id = $store_product_id; $item->supplier = "CDL"; // if ($type=="FOR_INSERT") { // $item->id_manufacturer = $this->get_manufacturer_id($item->manufacturer); // $item->manufacturer_id = $item->id_manufacturer; // } $item->ean_upc = ""; $item->price = (double) $art[9]; // $item->rrp = (float) (str_replace("$", "", $art[3]));; $item->raw_price = $item->price; if ($item->price < 0.1) { continue; } // echo Settings::get_margin_from_price($item->price);exit; $margin = @$this->import_settings['MARGIN'][$item->category_XML]; // dump($this->import_settings['MARGIN']);exit; //dump($this->import_settings); $item->margin = $margin > 0 ? $margin : (int) $this->import_settings['GLOBALPROFITMARGIN']; // dump($item);exit; /// $item->margin = ($margin !="") ? $margin : Settings::get_margin_from_price($item->price); $item->price_raw = $item->price; $item->price = $item->price * (1 + $item->margin / 100); $item->_regular_price = $item->price; $item->wholesale_price = $item->price_raw; $item->weight = ""; $item->length = ""; $item->width = ""; $item->_sale_price = ""; $item->_wc_cog_cost = ""; $item->height = ""; $item->active = 1; $item->status = 1; $item->images = array(); $imgfile = IMPORT_ABS_PATH . "/CDL_temp_/Jpegs/" . str_replace("-", "", strtolower($item->sku)) . ".jpg"; if (@filesize($imgfile) > 100) { $item->images = "http://www.bestdirect.co.nz/CDL_temp_/Jpegs/" . str_replace("-", "", strtolower($item->sku)) . ".jpg"; // dump($item);exit; } // dump($imgfile);exit; if ($sku == "A-U2AFMICBM") { // dump($item); // dump($art); // exit; } echo "{$item->sku} | {$item->category_XML} | {$item->price_raw} + {$item->margin}% => {$item->price}<br>"; $articles_final[$sku] = $item; $i++; // dump($art);; // dump($item);exit; } // dump($articles_final);exit; return @$articles_final; }
public function process_xml($type = "FOR_INSERT") { global $logger, $db; $this->store_products = $this->get_imported($this->name); $this->updatedIceCatItems = IceCat::getUpdatedIceCatItemsOK(); $this->import_settings = Settings::get_import_settings($this->name); $cached_ancestors = array(); $fh = @fopen(FEED_PATH . "/215841.csv", "r"); $art = fgetcsv($fh, null, "\t"); // dump($art) ; $i = 0; $bz = 0; $this->all = 0; while (($art = fgetcsv($fh, null, ",")) !== false) { // dump($art);exit; $sku = (int) trim($art[0]); if ($sku == "1520519") { continue; } $store_product_id = @$this->store_products[$sku]; $this->all++; if ($type == "FOR_INSERT" && $store_product_id) { continue; } if ($type == "FOR_UPDATE" && !$store_product_id) { continue; } // exit; if ($type == "FOR_UPDATE") { // if ( !$this->updatedIceCatItems[$sku] ) continue; } $item = new stdClass(); $item->category_XML = $art[12]; if (@$this->category_mapping[$item->category_XML]) { foreach ($this->category_mapping[$item->category_XML] as $catstore) { if (isset($cached_ancestors[$catstore])) { $d = $cached_ancestors[$catstore]; } else { // $logger->LogCron(" - $catstore"); $cached_ancestors[$catstore] = $this->get_category_ancestors($catstore); $d = $cached_ancestors[$catstore]; // $logger->LogCron(" - ok => " . print_r($d, true)); } // dump($d);exit; foreach ($d as $cc) { $item->category_ids[] = (int) $cc; } $item->category_ids[] = (int) $catstore; } } if (@count($item->category_ids) == 0) { //echo $bz++ . ". {$sku} NO CATEGORY ({$item->category_XML}) <Br>"; continue; } //$item->category_ids = array_unique($item->category_ids); // dump($item->category_ids) ;exit; $item->sku = $sku; // part number // dump(explode(",",$this->import_settings['NOT_IMPORT_NAME']));exit; //if (in_array($item->sku, explode(",",$this->import_settings['NOT_IMPORT_SKU']))) continue; // 33,34 $item->quantity = $art[16]; if (!$item->quantity) { continue; } // if ($item->quantity < 10) continue; $item->title = $art[1]; $item->desc_short = ImpLib::limitString($art[23]); $item->desc_long = $art[23]; /* ['0'] = String(18) "Ingram Part Number" | ['2'] = String(20) "Customer Part Number" = 0 | ['3'] = String(18) "Vendor Part Number" | ['6'] = String(13) "Vendor Number" * */ $item->vendor = $art[7]; $item->plant = $art[5]; $item->manufacturer = $art[7]; $item->manufacturer_sku = $art[3]; $item->meta_desc = $item->desc_short; $item->meta_keywords = $item->desc_short; $item->tags = $item->desc_short; //$item->supplier_reference = $art[3]; $item->manufacturer_sku_2 = $art[6]; $item->store_product_id = $store_product_id; $item->supplier = "IM"; //$db->query("UPDATE "._DB_PREFIX_."product_supplier SET id_supplier='{$item->id_supplier}' WHERE id_product='{$store_product_id}'"); $item->manufacturer_id = $this->get_manufacturer_id($item->manufacturer); //dump($item);exit; if ($type == "FOR_INSERT") { //$item->id_manufacturer = $this->get_manufacturer_id($item->manufacturer); //$item->id_supplier = $this->get_supplier_id($art[4]); } $item->ean_upc = $art[4]; $item->online_only = 0; $item->price = $art[13]; $item->rrp = $art[14]; $item->raw_price = $art[13]; // customer price if ($item->price < 0.1) { continue; } // echo Settings::get_margin_from_price($item->price);exit; if ($i == 1500) { $db->query('UPDATE imported SET processed = 0 WHERE supplier="IMNZ"'); } if ($i == 3000) { $db->query('UPDATE imported SET processed = 0 WHERE supplier="IMNZ"'); } $margin = @$this->import_settings['MARGIN'][$item->category_XML]; // dump($this->import_settings['MARGIN']);exit; //dump($this->import_settings); $item->margin = $margin > 0 ? $margin : (int) $this->import_settings['GLOBALPROFITMARGIN']; // dump($item);exit; /// $item->margin = ($margin !="") ? $margin : Settings::get_margin_from_price($item->price); $item->price_raw = $item->price; $item->price = $item->price * (1 + $item->margin / 100); $item->price = $item->price; /// 1.15; // * 1.15; // $item->rrp = $item->rrp * 1.15; echo "{$item->sku} | {$item->category_XML} | {$item->price_raw} + {$item->margin}% => {$item->price}<br>"; $item->wholesale_price = $art[13]; if ($item->wholesale_price == 0) { continue; } $item->weight = (double) $art[9]; $item->length = (double) $art[24]; $item->width = (double) $art[25]; $item->height = (double) $art[26]; // dump($item);exit; $item->active = 1; $item->status = 1; $item->images = array(); //if ($item->active == 0) continue; if ($sku == "2307809") { // dump($art); // dump($item);exit; } $articles_final[$sku] = $item; $i++; // echo $i . " | "; //break; } // dump($articles_final); // exit; return @$articles_final; }