PHP script required to update one field in a
mysql database.
products table
sql dump, csv example and stklevel.dat files attached for your convenience.
The script is required to update stock levels and will be hooked up to a cron job and run every hour.
Field to update - pInStock
The data file stklevel.dat has two columns, column A contains the pID (inique) and column B contains the latest stock levels. Column A will have pID's that may not exist in the products table, these are to be ignored and must not be added to the pID field.
The data file will reside on the server - the exact location is not yet known
The data base connection is configured through the vsadmin/db_conn_open.php file
Timescale - 2-3 days
