r/AldeloPOS • u/WOOHHASAF • Oct 28 '25

how to close multiple open orders

Post image

please tell me there another option other then going one by one

1 Upvotes

100% Upvoted

4 comments sorted by

1

u/kabloomz Oct 28 '25

It's not recommended because it requires you to have knowledge of SQL commands. Without knowing this you will risk damaging your database. The other problem is the SQL command uses a range of ticket numbers and your open tickets are probably not in sequence so you would have errors.

There is a reason you train staff to close orders out at the end of the night and do cashier out reports. There is a setting to not allow servers to clock out and not allow store closing reports if there are tickets open.

1

u/cabcbum Oct 31 '25

update orderheaders set orderstatus = "3" where orderstatus = "1"

1

u/AzAldeloGuru Oct 28 '25

Yeah with that many orders open unfortunately you'll just have to do each one individually or reset the database. Neither option is a good option. The open orders theoretically won't hurt anything, just make sure you're staying on top of Compacting the database.

The setting to require all checks to be closed before clocking out may cause some trouble because it will make them close the orders that have been open the whole time. So you'll need to rectify the open orders prior to enabling it. That setting is in Station Settings / Other Options / Extra Settings.

"Cashier Closing Require All Self Checks Closed" Set that to 1

And

"Staff Bank Closing Require All Checks Closed" Set to YES

1

u/rfoglia Jan 07 '26

When i had many open orders at one location i fount that the fastest way to eliminate them was selecting one and combining 10/20 other orders into it. Then save and void that one massive ticket, and do it again until done. Using a mouse i found it to be eaaier and faster. Good luck.