Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

moving to 2.0.4 Rate Topic   - - - - -

 
  • Darius
  • Douchebag
  • Members
  • Join Date: 20-Apr 08
  • 3313 posts

Posted 16 June 2009 - 06:14 PM #21

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?


Not sure why products do not show up, for me they do. However I had also a problem with images.

I have exported images from my live store with SP3,

Edit exported csv the order of the columns should look like this (Product code; Detailed image (with full path to image); Pair type) thumbnails are not required, server will generate them.

 
  • awolff
  • Junior Member
  • Members
  • Join Date: 07-Sep 08
  • 4 posts

Posted 16 June 2009 - 08:29 PM #22

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

Give several examples please.


Well, there seems to be no relationship at all. Here are some examples:

Example 1

version 1.3.5 : shows:
/images/detailed_images/2356.jpg (normal image)
/images/product_images/thumbnail_2356.jpg (thumbnail).
My product item number is 2356.

version 2.04 (after upgrade)
images/detailed/product_detailed_image_250.jpg
/images/product/product_image_250.jpg (thumbnail).

The above two are from the same product.

Example 2

version 1.3.5 : shows:
/images/detailed_images/2199.jpg
/images/product_images/thumbnail_2199.jpg

version 2.04
/images/detailed/product_detailed_image_111.jpg
/images/product/product_image_111.jpg

It appears the new image in 2.04 is named after the product id, whereas in v 1.3.5 the name is what I originally assigned to the product (the product code), but there is no sign of the image.

Also, any additional images are simply gone.

 
  • TonyK
  • Member
  • Members
  • Join Date: 03-Mar 06
  • 1686 posts

Posted 17 June 2009 - 08:21 PM #23

I believe the upgrade says you have to be on 1.3.5 sp4.
Pimpin' skins since v1.0

 
  • Darius
  • Douchebag
  • Members
  • Join Date: 20-Apr 08
  • 3313 posts

Posted 18 June 2009 - 05:19 AM #24

I got more additional images then I should (most are correct, but some are non existing). How to remove all images so I can make a clear import ?

 
  • awolff
  • Junior Member
  • Members
  • Join Date: 07-Sep 08
  • 4 posts

Posted 18 June 2009 - 08:11 AM #25

I believe the upgrade says you have to be on 1.3.5 sp4.


The upgrade was done from 1.3.5 sp4. I realized the upgrade script does not work with sp3.

 
  • Darius
  • Douchebag
  • Members
  • Join Date: 20-Apr 08
  • 3313 posts

Posted 18 June 2009 - 08:29 AM #26

The upgrade was done from 1.3.5 sp4. I realized the upgrade script does not work with sp3.


After you move images from file system to db, do upgrade script, image names are renamed.

 
  • Eddy
  • Member
  • Members
  • Join Date: 08-Nov 07
  • 37 posts

Posted 18 June 2009 - 08:36 PM #27

I tried to export from v1.35sp4 to file and then import to cs 2.04
The name, description, meta... is ok but I cannot import the Images to cs2.04

Now my new shop (cs2.04) with full info but no product images

Does anyone have the experience or trick to do that?

 
  • craiglove
  • Junior Member
  • Members
  • Join Date: 22-Nov 08
  • 21 posts

Posted 20 June 2009 - 10:37 PM #28

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


would be nice to get the 2.04 version running in its virgin form first.. cant even see the install folder index.php

 
  • duneraver
  • Member
  • Members
  • Join Date: 29-Mar 08
  • 74 posts

Posted 21 June 2009 - 07:04 PM #29

Please read the instruction below carefully to proceed with upgrading your CS-Cart 1.3.5 .


Important note!

This script will update your CS-Cart v 1.3.5 sp4 up to CS-Cart v 2.0.4 and this will entail the following:

1) Addon settings will not be saved.

2) All modifications made on CS-Cart v 1.3.5 sp4 will not be transferred to CS-Cart v 2.0.

3) Not all Condition rules will be transferred from CS-Cart v 1.3.5 sp4 to CS-Cart v 2.0. Therefore promotions may intersect with each other.

4) There will be only those sideboxes specified in Listmania of CS-Cart v 1.3.5 sp4 and four more (Categories, My account, Mailing list, Information)

5) The "Basic" skin will be used for the admin panel and the skin defined during the installation of CS-Cart v 2.0 will be used for the storefront.

6) All images which were stored in the database will be transferred to the file system.

7) Manufacturers will be related to product features.

8) Topics will be moved to Pages.

9) Links in Top Quick Links will have the same values as before.



Upgrade steps.

1) Log in to the admin panel of CS-Cart version 1.3.5 sp4 which needs upgrading.

1.1) If it is specified in the settings that images are stored in the file system:
Ã*) Go to the "Settings" page (http://[YOUR-SHOP-CA...arget=settings).
b) Select the "Database" value for Images location.
c) Click "Update" to move images to the database.

2) Go to the "DB Backup/Restore" page (http://[YOUR-SHOP-CA...arget=database).

3) Specify the file name for dump - "dump_135_sp4.sql" and make the full dump of the database (all the tables) without any archivation.

4) Install the CS-Cart version NO LESS THAN 2.0.4 to a different web folder on your server.

5) Copy the following files to the root folder where CS-Cart version 2.0.4 is installed:
do_upgrade.php,
change_structure.sql,
update_descriptions.sql,
update_vars.sql.

6) Copy the CS-Cart 1.3.5 database dump created in point 3 of this instruction to the folder where CS-Cart version 2.0.4 is installed.

7) Launch the "do_upgrade.php" script.

After the "OK" text is displayed, the upgrade is considered complete and you can open the store. It is necessary to delete the following files after the upgrade is finished:
do_upgrade.php,
change_structure.sql,
update_descriptions.sql,
update_vars.sql.


Thank you for choosing CS-Cart

 
  • Darius
  • Douchebag
  • Members
  • Join Date: 20-Apr 08
  • 3313 posts

Posted 22 June 2009 - 04:34 AM #30

I tried to export from v1.35sp4 to file and then import to cs 2.04
The name, description, meta... is ok but I cannot import the Images to cs2.04

Now my new shop (cs2.04) with full info but no product images

Does anyone have the experience or trick to do that?


You need to edit cvs before import.

Columns should be arranged: code detailed image pair
In sp4 they are named differently so make sure everything is as in 2.04.

 
  • Eddy
  • Member
  • Members
  • Join Date: 08-Nov 07
  • 37 posts

Posted 22 June 2009 - 01:52 PM #31

Please read the instruction below carefully to proceed with upgrading your CS-Cart 1.3.5 .


Important note!

This script will update your CS-Cart v 1.3.5 sp4 up to CS-Cart v 2.0.4 and this will entail the following:

1) Addon settings will not be saved.

2) All modifications made on CS-Cart v 1.3.5 sp4 will not be transferred to CS-Cart v 2.0.

3) Not all Condition rules will be transferred from CS-Cart v 1.3.5 sp4 to CS-Cart v 2.0. Therefore promotions may intersect with each other.

4) There will be only those sideboxes specified in Listmania of CS-Cart v 1.3.5 sp4 and four more (Categories, My account, Mailing list, Information)

5) The "Basic" skin will be used for the admin panel and the skin defined during the installation of CS-Cart v 2.0 will be used for the storefront.

6) All images which were stored in the database will be transferred to the file system.

7) Manufacturers will be related to product features.

8) Topics will be moved to Pages.

9) Links in Top Quick Links will have the same values as before.



Upgrade steps.

1) Log in to the admin panel of CS-Cart version 1.3.5 sp4 which needs upgrading.

1.1) If it is specified in the settings that images are stored in the file system:
Ã*) Go to the "Settings" page (http://[YOUR-SHOP-CA...arget=settings).
b) Select the "Database" value for Images location.
c) Click "Update" to move images to the database.

2) Go to the "DB Backup/Restore" page (http://[YOUR-SHOP-CA...arget=database).

3) Specify the file name for dump - "dump_135_sp4.sql" and make the full dump of the database (all the tables) without any archivation.

4) Install the CS-Cart version NO LESS THAN 2.0.4 to a different web folder on your server.

5) Copy the following files to the root folder where CS-Cart version 2.0.4 is installed:
do_upgrade.php,
change_structure.sql,
update_descriptions.sql,
update_vars.sql.

6) Copy the CS-Cart 1.3.5 database dump created in point 3 of this instruction to the folder where CS-Cart version 2.0.4 is installed.

7) Launch the "do_upgrade.php" script.

After the "OK" text is displayed, the upgrade is considered complete and you can open the store. It is necessary to delete the following files after the upgrade is finished:
do_upgrade.php,
change_structure.sql,
update_descriptions.sql,
update_vars.sql.


Thank you for choosing CS-Cart


Where can I have the files:

do_upgrade.php,
change_structure.sql,
update_descriptions.sql,
update_vars.sql.

 
  • duneraver
  • Member
  • Members
  • Join Date: 29-Mar 08
  • 74 posts

Posted 22 June 2009 - 04:55 PM #32

www.babyschoentjes.eu/dbupgrade135_20.zip

 
  • wisdomci
  • Junior Member
  • Members
  • Join Date: 13-Jan 08
  • 20 posts

Posted 24 June 2009 - 07:40 AM #33

Please can you explain further and probably show the step?

Thanks

You need to edit cvs before import.

Columns should be arranged: code detailed image pair
In sp4 they are named differently so make sure everything is as in 2.04.


WisdomCI

 
  • Darius
  • Douchebag
  • Members
  • Join Date: 20-Apr 08
  • 3313 posts

Posted 24 June 2009 - 08:46 AM #34

Please can you explain further and probably show the step?

Thanks


Your should open exported csv file with program like excell from MS office. Or find some other free csv editor via google.

Your modified file columns should look like in picture, how columns are arranged is most important thing. Thumbnails column can be deleted. Make sure to specify full correct path where your detailed images (better have them in some images/backup/"detailedimages" folder) are located, I used find replace tool to correct paths as they were different from 135SP3

In import process cs-cart will copy pictures from (images/bacup/"detailedimages") to "images/detailed" and automatically generate thumbnails for them. That is why you also need to set thumbnail image size here prior import

admin.php?dispatch=settings.manage§ion_id=Thumbnails

 
  • CutRiteFX
  • Senior Member
  • Members
  • Join Date: 02-Jun 08
  • 431 posts

Posted 24 June 2009 - 06:17 PM #35

I just exported and then imported. I have all the products and users. But had to recreate ALL of the OPTIONS for the products.

The problem I have is when I imported all of the sales. They do not line up with the products. It shows the sale and amount but there is no link for the product they bought in the invoice.


Should I start over and use this type of upgrade you guys are using?

And where is the official script to upgrade already.

CS-Cart 4.7.4


 
  • jobosales
  • Senior Member
  • Members
  • Join Date: 04-Nov 06
  • 3114 posts

Posted 24 June 2009 - 09:38 PM #36

I also had a problem importing Order Items into 2.0.4 from a 1.3.5-sp4 export. Like you, the orders imported fine but order items failed apparently due to mismatches between the products.

Bob
CS-Cart 2.0.14 (testing)

 
  • Eddy
  • Member
  • Members
  • Join Date: 08-Nov 07
  • 37 posts

Posted 25 June 2009 - 08:43 PM #37

I tried to import but it doesn't seem ok

Wow, I have to re-upload all my pictures for the products.

Anyone can make Sort by: Default by the added date (Time stamp)

In the home page, I add the block for newest products and set Last days as 5 day but I think it doesn't work well

I don't know why?

 
  • Mike_EG
  • Junior Member
  • Members
  • Join Date: 22-Oct 08
  • 18 posts

Posted 25 June 2009 - 10:05 PM #38

looks like cs-cart doesn´t care about old users .. just new clients can have the benifit of cs-cart 2.0 ...

i think cs-cart team should give us a way to upgrade .. everybody is loosing days .. trying to figure out ways to upgrade .. i already lost days .. with no sucess ..

scripts doesn´t work .. no explications .. no tutorial ...

in my opinion if you release a new version .. you need to offer a upgrade manual or script .. and support for that ..

i´m getting tired of trying .. almost giving up ..

Mike

 
  • pheritage
  • Junior Member
  • Members
  • Join Date: 19-Sep 06
  • 34 posts

Posted 27 June 2009 - 04:14 PM #39

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


Did you get any resolution to this?

I have the same issue and I can't go down the route that other people suggest of export/import because I have 100's of products with multiple listmania links to other products. It would take many many days to import the products and then add all the links that are in my current store.

Paul.

 
  • dragondf
  • Senior Member
  • Members
  • Join Date: 02-Nov 07
  • 211 posts

Posted 28 June 2009 - 12:36 AM #40

Please read the instruction below carefully to proceed with upgrading your CS-Cart 1.3.5 .


Important note!

This script will update your CS-Cart v 1.3.5 sp4 up to CS-Cart v 2.0.4 and this will entail the following:

1) Addon settings will not be saved.

2) All modifications made on CS-Cart v 1.3.5 sp4 will not be transferred to CS-Cart v 2.0.

3) Not all Condition rules will be transferred from CS-Cart v 1.3.5 sp4 to CS-Cart v 2.0. Therefore promotions may intersect with each other.

4) There will be only those sideboxes specified in Listmania of CS-Cart v 1.3.5 sp4 and four more (Categories, My account, Mailing list, Information)

5) The "Basic" skin will be used for the admin panel and the skin defined during the installation of CS-Cart v 2.0 will be used for the storefront.

6) All images which were stored in the database will be transferred to the file system.

7) Manufacturers will be related to product features.

8) Topics will be moved to Pages.

9) Links in Top Quick Links will have the same values as before.



Upgrade steps.

1) Log in to the admin panel of CS-Cart version 1.3.5 sp4 which needs upgrading.

1.1) If it is specified in the settings that images are stored in the file system:
Ã*) Go to the "Settings" page (http://[YOUR-SHOP-CA...arget=settings).
b) Select the "Database" value for Images location.
c) Click "Update" to move images to the database.

2) Go to the "DB Backup/Restore" page (http://[YOUR-SHOP-CA...arget=database).

3) Specify the file name for dump - "dump_135_sp4.sql" and make the full dump of the database (all the tables) without any archivation.

4) Install the CS-Cart version NO LESS THAN 2.0.4 to a different web folder on your server.

5) Copy the following files to the root folder where CS-Cart version 2.0.4 is installed:
do_upgrade.php,
change_structure.sql,
update_descriptions.sql,
update_vars.sql.

6) Copy the CS-Cart 1.3.5 database dump created in point 3 of this instruction to the folder where CS-Cart version 2.0.4 is installed.

7) Launch the "do_upgrade.php" script.

After the "OK" text is displayed, the upgrade is considered complete and you can open the store. It is necessary to delete the following files after the upgrade is finished:
do_upgrade.php,
change_structure.sql,
update_descriptions.sql,
update_vars.sql.


Thank you for choosing CS-Cart



HELLO PEOPLE!

Well, I am having a BIG PROBLEM to migrate from my CS-CART version (1.3.2) to the new version (2.0).

In your cases, 1.3.5 has a different database structure from my version (1.3.2).
So, in my case, your script (I think) will not work. Am I right?


What I am trying to do is to export some tables like PRODUCTS and USERS (the biggers) to MS EXCEL and migrate the by hand to the new database called products in 2.0 version.
I really don't know if this will work, but I will post later if I have problems.

I have another doubt about IMAGES.
How can I migrate them? Or is this not possible?



Maybe someone else is having the same problem then me. Maybe we could find a good way to do the migration.


Thanks!
Have a nice day!