";*/
$previousid = "";
$previousCostship = 0;
while (($data = fgetcsv($handle, 1000, " ")) !== FALSE)
{
$artSKU = "";
$frameSKU = "";
$tileSKU = "";
if ($row > 0)
{
//echo "in the while loop";
//$name = addslashes($data[1]);
if ($data[0] != "")
$orderID = addslashes($data[0]);
else $orderID = "";
/* if ($data[1] != "")
$lineNumber = $data[1];
else $lineNumber = 1;
*/
if ($data[1] != "")
$upc = $data[1];
else $upc = 1;
if ($data[2] != "")
$SKU = $data[2];
else $SKU = "";
if ($data[3] != "")
$ASIN = $data[3];
else $ASIN = "";
if ($data[4] != "")
$Title = addslashes($data[4]);
else $Title = "";
if ($data[5] != "")
{
$galleryPrice = $data[5];
$galleryPrice= preg_replace('/[\$,]/', '', $galleryPrice);
}
if ($data[7] != "")
{
$salePrice = $data[7];
$salePrice= preg_replace('/[\$,]/', '', $salePrice);
}
if ($data[8] != "")
$qty = $data[8];
else $qty = "";
if ($data[22] != "")
$DC = $data[22];
else $DC = "";
$pos = strpos($SKU, "FR-");
$pos2 = strpos($SKU, "-GAL");
if ($pos)
{
$artSKU = substr($SKU,0,$pos-1);
$frameSKU = substr($SKU,$pos); //find the frame part number
}
else if ($pos2)
{
$artSKU = substr($SKU,0,$pos2);
$frameSKU = substr($SKU,$pos2+1); //find the frame part number
}
else
{
$artSKU = $SKU;
$frameSKU = "";
}
//update amazon Vendor POs table
$query_amazonV = "INSERT INTO `amazonVOrders` (orderID,SKU,artSKU,frameSKU,UPC,ASIN,Title,qty,galleryPrice,salePrice,DC) VALUES ('$orderID','$SKU','$artSKU','$frameSKU','$upc','$ASIN','$Title','$qty','$galleryPrice','$salePrice','$DC');";
echo "row #" . $row . " the query: " . $query_amazonV . "
";
mysql_query($query_amazonV); // or die("Couldn't add row2 $name");
}
$row++;
}
//echo "order # " . $orderid . " Ship Cost: " . $cost . "
";
/*$query = "UPDATE `manual_orders` SET cost = '$sumCost' WHERE orderid = '$prev_orderid' LIMIT 1; ";
mysql_query($query) or die("Couldn't add row 1");
*/
fclose($handle);
?>