We have been working on an upgraded version of our webshop on a testserver for a few weeks. We have worked on products, categories, functions, layouts, design etc.. Simultaniously we have had our live server doing business as usual, so we have revieved orders, new customers etc on our live server that dont exist on our test server.
Now we are ready to go live with our test installation. I am trying to find the best way to do this with as little downtime and possible errors as possible.
We want to keep new orders and customers from live server, and remaining data from test server. How do we achieve this? Is there any documentation on this topic? Or does anyone have the exact database tables that we need to keep or restore from the live server?
Thank you for any help!
Hello
1. Back up your new store.
2. You can try to do the data transfer via import/export and check the effect
3. Can do it at the database level via phpmyadmin but then you have to move the tables manually (the problem will increase if there are differences in table structures - I don't know what your previous version of the store is)
4. Write a script that will connect to the databases of both stores and transfer data between them (I prefer this way)
5. You must consider the tables order*, user*, profile* (not all)
Best regards
Robert
There is no easy way to merge two websites. You can try import/export options. But please note that User ID is used on orders export and not used in users export. As a result orders and users can be mixed up
Given you want the data from your old site and the files/templates from your new:
1) backup both sites (files and databases)
2) Go through the normal upgrade process of your production site (this gets the data ready).
3) copy (or otherwise) update the files from your test site to your production site excluding config.local.php and .htaccess
4) Manually clear the cache by deleting var/cache and it's contents.
If you've installed any addons in your test site but not in your production site, you'll have to do the again,
There is no easy way to merge two websites. You can try import/export options. But please note that User ID is used on orders export and not used in users export. As a result orders and users can be mixed up
Yes... i make these some time a go
I win...and i explain all details on forum for other people
I write all steps to a clean new version and import products, orders, and users
And now i must to make it again...and i forgot...and i don`t see my topic :(
Import store addon don`t work with 4.11 :(((
why someone delete topics ?
even are old are still very useful for everyone
here are a lot of good tweaks for all
Our EZ Admin Helper addon has a function to synchronize users in orders to user's in database.