Create Magento 2 admin user from shell/terminal

Thankfully, Magento 2′s newly introduce CLI (command-line interface) allows you to do this without writing any code. Here is an example of how I would execute this command to create a new administrator.

Go to your magento bin folder in terminal, Example - cd <your Magento install dir>/bin and run the following command.


Magento: Getting Skin Urls in transactional emails

A problem I have come across before is when I want to include an image within a transactional email, using:

 The problem being that by default, the transactional emails will look in the skin folder for the admin area in the base package. However if your storing images in the frontend skin folder for your package/theme, you need to be able to provide this CMS syntax additional information. You can specify the area, package and theme you wish to refer to. See the code snippet below:



Split time slots between start time and end time in PHP

Creating time between start time and end time in interval of 30 Minutes in PHP

Test it now



How to add a new field to Magento configuration?

In this example, I am going to add a new field under the Configuration -> CATALOG -> Catalog -> Product Alerts, The filed name is “some text” and it is a select box with Yes, No Options.

To do that, we need to add/edit system.xml in our custom module. Here is the XMl to add a new filed.

Thats it, Clear the Magento cache and test it.  You will be able to see the changes.

How to add a new field to Magento configuration - IYngaran

Calculate distance between two locations by Latitude and Longitude

The following code returns the distance between to locations based on each point’s longitude and latitude.

Passed to function:
lat1, lon1 = Latitude and Longitude of point 1 (in decimal degrees)
lat2, lon2 = Latitude and Longitude of point 2 (in decimal degrees)
unit = the unit you desire for results
where: ‘M’ is statute miles (default)
‘K’ is kilometers
‘N’ is nautical miles


PHP Code


Reference Links


How to Manually Add a WordPress Administrator to the Database using SQL Queries

In a recent WordPress hack attack which we worked on and recovered, the owner’s WordPress administrator account was demoted to a user role, therefore the owner did not have any control over the WordPress installation. To regain back access to WordPress, we manually created a new WordPress user with an Administrator role directly in the database.


In this tutorial I will show you how to manually create a WordPress administrator in the WordPress database by using any of the following methods; MySQL command line (SQL queries), or via phpMyAdmin.


If you have access to your MySQL database server via command line, you can use the below SQL queries to create a new WordPress administrator in the database.


Below is the code to create a new admin account named ‘iyngaran’ with the password pass123. You may change any of the content in red to fit your needs, but leave all other data as is.


Note : In this code, the table prefix is ‘wp_’. You need to change the query, if you are using different table prefix before execute this query.

You should see the message ’1 row affected’ after each of the three SQL statements. This means the insertion ran smoothly. From here, visit your wordpress admin login area as normal and use the new admin login information. You should get to the admin interface without issue.

Bulk delete pending wordpress comments

Been under a comment spam attack lately? Or you just did not have time to delete spam comments over several months and you now have hundreds of spam comments that needs be deleted page by page using the wordpress admin? Don’t worry, there are a couple of easy ways to bulk delete pending comments in your wordpress blog.

Method 1: Direct MySQL Query

If you know yourself around phpMyAdmin and MySQL queries, just run this one line query in the “Sql Query” window of your WordPress database in phpMyAdmin. This query instantaneously deletes all comments in “pending” status. All your approved comments won’t be touched. To be on the safer side you may also want to backup your entire database or just wp_comments table just in case something goes wrong.

Method 2: Using a wordpress plugin

If you don’t want to mess with your database directly, use a plugin like Delete Pending Comments . I tried this in a blog which had around 600 pending comments. Took about 4 minutes to delete all pending comments and it did the job well. There are also few other plugins similar to this plugin out there in the WordPress Plugin Directory.

How to clear the Qmail Queue (clean & delete it quickly) – Forcefully clearing the qmail queue

Is your qmail queue on your server out of control? Look no further! Here’s a quick and easy way to clear, clean, or empty your qmail queue.

Clear & Clean Qmail Queue Completely, Safely & Fast!

This method only removes the messages from the queue, and nothing else is lost.

First of all check the number of messages from the queue using the qmail-qstat tool:

To remove the messages from the queue ALWAYS stop the qmail service first, to avoid having to reconfigure it again:

Once the service is stopped execute the following commands one by one (based on the number of files stuck in the queue, this may take a while):

Finally start the mail service and recheck the queue to ensure that all the messages have been removed:

I hope it will be useful!

How to change a product dropdown attribute to a multiselect in Magento ?

First, update the attribute input type to multiselect:


Next, copy the attribute values from the old table to the new:



Finally,  remove the old values or they will conflict with the new setup (the old values will load, but Magento will save new values to the varchar table):



Top 20 Most Recommended Human Resources Systems

The Human Resource Management software are used to design, organize and streamline a company’s human resources. The HR software can manage all the common HR functions such as compensation, evaluation and management of performance, promotions, managing relations, planning, payroll and retirement. Although finding the right HR software is an uphill task, you need to look for automated HR software solutions that has helped other organizations to mange their workforce efficiently at a much lower price. Let us look at the top 10 of its kinds.

1. Obtor Enterprise Management Portal

- By Obtor
- Website :

Obtor EMP is a Powerful and Simple Cloud base system is to manage your staffs,sales, marketing, customer support, inventory and lots more in a single system. With built-in solutions that range from email marketing, to activity and project management and beyond, ObtorEMP is an inclusive system to automate and manage the operations of a business.

ObtorEmp provides comprehensive, efficient, secure and fast human resources management system that facilitates managing full range of HRMS functions and responsibilities in any company. It gives your organization the much needed tools to manage your day-today tasks effortlessly.

Cloud-based Human Resource Management System( HR Software) that includes attendance, time tracking, leave management and lots more. With Obtor People’s centralized management and employee self service portal, manage all your HR programs from a central location. Also you can track your employee’s time, attendance, absenteeism, holidays and much more even when you’re away from the office.


2. Zoho People

- By Zoha
- Website :

Zoho People lets you manage all your HR and benefits programs from a central locationmaking it easier than ever to attract, retain and reward top talent. All while reducing costs, saving time, and integrating and aligning your HR efforts with the rest of your organization.


3. Paywings Payroll & HRMS

- By STPL Global
- Website :

New Version Release! Easy to configure Payroll and HR software developed specifically for African, Asian and Middle Eastern markets


4. HR Acuity On-Demand

- By HR Acuity
- Website :

Web-based solution to mitigate financial & legal risk by establishing a transparent, employee relations and HR investigation process.


5. Manage With Success

- By Manage With Success
- Website :

HRIS System. With ManageWithSuccess, you can fill that void with a ‘virtual professional’: Efficiently, Effectively and Affordably.


6. Online Orientation

- By Comevo
- Website :

Interactive online orientation software for students, employees, and volunteers for education, corporate, and non-profit.


7. SentricWorkforce

- By Sentric
- Website :

Web-based modular system that includes human resources management, payroll, time and labour management components.


8. Staff Squared

- By Atlas Computer Systems
- Website :

Social HR system with employee data organization, scheduling, leave management, document keeping, organization chart tracking.


9. OrangeHRM

- By OrangeHRM
- Website :

OrangeHRM is the world’s most popular and used open source human resource management software.


10. StartDate

- By HireGround Software Solutions
- Website :

Mobile-friendly system that helps HR departments to manage applicants, compare candidates, and post a job with a questionnaire.


11. JobApp

- By JobApp Plus
- Website :

Allows your applicants to apply online or by phone and manages the process of applicant sourcing, tracking, and onboarding.


12. Attend HRM

- By Lenvica Computer Solutions
- Website :

HRM solution with integrated payroll and time attendance module; automates attendance and payroll/salary processing.


13. Calibrix

- By Centhrix Technologies
- Website :

An HR platform for managing recruitment, talent, payroll, attendance and leave, training, and more.


14. HR Communications

- By SnapComms
- Website :

Internal communications tools that include interactive screensavers, scrolling news feeds, desktop alerts, and right time tools.


15. HR management Software

- By Business Database Builder
- Website :

Access based HR software designed for human resource management proposes, offers wide solutions for your human resource department.


16. PeopleStrategy eHCM

- By PeopleStrategy
- Website :

Human capital management solution delivered as a SaaS with integrated payroll, HR, benefits administration, applicant tracking, etc.


17. HR Management System

- By HR Management Software
- Website :

HRMS includes different modules for personnel (leave, time & attendance etc.) and organization (recruitment, training, benefits, performance etc.) information providing multiple access.


18. Worklogic

- By Worklogic
- Website :

Comprehensive HRIS system with modules for onboarding, attendance tracking, payroll, document and case management, and self-service.


19. Accura Software HR Portal

- By Accura Software
- Website :

Allows your employees to access and update their personal information using a web browser.


20. Agito eHRM

- By Agito
- Website :

eHRM is a comprehensive Human Resource Management System which support HR processes.