Question about importing with images URLs

[shimony]

Hi,

 

I am using PS 1.4.4.0.

I am using the default import tool with CSV files and i am putting multiple images URLs.

 

Everything works great!, only none of the images is set as cover and i need to do it manually after the import.

Is there a way to set a cover bit or something? shouldn't it automatically set the first image as cover?

The import i am doing is for new products.

 

Thank you.

[phrasespot]

none of the images is set as cover and i need to do it manually after the import.

UPDATE `PREFIX_image` SET `cover`=1 WHERE `position`=1

Backup first.

[shimony]

Thanks, but im not sure on which file should i update this.

 

Also, is it possible to set it with SQL script? i mean, is there a record for it in the DB? which table?

 

Thank you,

Eyal.

[shimony]

Never mind - i did it with SQL:

 

UPDATE `DBNAME`.`ps_image` SET `cover` = '1' WHERE `ps_image`.`id_product` =PROD_ID AND `ps_image`.`position` =1 LIMIT 1 ;

 

Works great!