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

[Alex Clarke]

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?

[Kim]

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

[Alex Clarke]

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. :)

[DrByte]

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?

[Alex Clarke]

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?

[DrByte]

Is there a way to work around this?

Naturally.
Just rewrite the tax calculation logic

[Alex Clarke]

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'?

[DrByte]

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

Yes, it's quite involved.

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.

[Alex Clarke]

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.

[DrByte]

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.