Hello, i have a question about development workflow.
I have some extensive modifications to do on an existing active shop, so have created a local filesytem copy, dumped the database, performed a find and replace in the dump for 'domain.com' to 'domain.dev', and changed the config to point the local copy to the new dev database.
All good so far, i can make changes on the local copy without effecting the live site.
The problem arises when i want to merge my dev site with the live one.
Changes to the filesystem are easy enough to handle - track in git and simply upload and overwrite.
However a lot of changes modify the database, primarily:
Installing and configuring a blog module
Uninstalling a module
Adding shop categories and changing the hierarchy
Changing module positions and generally modifying what modules appear in what hooks.
During the process of editing the dev copy, the live site has received a number of new orders and customers, so now the databases are out of sync, and i dont know how to proceed.
I imaging this must be an issue for pretty much any active prestashop install that requires non trivial modification, but i cant find any resources that help with this.
How are other developers handling this?
Any help very much appreciated.