Magento Quick Personalisation
Introduction Magento does not include personalization features out of the box, and external solutions can be costly. In this post, I’ll share a quick, free method I used to personalize content on a customer’s account page based on their email address. This solution is intended as a temporary fix and should not be used to […]
Magento Optimisation – Part 1
Introduction Magento is known for being a robust but resource-intensive eCommerce platform. In this post, I explore various strategies to enhance Magento’s performance, making it faster and more efficient right out of the box. Choosing the Right Server One crucial factor in Magento’s performance is the hosting server. My top recommendation for Magento hosting is […]
Magento SQL Average Order Value
Introduction Understanding the Average Order Value (AOV) is crucial for evaluating the overall performance of your e-commerce store. This guide will show you how to calculate AOV using SQL queries tailored for a Magento database. Basic AOV Calculation To calculate the AOV, you need to divide the sum of all order totals by the number […]
Magento SQL Repeat Customers vs New Customers
Introduction Understanding the composition of your customer base is crucial for effective marketing and sales strategies. This guide will show you how to categorize customers into new and repeating groups using SQL queries in Magento. Step-by-Step SQL Queries 1. Total Number of Customers To get the total number of unique customers: SELECT COUNT(*) AS grand_count […]
Magento SQL Average Total Orders Per Customer
Calculating Average Orders Per Customer in Magento Introduction This guide explains how to calculate the average number of orders per customer in a Magento database using SQL queries and PHP. Step 1: Retrieve Total Number of Orders Start by running a SQL query to get the total number of orders excluding certain statuses like ‘canceled’ […]
Magento display minimum order amount
Introduction Displaying the minimum order amount in Magento can be useful for informing customers about order requirements. This guide demonstrates a simple method to display the minimum order amount in any template file, such as the header. Implementation Below is a straightforward way to display a message if the order subtotal is below the minimum […]
Magento 2 Creating a theme
Introduction In this guide, I will cover the steps to create your own custom theme in Magento 2, including the folder structure and necessary files. This should help you get started with theme development in Magento 2. Theme Folder Structure To create a custom theme, you need to set up the following folder structure in […]
Magento 2 Removing H1 Title from Homepage
Introduction If you want to remove the H1 title from your Magento 2 homepage, you can easily achieve this by adding a specific line of code to the page’s design settings. This guide will show you the steps to remove the H1 title from your homepage. Step-by-Step Guide 1. Access the Homepage Settings Navigate to […]
Magento 2 can’t checkout
Introduction If you encounter the error message ‘Unable to save address, please check input data’ while trying to checkout in Magento 2, it may be related to a PHP setting in Plesk. This post will guide you on how to resolve this issue. Error Description During the checkout process, Magento 2 may display the error […]