Order of Listings by Those with a Logo

This topic contains 18 replies, has 4 voices, and was last updated by  Stiofan O’Connor 9 years, 6 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • November 5, 2014 at 1:36 am #20612

    Kenny Eliason
    Expired Member
    Post count: 54

    Hey guys, working on this site: http://musclecars.wpengine.com/listings/associations/

    You can see the listings with logos are sporadic, but what I would like is for all listings with logos up top, then the rest of the listings below. Can you tell me the best way for accomplishing that? Thanks!

    November 5, 2014 at 1:45 am #20613

    Kenny Eliason
    Expired Member
    Post count: 54

    Whelp, I spoke to soon… figured this out:

    UPDATE 'geodir_gd_place_detail' SET 'is_featured'= 1 WHERE 'featured_image' IS NOT NULL

    Now how do I set the default sort to featured?

    Thanks!

    November 5, 2014 at 2:01 am #20615

    Kenny Eliason
    Expired Member
    Post count: 54

    Annnnd sorry. One further for you. How can I sort via featured first, alphabetically, then the rest alphabetically under that? Or as my client asked:

    “Listings with a logo appear alphabetically at the top in descending order followed by those listings alphabetically without the logo. ”

    Thanks!

    November 5, 2014 at 1:23 pm #20653

    Guust
    Moderator
    Post count: 29970

    The popular post widget allows sorting alphabetically, and featured etc.
    Not sure the combination you want is available out of the box, so have a play, and I’ll get Stiofan to look at your question too.

    November 5, 2014 at 1:25 pm #20655

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Ordering by features should do it if i am reading the question right.

    Stiofan

    November 5, 2014 at 4:15 pm #20689

    Kenny Eliason
    Expired Member
    Post count: 54

    Thanks for the feedback, guys! So for some reason the default sort appears to be putting all featured listings first, but I don’t think they’re alphabetized… check out the listings on this page:

    http://musclecars.wpengine.com/listings/classic-auto-parts-and-restorations/

    See what I mean? Anything I can do to make it so it orders the featured ones first alphabetically, then the rest alphabetically?

    Thank you!

    November 5, 2014 at 5:43 pm #20701

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    It seems to be working for me on my site, can u check your setting under place settings> sort

    Stiofan

    November 5, 2014 at 6:56 pm #20716

    Kenny Eliason
    Expired Member
    Post count: 54

    See attachment.

    Is that where you’re talking about? Seems to be set up correctly, although they’re still not alphabetized… sorry!

    November 5, 2014 at 8:34 pm #20742

    Paolo
    Site Admin
    Post count: 31206

    Honestly,

    I don’t think you can have a double sorting. So it is either Featured or Alphabetic.

    Not a combination of the 2.

    @stiofan correct me if I’m wrong.

    Thx

    November 5, 2014 at 8:39 pm #20743

    Kenny Eliason
    Expired Member
    Post count: 54

    Yeah, I think you can do it by two parameters… I saw this: https://wordpress.org/support/topic/how-can-i-order-my-posts-using-multiple-meta-values

    Haven’t tested. Thanks!

    November 5, 2014 at 8:49 pm #20746

    Paolo
    Site Admin
    Post count: 31206

    Everything can be done, once the code is written to do what you have in mind.

    What I meant is that GeoDirectory should be able to sort by Featured or Title. Not a combination of the two.

    Thx

    November 5, 2014 at 8:57 pm #20748

    Kenny Eliason
    Expired Member
    Post count: 54

    Ah, I think I follow you.

    Is there a way I can manipulate the query, then? I know messing with core files can screw things up, but this seems like a pretty good one that maybe I’ll send over for inclusion in a future update! 😉

    November 5, 2014 at 9:02 pm #20749

    Paolo
    Site Admin
    Post count: 31206

    Honestly, I wouldn’t know where to start from. It’s definitely not going to be a simple tweak.

    It would require some time to study the issue, it would require extra backend options and rewriting basically all queries.

    But as i said, let’s leave the last word to Stiofan.

    Thx

    November 5, 2014 at 9:53 pm #20758

    Kenny Eliason
    Expired Member
    Post count: 54

    Thanks Paulo for all your help!

    November 6, 2014 at 2:57 pm #20818

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    can you provide me wp-admin details so i can check ur setting please.

    Stiofan

  • Author
    Posts
Viewing 15 posts - 1 through 15 (of 19 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket