PrestaShop Documentation, PrestaShop Tutorials

Prestashop activate module from database

In PrestaShop, modules can be activated or deactivated directly from the database by updating the ps_module table. However, please note that making changes directly in the database can be risky and may lead to unexpected issues if not done correctly. It’s advisable to backup your database before making any changes.

Here are the general steps to activate a module from the database:

  1. Backup your database: Before making any changes, it’s crucial to create a backup of your PrestaShop database. This ensures that you can revert to the previous state if anything goes wrong.
  2. Access your database: Use a database management tool like phpMyAdmin or any other database client to access your PrestaShop database.
  3. Locate the ps_module table: Look for the ps_module table in your database. This table contains information about the installed modules.
  4. Find the module you want to activate: Identify the module you want to activate by looking at the name column.
  5. Update the active column: There should be a column named active in the ps_module table. Set the value of this column to 1 for the module you want to activate.


  • UPDATE ps_module SET active = 1 WHERE name = 'your_module_name';

    Replace 'your_module_name' with the actual name of the module you want to activate.

  • Clear the cache: After making changes, it’s a good practice to clear the PrestaShop cache. You can do this by deleting the contents of the /var/cache directory.


  1. rm -rf /path/to/your/prestashop/var/cache/*

    Replace /path/to/your/prestashop with the actual path to your PrestaShop installation.

  2. Verify the changes: Visit your PrestaShop back office and navigate to the “Modules” section to verify that the module is now active.

Remember that manipulating the database directly should be done with caution, and it’s always recommended to perform such actions in a controlled environment, such as a development or staging site, before applying changes to a live store.

About zohaibk

We develop useful addons for #E-Commerce and #CRM software to provide extra features.#PrestaShop,#Magento,#SugarCRM,#Vtiger & #Android #apps
View all posts by zohaibk →