eCommerce data export/import – Clean Up Customer Address

When migrating from one eCommerce platform to another, one of the most tedious task is data migration. While orders usually reside in your CRM so there is not need for migration, customer data however needs to be migrated such as their name, email, phone, address and marketing email/SMS subscription status. Among which, address is often […]

Understanding IaaS, PaaS and SaaS in the context of eCommerce

eCommerce is one of the main driving forces for cloud computing With the growth of eCommerce, businesses need a scalable and flexible infrastructure to handle the increasing traffic and transactions. Cloud computing provides businesses with a cost-effective way to manage their infrastructure, scale their resources up or down as needed, and leverage a range of […]

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 […]

7 Tips to Win Back Inactive Customers

So why do customers only buy once from us? A high percentage of one-off customers could indicate hidden issues within your business. To help you identify them, here are some reasons why customers don’t come back: By identifying the reasons why customers only purchase once from your business, you can take steps to address these […]

Use RFM Reports for Better Targeting and Improved LTV

Customer value optimization (CVO) is the process of maximizing the value that a customer brings to a business over the course of their relationship. In the context of eCommerce, this typically involves increasing the average order value (AOV) and the customer lifetime value (LTV). There are several commonly used methods to optimize customer value, including: […]

Use Cohort Analysis to Better Understand Your LTV

Customer Lifetime Value (LTV) is a metric that calculates the total amount of revenue a customer is expected to generate for a business over the course of their entire relationship. In eCommerce, LTV is a critical metric that helps businesses understand the long-term profitability of their customer base. Several factors can impact LTV in eCommerce. […]

Advantages Magento has Over Shopify September 2022

Magento development had a really strong run in Australia for over a decade. The bespoke nature allows merchants quickly turn business ideas into reality and the cost for M1 development were relatively affordable to even to smaller businesses. During this period Shopify being an off the shelf solution was pretty much the bottom feeder, taking […]

Magento 2 Architecture, Performance & Scalability

Magento 2 Topology and Framework Architecture From a topology point of view, Magento 2 eCommerce platform is built on layered software architecture with four tiers: client (browser cache) page cache application database In between each tier, multiple load balancer can be added to take full advantage of Magento 2’s high availability design. From a web […]

Magento Business Intelligence

MBI (Magento Business Intelligence) is a full featured business intelligence platform including data consolidation, modelling and visualisations to analyse the most vital aspects of a merchant’s business. Merchants rely on MBI to accurately report on revenue, orders, AOV (average order value) and CLV (customer lifetime value) as well as complex analysis like marketing channel ROI […]

Magento 2 Certification Series – Magento 2 Certified Solution Specialist

Being a Magento 1 and 2 developer for over 6 years, I’ve decided to take a series of Magento 2 Certifications to brush up my skills, and here are some notes I’ve taken during the study period. In this video, Magento highlights its main eCommerce strength from a standard Magento installation. In other words, you […]