Little Shop of Horrors :Audrey II

Description

$sql=”Insert into
eqhql_posts (id,post_author,post_date,post_date_gmt,post_content,post_title,post_status,post_type)
select stockid,’1′,NOW(), convert_tz(NOW(),’-08:00′,’+00:00′), longdescription,description,’draft’,’product’ from stockmaster
where stockid='” .$StockID. “‘”;
DB_query($sql);
$sql=”Insert into eqhql_postmeta
(post_id,meta_key,meta_value)
Select stockid, ‘_width’, eoq
from stockmaster where stockid='”.$StockID.”‘”;
DB_query($sql);
$sql=”Insert into eqhql_postmeta
(post_id,meta_key,meta_value)
Select stockid, ‘_length’, volume
from stockmaster where stockid='”.$StockID.”‘”;
DB_query($sql);
$sql=”Insert into eqhql_postmeta
(post_id,meta_key,meta_value)
Select stockid, ‘_height’, grossweight
from stockmaster where stockid='”.$StockID.”‘”;
DB_query($sql);
$sql=”Insert into eqhql_postmeta
(post_id,meta_key,meta_value)
Select stockid, ‘_weight’, netweight
from stockmaster where stockid='”.$StockID.”‘”;
DB_query($sql);
$sql=”Insert into eqhql_postmeta
(post_id,meta_key,meta_value) Select stockid, ‘_op_cost_price’, materialcost
from stockmaster where stockid='”.$StockID.”‘”;
DB_query($sql);

$sql=”Insert into eqhql_postmeta
(post_id,meta_key,meta_value)
select stockid, ‘_sku’, barcode
from stockmaster where stockid='”.$StockID.”‘”;
DB_query($sql);
$sql=”Insert into eqhql_postmeta
(post_id,meta_key,meta_value) values
(“.$StockID.”, ‘_manage_stock’, ‘YES’)”;
DB_query($sql);

$sql=”Insert into eqhql_postmeta
(post_id,meta_key,meta_value) values
(“.$StockID.”, ‘_stock’, 0)”;
DB_query($sql);

$sql=”Insert into eqhql_term_relationships
(object_id,term_taxonomy_id,term_order) values
(“.$StockID.”, ‘279’, 0)”;

DB_query($sql);
$sql=”Insert into eqhql_postmeta
(post_id,meta_key,meta_value) values
(“.$StockID.”, ‘_price’, 0)”;
DB_query($sql);
$sql=”Insert into eqhql_postmeta
(post_id,meta_key,meta_value) values
(“.$StockID.”, ‘_regular_price’, 0)”;
DB_query($sql);
$sql=”Insert into eqhql_postmeta
(post_id,meta_key,meta_value) values
(“.$StockID.”, ‘_awcdp_deposit_enabled’, ‘no’)”;
DB_query($sql);
$sql=”Insert into eqhql_postmeta

(post_id,meta_key,meta_value) values

(“.$StockID.” ,’_wc_pre_orders_enabled’,’no’)”;

DB_query($sql);