Managing Inventory & Databases

One aspect of running an online store is inventory – specifically, the fact that we have a huge database of games, accessories etc but only a small percentage of them are actually active at any one time.  There are a lot of games and items that either go out of print or just aren’t worth bringing back into stock.   Many of those we let go down to 0 and put it on special order status.

The problem of course is that if you have every single item that could be pre-ordered up on the site, it’d fat become extremely hard to browse.  It also slows the entire site down since we aren’t Amazon and have multiple servers running the site.

So, the question then becomes managing the database and listings, by turning some off and leaving others on.  That seems fine to start, but you also start seeing a new problem where old URLs which Google has cached become 404’s.  That’s not a good thing, especially if too many of your pages go offline.

So, the next question is what to do – do you manually remove the links from Google or create 301 reroutes to other pages? Or do you keep all those pages up instead, making your entire site much more difficult to browse but definitely more prominent on Google for these obscure / less demanded games?

It’s an interesting question on a business perspective but it certainly does create its own set of problem whichever way you go.