Jump to content

Migrating data from a prestashop 1.4 database to prestashop 1.6 database


Recommended Posts

Hi,

 

I recently began developing a new website from scratch on my localhost to replace my aging live website. I was wondering if their was a method to take all of the existing data from my prestashop 1.4 SQL database and more or less transplant it into my new 1.6 SQL database. I understand this can be done through CSV imports but i continually run into errors stating "cannot be saved" using this. I assume that between 1.4 and 1.6 the table structure for the database has changed a bit as well.

Link to comment
Share on other sites

Yes, the database is little different, you can use the module 1-Click Upgrade and...

1. Update to the latest version of PS 1.4

2. Update to firs stable version of PS 1.5

3. Update to latest stable version of PS 1.5

4. Update to firs stable version of PS 1.6

5. Update to latest stable version of PS 1.6

Link to comment
Share on other sites

Hi Rolige,

 

this mean  "to do all the steps, one after the other"?

 

First the 1-click upgrade from 1.4.7 to the  latest version of PS 1.4

then the 1-click upgrade to the  firs stable version of PS 1.5

then the 1-click upgrade to the  latest stable version of PS 1.5

and so on...

 

Thanks

Link to comment
Share on other sites

Yes, the database is little different, you can use the module 1-Click Upgrade and...

1. Update to the latest version of PS 1.4

2. Update to firs stable version of PS 1.5

3. Update to latest stable version of PS 1.5

4. Update to firs stable version of PS 1.6

5. Update to latest stable version of PS 1.6

 

It makes NO SENSE !

If 1 click upgrade is available in your PS 1.4 version, just update to the latest 1.6 version. 

If not, then upgrade to the latest 1.4 version then to the latest 1.6 version.

I already did this thousand times

Link to comment
Share on other sites

Hi Rolige,

 

this mean  "to do all the steps, one after the other"?

 

First the 1-click upgrade from 1.4.7 to the  latest version of PS 1.4

then the 1-click upgrade to the  firs stable version of PS 1.5

then the 1-click upgrade to the  latest stable version of PS 1.5

and so on...

 

Thanks

Exactly

 

 

It makes NO SENSE !

If 1 click upgrade is available in your PS 1.4 version, just update to the latest 1.6 version. 

If not, then upgrade to the latest 1.4 version then to the latest 1.6 version.

I already did this thousand times

Ok, do you have experience doing this before?

Link to comment
Share on other sites

Of course

 

I use PrestaShop since version 1.1.0.5 (2009), and made many, many, many update for 8 years now.
Before the 1 click upgdate module appeared, updates were made manualy, but when it appeared (PS 1.4.x), you can update directly to the latest versions. Modifications made to the database are sequentialy made (look at the sql folder in the installation folder). So really no need to to PS 1.4 -> PS 1.5.0 -> 1.5.6.3 -> PS 1.6.0 -> PS 1.6.1.10

 

You can even update PS 1.1.0.5 manually to 1.4.11 and then use 1-click module to update to 1.6.1.10. In just two steps :)

Link to comment
Share on other sites

Prestashop you can manually upgrade from 1.1. to 1.4 After this you should use necessarily the 1-click upgrade module.

 

Before you upgrade 1.4. to 1.5. with the upgrading module you should:

 

1) Deinstall non native theme and use the native one during upgrade.

2) Deactivate all non native tools/addons/modules.

 

After upgrade to 1.5./1.6 (if you are making an upgrade directly to latest 1.6. version), activate one by one the extras (non natives) and check if they are working. 99,99% possibly not the case, cause the structure from Prestashop changed with 1.5. and now hooks are used.

 

PS: as your added topic has nothing to do with SEO, I'm moving it to the correct forum section. ;)

  • Like 1
Link to comment
Share on other sites

Hi all,

 

Thanks for all the responses on the topic. I havent had a chance to do any of the suggested steps yet but ill be sure to try them. I used the 1 click upgrade initially going from 1.4 to 1.6 without disabling my custom theme or modules and it lead to a rather broken store so i rolled it back and went with a new approach of building a store from scratch. Ill post again when ive gone through everything will my results.

Link to comment
Share on other sites

  • 2 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...