we need to develope script 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. Database was created by OsCommerce script.
There are 3 things to import:
1. categories - create categories, subcategories and subsubcategories, 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.
There is one change: URL address of product's image.
In XLS there is for example: [url removed, login to view]
and we need to change it. All pictures are saved on our server in directory: /images/products/
so just change [url removed, login to view] for images/products/ I think.
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 is almost 3000 records in the catalogue.
Thank you for reading. Looking forward for your bids.