Magento2 Created at Date sort column/ filter on product admin grid

Solution:

We can add the below code on this file :vendor/magento/module-catalog/view/adminhtml/ui_component/product_listing.xml

<column name="created_at">
   <argument name="data" xsi:type="array">
        <item name="config" xsi:type="array">
            <item name="filter" xsi:type="string">dateRange</item>
            <item name="editor" xsi:type="string">text</item>
            <item name="label" xsi:type="string" translate="true">Created At</item>
            <item name="sortOrder" xsi:type="number">60</item>
        </item>
    </argument>
</column>

Magento2 Web Setup Wizard stuck after failed rollback

Solution:

Try running the following 2 commands from the magento root directory as the magento user:

mv var /.update_error.flag
var/.tmp_update_error.flag
var/.update_queue.json
var/.tmp_update_queue.json
This will remove the flag that causes the Web Setup Wizard to stay stuck in this state.

or manually rename these files, .update_queue.json, .tmp_update_queue.json

magento2 Recaptcha problem

reCaptcha V3 “You cannot proceed with …. your reCaptcha reputation is too low”

{“0”:”Warning: file_get_contents(): https:\/\/ wrapper is disabled in the server configuration by allow_url_fopen=0 in \/home\

Solution: Edit the php.ini file and enable using below code

allow_url_fopen = 1 //0 for Off and 1 for On Flag
allow_url_include = 1 //0 for Off and 1 for On Flag

search improvement in magento2

AND or OR? Magento’s Search Types and Search Operators,

In Magento 1.9x there is a way choose alternative search method for the on-site search, how would achieve an ‘AND’ operator for searches in Magento 2?

Here is the solution, (as always recommended backup you system and db prior to making any file changes. also it is always recommended you do not change Magento core files, instead apply this fix by creating an override custom extension/module)

edit search_request.xml
vendor\magento\module_catalog_search\etc\search_request.xml

change <queryReference clause=”should” ref=”search” />

to  <queryReference clause=”must” ref=”search”/>

//www.expertwebsolutionsinc.com/wp-content/uploads/2020/06/expertwebsoutions-bottom.png