Script to import from several CSV/XML/XLS files to Prestashop

We need an script to import from several CSV/XML/XLS files (attached examples) from internet to an mysql database for a prestashop site. The script should be written in php+mysql. We are doing dropshipping from some suppliers that publish a file that we need to import to our prestashop database on a dayly basis. PROJECT EXPLANATION ==================== We need: 1) A database with two tables (suppliers and categories) 2) One PHP script for import from several CSV / XML / XLS files. 3) A text log file for reference THE DATABASE In mysql. I provide the cpanel login (to create the database) and a login to a test prestashop (later will be copied to the production site) Table 1: suppliers: name -> name of supplier tax -> tax applied to the supplier products URL -> of the CSV/XML/XLS file to import carrier -> to be assigned to each product of same supplier benefit -> % to add to the prize each product of each supplier by default (each categories have one benefit that will prevail) text_to_add -> to add to the description of each product language -> of the description of the producs: will be en-english, es-spanish and ru-russian Table 2: Categories supplier -> to link each producto with his supplier (index) category_local -> the name of the category on the local shop category_csv -> the name of the category on the csv (supplier given name) benefit -> % to add to the prize of each product (if absent, must to be used the benefit in supplier table) tex_to_add -> a text to add to the description of each product in same category (first the product description, then the product text_to_add, and last this text_to_add) THE PHP SCRIPT The PHP script is for import from several CSV / XML / XLS files. Each supplier has one different, so the script will grow by adding more and more. The first version will include one supplier and we will pay $50 (first milestone). The other suppliers will be added later at $20 by each new supplier/file. Steps: 1).- Delete the [login to view URL] file if more than 5 Mb (to avoid to increase without limit). 2).- Process each supplier by downloading to a local directory the remote csv file (first see if the files are the same. If yes, do not process it): a CASE sentence for each supplier, to do easy future modifications and supplier additions. For each one: 3).- Process the CSV file for the categories a) extract the categories/subcategories from the CSV file b) if the category is not in the database, add it and write this error in log file (to update later by hand the related category in local shop) c) If a category is in database but it is not in the CSV file anymore, delete it from database with the related products (write an error to log file) 4).- Process the CSV for the products that have categories in local database (both local category and csv category) update the products database. a) if the product exist in local database (shop) update it (all fields that change) b) if the producto does not exist in local database (shop) add it c) if the product exists in local database but not in the CSV, delete it. 5).- Translate the product database: a) from english to spanish (if absent) and from english to russian (if absent) b) from spanish to english (if absent) and from spanish to russian (if absent) Notes for #4: Each field in prestashop product database will be linked with a field in CSV, plus adding the: carrier name and tax. To the extended description the fields text_to_add in suppliers and in categories must be added. LOG FILE Formart: date, hour, supplier - text error or information 30/02/2015 15:59 DRESSLINK - The text error or information We provide a test site. When the job is done and error free, will be uploaded to the production site. Milestones: - 50$ script, database and log, working with 1 wholesaler on production site. - 20$ each new wholesaler (each CSV/XML/XLS has minor changes) x 10 on production site. Total 250$ at the end of the project. Maximum price. Please do not bid if not agree.