I have built a django/satchmo ecommerce site that is beginning to obtain some traffic, and i'm getting an issue because I don't possess a wise way to cope with database changes. After I develop the website on my small local system, I make changes towards the layout and also the DB, which handles the merchandise characteristics.

When I wish to push new developments towards the server, I must overwrite the server database that has details about recent consumers and purchases.

What I wish to do is "merge" the 2 databases together to ensure that new purchases still stay recorded within the database, but that also let me push local changes towards the server.

I'd appreciate any advice. Thanks.

are you currently using south? (otherwise, you need to)

particularly, take a look at data migrations