Understanding Adobe Commerce API Mesh: A Game-Changer for Headless Magento
1. Introduction: What is Adobe Commerce API Mesh? As Adobe Commerce (formerly Magento) evolves, one of the biggest challenges for developers and merchants is managing API complexity. API Mesh was introduced to solve this problem by unifying multiple API endpoints into a single, optimised request, reducing latency and streamlining headless commerce integrations. Instead of having […]
Troubleshooting Magento 2 – We can’t find products matching the selection
Introduction Magento 2 is a powerful eCommerce platform, and it integrates seamlessly with Elasticsearch for search and product catalog indexing. However, when upgrading Elasticsearch or Magento versions, issues may arise with products not showing in category pages (PLP), even though they are visible in the front-end and their configurations seem correct. This post will walk […]
Is Multi-Store Architecture a Thing of the Past?
For years, multi-store architecture has been a cornerstone of eCommerce platforms like Magento, enabling businesses to manage multiple regional or brand-specific stores under a single instance. While this setup offers undeniable benefits in terms of centralised administration and potential cost savings, it also introduces complexities that can grow exponentially as a business scales. Is it […]
How to Export Product Reviews from Magento 2 Database
Prerequisites Magento 2 EE, MySQL 8 and PHPMyAdmin, Docker (doing this in a production Environment is not recommended) Install PHPMyAdmin in Docker It can be tricky to install PHPMyAdmin in Docker vs a traditional LAMP stack as you need a basic understanding of Docker Network. See commands and comments below: Up to this point, you […]
Update Magento from 2.3.0 to 2.3.4
This article covers: Audiences of this article: Getting Magento 2.3 file and folder permission right One of the most confusing areas about Magento 2 development is getting the file system owner and permission right. Due to a lack of workable official recommendations, prior to Magento 2.3, there were thousands of threads floating around the Internet […]
How to Update Magento 2.3 Website URL in MySQL
This article covers: Update Magento 2.3 Base URL in MySQL A culprit of flushing Magento 2 cache in command line Audiences of this article: Magento 2.3 developers Find the rows of base_url in core_config_data Table Both secure and unsecure base_url are located in table core_config_data. If you’re not familiar with core_config_data structure, use MySQL LIKE […]
Magento eCommerce – Fix your Google Search Console Coverage Server Errors(5xx)
This article covers: How to fix Google Search Console Coverage Server Error (5xx) for Magento stores How to create a large number of 301 redirects with Google Sheet Audiences of this article: Magento stores experiencing indexing/coverage issues, which is likely to be caused by changing product categories This could also apply to other types of […]
How to Stop Search Engine Robots from Creating Magento Session
This article covers: Stop bad bots with Apache Fail2Ban Limit good bot access Stop search engine robots from creating Magento sessions Audiences of this article: Magento stores who are effected by excessive bot traffic and the session files are growing at an alarming rate. Stop Bad Bots with Fail2Ban Excessive bot traffic can act like […]
Why Your Magento Store is Running Slow and How to Improve it
This article covers: Magento 1 performance Possible ways to compromise Magento performance & how to fix Audiences of this article: Magento developers who struggle with Magento performance Magento store owners seeking solution to improve their store speed 1. Too Many Attribute Values Not been able to fully understand Magento EAV while putting too many attribute […]
Understand Magento EAV, Flat Tables and Indexing
This article covers: What is Magento EAV What is Magento Flat Table Why Indexing is needed Discussions are based on Magento 1 Audiences of this article: Magento developers who wants refresh their Magento theory, perhaps for the sake of a job interview Anyone who are interested in learning Magento EAV (Entity-Attribute-Value) Model When Varien first […]