I’ve been thinking lately about EPOS system for stocktaking for this scenario;
– offline retail shop in the high street
– online shop
The need is there to ensure that we don’t oversell in the online shop. To this end, what is needed is some type of EPOS (point of sale) system that simply allows to scan the barcode of the product which reduces the stock by 1 in the online shop.
There are LOADS of suppliers of EPOS systems, but getting to speak with someone technical is really difficult – it’s all about the BS salesmen, then once you’ve bought they allow you to get more technical. No thanks.
So, I had the thought to make a “home made” EPOS system (solely for stocktaking), and here is my initial thoughts;
1. Have a notebook or similar computer hooked up in the shop (perhaps under the desk of the checkout).
This computer would be online all the time in shop hours, and have open a page.
2. Plug a USB hand held scanner into the computer
These are very cheap to buy, and should be able to work by inserting the barcode into a input box
Barcode scanners can be programmed to “enter” after the scan.
3. The page that is open would be the “reduce stock” page
This page is a simple form where the input box is populated by the barcode scanner, which also “enter”‘s to action the form
4. Logic then takes over and reduced the available quantity in the online shop by 1.
If the available quantity hits zero, the product is placed “out of stock”.
In thoery, what can go wrong? Would be pleased to hear any comments.
Also, it would be easily possible to add stock by making a “add stock” page. Same system as the reduce stock page pretty much but instead of reducing stock by 1, it increases stock by 1.
Of course this all depends on the product already being in the database, with the correct bar code number – which would have to be a manual task. I suggest using the products_model for this, or better, perhaps use a new input field entirely.