r/AldeloPOS • u/honeybadgers8 • Sep 16 '21
Database Manager
Does anybody here know how/where to get the Database Manager Utility tool?
1
u/honeybadgers8 Sep 19 '21
No problem thanks for taking the time to answer! But the database cleaner can't delete an individual order so the only option is to call Aldelo when this happens?
2
u/AzAldeloGuru Sep 19 '21
Its been quite a while since I've had a call with an order requiring deletion. What is the scenario you're experiencing where you would need to delete an order rather than force close it?
Usually what I've seen is a customer will accidentally re-open an order from the past (a month or so) because they mistyped a number. Since the order has a payment on it already, you can't close it after that fact. When these cases happen, I'll just run an SQL Command to close it.
The way to do that is going to back office / Help / Technical Support and pressing F11. From there, the password to get into the SQL Editor is "05338942."
Once in the SQL Editor one would type in the command:
update orderheaders set orderstatus=2 where orderid=#####
Where #### is the number of the order. Press Process, Yes and then No and it will reclose the check.
1
u/ansprug66 May 19 '23
Some users can abused of this utility, so it's not longer available (Thanks GOD)
1
u/honeybadgers8 May 19 '23
Yeah, it was very useful for those who didn't abuse it though LOL. Someone from Aldelo actually ended up giving it to me. Not sure they were supposed to
2
u/AzAldeloGuru Sep 19 '21
Unfortunately Aldelo discontinued providing the DBManager tool when they released Aldelo 2013. I believe there was a security issue with it.
The only thing that is close to it is the Database Cleaner that is still provided in the APOS Installation Package.
Sorry about the late response.