This topic contains 2 replies, has 2 voices, and was last updated by  oliver303 6 years, 11 months ago.

Ordering for Stores

  • oliver303 December 14, 2017 at 2:03 pm

    Hi,

    is it possible to change the ordering of the stores from “Name” (ascending) to “Zip-Code”?

    regards
    oliver

    Sofia Moss
    StaffSuper ContributorUser Level
    Sofia Moss December 14, 2017 at 4:07 pm

    Hi there,

    Thank you for your inquiry, you can edit ssf-wp-xml.php and search for the following code:

    $query=$wpdb->get_results("SELECT * FROM ".SSF_WP_TABLE." WHERE ssf_wp_store<>'' AND ssf_wp_longitude<>'' AND ssf_wp_longitude!='0' AND ssf_wp_latitude<>'' ORDER BY ssf_wp_store ASC", ARRAY_A);

    and change it to:

    $query=$wpdb->get_results("SELECT * FROM ".SSF_WP_TABLE." WHERE ssf_wp_store<>'' AND ssf_wp_longitude<>'' AND ssf_wp_longitude!='0' AND ssf_wp_latitude<>'' ORDER BY ssf_wp_zip ASC", ARRAY_A);

    Cheers,
    Sofia

    oliver303 December 14, 2017 at 5:49 pm

    great! works! thx!

Tagged: 

The topic ‘Ordering for Stores’ is closed to new replies.