Find Jobs
Hire Freelancers

Google Category Taxonomy to workable DB format using PHP

$30-250 USD

Completed
Posted over 12 years ago

$30-250 USD

Paid on delivery
Hi, I need someone to reformat the following list of categories and subcategories form the following list: [login to view URL] to this specific format (see first five lines example below) using a PHP script and then export this to a CSV file or MySQL DB: CatName CategoryID ParentID Level Animals 1 0 1 Live Animals 2 1 2 Pet Supplies 3 1 2 Bird Supplies 4 3 3 Bird Cages & Stands 5 4 4 and so on... The CategoryID is as you can see is just a auto increment from 1 to infinite, also, all the main categories have ParentID 0 and the subcategories have ParentID of immediate previous category and have also been stripped from the sequence (e.g. from Animals > Pet Supplies > Bird Supplies > Bird Cages & Stands to Bird Cages & Stands) and the Level (starts at value 1) will correspond to the position of the category from the sequence (Animals = 1, Animals > Live Animals = 2 and so on). This is how it should not look for subcategories CatName since this will be assumed by the ParentID: CatName CategoryID ParentID Level Animals > Live Animals 2 1 2 Animals > Pet Supplies 3 1 2 Animals > Pet Supplies > Bird Supplies 4 3 3 Animals > Pet Supplies > Bird Supplies > Bird Cages & Stands 5 4 4 When processed, the data should be saved to a CSV file or to a MySQL DB in the format previously specified. If you can do it and can send the PHP script as soon as possible, please bid. The lowest bid and fasted delivery will win. This project has a secondary purpose for category mapping of products, so if you do it well you will also get the upcoming project.
Project ID: 1253912

About the project

5 proposals
Remote project
Active 13 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
I am your earlier contractor...
$30 USD in 0 day
4.8 (1 review)
1.0
1.0
5 freelancers are bidding on average $148 USD for this job
User Avatar
I can deliver the same asap
$200 USD in 5 days
4.8 (154 reviews)
7.4
7.4
User Avatar
Need more info. Please see PM, thanks.
$250 USD in 2 days
5.0 (76 reviews)
6.4
6.4
User Avatar
Ready to help you with this,
$140 USD in 4 days
5.0 (80 reviews)
6.0
6.0
User Avatar
i wil do it very fast i've a good expirence in this
$120 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Hove, United Kingdom
5.0
2
Payment method verified
Member since Sep 23, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.