Jump to content

Options and combinations images - again... Rate Topic   - - - - -

 
  • sok777
  • Advanced Member
  • Members
  • Join Date: 23-Jun 11
  • 120 posts

Posted 29 July 2012 - 02:02 PM #1

Hello

in cs cart 3 you can add images for every product combination and thumbs of that images in product options variants...That is perfect!


But again comes a question is there any easy way to upload or import these images BESIDES MANUALLY????

 
  • johnbol1
  • Senior Member
  • Members
  • Join Date: 23-Feb 10
  • 2,516 posts

Posted 29 July 2012 - 05:00 PM #2

Sure...just go import/products/images, then upload the .csv you will have already created with the filepaths to your images.
(upload your images to your backup folder first)
The screenshot is for one of my products with 26 images.

John

edit! just realised you need option images .....sorry no dont think so although I think someone did it through the database one time.

Attached Thumbnails

  • Attached Image: image upload.JPG

www.hivis.co.uk the UK's online hivis safety marketplace

"Give me a man that tries and fails
than a man that never tries at all"

 
  • sok777
  • Advanced Member
  • Members
  • Join Date: 23-Jun 11
  • 120 posts

Posted 29 July 2012 - 09:24 PM #3

Hello John,

Do you remember how it was done via database? or may be thread link?

As I figured out the folllowing tables are involved for option thumbs:

cscart_images
cscart_images_links
cscart_product_option_variants
cscart_product_option_variants_descriptions (to see the variant id description)

but for combinations it is something else...

cscart_images
cscart_images_links
+++++

Can not believe people still doing it manually (imagine 2000 combinations....all with own photo....)

 
  • solesurvivor
  • Senior Member
  • Members
  • Join Date: 05-Aug 11
  • 744 posts

Posted 29 July 2012 - 11:12 PM #4

Just create a product with options and upload option combo images manually then go view the tables image_links and images to understand the logic and duplicate it in coding.

I have this all setup automatically with our erp i wrote a full product import script but don't have the code handy to tell you. If I remember and have time I'll try to pull a bit together this coming week when I get back to the office

 
  • johnbol1
  • Senior Member
  • Members
  • Join Date: 23-Feb 10
  • 2,516 posts

Posted 10 November 2012 - 02:54 PM #5

I am in need of this now too, 2900 products and at least 4 image variants for each, I am unsure of what to edit in my test database to get the images in there, can anyone give me some pointers

Thanks
John
www.hivis.co.uk the UK's online hivis safety marketplace

"Give me a man that tries and fails
than a man that never tries at all"