I've been working on the guts of the website for the past couple of days trying to get the main database into some sort of sensible structure. I'm at a point now where I could do with rebuilding the whole thing, I've added bits and pieces in the months that the site has been online. Now I could do with removing some of them but it's not obvious how to do so.
For the moment I'll be leaving the extra parts of the website inplace and just ignoring them. The main thing that I need to do is sort out the database structure for the shop. I'm trying to unify the various ways of accessing content from the site so that they are all just different views of the same database entity.
Wish me luck!