cgzhang/rayfox_catalog

Sort Products, Automatically sort by stock

rayfox_catalog's Issues

conflict with Amasty extensions!

First I want to thank you for your great extension

As I test, if we enabled "Amasty Improved Layered Navigation" or "Amasty Improved Sorting" extensions and then use your extension too and enable it for sorting products and we have configurable products, then we got error in categories!
If disable your extension or disable one of the Amasty's extensions, then errors gone and category load fine!
You can see code below(error that I got it)

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'stock_status.stock_status' in 'field list', query was: select SUM(stock.salable) as in_stock, COUNT(stock.salable) - SUM(stock.salable) as out_stock from (SELECT stock_status.stock_status AS salable FROM catalog_product_entity AS e
INNER JOIN catalog_category_product_index AS cat_index ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '44' AND cat_index.is_parent=1
INNER JOIN catalog_product_index_price AS price_index ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
LEFT JOIN cataloginventory_stock_status AS cisi ON (cisi.product_id=e.entity_id) AND (cisi.website_id = '1')) as stock

Don't work

Hi,

I installed this extension, change the two new fields do YES, and nothing different happens. Still the same.

I'm using Porto theme. Ho can i debug this problem?

Rayfox_Catalog Sorting issue

This extension sorts the out of stock products after the in-stock products.
What changes should I make if I want to have out of stock products before the on-stock products.

Not working on searches

Hi. Thanks for the extension.
I am using it on Magento CE 1.9.1 and it is working OK, except that it is doing nothing on searches. I didn't find anything on the logs that could point to where the problem is. Is there any tests I can make? It is enabled for searches on the backend of course.
EDIT: I installed it from MagentoConnect. Is it the same version? Yes, it is.
EDIT2: The backend doesn't seem to cause any effect in my install. I can set anything there and the catalog listings will always have out-of-stocks as last and searches will never have them. Cleared the caches and rebuilt indexes many times.

Ok, so my problem is that this extension conflicts with Smartwave_AjaxCatalog, since they both rewrite the same files. For searches the problem is worse because they rewrite the same method as well. In the end, I have incorporated most of the code from this extension into the Smartwave one, mostly because they change the prepareProductCollection($collection) in the search Layer file (they don't even use the parent one). So I had to make the sorting on the collection prepared by them.

I tried making one Class extend the other (instead of the Mage one), remove the rewrite, but could not make it work. Disabling their extension breaks my site. I was trying for hours and then just realised it would be easier to sort their collection.

Not works with layered navigation

Thank for your work, but not working when the collection is filtered by layered navigation.
There is a way to do that?

Problem in main page

Hello,

The module is working fine, but on my home page when i click on any product it goes to CART and doesn't add the product on the cart.

I have seen many errors on /var/log like this:

Notice Undefined offset 135 in /usr/share/nginx/html/app/code/core/Mage/Catalog/Model/Resource/Category/Flat.php on line 833

Please help me! thanks a lot