Import products from XML,XLS or CSV to OsCommerce webshop

Dear coders,

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.


Peter Macel

For downloading whole XLS catalogue please use this link:

Beceriler: PHP, XML

Daha fazlasını gör: import xls oscommerce, oscommerce xls import, oscommerce import xls, webshop xml import, oscommerce import products xml, oscommerce xml import products, oscommerce example xls, products webshop xls, csv webshop, oscommerce csv import, php import xls, xml import oscommerce, xls import oscommerce, import xml xls, oscommerce xml csv, webshop csv, xls oscommerce, import xls file oscommerce, csv oscommerce, import xml webshop

İşveren Hakkında:
( 3 değerlendirme ) Janova Lehota, Slovakia

Proje NO: #129255



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

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(2 Değerlendirme)

Bu iş için 11 freelancer ortalamada $78 teklif veriyor


Can help you. Please provide example xls file in PMB with just few lines. Thanks!

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(391 Değerlendirme)

Glad to work. Regards

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(286 Değerlendirme)

We can do it.

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(100 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde80%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(39 Değerlendirme)

Please check PMB. Thanks.

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(45 Değerlendirme)

Hello! If possible provide me a sample of this XLS file. Thanks in advance

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(27 Değerlendirme)

Hello, I can write such a script.

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)

See PM plz

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)

Hi i am intrested in your project to do it.

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Dear Sir I have 3 years experience in php,mysql,smarty,oscommerce,ajax,javascript. Following oscommerce sites are developed by me. Oscommerce:-- [login to view URL] CRE Loaded:- [login to view URL] [login to view URL] Daha Fazla

in %bids___i_period_sub_35% gün içinde40%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)