OS커머스 -> 영카트 카데고리 이동 및 상품 이동 정보
OS커머스 -> 영카트 카데고리 이동 및 상품 이동
본문
변환프로그램으로 가려면 손 볼 곳이 너무나도 많아서
혹시 필요하신분 있으면 조금이라도 참고 하실까 싶어 올려봅니다.
작업이 지연되어 무척 바삐 작업했던거라 많이 엉성합니다.
바로 적용은 무리가 있고 필요에 따라 수정해서 쓰셔야 할겁니다.
(이미지 부분은 옮기지 않았습니다. 가격부분 등 필드 수정해야 됩니다.)
(중간중간에 세금 적용 및 기타 몇가지 수정사항이 있어서 소스가 완벽하지 않습니다)
1. 카데고리 이동(먼저 영카트 카데고리 테이블에 cat_id 필드를 잠시 생성 상품옮길때 참고용)
<?
include_once("./_common.php");
include_once("./head.sub.php");
//exit;
$sql = '
SELECT categories_id as cat_id, categories_name as cat_name
FROM `categories_description`
WHERE language_id = 5
';
$result = sql_query($sql);
while($row=sql_fetch_array($result)) {
$cat_list["{$row[cat_id]}"] = $row['cat_name'];
}
$sql='
SELECT *
FROM `categories`
';
$result = sql_query($sql);
while($row=sql_fetch_array($result)) {
$cat_list2["{$row['parent_id']}"]["{$row['categories_id']}"] = $cat_list["{$row['categories_id']}"];
}
//print_r2($cat_list2);
for($i=1;$i <=3; $i++) {
$sh_cat["{$i}0"]['_num']=$i;
$sh_cat["{$i}0"]['name']=$cat_list2[0][$i];
$temp=$cat_list2[$i];
$j=1;
foreach($temp as $key=>$value) {
$sh_cat["{$i}0"]["{$i}0{$j}0"]['_num']=$key;
$sh_cat["{$i}0"]["{$i}0{$j}0"]['name']=$value;
if(is_array($cat_list2["{$sh_cat["{$i}0"]["{$i}0{$j}0"]['_num']}"])) {
$k=1;
$temp2=$cat_list2[$key];
foreach($temp2 as $key2=>$value2) {
$sh_cat["{$i}0"]["{$i}0{$j}0"]["{$i}0{$j}0{$k}0"]['_num']=$key2;
$sh_cat["{$i}0"]["{$i}0{$j}0"]["{$i}0{$j}0{$k}0"]['name']=$value2;
$k++;
}
}
$j++;
}
}
//print_r2($sh_cat);
foreach($sh_cat as $key=> $value) {
$ok[$key]=$sh_cat[$key]['name'];
$ok2[$key]=$sh_cat[$key]['_num'];
foreach($value as $key2 => $value2) {
$ok[$key2]=$sh_cat[$key][$key2]['name'];
$ok2[$key2]=$sh_cat[$key][$key2]['_num'];
if(is_array($value2)) {
foreach($value2 as $key3 => $value3) {
$ok[$key3]=$sh_cat[$key][$key2][$key3]['name'];
$ok2[$key3]=$sh_cat[$key][$key2][$key3]['_num'];
}
}
}
}
unset($ok['name'],$ok['_num'],$ok2['name'],$ok2['_num']);
//print_r2($ok2);
//exit;
foreach($ok as $key=>$value) {
$sql_common = " ca_skin = 'list.skin.10.php',
ca_opt1_subject = '$ca_opt1_subject',
ca_opt2_subject = '$ca_opt2_subject',
ca_opt3_subject = '$ca_opt3_subject',
ca_opt4_subject = '$ca_opt4_subject',
ca_opt5_subject = '$ca_opt5_subject',
ca_opt6_subject = '$ca_opt6_subject',
ca_img_width = '120',
ca_img_height = '120',
ca_sell_email = '$ca_sell_email',
ca_use = '1',
ca_stock_qty = '99999',
ca_explan_html = '1',
ca_list_mod = '4',
ca_list_row = '5',
ca_head_html = '$ca_head_html',
ca_tail_html = '$ca_tail_html',
ca_include_head = '$ca_include_head',
ca_include_tail = '$ca_include_tail',
ca_mb_id = '$ca_mb_id' ";
$sql = " insert $g4[yc4_category_table]
set ca_id = '$key',
ca_name = '$value',
cat_id = '{$ok2[$key]}',
$sql_common ";
sql_query($sql);
}
?>
2. 상품이동
<?
include_once("./_common.php");
include_once("./head.sub.php");
//exit;
// price_u
// it_amount2
/*
$sql = "ALTER TABLE yc4_item ADD old_pic_2 VARCHAR(64) NOT NULL ";
sql_query($sql);
$sql = "ALTER TABLE yc4_item ADD price_u decimal(15,4) NOT NULL ";
sql_query($sql);
$sql = "ALTER TABLE yc4_item ADD weight decimal(5,2) NOT NULL ";
sql_query($sql);
$sql = "ALTER TABLE yc4_item ADD tax int(11) NOT NULL ";
sql_query($sql);
$sql = "ALTER TABLE yc4_item ADD old_id int(11) NOT NULL ";
sql_query($sql);
exit;
*/
// 코드 time()
$sql = '
SELECT products_id as old_id, products_image as old_pic_1, products_image_sm_1 as old_pic_2, products_price as price_u, products_weight as weight, products_tax_class_id as tax
FROM `products`
';
$result = sql_query($sql);
while($row=sql_fetch_array($result)) {
$cat_list["{$row[old_id]}"] = $row;
}
$sql = '
SELECT products_id as old_id, categories_id as cat_id
FROM `products_to_categories`
';
$result = sql_query($sql);
while($row=sql_fetch_array($result)) {
$cat_list["{$row[old_id]}"]['cat_id'] = $row['cat_id'];
}
//print_r2($cat_list);
$sql = '
SELECT *
FROM `yc4_category`
';
$result = sql_query($sql);
while($row=sql_fetch_array($result)) {
$_cat["{$row[cat_id]}"] = $row['ca_id'];
}
//print_r2($_cat);
//한글설명만 가져온다
$sql="
SELECT *
FROM `products_description`
WHERE `language_id` =5
";
$result = sql_query($sql);
while($row=sql_fetch_array($result)) {
$_description["{$row[products_id]}"]['it_gallery'] = 0;
$_description["{$row[products_id]}"]["it_name"] = $row['products_name'];
$_description["{$row[products_id]}"]["it_basic"] = $row['products_name'];
$_description["{$row[products_id]}"]['it_explan'] = addslashes($row['products_description']);
}
foreach ($cat_list as $num => $value) {
$ca_id = $_cat["{$value['cat_id']}"];
unset($value['cat_id']);
if($_description["{$value['old_id']}"]) $value = array_merge($value,$_description["{$value['old_id']}"]);
$value['ca_id'] = substr($ca_id, 0, 2);
if($ca_id[2]) $value['ca_id2'] = substr($ca_id, 0, 4);
if($ca_id[4]) $value['ca_id3'] = substr($ca_id, 0, 6);
$sql_common='';
foreach ($value as $s_key => $s_value) {
$sql_common .= "
$s_key = \"$s_value\", ";
}
$it_id = time()+$t;
$sql = " insert yc4_item
set it_id = '$it_id',
$sql_common
it_type1 = 0,
it_explan_html = 1,
it_use = 1,
it_stock_qty = 99999,
it_time = '$g4[time_ymdhis]',
it_ip = '$_SERVER[REMOTE_ADDR]',
it_order = '$it_order',
it_tel_inq = '$it_tel_inq'
";
sql_query($sql);
$t++;
}
//print_r2($ca_id);
$sql = "update yc4_item set it_amount2 = price_u";
sql_query($sql);
exit;
?>
영카트 팁으로 가야될까요? 음..;;
추천
0
0
댓글 0개