<!DOCTYPE HTML>
<html>
<head>
<?php
include 'awsScript.php';
?>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
</head>
<body>
<?php
itemLookup('B000MXKMJY');
?>
</body>
</html>
fwrite($log, "FAILED to update old item_prices record with end_date for {$row['id']} :: " . $dbh->error . "\n");
return false;
}
}
$query = "INSERT INTO item_prices (item_id, item_price_type_id, price, start_date, end_date) VALUES ('{$itemid}', '{$type}', '{$price}', '{$start}', NULL)";
if (!$dbh->query($query)) {
fwrite($log, "FAILED to insert new item_prices record - {$query} :: " . $dbh->error . "\n");
return false;
}
return true;
}
print "\nProcessing price sheet file ";
// Cycle through the main loop
while (($data = fgetcsv($file, 1024, ',')) !== false) {
print '.';
if ($item_id = itemLookup($data[0], $data[1])) {
// set the UK price
if (!$data[3]) {
// skip to next record
fwrite($log, "MISSING PRICE value for {$item_id} :: " . $dbh->error . "\n");
continue;
}
itemPrice($item_id, $data[3], 6, $data[2]);
if ($data[4]) {
// US price
itemPrice($item_id, $data[4], 1, $data[2]);
}
if ($data[5]) {
// CAN price
itemPrice($item_id, $data[5], 3, $data[2]);
}
