How to change OpenCart URL

In the world of website management, most of the times, we need to create website on a test link before they are ready to be published on web. In several other cases, host name of the company is changed resulting into change in the website URL.

So, we can say that it is very common to change the URL of website installations.
When we work on any CMS (Content Management System) tools, this may not be so easy and you may get tangled in the intricacies of CMS tools to achieve this.

After struggling a bit with OpenCart  , I decided to write this article as reference to others.

Change Home URL

Changing home URL in OpenCart is very easy. Just a few steps and you are done with it.

For Front End (Front Store)

1. Access installation files of your OpenCart instance (using FTP or the FileManager in your cPanel) and go to the root folder of your installation
2. You will find a file named config.php
3. Open this config.php file in an editor (If you are using FileManager, you will have something to edit the file in browser)
4. Find for the properties named 'HTTP_SERVER' & 'HTTPS_SERVER' in the file:
   
   // HTTP
define('HTTP_SERVER', 'http://vibhav.com/');

// HTTPS
define('HTTPS_SERVER', 'http://vibhav.com/');



5. Change the existing host name (highlighted above) to the new URL name and save the changes
6. After this file, the front store will start working well. However, the management backend (admin panel) will still not work after these changes.

For management backend (admin panel)

1. Access installation files of your OpenCart instance (using FTP or the FileManager in your cPanel) and go to the /admin folder of your installation
2. You will find a file named config.php
3. Open this config.php file in an editor (If you are using FileManager, you will have something to edit the file in browser)
4. Find for the properties named 'HTTP_SERVER', 'HTTP_CATALOG', 'HTTPS_SERVER' & 'HTTPS_CATALOG' in the file:
   
   // HTTP
define('HTTP_SERVER', 'http://vibhav.com/admin/');
define('HTTP_CATALOG', 'http://vibhav.com/');

// HTTPS
define('HTTPS_SERVER', 'http://vibhav.com/admin/');
define('HTTPS_CATALOG', 'http://vibhav.com/');


5. Change the existing host name (highlighted above) to the new URL name and save the changes
6. Your OpenCart URL is changed and your website will function on your new URL

Isn't it so simple?

Happy New Year 2015

Wishing you a very Happy and Prosperous year 2015...

How to keep one variable constant with other one changing in formula in MS Excel?

Today I will talk about a small tip on MS Excel.

Excel is one of the frequently tools in the life of an IT personal. We mostly use it to generate some report, various tables, charts etc.
One of the most common use case include calculating values of various rows in a column based on a formula which includes a value of a cell.

For example, in the below screenshot, based on the principal and duration specified on top, we would like to know the value of Simple Interest & Compound Interest based on different rate of interests.

Most of us start using some formula for the first cell (for example in this case value for cell B5 is "=B1*B2*B4") and then drag (or copy) that to other cells which need to have same formula. But ALAS!!! What you get is broken formula with a lot of errors or incorrect value (for example G5 would end up having value formula "=G1*G2*G4" which is incorrect).

One day without internet!

Can you imagine getting disconnected from world due to lack of internet connection ??

Now you are going to say big Nooooooooo, Ofcourse am too addicted to Internet, it doesn't a big deal.

For me personally, One day without internet is one day without oxygen.

My day start in front of laptop and it ends in front of laptop. I usually connected on social networking sites (ofcourse office work also going in parallel), Chatting, blogging and surfing that's all what I do on Internet.

wait wait wait.. It doesn't like I am doing all the time useless things, sometimes I'll do some kind of work like personal information of one friend transfer it to other...Ha Ha Ha (jokes apart)

Well now I have to be serious else you guys will think whats wrong with me today ..

In today's life style, it isn't possible or should say I don't have time to sit on a road side corner shop and meet/gossip with my friends (as most of them are not living nearby). So, to connect with them also, I have to depend on internet. Now technology has advanced so much that our household chores like electricity bill payment, banking and many more too need internet; without this I have to personally visit that places and everyone very well know these offices and their working style.

 

Also, as most of us work in IT companies, and most of our work depend on the offices in other locations, which connect to you with internet itself. (vaise ek raaz ki baat... jo sabko pata hai... it feels awesome when you don't have internet connectivity at office... Kaam se chhutkara chahein wo thode time ke liye hi sahi...)

Anyways, Internet has become a necessity of our life. Even though, I saw my neighborhood kids who are in 1st grade and they require Internet to finish their assignments and not only for school assignments they prefer to play computer games instead of physical/outdoor games. For them, electronic gadgets are like a toy. When they are only two years, they very well know that how to operate these gadgets.

Have you ever faced a situation of no internet for a whole day???

Happiness is...

Sometimes I thought what is happiness or should I say what is real happiness!!!

According to Mahatma Gandhi “Happiness is when what you think, what you say, and what you do are in harmony.”  

Well , Everyone has its own feelings and own definitions over this. But when I try to think over this then I come to a conclusion with...Happiness is nothing, it just a very little little things by which we can feel good internally...

• fighting with your brother/sister
  
• sharing your food with your best buddies
  
• chatting/talking to your long distance friends after so long
  
• working together to achieve a shared goal