Upgrade Prestashop moving tables?

[alberto.emanuele]

Hi community, i have two sites in prestashop, identical to each other, but with two different version, 1.5  and 1.6.

I worked on 1.6 from 2 months for many fix on theme.
Now i should move the new updated site, but the problem is clearly missing some data.

So i ask you, when i update the 1.5 version, can i move only some tables (order, customers and products) or i must necessary reconfigure themes and modules?

If so, what should i select tables?

Thank you for your help.

[musicmaster]

I am puzzled what you want:

 - you should check your theme to see whether it is compatible with the 1.6 version you want to move to.

 - be aware that in many ways there are more differences between 1.6.0 and 1.6.1 than between 1.5.x and 1.6.0. So be careful what version you move to.

 - when moving data always use Prestashop's autoupdate. With every version Prestashop makes some changes to its database. Usually it is just indexes, but occasionally there are more important changes. The transition to 1.6.1 brought major changes. 1.6.0.11 had also some new fields.

 

So the better procedure would be to update the shop you have and then to install there your new theme. That way you should have a shop with the same version and theme as your other shop. In that configuration you can copy all the modified files from that other shop.

[alberto.emanuele]

Hi musicmaster, i explain better

So, i have the sames prestashop versions,

In the first i have the default theme and 400 orders, 400 clients and 400 products

In the second i have another theme with more mod and more setting, with 200 orders, 200 clients and 200 products

 

I need to migrate the first database on the second Prestashop site, but if i migrate all database i lost the theme and the configuration.

 

But i think that i choose some tables (of the first site) for orders, clients and products and moves on the second site.

Isn't it?

Or i can take some tables of second site (like configuration, modules, theme etc.) and moves on the first site.

 

Can you tell me it's possibile and what tables i need to move?

 

Thanks a lot

[musicmaster]

Yes, you can copy those tables. 

 

I suggest you study my tool copy_shopdata (https://www.prestashop.com/forums/topic/445453-copy-shopdata-script-for-copying-shop-content-for-upgrade/). You can't use as you want to unite two shops instead of moving one, but it may give you some insight in the things involved.

 

There is a few catches:

 - the customer passwords. Those are encrypted with a key in your Settings.inc.php file. So when you unite those two shops the customers of one of the two shops will experience that their passwords no longer work and that they need to reset them.

 - obviously one of the two shops will have to adopt new product id's, customer id's and order id's. There are many other id's but there are the main ones. So you need to write some kind of script that takes these into account. As far as I know there isn't a script around so you will need to build a script yourself to do that. to make things easier you might choose to export and import products as CSV. You need to check for yourself whether that includes all your relevant information. Breaking the link between products and orders is no problem as the product-detail table contains the name of the products, so while the product id's no longer refer to the correct product that shouldn't be a problem. But I assume that you will want to keep the link between customers and their orders.