Google Category Taxonomy to workable DB format using PHP


I need someone to reformat the following list of categories and subcategories form the following list:

[url removed, login to view]

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.

Skills: Data Entry, Data Processing, Excel, MySQL, PHP

See more: google taxonomy mysql, google taxonomy script php, google category taxonomy, google taxonomy, php mysql taxonomy, google taxonomy php, workable, reformat data, how to win a project bid, five below, c# category, google category php mysql, taxonomy, pet delivery, google-form, google form-2, export php, db, csv php, export mysql data txt, php script mysql export, processing export, need form processing script, google form data, export mysql script

About the Employer:
( 2 reviews ) Hove, United Kingdom

Project ID: #1253912

Awarded to:


I am your earlier contractor...

$30 USD in 0 days
(1 Review)

6 freelancers are bidding on average $136 for this job


I can deliver the same asap

$200 USD in 5 days
(91 Reviews)

Need more info. Please see PM, thanks.

$250 USD in 2 days
(68 Reviews)

Ready to help you with this,

$140 USD in 4 days
(67 Reviews)

Hello, Please see PMB. Thanks.

$75 USD in 0 days
(14 Reviews)

i wil do it very fast i've a good expirence in this

$120 USD in 3 days
(0 Reviews)