Feb
23

How To: Change order number sequence in Magento

posted on February 23rd 2015 in blogposts with 0 Comments

1. Take a backup of your database as explained here. 2. Find out the entity_id value for orders and invoices by opening the table eav_entity_type: 3. Open the table eav_entity_store and change the value in the increment_last_id field to the number to want to use:  

Read Article
Dec
10

Transfer Magento from one server to another

posted on December 10th 2014 in blogposts with 0 Comments

If you’re developing your store on a staging server and need to move to a different production environment or you’re simply changing hosting providers, here’s a quick step by step tutorial that will help: Step 1 – Create a database First, you need to create a new MySQL database for the new server location. Log […]

Read Article
Dec
10

Reset Magento admin password using MySQL

posted on December 10th 2014 in blogposts with 0 Comments

Here’s an easy way to reset an admin user password in Magento with the user of MySQL: – log into PHPMyadmin and click on the DB used by your Magento installation – find the admin_user table – change the email associated to your admin user to one that you can access – go to Magento […]

Read Article
Aug
05

Backup/Restore Magento SQL database using SSH

posted on August 5th 2014 in blogposts with 0 Comments

This tutorial explains how to backup and restore a database using secure shell (SSH) as opposed to Cpanel or PHPMyadmin. SSH (Secure Shell) can be used in Windows via 3rd party apps like Putty or in OSX via native Terminal App. To backup your database through SSH (create SQL dump): mysqldump –opt -u user -p dbname > […]

Read Article