Announcement

Collapse
No announcement yet.

Customer Order History Total

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Customer Order History Total

    Hello,
    I've been trying to figure out a way to get a customer's total order purchase amount. I've used the Order History to get a list of their orders, but want to add the dollar amount of all the orders to see how much they've purchased. Is there a way to do this using Order History, or do I need to go another route?

    Thanks.
    Dan

    #2
    Re: Customer Order History Total

    I think Toolkit can do that.
    Leslie Kirk
    Miva Certified Developer
    Miva Merchant Specialist since 1997
    Previously of Webs Your Way
    (aka Leslie Nord leslienord)

    Email me: [email protected]
    www.lesliekirk.com

    Follow me: Twitter | Facebook | FourSquare | Pinterest | Flickr

    Comment


      #3
      Re: Customer Order History Total

      Thanks, Leslie. I looked through the toolkit docs, but he seems to be saying that his Order History functions are now deprecated, because Miva has its own version. I'm hoping to find some easy way to get the total, so I don't have to write a mySQL query to do it. Thanks again.

      Comment


        #4
        Re: Customer Order History Total

        Getting the total order history from the built in order history does not involve the tool kit order history function. Simply use the math functions (eg math_add) to sum the totals of each order for that specific customer in the order history.
        Bill Weiland - Emporium Plus http://www.emporiumplus.com/store.mvc
        Online Documentation http://www.emporiumplus.com/tk3/v3/doc.htm
        Question http://www.emporiumplus.com/mivamodu...vc?Screen=SPTS
        Facebook http://www.facebook.com/EmporiumPlus
        Twitter http://twitter.com/emporiumplus

        Comment


          #5
          Re: Customer Order History Total

          Thanks, Bill, I'll give it a shot. I'm a little surprised Miva doesn't have that built in, as I'd think merchants would want to easily know who their best customers are, and the figures are all stored there anyway.

          Comment

          Working...
          X