CPTs repeating on listings pages with random sorting

This is a known issue with sorting by package ID. We are looking into it. Please provide WP Admin and FTP so we can look into your case and apply a fix.

Thanks

WordPress Credentials
WP Admin Login URL:
WP Admin Username:
WP Admin Password:

FTP Credentials
FTP Host:
FTP Port:
FTP User:
FTP Password:

Hi Mike,

I checked and found SQL query results changes the listings order among same package id.

I have added “Post Date” as a second level sorting under package id at Platforms > Settings > Sorting > Package Id > Post Date.

Please check and let us know.

Thanks,
Kiran

Hi Mike,

It already doing that. It sorts first with package id and then applies 2nd level sorting within listing with same package id.

Example:
Listing A has package id = 1 & post date = 2019-10-07
Listing B has package id = 3 & post date = 2019-10-05
Listing C has package id = 1 & post date = 2019-10-02
Listing D has package id = 2 & post date = 2019-09-30
Listing E has package id = 6 & post date = 2019-09-30
Listing F has package id = 6 & post date = 2019-10-01

It will sort results in following order:
Listing F
Listing E
Listing B
Listing D
Listing A
Listing C

For Random(post_status) it will use random order.

Let us know.

Kiran

Hi Mike,

If you need random order within same package id then use following PHP snippet. It will first use package id sorting and then random.

/**
 * Set random sorting.
 */
function gd_snippet_191008_random_sorting( $orderby, $sort_by, $table ) {
	if ( $sort_by == 'package_id_asc' || $sort_by == 'package_id_desc' ) {
		$orderby .= ", RAND()";
	}
	return $orderby;
}
add_filter( 'geodir_posts_order_by_sort', 'gd_snippet_191008_random_sorting', 1000, 3 );

Kiran