Pk Magento 2: 2021

INSERT IGNORE INTO `inventory_source_item` (source_code, sku, quantity, status)
select 'default', sku, qty, stock_status from (`cataloginventory_stock_status` as `lg` join `catalog_product_entity` as `prd` on((`lg`.`product_id` = `prd`.`entity_id`)))

Apply command:

php bin/magento indexer:reindex

php bin/magento cache:flush

How To Install PHP 7.4 / 7.3 / 7.2 on Ubuntu 18.04 / Ubuntu 16.04

PHP is an open-source programming language widely used for web development. It is an HTML-embedded scripting language for building dynamic web sites.

By default, Ubuntu 18.04 and Ubuntu 16.04 ships PHP v7.2 (EOL) and PHP v7.0 (EOL), respectively.

In this post, we will see how to install PHP 7.4 / 7.3 / 7.2 on Ubuntu 18.04 / Ubuntu 16.04.

Add PHP Repository

Ondřej Surý, a third-party repository, hosted on the launchpad, which offers PHP 7.4 / 7.3 / 7.2 for Ubuntu operating system.

Update the repository cache.

sudo apt update

Install the below packages.

sudo apt install -y curl wget gnupg2 ca-certificates lsb-release apt-transport-https

Add the repository to your system.

sudo apt-add-repository ppa:ondrej/php

Update the repository index.

sudo apt update

Install PHP

Install PHP 7.4 on Ubuntu 18.04 / Ubuntu 16.04

Install PHP 7.4 with the below command.

sudo apt install -y php7.4 php7.4-cli php7.4-common

Install PHP 7.3 on Ubuntu 18.04 / Ubuntu 16.04

Install PHP 7.3 with the below command.

sudo apt install -y php7.3 php7.3-cli php7.3-common

Install PHP 7.2 on Ubuntu 18.04 / Ubuntu 16.04

Install PHP 7.2 with the below command.

sudo apt install -y php7.2 php7.2-cli php7.2-common

You can also have multiple PHP versions on your system. Each PHP version will have separate configuration files under /etc/php/7.X directory.

Verify PHP Version

Once you have installed the PHP package, check its version.

php -v

Output:

PHP 7.4.5 (cli) (built: Apr 19 2020 07:36:30) ( NTS )
Copyright (c) The PHP Group
Zend Engine v3.4.0, Copyright (c) Zend Technologies
    with Zend OPcache v7.4.5, Copyright (c), by Zend Technologies

PHP Support for Web Server

Both Apache and Nginx do not support the processing of PHP files by default when the browser requests the PHP page. So, we need to install the PHP package on the server to support PHP files.

PHP Support for Apache

You can install a below package with Apache webserver to support PHP for the LAMP stack. This package provides the PHP modules for Apache 2 web server.

READ: How To Install LAMP Stack on Ubuntu 18.04 / Ubuntu 16.04

Change PHP version, if required

sudo apt install -y apache2 libapache2-mod-php7.4

PHP Support for Ngnix

Nginx does not have a PHP modules package to support PHP for the LEMP stack. To have PHP support for Nginx, we can use the PHP FastCGI Process Manager to handle PHP requests.

READ: How To Install LEMP Stack on Ubuntu 18.04 / Ubuntu 16.04

Change PHP version, if required

sudo apt install -y php7.4-fpm

PHP-FPM listens on the socket run/php/php7.4-fpm.sock by default.

To make PHP-FPM use TCP connection, edit the below file.

sudo nano /etc/php/7.4/fpm/pool.d/www.conf

Then, change the listen parameter.

FROM:

listen = /run/php/php7.4-fpm.sock

TO:

listen = 127.0.0.1:9000

Add socket details in Nginx virtual host.

server {

# other codes

  location ~* \.php$ {
    fastcgi_pass    127.0.0.1:9000;
    include         fastcgi_params;
    fastcgi_param   SCRIPT_FILENAME    $document_root$fastcgi_script_name;
    fastcgi_param   SCRIPT_NAME        $fastcgi_script_name;
  }
}

Install PHP Extensions

PHP extensions enable specific functions/support for your code. For example, installing PHP MySQL extension will let your PHP code to connect with the MySQL database.

PHP extensions package is normally named like php<version>-<extn_name>.

To install MySQL support for PHP v7.4, you can install a php7.4-mysql package.

sudo apt install -y php7.4-mysql

Once you have installed a required extension, use the below command to verify it.

php -m | grep -i mysql

Output:

mysqli
mysqlnd
pdo_mysql

PHP Extensions for CMS

PHP Extensions for WordPress

The following extensions are required to install and run WordPress on Ubuntu. WordPress recommends having PHP v7.3 for the installation.

sudo apt install -y php7.3-mysql php7.3-dom php7.3-simplexml php7.3-ssh2 php7.3-xml php7.3-xmlreader php7.3-curl  php7.3-exif  php7.3-ftp php7.3-gd  php7.3-iconv php7.3-imagick php7.3-json  php7.3-mbstring php7.3-posix php7.3-sockets php7.3-tokenizer

PHP Extensions for Joomla

The following extensions are required to install and run Joomla on Ubuntu. Joomla requires PHP v7.1 and above.

sudo apt install -y php7.3-mysql php7.3-xml php-pear php7.3-json

PHP Extensions for Drupal

The following extensions are required to install and run Drupal on Ubuntu. Drupal requires PHP v7.1 and above.

sudo apt install -y php7.3-mysql php7.3-dom php7.3-gd php7.3-json php7.3-pdo php7.3-simplexml php7.3-tokenizer php7.3-xml

Magetno 2, What is Plugin/Interceptor? Real Example | Hindi

Magento 2 Java Script Bundling

JavaScript Bundling

Java-Script bundling is an optimization technique, you can use to reduce the number of files server requests for JavaScript requests. Bundling accomplishes this by merging files multiple JavaScript files together into one file to reduce the number of page requests.

Enable Java-Script bundling

JavaScript bundling does not work unless Magento is in production mode. Once in production mode, JavaScript bundling can only be enabled using the CLI. Follow these steps to setup JavaScript bundling from the CLI.

From the Magento root directory, switch to production mode:

bin/magento deploy:mode:set production

Enable JavaScript bundling:

bin/magento config:set dev/js/enable_js_bundling 1

Optimize bundling by minifying JavaScript files:

bin/magento config:set dev/js/minify_files 1

Enable cache busting on static file URLs. This ensures users get the latest version of the assets anytime they update:

bin/magento config:set dev/static/sign 1

To configure JavaScript bundling, you must disable Javascript file merging. Bundling will not work as the merging of files excludes bundling:
```
bin/magento config:set dev/js/merge_files 0
```

Modifying the settings above when Magento is in production mode will require static view files deployment:

bin/magento setup:static-content:deploy

Finally, clear the cache:
```
bin/magento cache:clean config
```
For example, when Sign Static Files is disabled (which is the default: config:set dev/static/sign 0), the URL to a static file might look like this: /static/frontend/Magento/luma/en_US/mage/dataPost.js. But when you enable the setting (config:set dev/static/sign 1), the same URL might look something like this: static/version40s2f9ef/frontend/Magento/luma/en_US/mage/dataPost.js, with a version number added as shown. The next time this file is updated (with bin/magento setup:static-content:deploy), a new version will be generated, causing the browser to download a new file from the server, thus busting the browser’s cache.

How bundling works in Magento

When you enable bundling, Magento combines hundreds of JavaScript files into just a few JavaScript bundles and downloads those bundles for each page. Because the browser downloads the bundles synchronously, page rendering is blocked until all bundles finish downloading. But the time saved from reducing server requests from hundreds to just a few, usually offsets the cost of downloading the bundles synchronously.

Excluding files

The <exclude> node in the etc/view.xml file for a theme specifies the files to exclude from the Magento JavaScript bundling process. JavaScript files excluded from bundling are loaded asynchronously by RequireJS as needed.

As such, you should exclude the JavaScript files you use for testing or development so that they are not loaded on every page.

The following code snippet from Magento’s Luma theme shows the types of files you should exclude from the bundling process.

Show example

Setting bundle file size

The bundle_size variable controls the file size of the generated bundles. Specifying a large bundle_size reduces the number of bundles generated, but generates larger file sizes. Specifying a smaller bundle_size generates more bundles with a smaller file sizes.

Example:

<vars module="Js_Bundle">
    <var name="bundle_size">1MB</var>
</vars>

The goal is to balance the number of bundles to download with the size of each bundle. As a rule of thumb, each bundle should be at least 100 kB.

Fine tuning your theme

There are many ways to tune your theme using the etc/view.xml file.

For example, the Magento Luma theme is configured to work well for all pages, but you can maximize browser performance for home, catalog, or product pages by adding items to or removing items from the <exclude> node.

Follow these steps to help you identify which JavaScript files to bundle for your theme:

Create a blank page with the layouts you would like to tune.
Compare the JavaScript files loaded in the pages with the JavaScript files in Magento.
Use the results of that comparison to build your exclude list.

Pk Magento 2

linux rewrite engine on a2enmod rewrite

Zip in chunks

Mysql create user and privileges assign.

magento 2 how to disable inventory modules.

Product saleable qty not showing and update in magento 2.x