have you tested to see if it updates once you press the close button?
To my understanding, as long as the ticket isn’t closed or in a state of submitted, or in any state that is writing to database, then it isn’t writing anything to the db as yet. Once the close button is pressed, or the ticket is settled, then it begins writing the information into the db and saving it.
So I’d check if it will show once you press the close button, then re run that script of yours and see the results.
Just to add my thoughts given I had to do a bit of work with orders for my PMS API scripts there are a few things needed to correctly deal with orders, including order tags and the ‘calculate price’ option used with gifts and voids which dont change the order price but makes the price ignored for ticket total.
Also dont forget there is the facility to override an orders price…
If i remember correctly (but it was a while ago now) tags also work differently when selecting the include in order price option for the tag.
What database? The software creates a stock database on install.
The only thing shown in this topic is order tags which can easily be created. Perhaps elaborate on your request.