Aloha Help - Updating Item Prices via Database

[ThisnThat15]

I'm trying to develop a 3rd party application for a client to change item prices automatically via database without a system refresh. I'm correctly updating the Aloha database (Aloha version 19) but the price update isn't being reflected in the terminals.

Any help would be greatly appreciated!

 

[shawnfv]

This isn't possible. You are using Aloha v. 19, which means that you are either using CFC or Aloha Manager (CFC standalone) in the BOH. The SQL database that CFC uses has the pricing and each time you do a refresh or run EOD, it runs through a process to validate that the DBF configuration/data files hold the correct information. If they don't it recreates them and then they are pushed to the FOH.

Just changing the DBF files in the BOH won't do anything. When either of the two process above run, they will just wipe out what you have updated manually via the check process above.