445605 Extract All eBay Categories to MySQL Database and more.. - Repost - open to bidding

What I am looking for is a programmer who excels in PHP, AJAX, MySQL and API calls/Data mining to perform the following three simple tasks. No styling is required, just a few clean basic PHP pages with information on.

The successful applicant must have excellent English and keep lines of communication open as often as possible, and should they complete this successfully, there's much more work in the future.

Here's what is needed:

STEP ONE: Create a script that extracts a COMPLETE list of eBay categories from [login to view URL] and inserts them to a MySQL database. I believe this page (at the time of writing) illustrates what I ultimately need. [login to view URL]

This should be a simple API call or you can carry it out in your own chosen method, as long as the I end up with a database populated of ALL eBay categories and no duplicates. This includes eBay's motor categories. The table is structured as the following SQL INSERT example:

INSERT INTO categories (category_id, parent_id, category_label, issubcat) VALUES (20081, 0, 'Antiques', 'Yes');

category_id -- the eBay category ID

parent_id -- the parent category ID if there is one

category_label -- the category name

issubcat -- denotes whether there's any sub categories

STEP TWO: Create a PHP page that lists the top level (root) categories initially, that is expandable when you click on the category IDs (in the square brackets). Essentially it's a simple expandable navigation tree with breadcrumbs at the top, displayed as follows:



Antiques [ 20081 ] edit

Art [ 550 ] edit

Baby [ 2984 ] edit

Books [ 267 ] edit

Business & Industrial [ 12576 ] edit

Cameras & Photo [ 625 ] edit

Cell Phones & PDAs [ 15032 ] edit

*and so on...

For example, should you click on the category ID [ 20081 ] (above) it should expand and look as follows with a new breadcrumb (clickable) displayed at the top:

Home -> Antiques


Antiquities [ 37903 ] edit

Architectural & Garden [ 4707 ] edit

Asian Antiques [ 20082 ] edit

Books & Manuscripts [ 2195 ] edit

Decorative Arts [ 20086 ] edit

Ethnographic [ 2207 ] edit

*and so on...

And should you then click on the [ 37903 ] link, the following will show.

Home -> Antiques -> Antiquities


The Americas [ 37908 ] edit

Byzantine [ 162922 ] edit

Celtic [ 162923 ] edit

Egyptian [ 37905 ] edit

Far Eastern [ 162916 ] edit

STEP THREE: Make each category editable. By clicking on the 'edit' link next to each category, a new page must appear allowing you to edit or delete the information in the database for that record. It also needs a confirmation request to ensure you really want to save the changes or delete the record.

NOTES: FTP details will be provided to winning bidder along with MySQL database details. All uploaded work should be carried out on project owner's servers. Good luck and I look forward to working with one of you.

Skills: MySQL, PHP

About the Client:
( 0 reviews ) Sweden

Project ID: #5698503

11 freelancers are bidding on average $187 for this job


Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks

$237 USD in 11 days
(459 Reviews)

Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi

$230 USD in 5 days
(293 Reviews)

Hello Sir, We have gone through the details you have provided and would be pleased to work on this with you to deliver the results that you have expected and We are sure you will not be disappointed if you give us More

$175 USD in 4 days
(110 Reviews)

Hello, I'll provide you categories and list as per your requirement. I can start right away. I show you demo on my server. Feel free to discuss me anytime. Hopefully you see 50% work today or complete. Thanks Raj

$210 USD in 3 days
(155 Reviews)

Hi, I already have experience with eBay API. and ready to start the work, Contact me with your eBay authentication token. Thanks -udana-

$242 USD in 3 days
(72 Reviews)

Hi, We have worked on many web application projects for our clients in the past. We have professionals experienced in back-end technologies including node.js, PHP, J2EE etc as well as front-end technologies includin More

$110 USD in 3 days
(92 Reviews)

Hello, we can provide best solution for your work so please provide one chance to us for this work related... we are not just looking for any kind of one project or some money but we are looking for lon More

$257 USD in 10 days
(94 Reviews)

Hello, I am experienced with PHP / MySQL and have written several scrapers (check my reviews). I am a member of this site since 2005. I can use my local linux server to create the database and PHP files, then I will im More

$140 USD in 3 days
(48 Reviews)

Hi, I have a 5+ years of an experience in scraping, i done lot of scraping jobs before. I can develop a tool which scraps data and i can give you the output in excel format. I have already devoped a email load gen More

$166 USD in 7 days
(15 Reviews)

Hello Sir, I have experience in php, mysql, ebay api. I can do this project. Do you also require as admin panel to edit delete categories, so that only you can edit/delete after login. This is also included in bid.

$111 USD in 5 days
(13 Reviews)

We are '3stechmind' team of dedicated software professionals developing the web projects for our [login to view URL] area of expertise is design the web site and implement the functional aspects in software technolgies like ph More

$175 USD in 6 days
(3 Reviews)