magento import/merge

1. you get a magento 1.4.1.1 store, prepopulated with products (around 4000, but it doesn't matter) 1.1 each product has a custom attribut "EAN" (important, EAN looks like a number, but can have leading zeroes like "0688399") 2. you get a table with products, either as CSV or imported into a MySQL table (as you prefer) with columns: "EAN", "cost", "manufacturer", "stock quantity", "magentoID" (this last column is empty, see 3.3) 3. you need to write a script (SQL or PHP, your choice) which does this (pseudocode): 3.1 for each magento product, if category != X (we need to exclude some products) do read value ("EAN") 3.2 lookup in external table of products (see 2.) the product with the value of "EAN" (from 3.2) 3.3 take the product you found in 3.3 and copy the values of "cost", "manufacturer", "stock quantity" from external table of products into the product in magento you selected in 3.1 3.4. put the value of magentoID of the current product in magento (ie the unique identifier of magento products: [login to view URL]) into the column magentoID in the external table (so that we later know, where we put all this data) done this script doesn't need to be portable, reusable or whatever, after the job it will belong to you, we are not interested in copyrights or your IP, we just need to get the products merged. you get full access to the magento store, which is on our servers, you can remotely access the mysql db, so you don't need to jump thru loops to get the job done. i will assist you and will be available for questions and data preparation etc. we need this done by monday night CET if in any way possible, but as it is almost a one liner, chances are good i think..