hi, How can I reset awarded points?
I would like to make all previously awarded points zero and restart.
re-set rewards points
Re: re-set rewards points
You will need to use a 3rd party SQL tool to do them all at once. You can use SQLite Expert, or SQLite3.exe which is a command line tool from sqlite.org (or any others of your choosing).
Execute the following command on your database (pospizza.PZ6):
UPDATE customers_tbl SET points=0;
This will reset all customer records to zero points.
P.S. Always use extreme caution when using 3rd party tools on your POS Pizza database, and always do a backup before starting!
Scott
Execute the following command on your database (pospizza.PZ6):
UPDATE customers_tbl SET points=0;
This will reset all customer records to zero points.
P.S. Always use extreme caution when using 3rd party tools on your POS Pizza database, and always do a backup before starting!
Scott
Re: re-set rewards points
I would like to know how to do this as well and I'm not understanding the process of editing with a SQL program. Are the database files only located on PC being used as the server? I downloaded APEX SQL and there are all types of .exes? Like "Build" "Analyze" "Generate". Any more information would be appreciated. Thanks
Re: re-set rewards points
If you are not familiar with SQL, then I don't recommend using an editor. If you try, make a backup of your current database beforehand.
You can export your customers to CSV and then re-import them. Simply omit importing the "Points" field when doing the import, and all rewards will be set to ZERO. Note, you will lose the links between your customers and their previous orders when doing this.
-------------------------
Editing the SQL
The database is usually named POSPizza.PZ6 and can be found in the server program's folder (C:\POSPizza6\Server). Shutdown the server, then make a copy of this file as a backup before editing it. Next open the POSPizza.PZ6 file with an SQLite editor such as SQLiteExpert Personal Edition (I don't know anything about APEX). Go into the part of the editor where you can issue direct SQL commands against the database. Issue the following command:
UPDATE customers_tbl SET points=0;
This will zero out the points field for all customers in the database. Exit the editor, start the server up again, and then check the results in the Management Utility.
Scott
You can export your customers to CSV and then re-import them. Simply omit importing the "Points" field when doing the import, and all rewards will be set to ZERO. Note, you will lose the links between your customers and their previous orders when doing this.
-------------------------
Editing the SQL
The database is usually named POSPizza.PZ6 and can be found in the server program's folder (C:\POSPizza6\Server). Shutdown the server, then make a copy of this file as a backup before editing it. Next open the POSPizza.PZ6 file with an SQLite editor such as SQLiteExpert Personal Edition (I don't know anything about APEX). Go into the part of the editor where you can issue direct SQL commands against the database. Issue the following command:
UPDATE customers_tbl SET points=0;
This will zero out the points field for all customers in the database. Exit the editor, start the server up again, and then check the results in the Management Utility.
Scott
-
- Member
- Posts: 25
- Joined: Fri Mar 20, 2015 9:00 pm
Re: re-set rewards points
Scott,
it would great if you add this option to "DB maintenance tool". Please!
it would great if you add this option to "DB maintenance tool". Please!