Announcement

Collapse
No announcement yet.

Sort by Ratings

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

    Sort by Ratings

    Before I bug Bill about how to use the Toolkit to do this, maybe someone else already has.

    I'm trying to create a sort link to sort Product Ratings from highest to lowest. The site is using the Sebenza Ultimate Reviews and I'd like to do something similar to how the Top Reviewed Products by Category displays but I don't want to actually use the display.

    I've used the KSE Variables & Entities for Miva Merchant 5.5 to try and discover what variable/entity might be used for this. Without using the display, I've come up with:

    l.settings:TOPCTGYREVIEWEDPRODUCTS[1]:RATING &mvt:topctgyreviewedproducts[1]:rating;

    (there is one associated with each product in the category).

    Some other FYI:

    There are other nicely functioning sort links that are pulling from default (global) sorts. The initial sort method for the page is set using this token:

    Code:
    <mvt:item name="toolkit" param="ctgyproduct_list|999|name.asc|1" />

    HTML Code:
    <li><strong><a href="http://www.domainname.com/&mvt:category:code;.html?ProductsPerPage=&mvta:global:ProductsPerPage;&amp;sort=name.asc&amp;Initial=&mvta:global:Initial;">NAME</a><span style="padding-left:5px;">&bull;</span></strong></li>
      <li> <strong><a href="http://www.domainname.com/&mvt:category:code;.html?ProductsPerPage=&mvta:global:ProductsPerPage;&amp;sort=price.asc&amp;Initial=&mvta:global:Initial;">PRICE</a><span style="padding-left:5px;">&bull;</span></strong></li>
      <li> <strong><a href="http://www.domainname.com/&mvt:category:code;.html?ProductsPerPage=&mvta:global:ProductsPerPage;&amp;sort=best&amp;Initial=&mvta:global:Initial;">BEST SELLERS</a><span style="padding-left:5px;">&bull;</span></strong></li>
      <li> <strong><a href="http://www.doaminname.com/&mvt:category:code;.html?ProductsPerPage=&mvta:global:ProductsPerPage;&amp;sort=id.desc&amp;Initial=&mvta:global:Initial;">NEWEST ITEMS</a></strong></li>

    So my question(s) is/are - can this be done and what would be the variable/conditionals needed to pull the sort method in?

    Thanks!
    Leslie
    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

    #2
    Re: Sort by Ratings

    That function sorts on the native product fields or custom product fields. The ratings system you are using does not use either of those to store its data.
    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


      #3
      Re: Sort by Ratings

      Yup - that much I knew. I'm trying to find out if, through the magic of the Toolkit, there is a way to pull that variable in. Yeah, if the site was using the Sebenza Category Template Manager, it's one of the built in sort functions for it but the site's not.

      Leslie
      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


        #4
        Re: Sort by Ratings

        There won't be a way to do it.
        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: Sort by Ratings

          Originally posted by wcw View Post
          There won't be a way to do it.
          Wow - I'm so depressed...
          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


            #6
            Re: Sort by Ratings

            The Sebenza module has a variable on the product page called g.rating that is a numeric value and g.Product_Rating that is rounded up to a single digit. Either value could be written to a product custom field. Toolkit #105
            Last edited by nottheusual1; 05-01-12, 09:23 AM.

            Comment


              #7
              Re: Sort by Ratings

              Pure genius. Since search bots hit practically every product page daily, this would be fairly current.
              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


                #8
                Re: Sort by Ratings

                Well let me see if I can figure out how to put that into a custom product field and get it to sort by ratings. Hints are welcome

                Thanks!
                Leslie
                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


                  #9
                  Re: Sort by Ratings

                  Create a custom field called "rating"


                  Code:
                  <mvt:item name="toolkit" param="prodinsert|l.all_settings:product:id|rating|g.rating" />
                  **I think** - might need to spec the g.rating different. Should be below the place where you have the product reviews item inserted so the variable will be available.
                  Last edited by nottheusual1; 05-01-12, 10:27 AM.

                  Comment


                    #10
                    Re: Sort by Ratings

                    Originally posted by wcw View Post
                    Pure genius. Since search bots hit practically every product page daily, this would be fairly current.
                    I think I'll take the rest of the day off ;)

                    Comment


                      #11
                      Re: Sort by Ratings

                      Me too. I'm on my way to get some conch fritters over at Guanabanas. The snow birds have all gone home so the three hour waits are history (until next winter).
                      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


                        #12
                        Re: Sort by Ratings

                        Yes, they are evacuating - we've had a higher incidence of Crown Vics and blue hair up here at the big box stores.

                        Conch fritters are major goodness. When I was stationed in Orlando my roommate was from Coconut Grove, and he dragged me home for Goombay in the early 80s, like the 6th or 7th year of the festival there. First fritters I ever had, and it was unreal good. Now I'm hungry.

                        Comment


                          #13
                          Re: Sort by Ratings

                          Were you at the Naval Training Center? I was stationed at the Naval Training Center in Orlando 75-80.
                          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


                            #14
                            Re: Sort by Ratings

                            I just missed you! Did boot camp at RTC-ORL in the '81 and was gone in early '82 after school on SSC side. My future wife and I were the first people to get marriage blood tests at the (then) new hospital!

                            Was supposed to go back for NPS in Orlando after ET-A at Great Lakes but got stuck on a government boat till late 1985, then went back to the Lakes and taught at ET-A and a Marine NCO school at NAS Glenview until I mustered out.

                            Orlando was great duty. Great Lakes was the exact exponential opposite, especially coming in from good sea duty. Getting a billet at NTC Orlando was a gift from the Gods. I asked my detailer and he laughed.
                            Last edited by nottheusual1; 05-01-12, 02:28 PM.

                            Comment


                              #15
                              Re: Sort by Ratings

                              That was my first assignment after graduating from Veterinary school. Everybody wanted to know what I had to do to get that assignment. It was kinda fun when I first got there. As a young Air Force Captain, I'd call places on base and identify myself as a Captain. That got their attention until everybody figured out I was that wet-behind-the-ears Air Force guy. Working with the navy folks was a lot of fun. Four years there was my 2nd best assignment out of 25 years in the AF; Aviano, IT being the best.
                              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

                              Working...
                              X