When you look at the customer purchase history and you add up all the individual items that they purchase, It doesn't match with the sales total box. Example: I have a customer brought 5 items in the past at $1 dollar each and you can see the each purchases under the "Purchase History" tab, but the total sales doesn't match and which shows Total Sales of $35. Is there a SQL statement to get the "Total Sales box updated correctly?
Thanks for your help Dave