Filter for unique values or remove duplicate values from Excel OR CSV

In Excel, there are several ways to filter for unique values—or remove duplicate values: To filter for unique values, click Data > Sort & Filter > Advanced. To remove duplicate values, click Data > Data Tools > Remove Duplicates. To highlight unique or duplicate values, use the Conditional Formatting command in the Style group on the Home tab.

Magento 1.9.4.1 Invalid header line detected error

HTTP headers are the name or value pairs that are displayed in the request and response messages of message headers for Hypertext Transfer Protocol (HTTP). Usually, the header name and the value are separated by a single colon. HTTP headers are an integral part of HTTP requests and responses. In simpler terms, HTTP headers are… Read More »

How to redirect non www or non https url to www and https

This is very common problem to everyone to redirect non www urls to www with https. You can follow simple .htaccess rules to implement it. RewriteEngine On RewriteCond %{HTTP_HOST} !^www\. [NC] RewriteRule ^(.*)$ http://www.example.com/$1 [L,R=301] RewriteCond %{HTTPS} off RewriteRule ^(.*)$ https://www.example.com/$1 [L,R=301] The only real difference here is that first we redirect from non-WWW to… Read More »

WHM cpanel magento 2 php cli command error

If you saw error php-cli: command not found when running magento command php bin/magento, then you need to run following commands. To fix this error, you need to enable php cli mode. Run following command source /opt/cpanel/ea-php72/enable It will solve your problem. but it will come again when you will reboot your server. You need… Read More »

SetEnv fails with Apache 2.4

If Apache error logs show below error message Invalid command ‘SetEnv’, perhaps misspelled or defined by a module not included in the server configuration The control of internal environment variables that are used by various Apache HTTP Server modules are controlled by the module mod_env. By default module ‘mod_env’ will not be enabled in apache2.4.… Read More »

Magento 2 – How to view CMS block in checkout page

Using CMS blocks, admin can easily change content of the store. CMS blocks can be used to display banners, sale blocks, return policies, important information message on some sections of the store etc. CMS blocks can carry plain text or HTML/JS/CSS code which means they can be used for even more complex content delivery like sliders,… Read More »