UPDATING CATEGORIES:

Now, let's click on LeftNav->Categories->Details. This is what should come up:

There is no magic here. This window just shows us the plain database. The third row, 'Vegetables', indicates that it has a category Id '7', and it belongs to category '6', which is 'Food'. That is how the database retains the hierarchy.

Again, writing a full-blown application for such a one-time job like categories is a bit overkill, and we will leave it right here. Assuming we made a mistake and realized that 'Vegetables' in fact is not a 'Food' category, rather, a piece of 'Hardware', we have to fix it directly in the database. If you have admin privileges, chances are you are also a 'Bora Admin'. As Bora administrator, we can simply connect to the database and do it by hand:

We assume you have that much sql knowledge. To be on the safe side, what this query basically says is: "from now on category 7 belongs to the parent 4, which is Hardware'.

Now, we can go back to LeftNav->Categories and look at the category tree. 'Vegetables' should show up right under the category 'Hardware', not 'Food, right?. Ooops, it does not!

If we look at the LeftNav->Categories->Details to see the plain database records, it still shows the old thing, that category Id 7 has a parent 6 (Food), not 4 (Hardware). How come?