re-set rewards points

Questions and Answers that relate to the [CS] Version of POS Pizza 6
Member
Posts: 13
Joined: Fri Mar 20, 2015 8:00 pm

re-set rewards points

Postby rahmiolgac84 » Tue Jul 07, 2015 7:25 pm

hi, How can I reset awarded points?
I would like to make all previously awarded points zero and restart.

Site Admin
User avatar
Posts: 2089
Joined: Wed Apr 16, 2003 4:35 pm
Location: Western PA

Re: re-set rewards points

Postby Scott » Wed Jul 08, 2015 7:24 am

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

Return to CS Version Discussion

Who is online

Users browsing this forum: No registered users and 1 guest