445605 Extract All eBay Categories to MySQL Database and more.. - Repost - open to bidding
$30-250 USD
Kapalı
İlan edilme: yaklaşık 10 yıl önce
$30-250 USD
Teslimde ödenir
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:
Home
-----------------------------
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.
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
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
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
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 long and strong business relationship with client...
so let's start with this project... :-)
Thanks in advance...
we are waiting for your valuable reply...
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 import / upload them to your server. Please contact me to discuss further details. Best Regards, Al
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.