I need a little module that import a CSV file from a remote site every day at a defined time, wich have to be able to update the corresponding products field for the selected supplier.
We use this method to have in the system the availability of prodcuts from our supplier or the ETA (estimated time of arrival).
The programmer should do these step:
1 - create a new table wich will be used to store data about availability from each supplier (considering there is already a table with supplier data (name and so on))
2 - implement a way to insert in the admin / products edit page the products model for each supplier: would be nice to have a little ajax program to add only the needed supplier and the code on the fly
3 - import the csv file every day at a defined time and update the field in the new table as described before