Adding custom fonts to Wordpress

Download the font zip file from any site, such as Google fonts:

Importing an SQL file in XAMPP MYSQL via command prompt

Importing an SQL file in XAMPP MYSQL via command prompt. You may need to do this if the sql file is too large. In excess of 500MB, I have imported a sql file of over 1GB.

Set DNS in AWS

1. For updating DNS on AWS head over to:

Migrate Wordpress to AWS (Amazon Web Server) video

Watch the below video for step by step instructions.

Home page new products widget in Magento 2.x

To display new products on Home page in Magento 2. Paste the following code in the block or home page to call new products.

Manual Installation of extensions in Magento 2

Example manual Installation of hide price extension in Magento 2.x, Download the extension package.

Magento 2.x update errors

If you are getting Error Update!  ....... Please click the "Rollback" button

Delete or rename this file: /var/.update_error.flag

Magento URL examples


<div class="custom-footer">

Magento 2 Installing Extensions

Installing Magento 2 extensions are different to Magento 1.x.

Find the extension you want to install and obtain the Public Key and Private Key from Magento Connect.

How to by Pass the SSL error in Magento 2 extension install

If are getting an SSL error in Magento 2 when installing an extension via Web

Magento commands

If you get the below error in Magento 2

Magento 2 Theme setup commands

Manual Installation

Step1: Upload and decompress the theme folders into Magento webroot folder (in which the Magento 2.x is setup and running). Example the file, which you have downloaded.

Magento Captcha

Time to time you may get spam registrations on your Magento store. If this happens an in built captcha can be enabled in Magento 1.x.

Encrypting a website with SSL to redirect HTTPS://

Encrypt the website or addon domain with SSL so the URL loads https://

Auto play YouTube

Get the YouTube embed iFrame code. As below

Adding a custom field with class in Contact Form 7 for Wordpress

Create the contact form in the Contact Form 7

Mobile number href link

To place a phone number on a mobile phone dialer use the following href link on responsive websites.

Magento order conformation email not sent

If you are running Magento 1.9.x or earlier and your order confirmation email is not sent. This can caused by the new cronjob settings in the Magento 1.9 version.

HTML Email Setup

Example of HTML Email footer: <p><a href=""><img title="MYRYDA" src="" alt="toy car sales" width="331" height="57" /></a></p>

Creating Facebook Pixel

Facebook Pixel lets you get the most out of the Facebook ad system, by providing you with the conversion tracking script for your website. It allows the conversion tracking of the final page of your funnel.

Moving Magento 2.x to another server

  • Edit the file /app/etc/env.php from the old folder

Setting up Table Rates on Magento 2 | Magento Shipping | Magento Table Rates

Setting up a custom table rate in Magento 1.x or Magento 2.x is not as simple as uploading your table rate CSV file in Store>Configuration>Sales>Shipping Methods.

Set up PayPal payment method in Magneto 2 | Magento PayPal payment

There has been some changes in going from Magento 1.x to 2.x in the PayPal payment methods. You will need an API Username, API Password and API Signature in Magento 2 PayPal payments.

Installing Magento 2.0.x

The main components you need to install Magento are:

  1. Download Magento from here:

Login here to publish helpful and technical articles.

Google Ads