We require some software to update our prices and quantity's of our store products aswell as a few other lines e.g product description etc.
We don't mind how the software is made i.e if its stand alone and works with windows or if its a php script, so long as it does what we require.
We receive csv or tab delimited pricelists from our suppliers daily and we need this software that is to be made to
1. gather the model number from the suppliers list and find the same model on our master spreadsheet
2. Find the qty for that model in the suppliers list and then update the models quantity in our master spreadsheet.
This software must give us the ability to pick and choose between prices. e.g we have the model: apple and there are 3 suppliers that sell the model: apple. as each model is unique in the database it must only accept one of the suppliers prices, being a. the one that is in stock or b. the cheapest.
It must also check for duplicates from the suppliers sheet to ours and also inform us if there are new products on the suppliers spreadsheets that we do not have in our master category, it must also inform us if products are missing from the supplier spreadsheet that appear on our master spreadsheet.
Also there must be a hidden entry that will tell us who the supplier is for the given item.
We upload the master spreadsheet to our website and then thats it all should be updated.
Please only bid if you can have this script / standalone program completed within 5 days as this is an urgent project.
The website is running on cre loaded 6.2 b2b, you will have to know php to be able to add the suppliers name to the database of our website.