Numeric sort order by Address

  • Resolved davidbfox

    (@davidbfox)


    10 years, 5 months ago

    We just launched my client’s new website using your plugin. The client pointed out that the address sort we’re doing is actually sorting alphabetically, and not numerically. They have a series of properties that we want sorted by increasing address number:
    12 Dipsea Rd
    14 Dipsea Rd
    129 Dipsea Rd

    But instead we are getting is an alphabetical sort like this:
    12 Dipsea Rd
    129 Dipsea Rd
    14 Dipsea Rd

    You can see it here: http://seadrift.com/rentals/#lagoon_dipsea

    Do you have any solution for this? The only solution I can think of (unless you have a way to force a text string to be sorted numerically) is to add another field that just contains the address number and sort on that. But then our “address” sort button would be mislabeled.

    Hope you can help.

    https://wordpress.org/plugins/wp-property/

Viewing 12 replies - 1 through 12 (of 12 total)
  • Plugin Contributor Maxim Peshkov

    (@maximpeshkov)

    10 years, 5 months ago

    Hello,

    Numeric Sorting only works for attributes which have ‘numeric’ or ‘currency’ Data Entry.
    You can manage your attributes ( including Data Entry ) on Developer Tab on Settings page.
    Also, be sure that you have only numbers or float values for particular attribute.

    Regards.

    Thread Starter davidbfox

    (@davidbfox)

    10 years, 5 months ago

    Thanks Maxim. The problem is that we want to sort by addresses, which by their nature, are a mix of numbers and letters. Is there a command that might force numeric-type sorting with a string that starts with numbers?

    Plugin Contributor Eric Sopp

    (@ideric)

    10 years, 5 months ago

    Sounds like you need “Alphanumeric” sorting. Is that what you’re requesting?

    Thread Starter davidbfox

    (@davidbfox)

    10 years, 5 months ago

    Well, no, I think that’s what we already have (alphanumeric sorting). What I really want is strict numeric sorting rules applied to an alphanumeric text string so 14 xxx sorts before than 129 xxx (sorting on the value of the address, 14, instead of the string 14).

    Plugin Contributor MariaKravchenko

    (@mariakravchenko)

    10 years, 5 months ago

    Unfortunately we do not have such type of sorting. You can create separate attribute street_number and sort by it. This is geolocation attribute, so it will be filled in all your properties automatically, if the address field is filled.

    Regards.

    Thread Starter davidbfox

    (@davidbfox)

    10 years, 5 months ago

    Thanks Maria… I added the street_number attribute, but I do not see it being filled in automatically, even though each house already has the location field and they’re all filled in. Does it only fill it in on new properties? Or is it not actually filled in and the sorting just happens? Or do I really have to go in and add the street number in each field?

    Please let me know if there’s anything more I need to do besides creating the field… and if the settings I choose for it are important here.

    Plugin Contributor MariaKravchenko

    (@mariakravchenko)

    10 years, 5 months ago

    No, street_number should be filled on all properties automatically.
    I have just checked that with following address
    209 W Church St, Ligonier, PA 15658, USA

    I set up address field, chose it as geolocation attribute in Settings/Main tab, add Street Number in Developer tab and it was filled automatically with 209 value.

    Probably Google is not recognizing your address. In that case I do not have other suggestions.

    Regards.

    Thread Starter davidbfox

    (@davidbfox)

    10 years, 5 months ago

    Ah, sorry, I used street_address instead of street_number. Got it to work! Is there a way in the sort to have it sort on multiple fields? For example: sort_by=street_number,location ?

    Plugin Contributor MariaKravchenko

    (@mariakravchenko)

    10 years, 5 months ago

    No, this is not possible.

    Regards.

    Thread Starter davidbfox

    (@davidbfox)

    10 years, 5 months ago

    Ok, thank you for your help!

    Plugin Contributor MariaKravchenko

    (@mariakravchenko)

    10 years, 5 months ago

    Please mark also the ticket as resolved.

    Thanks.

    Thread Starter davidbfox

    (@davidbfox)

    10 years, 5 months ago

    OK

Viewing 12 replies - 1 through 12 (of 12 total)

The topic ‘Numeric sort order by Address’ is closed to new replies.

Tags