Archive for the ‘How to do’ Category

On transferring a Magento website Database running on MySQL 5.7.34 to MariaDB 10.2.39, I get the following error: [naveenos@server2 etc]# mysql m1_db < db.sql ERROR 1005 (HY000) at line 4080: Can't create table `catalog_product_relation`...

PHP, Java and other languages provide replace all functionality to replace any character by any specific character. But REGEX is best method to replace or remove any specific value using pattern. Suppose, we have input string is $xyz = "This is my...

In my previous post [How to programmatically add shipment with a tracking number to any order : PART I], you found that how can we generate shipment for an order programmatically. Here we are going to learn next step to add tracking number with generated...

We are assuming that we have an order incremented id. and we want to make shipment for this order. Here also we are assuming that invoice has been generated for order already. so we are going to generate only shipment. $orderId = '1000001'; ...

I tried to wrote this code when I was working on a cron file for all orders. My client wants a cron file that get all orders information including all ordered item and their detail. First, I searched on google but I didn't found any exact solution then...

Magento provides following types of page layout in default. 1column, 2columns-left, 2columns-right, 3columns, empty, and print. But sometimes we need to change design in layout and we do not want to affect on other pages. For example, we want to use...