How to set up multiple Magento 2 websites / stores with Nginx?

Magento is so flexible that one instance of it can have multiple websites/stores with different languages, domain names, categories, etc. You can configure the websites, stores, and store views in the Magento Admin. You use the MAGE_RUN_TYPE and MAGE_RUN_CODE variables in entry point scripts(index.php), .htaccess or Nginx configuration files(depending upon the web server you are …

Read moreHow to set up multiple Magento 2 websites / stores with Nginx?

Sandbox script for quick testing in Magento2

What’s your approach for quick & dirty testing in Magento2? Creating a test module with a controller and executing it from the browser to see the output? Creating a Console module and executing via CLI? Obviously, the above two approach takes time. Rather I would create a simple script (a single file) and put it …

Read moreSandbox script for quick testing in Magento2

Magento 2: How the quantity_and_stock_status attribute value is populated in product object?

Well, a new product attribute that you may notice in Magento2 is quantity_and_stock_status. SELECT * FROM eav_attribute WHERE attribute_code = ‘quantity_and_stock_status’; Query Result: If you load a product object as: $product = $this->_productRepository->getById($productId); var_dump($product->getData()); You will see the value of quantity_and_stock_status as an array of is_in_stock and qty. You must be thinking from where the …

Read moreMagento 2: How the quantity_and_stock_status attribute value is populated in product object?

MySQL Issue: Table storage engine for ‘catalog_product_relation’ doesn’t have this option

When you export the Magento database dump from MySQL 5.5.x and try to import in MySQL 5.7.x, You are likely to face an error: ERROR 1031 (HY000) at line 3002: Table storage engine for ‘catalog_product_relation’ doesn’t have this option PROBLEM This is probably due to the table option that you have in your CREATE TABLE …

Read moreMySQL Issue: Table storage engine for ‘catalog_product_relation’ doesn’t have this option

Configure your Bash Shell for Magento 2 CLI Commands

One of the major improvement in Magento 2 is the introduction of CLI commands based on Symfony Console Component. CLI commands can perform multiple tasks. Some of them are: Installing Magento (and related tasks such as creating or updating the database schema, creating the deployment configuration, and so on) Clearing the cache Managing indexes, including …

Read moreConfigure your Bash Shell for Magento 2 CLI Commands