Magento2 : Select product attribute and values from SQL

SET @entityid (product_id) in line no. 1


Magento2, How to override the product list limit on category page in Magento 2 ?

Hello World,

In a large catalog where product count in a category exceed 10k in Magento2, The category shows products count 10000 only.

This value is added in search_request.xml in Magento/CatalogSearch module.


To override this value, create a module and define own value in size node.

Step 1 : Define New Module.

Create VendorName/PackageName directory in app/code.

Create etc/module.xml and registration.php in your PackageName.

2. Create search_request.xml which will be overwriting the values in CatalogSearch Module.

You will find size value defined in 3 requests, I have extended it for catalog view only, you can extended for search results as well.


Magento: Fetch Products with layered Navigation programmatically


Hello world!

This blog is dedicated to all the the developers who wants to do something new and creative. I am giving a new identity to all such developers as – “Credevators”

As the name suggests CREative + DEVelopers. Developers bound themselves to a key area and specific language which is good for industry but not for personal growth and work satisfaction. Web technologies upgrading from HTML to HTML5, CSS to CSS3, fixed to responsive, core to frameworks and developers to creative developers (Credevators).  So, This blog is basically a medium to upgrade ourselves from developer to Credevator.

I don’t know whether my words are effective or not but what should i say we developers are not bound to spelling mistakes or grammatical errors similar to the our variables and logic.

If you agree with this thought please find a way to come up from the boring regular work of development and join – Team Credevator.

You can join us on twitter using our twitter handle @credevator