A no nonsense notebook for nerds
-
Compare two columns in Excel and check the missing values
=IF(COUNTIF($B:$B, $A1)=0, $A1, “”)
-
Magento 2.1x – Add options in custom product attribute using backend
Go to the attribute edit page using magento 2 admin panel (Stores > Attributes > Product > Edit attribute) Use console – ctrl + shift + J Edit the js array mimim and then paste the following code in console.
-
Correct File Permissions for Magento 1.9x
find . -type f -exec chmod 644 {} \; find . -type d -exec chmod 755 {} \; find ./var -type d -exec chmod 777 {} \; find ./media -type d -exec chmod 777 {} \; chmod 777 ./app/etc chmod 644 ./app/etc/*.xml
-
How to view current deployment mode Magento2 and change it
php bin/magento deploy:mode:show php bin/magento deploy:mode:set production php bin/magento deploy:mode:set developer
-
How to Update Magento 2.1x to latest version via SSH
-
Updating Magento 1 via SSH
cd ~/public chmod 750 mage ./mage mage-setup . ./mage config-set preferred_state stable ./mage sync ./mage install https://connect20.magentocommerce.com/community Mage_All_Latest –force php shell/indexer.php reindexall rm -rf downloader/.cache/ var/cache/
-
Magento 2.1x Cron Jobs
Cron JobsAdd through cPanel/WHM Time interval – 10 minutes -> */10 * * * * Replace ^username^ with user dir Using Crontab editor in Terminal Use command crontab -e
-
How to unlike all Facebook pages from your profile and Clean your newsfeed
Hello humans, I have tried to keep this tutorial simple and detailed. Please proceed with caution. The following tutorial and the procedure will unlike pages you have liked from your profile, Please be clear about that the fact that the code provided here is clean and does not intend to do any harm to your…
-
Start a magento instance programmatically
This Code:
-
Inserting into SQL without specifying primary column
If Primary key is set to Auto-increment, there are chances that you would not want to provide its value in insert query. Here is how to do it in MySQL: INSERT INTO table_name VALUES (NULL, ‘column b’, ‘col c’); Assumption^: The first column is the primary key set to AI Similarly you can skip…
Got any book recommendations?