Copying customers & products from 13.8a to 1.5

My site 1.3.8a has so many extensions and stuff - and isnt working at all properly now the seo urls is causing all kinds of crawling errors.

Ive decided its easier to fresh install and copy all my products over manually.. or is there an easier way to copy products from 1.3.8a to 1.5?

Also i need to copy customers accross (including their passwords) which is something id have to have a script to do i think because all the passwords are encrypted

So how can i copy all customers (not too worried about orders) and products from 1.3.8a to 1.5

I could copy the products manually (about 200) via copy and paste.. just a days work.. but the customers ive got thousands im not sure what to do

creamcrackers:

My site 1.3.8a has so many extensions and stuff - and isnt working at all properly now the seo urls is causing all kinds of crawling errors.

Ive decided its easier to fresh install and copy all my products over manually.. or is there an easier way to copy products from 1.3.8a to 1.5?

Also i need to copy customers accross (including their passwords) which is something id have to have a script to do i think because all the passwords are encrypted

So how can i copy all customers (not too worried about orders) and products from 1.3.8a to 1.5

I could copy the products manually (about 200) via copy and paste.. just a days work.. but the customers ive got thousands im not sure what to do
By following the upgrade FAQs.. Short of re-posting these steps verbatim, you should read the FAQs and give it a try..

How do I upgrade my site?: https://www.zen-cart.com/tutorials/index.php?article=98
How do I Upgrade My Zen Cart site?: https://www.zen-cart.com/tutorials/index.php?article=108

Plus if you look through this topic: http://www.zen-cart.com/forum/forumdisplay.php?f=156, there's a TON of posts answering upgrade questions.. A little research will go a long way to preparing you..

Following these steps, I JUST did a 1.3.8 to 1.5 upgrade not more than 10 minutes ago.. All orders, customers, and products preserved..

DivaVocals:

By following the upgrade FAQs.. Short of re-posting these steps verbatim, you should read the FAQs and give it a try..

How do I upgrade my site?: https://www.zen-cart.com/tutorials/index.php?article=98
How do I Upgrade My Zen Cart site?: https://www.zen-cart.com/tutorials/index.php?article=108

Plus if you look through this topic: http://www.zen-cart.com/forum/forumdisplay.php?f=156, there's a TON of posts answering upgrade questions.. A little research will go a long way to preparing you..

Following these steps, I JUST did a 1.3.8 to 1.5 upgrade not more than 10 minutes ago.. All orders, customers, and products preserved..

Thanks, but as i stated my zen cart is broken.. its not working properly. Its kind of evolved over about 5 years.. and at the beginning i really had no idea what i was doing...

So.. please dont complain i should have done this i should have done that.. point it the site needs to be totally rebuild. The files are screwed and it would take me months to work out which files were changed to what.

I spent nearly a month trying to upgrade 1.38 to 1.39. I had loads of problems because the databse collation was diffeernt etc

So really... i think its best just to make the site again. Its been constantly upgraded and i think the best thing to start again

But i really need my customers logins transferred!!!!

To make it more complicated my site is on php 5.2 something, and its not high enough for ZC1.5 and i tried updating the server to higher php but then my existing ZC doesnt work

So its like a catch 22... i cant put 1.5 on the current server and if i upgrade php now.. then the current site wont work. So im stuffed !!!

Perhaps what i should have asked

I have a ZC1.38a site

Theres something wrong with it, i was using simple seo url and its not working at all properly now.

I need to upgrade also for security

So - using my 1.3.8 database... forgetting the files which are f**ed how can i get a 1.5 site. I dont mind manually putting add-ons in it again, acutally id prefer that because i want to use different ones now as the ones i had dont work with 1.5 anyway!!!

what can i do?

Is there someone i can pay to do for me?

it literally cost me over $10k in lost sales plus more than one months work trying to upgrade to 1.3.9 then when i finally.. nearly got it - they changed to 1.5

Im tearing my hair out here

Im just a flower selling not a programmer what should i do?

Goodness..:shocking:

Seriously read through the links I posted.. I PROMISE that they really are going to get you through this.. Running the upgrade WILL upgrade your database (your primary concern based on your original post).. File upgrades are a MANUAL process..

So if you wanted to start over, you could UPGRADE by copying the v1.5 files to your site, copying over your configure.php files, copying your database, and then running the install so you can UPGRADE your database.. (and this is covered in ONE of those links I posted)

Since you don't meet the minimum install requirements for v1.5 you can ONLY upgrade to v1.3.9.

DivaVocals:

Goodness..:shocking:

Seriously read through the links I posted.. I PROMISE that they really are going to get you through this.. Running the upgrade WILL upgrade your database (your primary concern based on your original post).. File upgrades are a MANUAL process..

So if you wanted to start over, you could UPGRADE by copying the v1.5 files to your site, copying over your configure.php files, copying your database, and then running the install so you can UPGRADE your database.. (and this is covered in ONE of those links I posted)

Since you don't meet the minimum install requirements for v1.5 you can ONLY upgrade to v1.3.9.

Im doing it now... i just upgraded the php to 5.2.1.7 which seems to be compatible with ZC1.3 and 1.5. I hosted the mysql server remotely to get around the mysql problem for the 2 different versions needing different mysql versions (i think?)

See what happens will post update for benefit of others..

I really wish this was like wordpress where you click "update" and all is done for you, on the other hand wordpress gets hacked all the time.

The biggest problem i have had, apart from worrying about security on 1.3.8a is that ZC created a load of dead links. I though this was just due to simple seo url mod but when turned off they were still there

The problem was that DELETED products were still linked to.. the links were showing up in the forward and back buttons when looking at products and also in the "whats new" showing at the bottom of a product listing.. for the various categories.

That was causing crawl errors with google bot which suddently went from about 200 404 errors to about 5,000 when i deleted the products... and that knocked my serps down about 5 places for my main keywords

So not knowing WTF was wrong my idea was just to rebuild the whole site.. but now i understand i cant just copy the customers accross so ill have to hope this works...:(

the minimum for ZC 1.5 is listed as 5.2.14. You can ONLY upgrade to v1.3.9h..

creamcrackers:

Im doing it now... i just upgraded the php to 5.2.1.7 which seems to be compatible with ZC1.3 and 1.5. I hosted the mysql server remotely to get around the mysql problem for the 2 different versions needing different mysql versions (i think?)

See what happens will post update for benefit of others..

I really wish this was like wordpress where you click "update" and all is done for you, on the other hand wordpress gets hacked all the time.

The biggest problem i have had, apart from worrying about security on 1.3.8a is that ZC created a load of dead links. I though this was just due to simple seo url mod but when turned off they were still there

The problem was that DELETED products were still linked to.. the links were showing up in the forward and back buttons when looking at products and also in the "whats new" showing at the bottom of a product listing.. for the various categories.

That was causing crawl errors with google bot which suddently went from about 200 404 errors to about 5,000 when i deleted the products... and that knocked my serps down about 5 places for my main keywords

So not knowing WTF was wrong my idea was just to rebuild the whole site.. but now i understand i cant just copy the customers accross so ill have to hope this works...:(

DivaVocals:

the minimum for ZC 1.5 is listed as 5.2.14. You can ONLY upgrade to v1.3.9h..

What? The minimum for 1.5 is 5.2.14 ... ive got 5.2.17 thats above 5.2.14 and it seems to be running 1.38 ok.. and im at the install screen for 1.5 and its all green ticks...

I think you misread what i posted?

Or are you saying i CANT upgrade 1.38a to 1.5 at all? i first need to upgrade to 1.39?

You didn't say you had 5.2.17, you said you had 5.2.1.7 (see post #8 above.) If you really do have 5.2.17, keep going. You're fine.

Rob

creamcrackers:

What? The minimum for 1.5 is 5.2.14 ... ive got 5.2.17 thats above 5.2.14 and it seems to be running 1.38 ok.. and im at the install screen for 1.5 and its all green ticks...

I think you misread what i posted?

Didn't misread anything.. Like Rob said, see what you posted..

creamcrackers:

Im doing it now...** i just upgraded the php to 5.2.1.7 which seems to be compatible with ZC1.3 and 1.5.** I hosted the mysql server remotely to get around the mysql problem for the 2 different versions needing different mysql versions (i think?)