Posted in: Magento 2, SSH

Updating Magento 2 to a New Sub-Version

Updating Magento 2 is very simple however, I would like to stress the importance of backing up your database BEFORE running any upgrade. I’d also like to HIGHLY suggest you do NOT do this on a production site until you’ve tested either locally or on a dev/staging environment. You will[…]

Read More »
Posted in: Magento 2

Reset Magento 2 Admin User Role via MySQL

If you’re having an issue with logging into the Magento 2 admin due to permissions, sometimes you need to reset the user authorization. If you’re unable to access the admin, you’ll need to do this via MySQL command line, phpmyadmin, or something similar. Just adjust the two values I have[…]

Read More »
Posted in: Magento, SSH

Create new Magento Admin user via SQL

insert into admin_user select (select max(user_id) + 1 from admin_user) user_id, ‘FIRSTNAME’ first_name, ‘LASTNAME’ last_name, ‘myemail@noemailaddress.com’ email, ‘USERNAME’ username, MD5(‘NEWPASSWORDHERE’) password, now() created, NULL modified, NULL logdate, 0 lognum, 0 reload_acl_flag, 1 is_active, (select max(extra) from admin_user where extra is not null) extra, NULL, NULL; insert into admin_role select (select[…]

Read More »
Posted in: Magento, SSH

Install Magento via SSH

There are many tutorials out there that show you how to install Magento using SSH, but in my experience, there is always something that is missing. Here’s a collection of what I’ve found to work. I am using the Magento Sample data on this installation as well. For those of[…]

Read More »
Posted in: SSH

Upload local file to server using ssh

Open terminal and cd to the location of your file then do the following: $ scp [filename.extension] [username@serverIP]:[folder]/. example using actual names $ scp 3.tar myusername@192.168.1.1:public_html/.

Read More »
Posted in: Magento

Exporting A Magento Database using phpMyAdmin

Access phpMyAdmin and select the database you need to export. Change “Compression” to bzipped. Click the “Export” Tab. Click the “Custom – display all possible options” radio button. Click “Disable foreign key checks” checkbox. Click “Add DROP TABLE” checkbox Click “Go” button

Read More »
Posted in: WordPress

Custom Styles for WordPress Visual Editor

Create a new CSS file in your theme folder and name it custom-editor-style.css Then open your functions.php file, in your theme folder, and paste the following: function my_theme_add_editor_styles() { add_editor_style( ‘custom-editor-style.css’ ); } add_action( ‘init’, ‘my_theme_add_editor_styles’ ); Then write your new styles in the custom-editor-style.css file.

Read More »
Posted in: Magento

How to add a default contact form to a Magento CMS page

It’s actually quite simple to do, and I’m surprised that Magento doesn’t come with a default “Contact” page already setup.  First, login to your Magento admin and navigated to CMS > Pages. Click “Add New Page” button. Just fill in your Title, URL Key and select your Store View. Make[…]

Read More »
Posted in: Magento

New Template Page Layout In Magento

This has to be one of the greatest tips for ANY Magento developer.  I’ve had to use it MULTIPLE times.  Giving credit where credit is due, this is not my post but originally posted here at TJGamble.com.  Although it says this is for Magento version 1.4.1, it does work in[…]

Read More »