Fixing the MySQL Error “Numeric value out of range: 167 Out of range value for column ‘value_id’ at row 1” in Magento 2

Are you encountering the frustrating MySQL error "Numeric value out of range: 167 Out of range value for column 'value_id' at row 1" when you try to run your Magento 2 store? If so, you're not alone. This error, stemming from a limitation in MySQL InnoDB database tables with an auto-increment column defined as int, …

Continue reading Fixing the MySQL Error “Numeric value out of range: 167 Out of range value for column ‘value_id’ at row 1” in Magento 2

Magento 2 Reset Admin Password

How to Fix: Admin Password Reset Fails in Magento 2.4.6-p3 and Below

In the labyrinth of Magento development, encountering unexpected roadblocks is all too familiar. One such conundrum that has puzzled many administrators is the failure of the reset password feature for the admin user in Magento versions 2.4.6-p3 and below. It's a perplexing issue that leaves users stranded, unable to regain access to their vital accounts. …

Continue reading How to Fix: Admin Password Reset Fails in Magento 2.4.6-p3 and Below

How I got in the international market and what I’ve learned so far

Today I want to talk about something different from what I've been posting on my blog lately. I'm not going to talk about anything technical, nor explain how something works behind the scenes. I want to talk a little to you, a developer or aspiring developer who is learning about Magento or any other platform …

Continue reading How I got in the international market and what I’ve learned so far

Database Magic: Shrinking Giants – Mastering the Art of Generating Compact Dumps from Massive Databases to Work on Your Local Environment

Generating a database dump is a critical practice in the realm of database management, offering a safeguard against data loss, aiding in disaster recovery, and facilitating seamless data migration or replication. A database dump essentially involves creating a snapshot of the entire database, capturing its structure and content at a specific point in time. While …

Continue reading Database Magic: Shrinking Giants – Mastering the Art of Generating Compact Dumps from Massive Databases to Work on Your Local Environment

10 Reasons Why You Should Always (I said ALWAYS) Enable the Google reCaptcha on Your Magento 2 Store

A few days ago a client complained their Magento website was suffering from a bot attack in the checkout with the credit card payment. They received thousands and thousands (I mean, thousands, like more than 30 thousand) of failed transaction emails in their email inbox. They immediately asked for our help to investigate and apply …

Continue reading 10 Reasons Why You Should Always (I said ALWAYS) Enable the Google reCaptcha on Your Magento 2 Store

“Use Default Value” for Multi Select Attributes Doesn’t Save for Store Scope View in Magento 2 Commerce (Enterprise) Edition

A few days ago I worked on a very interesting issue for a client in Magento 2 Commerce Edition. Basically, they have some multi-select product attributes and these attributes allow the admin user to add different values depending on the Store View because when these attributes were created, they were set to Store View in …

Continue reading “Use Default Value” for Multi Select Attributes Doesn’t Save for Store Scope View in Magento 2 Commerce (Enterprise) Edition

Finding the Villain Commit in the Magento 2 Codebase Using the GIT Bisect

A few days ago I was working as usual from my home office. I was entertained working on an investigation for a non-critical bug for one of our clients. Suddenly a Slack message popped up on my screen: "We have a critical bug happening on production for this given client that started happening after the …

Continue reading Finding the Villain Commit in the Magento 2 Codebase Using the GIT Bisect

Exploring the New Horizons: Magento 2.4.6 Overview

Magento, the powerhouse of e-commerce solutions, continues its journey of evolution and enhancement with the release of version 2.4.6. Packed with new features, improvements, and bug fixes, this version promises to elevate the e-commerce experience for both merchants and developers. In this blog post, we'll dive into the key changes introduced in Magento 2.4.6, shedding …

Continue reading Exploring the New Horizons: Magento 2.4.6 Overview

Static Content Generation gets too slow after upgrading to Magento 2.4.5

Recently I worked on a project which was being implemented in Magento 2.4.5 version. This project was based on Magento Cloud and after making a deployment there, I noticed that the deployment took more than 1 hour to complete and I found it very intriguing. Commonly, when the project is in good health of performance, …

Continue reading Static Content Generation gets too slow after upgrading to Magento 2.4.5

Optimizing Performance: A Few (and Good!) Tips for Speeding Up Your Magento 2 Store

In the competitive world of e-commerce, a fast and responsive website is essential for retaining customers and driving sales. Slow loading times can lead to higher bounce rates and abandoned carts. Fortunately, Magento 2 offers a range of optimization techniques to enhance the performance of your online store. In this blog post, I will list effective strategies to speed up your Magento 2 store, without digging too much into any of them.