mukesh.l

can you plz check all product price and variation price because it comes for maximum price from all product.

Thanks

yes pagination working fine for me now. you need to check value of $max

$max = ceil( $wpdb->get_var(
				$wpdb->prepare('
					SELECT max(meta_value + 0)
					FROM %1$s
					LEFT JOIN %2$s ON %1$s.ID = %2$s.post_id
					WHERE meta_key = \'%3$s\'
				', $wpdb->posts, $wpdb->postmeta, '_price' )
			) );

OR

$max = ceil( $wpdb->get_var(
				$wpdb->prepare('
					SELECT max(meta_value + 0)
					FROM %1$s
					LEFT JOIN %2$s ON %1$s.ID = %2$s.post_id
					WHERE meta_key =\'%3$s\'
					AND (
						%1$s.ID IN (' . implode( ',', array_map( 'absint', WC()->query->layered_nav_product_ids ) ) . ')
						OR (
							%1$s.post_parent IN (' . implode( ',', array_map( 'absint', WC()->query->layered_nav_product_ids ) ) . ')
							AND %1$s.post_parent != 0
						)
					)
				', $wpdb->posts, $wpdb->postmeta, '_price'
			) ) );

print value of both and try to check sql query and run that query in sql

i see there it problem in that filter so you need to check code so that you get perfect solution.

file path: /wp-content/plugins/woocommerce/includes/widgets/class-wc-widget-price-filter.php

you need to check this $max variable value. if you get any problem tell me.

also plz check product variation price also

Hello

you have one product with 3895GEL that’s wy it take maximum value of that product can you plz check all product value. i check you store but pagination is not work so next and prev is not work.

Thanks

Hello Merkucio,

For that filter you need to check code. can you plz tell me which plugin you are use?

Thanks

<!--MFUNC-->
<?php echo rand();?>
<!--/mfunc -->

this give same value in each pages because it’s goes in cache. where is w3tc suport team? plz help

<!--MFUNC-->
<?php echo rand();?>
<!--/mfunc -->

i add this code in page but it go in cache.