', $data[12]);
$cats[$a] = $cat[0];
if($cat[1] != '')
$subs[$cat[1]] = $cat[0];
$a++;
}
}
sort($cats);
foreach($cats as $cat)
{
if($cat != $last_cat)
{
$result = mysql_fetch_assoc(mysql_query("SELECT categories_id FROM categories_description WHERE categories_name='$cat'"));
if($result['categories_id'] == '')
{
$sql = "INSERT INTO categories (categories_image, date_added) VALUES ('".$cat.".jpg', '".date('Y-m-d H:i:s')."')";
mysql_query($sql);
$id = mysql_insert_id();
$sql = "INSERT INTO categories_description (categories_id, categories_name) VALUES ('$id', '$cat')";
mysql_query($sql);
echo $cat.'
';
}
$last_cat = $cat;
}
}
asort($subs);
foreach($subs as $key => $var)
{
$result = mysql_fetch_assoc(mysql_query("SELECT categories_id FROM categories_description WHERE categories_name='$key'"));
if($result['categories_id'] == '')
{
$cat = mysql_fetch_assoc(mysql_query("SELECT categories_id FROM categories_description WHERE categories_name='$var'"));
$im = mysql_fetch_assoc(mysql_query("SELECT categories_image FROM categories WHERE categories_id='".$cat['categories_id']."'"));
$sql = "INSERT INTO categories (categories_image, date_added, parent_id) VALUES ('".$im['categories_image']."', '";
$sql.= date('Y-m-d H:i:s')."', '".$cat['categories_id']."')";
mysql_query($sql);
$id = mysql_insert_id();
$sql = "INSERT INTO categories_description (categories_id, categories_name) VALUES ('$id', '$key')";
mysql_query($sql);
}
}
fclose($handle);
// Sort Categories Alphabetically
// Create Products SQL
$handle = fopen("stock.csv", "r");
while (($data = fgetcsv($handle, 2048, ",")) !== FALSE){
$date = date('Y-m-d H:i:s');
if(($data[0] != '')&&($data[12] != '')&&($data[0] != 'Model'))
{
$data[11] = $data[11] / 1.175;
if($data[11] < 10)
$price = money_format('%!i', ($data[10] + (($data[11] - $data[10])/1.5)));
else
$price = money_format('%!i', ($data[10] + (($data[11] - $data[10])/2)));
$rrp = money_format('%!i', $data[11]);
$sql = "INSERT INTO products (products_model, products_image, products_price, products_date_added, products_weight, ";
$sql.= "products_status, products_tax_class_id) VALUES ('".$data[0]."', '".$data[3]."', '".$price."', ";
$sql.= "'".$date."', '".$data[2]."', '1', '1')";
mysql_query($sql);
echo $sql.'
';
$id = mysql_insert_id();
$sql = "INSERT INTO products_description (products_id, products_name, products_description) VALUES ('$id', '".$data[1];
$sql.= "', '".ereg_replace("'", "\'", $data[5])."')";
mysql_query($sql);
echo $sql.'
';
$category = explode('->', $data[12]);
if($category[1] == '')
$cat = $category[0];
else
$cat = $category[1];
$cat = mysql_fetch_assoc(mysql_query("SELECT categories_id FROM categories_description WHERE categories_name='$cat'"));
$sql = "INSERT INTO products_to_categories VALUES ('$id', '".$cat['categories_id']."')";
mysql_query($sql);
echo $sql.'
';
}
}
fclose($handle);
mysql_close($conn);
?>