Magento - Change Skin and Package in DataBase

Magento - Change Skin and Package in DataBase

July 25, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento - Change Skin and Package in DataBase

Changing Magento Skin and Package Directly from the Database

As you’re developing an automated installation script for Magento using Node.js/Grunt, you’ll want to configure the skin and package directly without visiting the admin interface. This can be achieved by modifying specific tables in your database.

Identifying the Relevant Tables

The core_config_data table is where Magento stores various configuration settings, including the current theme (skin). The design_package field contains the name of the active package, while design/theme holds the active skin.

Here’s a basic SQL query to fetch these values:

SELECT value FROM core_config_data WHERE path LIKE 'design/package%' OR path LIKE 'design/theme%';

Modifying the Skin and Package

To change the skin or package directly via SQL, you’ll need to update specific rows in the core_config_data table. Here’s how it can be done:

Changing the Active Skin

  1. Find the row where path is set to design/theme.
  2. Update the value field with your desired theme name.

For example, if you want to change to the ‘theme_name’ skin:

UPDATE core_config_data SET value='theme_name' WHERE path='design/theme';

Changing the Active Package

  1. Find the row where path is set to design/package/default.
  2. Update the value field with your desired package name.

If you want to change to the ‘package_name’ package:

UPDATE core_config_data SET value='package_name' WHERE path='design/package/default';

Best Practices and Considerations

  • Always take a backup of your database before making direct modifications.
  • Be cautious when updating configuration data, as incorrect changes can impact site functionality.
  • Remember to flush the cache after making these updates. You can do this via SSH with php bin/magento cache:flush in some environments.

Conclusion

Directly changing the skin and package from the database provides a convenient way to automate your Magento installation process through scripts like Node.js/Grunt.

While it’s important to be careful when making direct database modifications, understanding the core configuration tables can help streamline your development workflow. If you’re looking for more advanced Magento development solutions or need expert consultation, don’t hesitate to reach out to us at Laravel Company.

Remember to thoroughly test any automated scripts in a staging environment before deploying them to production. This approach ensures that your live site remains stable and secure.

Happy coding!

Database Themes Admin Configuration

Our network