Hello this is what I need.
I need to developed script/ program for importing products into database for OsCommerce shop. We have data in XLS (MS Excel) format. Now we need to import all data to our database in MySQL. I need an easy why to upload the database to my Oscom site and make changes on the file attached is the file..
Product name and Products Description are the same..
There are 3 things very import:
1. Categories - create categories, subcategories and sub subcategories, so 3 levels of categories are in XLS
2. Manufacturers - import manufacturers from files: Name of manufacturer and URL of manufacturer are in XLS
3. Products - according to created categories and manufacturers, script will add all products from XLS to database.
The script should be able to update all products every time we get new XLS file by replacing existing products with new prices or adding new products if there are some.
There are almost 4000 records in the catalogue.