Yeah I just checked too, it exports on Ticket Closed. So on my PC I get same result on both Ticket Closing and Ticket Closed. I will update the rule on the POS terminal later and see if it makes any difference.
So the integration with Drink Exchange and SambaPOS v5 we did for my client was just shown on live TV - on TVB Jade in Hong Kong (the main TV channel here) on their Chinese language č²”ē¶éč¦ āMoney Magazineā program. It was discussing new ways bars can increase profits using alternative ways. You can see it uploaded to YouTube below, the section about the bar starts at 8:16. You can see SambaPOS v5 being used at 8:58 and 10:03. Itās in Chinese but parts in English. Even not directly about SambaPOS, itās nice to see someone using SambaPOS featured on TV.
Hallo Mark,
Thanks so much for you infoā¦ We are another company offering a similar product, actually the originators of the Bar Drinks Exchange concept, barSTOCK. I can easily alter rthe prices on the SQL database, but as you said, they need to be updated on the POS as they are cashed and I dont want Staff to have to logout every time.
I will study your response and get back to you with answers.
Thanks,
Stuart
A bar environment surely works better with auto logout?
All my systems use or have similar follow as autologout. This allows multiple people to more easily use a terminal and with my switch user setup allows layaway so someone else can ring up if the other hasnāt finnished.
With autologout or similar running they would be logged out between each transaction.
Iāve never looked at this concept but would you not want drinks bought on same round to use the same price point?
Or would it meant to be the case that two similar drinks ordered together but rang in seperatly could potentially be different prices?
I lived there for over 3 years but now back in the UK. We sold SambaPOS there for over 2 years, still do if someone wants but not actively promoting in that market like when I was there.
I donāt think hugely popular at the moment, the market is saturated with POS companies with crappy software. We did get a few good customers who are still using SambaPOS, and we also did the official Traditional Chinese translation for V5, because it really held back who we could sell to with an English only system.
The way these systems work is the bar owner decides the min and max price for each item, then the prices move depending on supply and demand, like a stock market. They also have āmarket crashesā where everything is sold at the min price for a short period of time.
It is said to bring better profits in as people like the concept and it can allow bar owners to sell popular items at higher margins and also push less popular items with a lower price and the lower margin is supplemented by the higher margin of the popular products.
The translation is already available from v5.1.59 onwards. You just set the UI language in settings.
However note that unless you create a new sample database when using Chinese as the language, you will still have a lot of things like automation commands, accounts, etc., in English. If you create a new sample database after changing language, it will create everything in Chinese.
For ourselves, we spent our own time to put together a database where everything was in Chinese for the display names but internally values were stored in English - it made it easier for our own management as myself I cannot speak or read Chinese. So it meant I can support customers even I canāt ready the UI language.
Back to the Drink Exchange topic, I think this idea would be excellent for restaurants dealing with live seafood too. In Hong Kong, seafood are frequently sold at a price called āmarket priceā, this will be almost the most direct market price one can experience. LOL
The only thing we struggled with was there is no way to easily switch language on SambaPOS. Like I mentioned above about creating the database after changing language, a lot of the settings and features in SambaPOS do not change when you change language. So itās fine if someone wants Chinese and never cares about English, but in reality, especially in other countries like the UK, they want to be able to switch language at the press of a button, and that just isnāt possible with SambaPOS. It is unfortunately possible in many other commercial bilingual POS software targeting this market, but like I say, those software arenāt very nicely designed and flexible compared to SambaPOS.
So I have spent some time thinking about how I could accomplish a language switch, if you accept a few things are dependant on the UI language, but you could in theory (havenāt tried!) create 2 versions of each automation command that is shown on the POS screen, then restrict each to a specific user role - so you could have Chinese user and English user. Yes, it would be dependant on user that logs in, but probably workable. You could alternatively do by terminal - pretty much just using a mapping.
No you are missing the point. Drink exchange isnāt about real time pricing - it is about creating a āstock exchangeā like environment in your bar. The seafood example you give is that they change prices frequently, but they control the specific prices. In drink exchange, the bar owner sets the thresholds but the system decides the price minute by minute based on what is being sold. So itās creating a game like environment that customers love.
There are a few companies doing this like also Stuart above said he works for one. The one we worked with I didnāt particularly like and was very expensive. It was our client who chose to work with them. From what I saw, most of them now work on a pay per use model for the bar owners.
I fully understand what you said - I am just stretching from the so-called āmarket priceā of seafood in HK restaurant to a scenario where the owner set the market like fluctuation for the customer to experience and improve the margin or stock situation. HK seafood restaurant owners set the so-called āmarket priceā with very little reference to the actual price but more to the ānewsā. For example, there is a typhoon coming, so āno supplyā. The supply may already have been in the market for several days but the price will jump the same day the news is on air. LOL. In the morning, there is a government radio channel that reports the market price but the restaurant owners always some how can see the future and act before the actual rise in price in the supply. LOL again.
Hallo Emre,
i would like to create a script which is called when Product button is pressed and updates the cached price from the database realtime.
My software already changes the prices on teh database, but prefer not to use Refresh Cache for the reasons you mentiuned.
Do you have any papers on guidance on creating scripts?
Probably you can do it by calling a script that would then get the price from the database by running an SQL script. The script I made used prices from an external file, so can confirm the concept works.
Not sure exactly what you mean here - there is plenty information about creating scripts on the forum. Just use the search feature. Not sure what āpapersā you are looking for?