How to Setup Multiple Magento 2 websites/stores with Nginx?

Setup Multiple Magento 2 Stores/Websites 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 more

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 more

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 more

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 more