name] = $obj->id;
}
echo "get data
";
// get items
$query = mysql_query('SELECT * FROM import_artikelcsv') or die("Anfrage nicht erfolgreich");
$data = array();
while($obj = mysql_fetch_object($query)) {
$data[] = $obj;
}
echo "imports
";
foreach ($data as $object) {
$manufacturer_id = 1;
if(isset($manufacturers[$object->ersatzteilvertreiber])) {
$manufacturer_id = $manufacturers[$object->ersatzteilvertreiber];
}
$sql = "
UPDATE items
SET
attribute_7='".mysql_real_escape_string($object->navisionid)."',
attribute_8='".mysql_real_escape_string($object->merkmale)."',
attribute_9='".mysql_real_escape_string($object->aufdrucke)."',
attribute_10='".mysql_real_escape_string($object->handlingeinheit)."',
attribute_11='".mysql_real_escape_string($object->handlingsifaktor)."',
attribute_12='".mysql_real_escape_string($object->verpackungseinheitfaktor)."',
ean_code='".mysql_real_escape_string($object->ean)."',
vendor_item_number='".mysql_real_escape_string($object->teilenrlieferant)."',
shipping_weight='".mysql_real_escape_string($object->gewicht)."',
manufacturer_id='".$manufacturer_id."'
WHERE number='".$object->altenr."'
";
//echo $sql.'
';
$query = mysql_query($sql);
if (!$query) {
echo $sql;
echo "
";
}
}
echo "ende
";
?>