moving to 2.0.4

hi guys,



what is the best way to move upto the new version from 1.3.5?



do a fresh install and re-import the products, images, customers etc…?



Regards Craig

New Zealand

That’s what i did.

I installed the new Version 2.04

Than exported products from version 1.5.3 along wiht all the descriptions

Exported Version 2.04 products to see the structure and copy and paste from 1.5.3 tables to 2.04 conresponding tables.

Than imported back into 2.04

Same way with users tables.

Always back up!!!

Great zeero6, will give that a go…



we imported all of Zen Cart the same way. would be nice to get a clean fresh install also.



Craig

Yes, that is the safest way to upgrade. There are enough significant changes to v2.0 that trying to migrate items from old database tables to the new ones can be a headache (I speak from experience :expressionless: ).



If you have fairly heavily customized templates (as I do), you will need to make changes to them. Some of the files have been reorganized into different directories, and the Smarty code has changed here and there.

zeero6, would you mind writing a step by step guide on how to do this? I think that others would find it beneficial to know exactly what to do (like me).

These were my steps

This worked for me. May not work for everyone. I’m not an expert but it was fun doing it.

We only have 1000 products and it’s used only for Company and Franchise Purchasing. Not Public.



Installed version 2.04 in new directory called shop



Older version was on dir cart



My first step was to export users from Version 1.3.5



V. 2.04 - Imported users in Administration – Import data – users tab on right

All users and passwords worked.



Than exported products from version 1.3.5 along with all the descriptions.



Added a product to Version 2.04 than exported products from Administration – export data – products tab to see the structure.



Compared both and copy the tables from version 1.3.5 to corresponding tables in version 2.04 like Product code – Category and so on.



Than imported back to version 2.04 when all the fields matched.



By adding a product first you can tell also where the images are stored in version 2.04 and uploaded the images to that directory.



I did have to add some images manually since I did not have all my images in my backup folder since I was not using file system and wanted to use better images.



Also I exported Quantity discounts from 1.3.5 since I use different memberships and imported back to version 2.04 under Administration – import data – Qty discounts. Create the Memberships if you use this option.



After testing for a while and customizing did a temporary redirected from cart dir to go to shop directory, that way still have the old version as a backup. Eventually will move.



Always backup first

Awesome! Would you mind if this gets published elsewhere? Credit will be provided.

Not at all. Would be nice to see if anyone else has done it.

user import is working ok for me, but the rest is rather chaotic… discarding some info allowed my self to import products but customer order’s history wasn’t imported.



not good…

upgrade script seems to be out, it was working for me

[url]Ecommerce Solutions and Software for all types of business - CS-Cart

[quote name=‘zeero6’]…

Compared both and copy the tables from version 1.3.5 to corresponding tables in version 2.04 like Product code – Category and so on.

…[/quote]

Instead of comparing the data I feel more comfortable exporting both database schemas only (no data, using DB Backup/Restore feature) before I transfer the data itself.







Just used the upgrade scripts (my 2.0.4 was still fresh, not touched) but I had no luck. There are no categories on the frontpage. Products are in the new database but are not linked to categories. When clicking on a product in the admin, I get the following SQL statement error:


Database error: Unknown column 'exception_id' in 'order clause' (1054)
Invalid query: SELECT * FROM cscart_product_options_exceptions WHERE product_id = 1 ORDER BY exception_id

using the new upgrade script worked well for me. There are a few issues I have to resolve like a required checkout field for business or residential address but no field is displayed. I cannot get shipping same as billing to work but I’m working on it.

[quote name=‘rdr’]upgrade script seems to be out, it was working for me

[url]Ecommerce Solutions and Software for all types of business - CS-Cart



Is this site run by CS-Cart? I normally look for my files in the File Area at CS-Cart.com.

That site is run by me and the upgrade script was written by CS-Cart.



I just posted the info.

[quote name=‘ETInteractive’]That site is run by me and the upgrade script was written by CS-Cart.



I just posted the info.[/QUOTE]



Cool, thanks for that!

The update script made my new, corrupt DB 245 tables big. A fresh 2.0.4 install has 191. How come there’s this difference? Are you guys having the same amount?

[quote name=‘ETInteractive’]That site is run by me and the upgrade script was written by CS-Cart.



I just posted the info.[/QUOTE]



Thanks for the work. It did just fine and the upgrade took about 15 minutes.

I followed the instruction with the upgrade script and everything went ok, except no product, or other images are showing up. When I check where it calls the images from, it appears all the product images are renamed, so even if I move all my images over to that folder, I will still have to manually rename them all.



Is this how an upgrade is supposed to work?

What were the old names and what does the DB say is the new name?



Give several examples please.

[quote name=‘roban’]Thanks for the work. It did just fine and the upgrade took about 15 minutes.[/QUOTE]



It took me approx 8 hours :smiley: could not make 2.04 show images