Change Table Prefix for Magento 2 DB (After Installation)

During installation, Magento provides the option to configure the table prefix for your database. That’s great. What if you missed it or realized later that you needed to configure it when you already have real data (catalog, customer, sales, etc.) in your database? Don’t worry, we have got you covered. You just need to follow …

Read moreChange Table Prefix for Magento 2 DB (After Installation)

Fix Region/State Dropdown not Loading on New Account Creation Page

By default, Magento doesn’t display any address fields on the new account creation (/customer/account/create) page. But if you ever want to, it’s just a piece of cake. You simply have to set the flag show.address.fields to true in the layout XML file (customer_account_create.xml): With the above XML update, followed by cache refresh, you may see …

Read moreFix Region/State Dropdown not Loading on New Account Creation Page

Tinkerwell: Tinker with your local/remote PHP & Magento 2 Code

Tinkerwell: Tinker with your local/remote PHP & Magento 2 Code

I was always looking for a quick playground for testing/debugging any PHP application esp. for Magento 2. Luckily, I got to know about Tinkerwell App in some twitter feed and thought of giving a try. [email protected] + Magento 2 is a great combo. It allows me to SSH into the server and execute code on …

Read moreTinkerwell: Tinker with your local/remote PHP & Magento 2 Code

How to Install Multiple Versions of PHP on Ubuntu?

Install-Multiple-Versions-of-PHP-on-Ubuntu

There are many tools like Docker, Vagrant, VirtualBox, etc. that gives you the power to achieve the multiple versions of PHP in your system. But I want to stay away as much as possible from third-party tools and try to leverage the native as much as I can. So want to learn how to install …

Read moreHow to Install Multiple Versions of PHP on Ubuntu?

Import Product Reviews in Magento via SQL

Import Product Reviews/Ratings in Magento

Customers are more likely to make purchasing decisions when they see a product that has good reviews.Also, some search engines give sites with product reviews a higher ranking than those without. Since Magento doesn’t support default functionality for importing product reviews, we came up with a quick approach using SQL. Database Schema for Product Reviews …

Read moreImport Product Reviews in Magento via SQL