Resolved Image not published

Hello,

I would like to see the debug log of the import of an image that is not published but does exist. This should tell us why CSVI thinks the file does not exist.

HI RolanD
Look at product code 965827

com_csvi.log.477.zip

Hello,

Product code 965827 is not in the debug log, only the first 20 records are logged. Can you run an import with just that product? I do see for other images that they are reported as do not exist but not sure if that is related.

If I run just 965827 product, it publishes the image.
So, I changed log and send again to you the full log
You cam check again product 965827 (the image has the same name)
As the file is bigger then the forum allows, I send it to you by we transfer.

Hello,

So I checked the log for product 965827 and see this for the image on line 451

UPDATE `xxx_virtuemart_medias` SET `virtuemart_vendor_id`='1',`file_title`='965827.jpg',`file_description`='965827.jpg',`file_meta`='965827.jpg',`file_class`='',`file_mimetype`='image/jpeg',`file_type`='product',`file_url`='images/virtuemart/product/965827.jpg',`file_url_thumb`='images/virtuemart/product/965827.jpg',`file_is_product_image`='1',`file_is_downloadable`='0',`file_is_forSale`='0',`file_params`='',`file_lang`='',`shared`='0',`published`='1',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='0000-00-00 00:00:00',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_media_id` = '7245'

This shows us that the published field has a value of 1, so it is set to published.

Later on in the log we find the same file being updated for a product with SKU 7F864827D on line 2455 and again on line 2460. This time it is different, look at line 2460:

UPDATE `xxx_virtuemart_medias` SET `virtuemart_vendor_id`='1',`file_title`='965827.jpg',`file_description`='965827.jpg',`file_meta`='965827.jpg',`file_class`='',`file_mimetype`='image/jpeg',`file_type`='product',`file_url`='images/virtuemart/product/965827.jpg',`file_url_thumb`='images/virtuemart/product/965827.jpg',`file_is_product_image`='1',`file_is_downloadable`='0',`file_is_forSale`='0',`file_params`='',`file_lang`='',`shared`='0',`published`='0',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='0000-00-00 00:00:00',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_media_id` = '7245'

This time published is set to 0, that is why you see the image as unpublished. Same happens on line 3492, 3501, and 3532.

So you will need to publish these other products as well if you want the image published. Another option is to change the order in your import file where you place the unpublished products first and after that the published ones. So the published ones will not be unpublished later on.

Yes, there are some images that belongs to several products…

Run just published ones and Works fine.
My solutions is to import two different templates:
One with published products
Other with unpublished products, but just product_sku and published fields; so, if you need to published it again, the image is still there.
Thank you!

Hello,

Yes, that is another solution as well