Changing Total Sales in Customer Properties

Posted by Portions on July 26, 2007, 5:58 pm

Please log in for more thread options

Is there a way to adjust a customers total sales in their customer properties
under puchase history? We are using the customers total sales to run a
customer appreciation program (without paying for additional software) and
one customer has made some significant purchases in the store but forgotten
to put them onto their "account". Now the total sales needs to be adjusted
accordingly to show the real amount. Is this possible?

Thank you.

Posted by Luminox on July 27, 2007, 7:42 am

Please log in for more thread options

Easy ... run a SQL to do the trick. Something like:
UPDATE CUSTOMER
SET TOTALSALES = 129.00
WHERE ACCOUNTNUMBER = '9999999999'

"Portions" wrote:

> Is there a way to adjust a customers total sales in their customer properties

> under puchase history? We are using the customers total sales to run a

> customer appreciation program (without paying for additional software) and

> one customer has made some significant purchases in the store but forgotten

> to put them onto their "account". Now the total sales needs to be adjusted

> accordingly to show the real amount. Is this possible?

> Thank you.