Product sorting not working anymore

[swissup]

Product sorting not working anymore

[iloa08]

Same here, waiting for any solution, thank you.

[0m3r]

I can't reproduce it on my Magento instance.

lmysql16.mp4

Maybe you guys @jeroentiem @iloa08 use some third-party extensions for layered navigation. Give me more information plz

[iloa08]

Thanks for watching.
Could you do the same by adding special-price please ?
(moreover, we can't see price of article on your video)

[0m3r]

What do you mean? Do you mean order by special price or product with special prices? Please send me your detailed explanation.

P.S. Sort by pricing work fine for me.

lmysql16-2.mp4

[iloa08]

Sorry for my english, so could you try to sort by price when you have special price in your listing.

[0m3r]

Work fine for me

p.s. Don't forget to run re-index after adding a special price to a product

bin/magento indexer:reindex catalog_product_price

[iloa08]

Could you please try with more articles with different discount.

Maybe a problem with tax+special price.

[0m3r]

Please provide step-by-step instructions to reproduce it.

[iloa08]

Could you try with only special prices in the listing ?

Here are some examples for my part :
OK - no special price : https://www.cycles-zanet.com/atelier/outillage.html
OK - just one special price : https://www.cycles-zanet.com/vtc-velos-ville/vtc-electriques.html
OK - special prices : https://www.cycles-zanet.com/electronique.html
NOT OK : only special prices : https://www.cycles-zanet.com/promotions.html
NOT OK - special prices : https://www.cycles-zanet.com/bonneterie/casques.html

Thanks.

[0m3r]

Unfortunately, I can't reproduce it.

16-3.mp4

• your store uses a custom "special price" attribute
• you forget to run bin/magento index:reindex
• you use a custom third-party module for navigation

[jeroentiem]

I'm using Amasty layered navigation. Please use Position for sorting.

[iloa08]

your store uses a custom "special price" attribute : no, the special price is the special price from MAGENTO 2 (class price-container price-final_price tax weee)
you forget to run bin/magento index: reindex : no reindex is ok (check it one more time)
you use a custom third-party module for navigation : this module does not change the order - even if this module is uninstall the problem is still here

You don't have try with only special prices in the listing (all products with a special price - with different discount)

Thank you.

[0m3r]

@iloa08 you need to debug it by yourself because I can't reproduce it.
Find where your product collection apply sort params - Magento\Catalog\Block\Product\ProductList\Toolbar::setCollection
what collection object uses var_dump(get_class($collection));
in my case, it's - Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection

@jeroentiem Sorry I don't support Amasty extensions, try to contact Amasty team