Đã Đóng

mySQL database to be filled with Icecat product data XML

Icecat ([url removed, login to view]) provides online shops and price comparison sites with structured product data for computers, electronic consumer goods, cameras, mobile phones and other gadgets. I need somebody who uses Icecats XML interface to store product data from selected product categories in a mySQL database (that has to be build up) and makes this data accessible for further processes. A presentation of Icecat and its XML interface can be found here: [url removed, login to view]

This is the job:

Download/transfer data from all products of these product categories:

- Notebooks (Category ID 151)

- Netbooks (Category ID 1561)

- Mobile & Smartphones (Category ID 119)

- Digital Cameras (Category ID 575)

- LCD TV (Category ID 1078)

- Plasma TV (Category ID 903)

- GPS navigation systems (Category ID 910)

Please notice that:

- I only need the product categories in the German language version (LanguageID= „4“)

- Only structured product data are needed (Product Quality = „ICECAT“)

- Product data of related products („ProductRelated“) are not needed neither

- To start with, the database will have to be build and tested with the free available brands („Open Icecat“). At the final project stage we would switch to the entire Icecat data base that includes all brands („Full Icecat“). The data structure is identical, only the XML addresses have to be changed.

Automatic update of the mySQL database

Icecat provides an update XML on a daily basis (*[url removed, login to view]) that contains new and obsolete products.

With respect to daily updates you will have to write a routine that

- updates the mySQL database on a daily basis for the seven product categories mentioned above (add new, remove old products),

- updates are only needed for the German market (<Country Market value = "DE">)

- sends a notification mail after each daily update with a .csv file attached stating which products have been added and which products have been removed (short information for each product such as date, category, added/removed, brand, product name, EAN, Icecat product ID)

Browser based Admin view to enable non IT experts to handle the mySQL database

This admin view should enable the following actions:

- export of product data sets in a .csv data file with filters to select

o which product data sets to export (e.g. category, date)

o which product features to include in the export (all, brand, specific product features etc.). For each product category this selection can be stored as a default for future exports.

- Direct search for specific products (e.g. brand, product name, EAN, Icecat product ID)

- Manual upload of additional products (within the given categories) with .csv data files structured according to the product information in the category

- Note: given a solid functionality of this admin view and possibilities to select and export data sets filtering for date ranges, the “mail notification functionality after uploads” mentioned above could be omitted.

Support with hosting and configuration

You should help me to choose the right selection and evaluation criteria for hosting providers and their services. Furthermore, I will need support to install and configure the database with a German provider.


You will have to transfer all rights for the developed services to me.

In case of a successful cooperation there will be more programming to be done for me (integration of Amazon API and price comparison services, other language versions, personal account services and many more).

You should state a fix price and a termination date for this project in your bid. Please mention references to past projects related to this one.

A sound knowledge of Perl is preferred but not mandatory as my services will use Perl to work with the Icecat product data.

Kỹ năng: MySQL, Perl, PHP, XML

Xem thêm: icecat computers category, icecat mysql, icecat database, mysql categories icecat, full icecat database download, download icecat database, xml icecat product, icecat mysql database, data icecat database, icecat category xml, icecat amazon, icecat csv, ean icecat, icecat perl, xml use case, xml services, xml programming needed, use references, help php online, view xml online, uses data structure, use data structure programming, use data structure, use case includes, use case amazon

Về Bên Thuê:
( 14 nhận xét ) Weilheim, Germany

Mã Dự Án: #1055511

23 freelancer đang chào giá trung bình €995 cho công việc này


Please check PMB for details.

€800 EUR trong 25 ngày
(66 Đánh Giá)

pls chk pmb

€1375 EUR trong 10 ngày
(537 Đánh Giá)

Please check PMB. Thanks.

€750 EUR trong 15 ngày
(420 Đánh Giá)

Please check a PMB.

€1000 EUR trong 14 ngày
(69 Đánh Giá)

--Hello Thomas, Please check your pm. Thanks.--

€800 EUR trong 5 ngày
(69 Đánh Giá)

Please check PM

€800 EUR trong 15 ngày
(57 Đánh Giá)

Please check your PMB

€750 EUR trong 30 ngày
(128 Đánh Giá)

Ready to start, please see PM for more details

€800 EUR trong 8 ngày
(85 Đánh Giá)

Kindly check pmb please.

€900 EUR trong 30 ngày
(41 Đánh Giá)

we are experienced in XML parsing, please check PM

€750 EUR trong 15 ngày
(33 Đánh Giá)

Please see pm. Thanks

€1000 EUR trong 30 ngày
(17 Đánh Giá)

Please see PM

€1250 EUR trong 45 ngày
(3 Đánh Giá)

Dear Sir, please read PM I sent you. I described all details about my bid there. Best regards, Jan

€1000 EUR trong 21 ngày
(23 Đánh Giá)

Please see my PM

€750 EUR trong 25 ngày
(9 Đánh Giá)

Hello, please see private message, thanks.

€1000 EUR trong 45 ngày
(3 Đánh Giá)

6 years old in web development.

€750 EUR trong 20 ngày
(6 Đánh Giá)

Hi I have experience with price comparision and feed csv,xml import to mysql/oracle I worked for pricegrabber.com, e-rackonline.com in developing APIs Please check my reviews. Thank you Vasundhar Boddapat Thêm

€1600 EUR trong 30 ngày
(1 Đánh Giá)

I can do it.

€1200 EUR trong 30 ngày
(2 Đánh Giá)

Hi, I do same work frequently, so I can help you.

€1000 EUR trong 10 ngày
(0 Đánh Giá)

we have experience of similar type of project

€1100 EUR trong 40 ngày
(0 Đánh Giá)