Assuming the excel got header and the duplicate rows are in first column: =IF(COUNTIF(A$1:A1,A2)>0,A2 & "." & COUNTIF(A...
Tuesday, January 5, 2021
Thursday, August 27, 2020
No Access-Control-Allow-Origin header is present on the requested resource issue Wordpress
Shyam Krishna Sreekumar
August 27, 2020
There will come situations like we need to make ajax request to some other domains with wordpress and we face issue related to it. When you ...
Monday, May 18, 2020
Match two columns in an excel
Shyam Krishna Sreekumar
May 18, 2020
Sometime we might be needed two columns to match and take the third column values. Confused? OK let me tell you a scenario. Suppose i ha...
Thursday, May 14, 2020
Bulk assign attributes to attribute sets programatically in Magento 2
Shyam Krishna Sreekumar
May 14, 2020
When we have a lot of new attributes and need to assign those to all the attribute sets at once, below code will be useful. So first you...
Wednesday, May 13, 2020
Sometimes when we load data to Magento, there might be cases where data need to load with specific new Attribute Sets. If its one or two, ...
Monday, May 11, 2020
Sometimes we need to match two columns to see if a term in Column A is there in Column B. In such cases COUNTIF function will be handy. T...
Monday, February 3, 2020
Write log in Magento 2 using Zend library
Shyam Krishna Sreekumar
February 03, 2020
Sometimes when we are troubleshooting, we might need to generate logs to see what values are returning in a special code. For this we can...
Tuesday, January 21, 2020
 issue in description after migration Magento 2
Shyam Krishna Sreekumar
January 21, 2020
This is an encoding problem; the  is a non-breaking space (HTML entity ) in Unicode being displayed in Latin1. To fix: U...
Wednesday, November 20, 2019
Migrating Reviews from Magento 1 to Magento 2
Shyam Krishna Sreekumar
November 20, 2019
Migrating Reviews from Magento 1 to Magento 2, please mail me @ shyam100379@gmail.com We can migrate all data including ratings, review ...
Tuesday, November 19, 2019
Reindex Magento 2 programatically
Shyam Krishna Sreekumar
November 19, 2019
To reindex a specific indexer, please use below use Magento\Framework\App\Bootstrap; require __DIR__ . '/app/bootstrap.php'; $...