PHP script required to update one field in a mysql database.
products table sql dump, csv example and [url removed, login to view] 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 [url removed, login to view] 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/[url removed, login to view] file
Timescale - 2-3 days