Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Importing Products from 2.2 to 2.3


jack_frost

Recommended Posts

Okay, so i've importet all my product from my older OsC version, the problem now is, that i have 1600+ items, where the picture is huuuge in the product_info page.

 

I know one fix for this problem, is to just add the same picture one more time under "Add Large Image" for all the items.

 

however. this will take about 26 hours, so i hoped there was a way of fixing this, without that very long work process.

 

Thanks in advance!

 

- Jack

Link to comment
Share on other sites

I accidentally put this post in the 3.x part of the forum, sorry, the version im running is 2.3.1

 

Use phpmyadmin to copy the value of the main products_image (and product id) to the new products_image table.

Would take 5 seconds to update 1600 items.

 

Hello and thanks for the reply!

 

The OsC 2.2 does not have a databsae called Products_image - i think its incorperated in the Product_description database.

 

Can i extract it somehow?

 

@ToyIcebear: I am not sure what you mean?

Link to comment
Share on other sites

You make a line of SQL that copies the values from 1 DB table/row into the other DB table.

Run it in phpmyadmin.

 

It probably already exists (or you will find instructions) if you search Google.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...