As there are differences in the structure of the database, this update is a bit more complicated, because in addition to replace the files, we will have to perform changes to the database, and because we loose  the modules configuration we need to redo the assignment of the modules and layouts in the administration.


To update the Opencart 2.0.0.0 to version 2.0.1.0 proceed as follows:


  1. Obtain the opencart 2.0.1.1 install package
  2. Extract the installation package to your computer.
  3. Make a backup of your current installation of Opencart.
  4. Take notes on module you have installed and their settings (including in layouts)
  5. Send all the directories and files that are within the upload folder to the root of your Opencart installa (accept the replacement of old files).
  6. Run the SQL indicated below (can run the SQL with phpmyadmin)
  7. Reconfigure modules and layouts


Confirm that everything works correctly.



CREATE TABLE IF NOT EXISTS `oc_affiliate_login` (

  `affiliate_login_id` int(11) NOT NULL AUTO_INCREMENT,

  `email` varchar(96) NOT NULL,

  `ip` varchar(40) NOT NULL,

  `total` int(4) NOT NULL,

  `date_added` datetime NOT NULL,

  `date_modified` datetime NOT NULL,

  PRIMARY KEY (`affiliate_login_id`),

  KEY `email` (`email`),

  KEY `ip` (`ip`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `oc_customer_login` (

  `customer_login_id` int(11) NOT NULL AUTO_INCREMENT,

  `email` varchar(96) NOT NULL,

  `ip` varchar(40) NOT NULL,

  `total` int(4) NOT NULL,

  `date_added` datetime NOT NULL,

  `date_modified` datetime NOT NULL,

  PRIMARY KEY (`customer_login_id`),

  KEY `email` (`email`),

  KEY `ip` (`ip`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


ALTER TABLE `oc_language` DROP `filename`;


ALTER TABLE  `oc_modification` ADD  `xml` TEXT NOT NULL AFTER  `code` ;


CREATE TABLE IF NOT EXISTS `oc_module` (

  `module_id` int(11) NOT NULL AUTO_INCREMENT,

  `name` varchar(64) NOT NULL,

  `code` varchar(32) NOT NULL,

  `setting` text NOT NULL,

  PRIMARY KEY (`module_id`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


ALTER TABLE  `oc_setting` CHANGE  `group`  `code` VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;


Write a review

Note: HTML is not translated!
    Bad           Good

Opencart upgrade 2.0.0.0 to 2.0.1.0

  • Product Code: doc-upgrade-2000-2010
  • Availability: In Stock
  • 0.00€

  • Ex Tax: 0.00€