<i> For example, I might want to know if there are any organic, locally brewed ales available, and I prefer darker rather than light coloured ones. If the system is set up properly, an assistant would be able to filter their stock database on these options, tell me what is available, and locate it within the store. </i>
Sorry but particularly where small shops are concerned I simply don't agree with you. Don't waste money on an EPOS system, pay your staff a little more and train them better. It is ludicrous for someone in a small shop to have to filter a database to find out if they sell something and where it is. Even more ludicrous if the shop is run just by the owner as is so often the case in the early days. Even more useless in shops like mine where good quality stock is displayed creatively and in ever changing ways to keep the interest of our regular customers. Many items don't actually 'belong' anywhere, they are where they are at the moment but often won't be there for long but even though I'm at home 20 miles from my shop at this moment, if you asked me where something was I could tell you, it is part of the art of being a shopkeeper.
The tale I told in my previous post was just one of many examples I constantly come across. Shops that can't sell anything because their till is down. It is a wretched nuisance if mine goes wrong, but there's no way I'll lose a sale because of it. List the items on paper, reach for a calculator, keep a copy and enter the sales when the till is feeling better. Some customers took their grandchildren to a well known tourist attraction but couldn't buy anything in the gift shop because 'the tills were down' - madness. Two years ago a staff member and I (sharing a van) were stranded on the way to our shop by a freak snowstorm, the police closed the road we needed to take as impassable, nothing could turn to the right because of tail backs due to accidents, you couldn't turn round and go back because the carriageway in the other direction was uphill and the police had closed it because of the number of stranded vehicles on it. After two hours of inching our way forwards in treacherous conditions, we reached a village an pulled into a pub and restaurant car park to think things over. Ah we thought, coffee and snacks must be available within, maybe even lunch if we are going to be stuck here. After a terrible drive I was more than willing to buy us both lunch as were obviously other sad motorists pulling into the car park. Guess what? We got inside and they couldn't/wouldn't sell us anything because 'the tills were down', they had cooks, they had food, they had waiting staff, but they would not sell anyone anything. They warmly invited us to use the toilets for free but anything paid for was a no no. My staff member was staggered, as she said, if we had a queue of stranded cars outside the shop we could go along the line of cars selling snacks from a tray, we could invite the drivers and passengers to use our toilet which means they'd have to walk through the shop and see all the lovely things we sell.
By the way in case you think I'm a dinosaur I actually love IT with a passion and get separation anxiety when away from computer access, but you must rule IT and bend it to your will, you must never let it rule you.