Product Listing Sort Error (sort by price ... doesn't)

I've just noticed an error on my site when I sort product listings (i.e. sort by price).

When clicking on the 'Price' column header the product listing data is sorted, but it's not correct. The listing appears to be random with products not display as price ascending/descending.

You can visit my website (adult toys retailer) by clicking on the Link in my signature.

Has anyone else experienced a similar issue?

Check you Admin> Tools> Store Manager and run the Update ALL Products Price Sorter -

Hi Kim,

Thanks for the advice... it worked great.

Is there any reason why my price sort order went 'out of sync'?

Also, I've noticed that the advanced search feature doesn't correctly filter out prices. For example, if I search for all items between £0.00 and £4.99 I'm displayed all the items below £5.00, but also one or two above £5.00 (i.e. £5.50).

Could these two issues be related?

Thanks again for the help. :)

Alex Clarke:

I've noticed that the advanced search feature doesn't correctly filter out prices. For example, if I search for all items between £0.00 and £4.99 I'm displayed all the items below £5.00, but also one or two above £5.00 (i.e. £5.50).Is this related to having tax-included-in-prices by any chance?

Hi DrByte,

You're correct. It was related to having tax-included-in-prices.

I set Display Prices with Tax to false in my admin and the correct products were then displayed.

I would still like to show my products inclusive of tax and also have the advanced search function take into account the tax on each product.

Is there a way to work around this?

Alex Clarke:

Is there a way to work around this?
Naturally.
Just rewrite the tax calculation logic :blush:

No nice admin switches!?!?! :(

Would I be correct in thinking that rewritting this code would be a big job?

Also, going back to my original post, do you know why my price sort order went 'out of sync'?

Alex Clarke:

Would I be correct in thinking that rewritting this code would be a big job?Yes, it's quite involved.
Alex Clarke:

Also, going back to my original post, do you know why my price sort order went 'out of sync'?
That usually happens when you use external means to update database content, such as importing or manipulating product data. When you do that, the automated calculations that update the pricing details don't fire, leaving you with unexpected results.

DrByte:

That usually happens when you use external means to update database content, such as importing or manipulating product data. When you do that, the automated calculations that update the pricing details don't fire, leaving you with unexpected results.

That makes sense, as I have a couple of scripts that update my product information (prices, special price, etc).

Now, please correct me if I am wrong, but it should be ok to setup an automated task on my server to access the following URL admin/store_manager.php?action=update_all_products_price_sorter, which would correct the price sort order.

Or, whenever you do an update via one of your scripts, simply call zen_update_products_price_sorter($products_id) after you apply your update. Repeat for each product you're updating.

Is it possible to us an array with this?

For example...

zen_update_products_price_sorter('product1', 'product2', 'product3')

No.
And, technically, what you posted was not an array either.

Nevertheless, you could always adapt the actual function to work as you desire.

I've been trying to find the zen_update_products_price_sorter, but so far without success. I'd like to call it from within my external product loading script, if possible. (Yes, I'm a Zen Cart newbie.)