Seems like the featured listing sorting is not working

This topic contains 20 replies, has 3 voices, and was last updated by  Alec 9 years, 4 months ago.

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

Open Support Ticket
  • Author
    Posts
  • December 8, 2014 at 10:32 pm #23886

    Alec
    Lifetime Member
    Post count: 319

    cant get featured listings to appear correctly in sort.

    Tried both ascending and descending, does not seem to work.

    http:// vapestores.com/listings/?sort_by=is_featured_asc
    http:// vapestores.com/listings/?sort_by=is_featured_desc

    I want to make it where featured listings always have priority and are default viewed.

    December 9, 2014 at 5:16 pm #23937

    Paolo
    Site Admin
    Post count: 31206

    hi,

    please provide wp admin credentials.

    Thx

    December 11, 2014 at 6:46 pm #24110

    Alec
    Lifetime Member
    Post count: 319
    This reply has been marked as private.
    December 12, 2014 at 4:58 pm #24192

    Alec
    Lifetime Member
    Post count: 319

    Ok, Also related to this. People are able to get the Featured listing upgrade options in the FREE listing choice. They should not be able to do this since i set limits on what can show for free listings, but they are able to do things that only paid listings can do.

    /listings/united-states/alabama/alexandria/ecig-south-2/ is a free listing who loaded 12 images and 2 catagories for FREE, when this should only be able to be done with paid listing.

    This is the 2nd time something like this happened, the first I let go since thought was just weird, now looks like something is a bug in system.

    Please help, what is going on?

    December 12, 2014 at 5:26 pm #24193

    Alec
    Lifetime Member
    Post count: 319

    If i had to guess how they are doing it i would say. They choose the paid option and begin filling out the info, then after filling in information they switch to free option and submit. The system does not delete data that they already submitted in available fields while submitting data under paid option plan, and modify to reduce to free plan options.

    December 12, 2014 at 7:09 pm #24200

    Paolo
    Site Admin
    Post count: 31206

    Hi Bob,

    ecig-south-2 isn’t really a free listing, it’s an hybrid that shouldn’t be possible to create.

    What happened is that your default price for gd_place was “Premium Classified Listing” and was inactive (it shouldn’t be possible) and when the user went to the add listing page, there was no price selected and the form didn’t know basically what needed to be restricted. He filled in all fields and submitted and went through as if the payment manager wasn’t active basically.

    Now I’ve made the Gold price default and this will never happen again. I also ask to the developer to make sure that inactive prices can’t be made default.

    For the featured sorting not working as expected I’ve asked Stiofan to have a look at it, because all I tested didn’t seem to fix the issue. He’ll have to check what is messing up with the queries using query monitor.

    We’ll keep you posted.

    Thx

    Thanks

    December 12, 2014 at 7:28 pm #24201

    Alec
    Lifetime Member
    Post count: 319

    Thanks

    December 12, 2014 at 8:15 pm #24204

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    OK the featured things is weird, i would need DB access to properly debug it.

    Stiofan

    December 12, 2014 at 9:17 pm #24210

    Alec
    Lifetime Member
    Post count: 319
    This reply has been marked as private.
    December 12, 2014 at 10:28 pm #24214

    Alec
    Lifetime Member
    Post count: 319

    I have a batch of listings ready to upload, gonna go ahead with it, k

    December 13, 2014 at 2:50 pm #24244

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Thanks for the info, ok the problem must be happening when u are importing, the is_featured value is empty where is should be either 0 or 1

    i fixed this for places by running this query on ur table:

    UPDATE geodir_gd_place_detail SET is_featured ='0' WHERE is_featured=''

    Thanks,

    Stiofan

    December 13, 2014 at 7:34 pm #24260

    Alec
    Lifetime Member
    Post count: 319

    Cool,

    The other added fields you told me to make were – paid_amount package_id alive_days expire_date .

    This might be something to update with the is_featured field for uploading in the example file.

    expire_notification , could be useful for people who are migrating to wp_geo from other systems where they have paid packages already too maybe.

    Thank you

    December 14, 2014 at 8:35 pm #24312

    Alec
    Lifetime Member
    Post count: 319

    Its happening again. http://vapestores.com/listings/united-states/virginia/alexandria/stratosphere-llc/

    Another field that is empty in the tables for many of the listings is “Businesses” . Could that field being empty cause this too?

    December 14, 2014 at 8:47 pm #24315

    Alec
    Lifetime Member
    Post count: 319

    Also the twitter facebook and video columns are empty for uploads i did instead of saying Null.

    December 15, 2014 at 4:42 pm #24390

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    sorry what is the problem now? The sort order, why are u linking direct to a page if so?

    Thanks,

    Stiofan

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

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

Open Support Ticket