Blogathon 15/26: Stock

I’ve been playing around with a bunch of custom CSS and some newly-created database fields because I had a really good night’s sleep last night (yay!) and my brain needed a fresh challenge this morning. And now, after a couple of hours of tinkering around people can see… Oh, hang on. You need some context.

Most of the paperback sales for my books come from my website, not bookshops. That’s because I heavily discount the price whereas mainstream and independent book-sellers don’t.

So what I’ve done this morning is build a stock management function into the online store so that users can see how many copies of a book I have in stock. Now, they might not want to know I’ve only got 2 copies of Tempest ready to fly out of the door, but they may want to know Storm is (currently) out of stock (I certainly do). The database presents these new pieces of information to anyone browsing the online store. It also sends me an email every time a copy is sold, reduces the stock count, and flags up I need to get additional copies in when the stock gets to zero. Yeah, I might shift that warning upwards to 1.

But anyway, that’s what I’ve been doing this morning. Not too shabby, eh? WYD?

3 thoughts on “Blogathon 15/26: Stock

  1. Not bad for a Sunday morning!
    Well, inbetween bouts of decorating the dining room, I’m tinkering with LoRa on 439Mhz… although at the moment we are just networking it through a server in Saffron Walden whilst we build the mesh.

Comments are closed.