We will post files to supprt what we are doing.
This is a multi-Part project - your bid will need to indicate what you can handle and how far you can take this.
Part one - need to determine the best database layout for the taxonomy structure.
(Single table, multiple tables - best layout for speed and performance.)
Main level with up to 4 sub-tiers (as seen in the spreadsheet)
Part two - Then with the data loaded we will want to use dropdown boxes (or better suggestions) to select the categories, and the available tiers under each. Would prefer to have Ajax here rather than to reload the page.
Once the data is selected, we need to tie it to our products.
Here is an example
"Animals > Pet Supplies > Fish Supplies > Aquarium Air Pumps"
Part Three - The finial output will need to be formatted for xml so it will need to look like
Animals > Pet Supplies > Fish Supplies > Aquarium Air Pumps
In the product data feed.