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.
For downloading whole XLS catalogue please use this link:
Professional developer here. I have done many projects on osCommerce. So, I have enough knowledge of osCommerce database and constraints. Also, I have more than 1 year of experience on PHP/MySQL.. So, Hoping to get an Daha Fazla
Bu iş için 11 freelancer ortalamada $78 teklif veriyor
Dear goldux, thanks for your zip file, I have looked at it. This should be a 3 hours job after we settle down the requirment. Because I have done three similiar projects before, thus I can assure you this project can b Daha Fazla