In order to have OsCommerce add-on "Easy Populate" function as a product adder, a product translator, a product modifier and a product-to-store allocator, the EP add-on needs to be changed with the following:
1) Whenever a product is submitted from a csv file to EP, the script should only add the full information of the product to the database when that product does not yet exist in the db (having same model number).
2) When a product does not yet exist in the database, the title and the description of the product need to be translated to the two columns (title + desc) of that language, using Google's Translation API.
3) When a product does exist in the database, only the price needs to be updated.
4) When the column 'store' in the csv file contains, on a product row, the name of a store, this product, along with its category, needs to be allocated to the id of a store. I'm using the Multi stores add-on.
An earlier version of EP has been modified for the Multi stores add-on, so you could probably just copy some of that code.? <[url removed, login to view],1730>? (@ 1 Mar 2006) - look for some of the code that's preceded by //rmh M-S_easypopulate
Please only reply when you have experience with these kinds of things, can start now and can commit to the set deadline.