This article provides the solution to the following MySQL error: ERROR 2006 (HY000): MySQL server has gone away We generally get this kind of error when we try to import or insert a large volume of data into the MySQL database. To solve this error, we can: – either update the MySQL’s configuration file: my.cnf … Read more
This article provides the solution to the following MySQL error: The server quit without updating PID file Open terminal Kill the MySQL process There are different ways to kill the MySQL process. You can try any one of them. Below are some of the ways listed: WAY 1 Run the following command to find the … Read more
This article shows how you can change/update the Order Increment ID, Invoice Increment ID, Creditmemo Increment ID, Shipment Increment ID of your Magento 2 store. In Magento 1, you could simply change the increment prefix and last increment id from the database table entity_store_id. In Magento 2, it’s different. You have the option to change … Read more
This article shows how you can create a new database table and install data into the table while installing a custom module or upgrading the module in Magento 2. The install and upgrade setup script file should be inside the Setup folder of your module. The install script should be named InstallSchema.php & InstallData.php and … Read more
This article shows how you can programmatically assign a product to multiple categories and how you can remove a product from a category in Magento 2. I am using a standalone script for this purpose using Object Manager. You can use this code in your custom module as well by using Dependency Injection (DI) instead … Read more
This article shows how you can add a product from your custom module’s InstallData or UpgradeData Setup script file. This code is useful when you need to auto add product while installing or upgrading your custom module. Add product from InstallData Setup Script This will add product when you install your custom module for the … Read more
This article shows how you can insert multiple rows or records into your database table. Generally, we add a single row of data into the database table. However, we have situations where we need to insert multiple rows of data into the table at once. We can do so by running the insert query multiple … Read more
This article shows how you can add Configurable Product programmatically in Magento 2. I am using a standalone script for this purpose using Object Manager. You can use this code in your custom module as well by using Dependency Injection (DI) instead of Object Manager. Initialize Object Manager and Set the Area code The following … Read more
This article shows how you can add Simple & Virtual products programmatically in Magento 2. This article also shows how you can: – add images to the product – assign the product to different categories – add custom options to the product I am using a standalone script for this purpose using Object Manager. You … Read more