Announcement

Collapse
No announcement yet.

View orders associated with a coupon code

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

    View orders associated with a coupon code

    After a coupon code is created, there's no way to see the actual orders that used the specific coupon code, revenue generated from it etc...Only the number of times it was used. Kind of useless to generate a coupon code with no way of knowing the value of that marketing campaign.

    #2
    I haven't moved over to using the new Miva coupon module for exactly this reason. If you really want this level of reporting, it is available with the older (and inexpensive!) Emporium Plus Coupon Redemption module. I'm still using this and it works fine with the current version of Miva and gives me all the reporting information I need on each campaign.

    http://apps.miva.com/coupon-redemption.html
    Todd Gibson
    Oliver + S | Sewing Patterns for Kids and the Whole Family

    Comment


      #3
      We do have plans to add a bunch more reporting related to discounts and coupons. For the time being, it can be done with a batch report. I'll post a sample here that can be used as a starting point and modified.
      Brennan Heyde
      VP Product
      Miva, Inc.
      [email protected]
      https://www.miva.com

      Comment


        #4
        Below is a simple batch report which will give you some high level data on coupon usage.

        http://docs.miva.com/code-samples/coupon-batch-report

        Brennan Heyde
        VP Product
        Miva, Inc.
        [email protected]
        https://www.miva.com

        Comment


          #5
          Thanks Brennan!!

          Comment


            #6
            Brennan I have just started the process of migrating to the Miva coupon module. I've found the batch report has everything I need to do my ROI reporting for promotions except for one thing. I would like to get able to get the order subtotal included in the report as well so that I can see the total product value (excluding shipping, tax, and the value of the coupon) of all orders that made use of the coupon. This is something included in the old Emporium Plus report (screen shot attached).

            Is there a formula I could add to the batch report as another column in the table to provide this?

            Capture.JPG
            Todd Gibson
            Oliver + S | Sewing Patterns for Kids and the Whole Family

            Comment


              #7
              It does not appear the order subtotal is a native variable on the batch reports. You could easily add the item subtotals together to create it and then output your own custom variable for that value.
              Brennan Heyde
              VP Product
              Miva, Inc.
              [email protected]
              https://www.miva.com

              Comment


                #8
                Originally posted by Brennan View Post
                Below is a simple batch report which will give you some high level data on coupon usage.

                http://docs.miva.com/code-samples/coupon-batch-report
                Me again dragging up an old post with a question:

                Is this still the best way to get a report on coupon usage by order, revenue, etc.

                Thanks,

                Jamie
                Jamie Donaldson
                JSDVS Web Design / Development
                Web Design | Web Development | E-commerce Design & Integration

                Comment


                  #9
                  Coupon reporting is now part of Miva 10:

                  https://docs.miva.com/miva10/referen...s#coupon-usage

                  Brennan Heyde
                  VP Product
                  Miva, Inc.
                  [email protected]
                  https://www.miva.com

                  Comment


                    #10
                    Originally posted by Brennan View Post
                    Coupon reporting is now part of Miva 10:

                    https://docs.miva.com/miva10/referen...s#coupon-usage
                    HI Brennan,

                    Yes, I was there. Didn't give much on specifics. Can that report give usage by order, revenue, whatever I want?

                    Thanks,

                    Jamie
                    Jamie Donaldson
                    JSDVS Web Design / Development
                    Web Design | Web Development | E-commerce Design & Integration

                    Comment


                      #11
                      Would be nice to see coupon usage by orders and other factors in the coupon utility. Two months worth of orders/coupons on the batch report and it choked. At least it gets us a little somewhere though....
                      Jamie Donaldson
                      JSDVS Web Design / Development
                      Web Design | Web Development | E-commerce Design & Integration

                      Comment


                        #12
                        I think what is slowing down that public coupon report is the additional call to get the order info during the final display of the order. I have tired to get around it but could not figure out how to make the data available for "later" when I needed it again. That might help with the "choke" parts Jamie . At least that was a red flag when I was programming it into a site.
                        Colin Puttick
                        Miva Web Developer @ Glendale Designs

                        Comment


                          #13
                          Originally posted by dreamingdigital View Post
                          I think what is slowing down that public coupon report is the additional call to get the order info during the final display of the order. I have tired to get around it but could not figure out how to make the data available for "later" when I needed it again. That might help with the "choke" parts Jamie . At least that was a red flag when I was programming it into a site.
                          I see. Thank you for the reply Colin.
                          Jamie Donaldson
                          JSDVS Web Design / Development
                          Web Design | Web Development | E-commerce Design & Integration

                          Comment

                          Working...
                          X