There is a bug when calling the order table update in the code amazonorder.php.

buggy line
PHP Code:
$sql_order_date_update = "UPDATE ".TABLE_ORDERS." set date_purchased = '".$data->getOrderDate()."' where orders_id = '$insert_id'"; 
Fixed line
PHP Code:
$sql_order_date_update = "UPDATE ".TABLE_ORDERS." set date_purchased = ".$data->getOrderDate()." where orders_id = '$insert_id'"; 
the issue is, getOrderDate returns 'now()'. the buggy line is again wrapped with single quote and hence the date is random.

In SQL query, when using now() mysql function, they should *not* be wrapped with quote. Now i got it working :)