Hello,
If you looking forward to updating design/theme then the following steps help you.
- Replicate and set up your project code and database in sub-directory or in sub-domain.
- Create a new theme for your changes
- If you want to edit any theme then create a child theme of that theme and do your changes in child theme
- For any database operation creates a new module in app/code directory. Database operation like update database table field, create a new database table, fetch data from the database, create new EAV attribute for a customer , product.
- After successfully done with changes note down your file list, module list, Magento command list, and admin configuration list
- Move your files in which you changed in the live server.
- Enable your module
- Set Admin Configuration
- Select a new theme for your store scope.
- Run following Magento Command
php bin/magento setup:upgrade && php bin/magento setup:static-content:deploy && php bin/magento c:f
If this helps you then click on Kudos and Accept as Solution.
Thank you
Hiren Patel