1. soura123
  2. RO CSVI
  3. Thursday, 24 September 2020
  4.  Subscribe via email
i have an xml export for vm products
my products have stockable custom fileds plugin for creating child products
my issue is that after i change image on parent product on the export on childs exports the old image
how we can fix this please???
Accepted Answer Pending Moderation
Hello,
my issue is that after i change image on parent product on the export on childs exports the old image

If a product has its own image then that image is exported, parent product image is exported only when the child product does not have an image and that depends on the field you use for export. Getting a parent product image when child product does not have an image happens when you only use picture_url field in export.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
yes my child product dont have image so correctly must export the parent image
my field is the picture_url
the problem is that after i change the parent image csvi keep exportng the previous image on the childs
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
With picture_url field we select the first image of parent product as default. It is possible that your old parent product images are still in the database and that is selected with query. Did you replace the old images of parent product or you appended the images?
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
i replace the old image with a new one, on front end of site i see the new one but csvi exports the old one
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
i replace the old image with a new one,

Can i ask how you replaced the old image? Did you do it with VirtueMart or with RO CSVI import?


on front end of site i see the new one but csvi exports the old one

RO CSVI does not know if the image is old or new. All it does is run a query to fetch images from database and takes the first record and uses it in export. You can create a Media export template and add fields product_sku and file_url. Run the export and check if you see both old image and new image for the product.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
i replace it in vm not with csvi
i think this is a bug and i would like a fix please
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello,
i replace it in vm not with csvi

So i tested this, replacing a parent product image with VirtueMart replaces the old image and export gets the new image. I think in your case you have uploaded the new image and not replaced it. On backend for parent product how many images do you see? Can you share a screenshot?

i think this is a bug and i would like a fix please

There is no bug here. If you have old images still set for the product, you may need to remove them if not used or change the order of the new image and old image so new image takes the first in the order. You can do that from VirtueMart Products edit page and under Product Images tab.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
you are wrong about my case
i replace the image not upload it
here
http://prntscr.com/unqb32
this is the parent
here is the child on export
http://prntscr.com/unqbn9
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hello,
In that case i would like to see the data for your products. As i mentioned in my previous post can you do a Media export with product_sku, file_url and file_mimetype fields and send me the exported file?. Please also mention the product_sku of parent and child product so i can check in the export file. Also attach the export debug log of the VirtueMart product export. To get the debug log check How to collect debug information? document.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
i see on media export that it is correct
http://prntscr.com/unrqoa

https://www.e-agrogeoponiki.gr/media.xml
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
i did a simple save on the child products and on parent i export again, and it finally get export the replaced image
can you explain this?
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
yes double check
when i go to child and do a simple save
and export again only then take the replaced image of the parent product
can you please help through this?
as you understand i can t do save on every product just to export the correct file
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
Hello,
i see on media export that it is correct
http://prntscr.com/unrqoa

This is parent product, is that correct? What about child product row?

https://www.e-agrogeoponiki.gr/media.xml

This link shows the error that document is empty. I am not able to check the images.

i did a simple save on the child products and on parent i export again, and it finally get export the replaced image
can you explain this?

I looked into your debug log and that shows that the child product has an image. With picture_url field we first look for child product image and if that is not available we select the parent product image. In your case as per debug log child has an image and so parent product image is not selected.

yes double check
when i go to child and do a simple save
and export again only then take the replaced image of the parent product
can you please help through this?
as you understand i can t do save on every product just to export the correct file

Yes, i totally understand. So let us check what is stored for child product in the database. With child product query RO CSVI is getting a record and so it does not look for parent image. We need to check where that is coming from. Run the below query in PHPMyAdmin and see what you get for child product for which you did not do simple save. Replace XXX with virtuemart_product_id of child product and #__ with table prefix as per your database before running the query.


SELECT `file_url` FROM `#__virtuemart_medias` LEFT JOIN `#__virtuemart_product_medias` ON `#__virtuemart_product_medias`.`virtuemart_media_id` = `#__virtuemart_medias`.`virtuemart_media_id` WHERE `virtuemart_product_id` = XXX AND `file_mimetype` LIKE 'image/%' ORDER BY `#__virtuemart_product_medias`.`ordering`
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
first of all my childs product has no images
http://prntscr.com/uo55it

i did the sql query, i get this, which is wrong

http://prntscr.com/uo558b

any ideas?
  1. more than a month ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
my vm versions is VirtueMart 3.8.2 10325
any chance to be a VM bug?
  1. more than a month ago
  2. RO CSVI
  3. # 15
Accepted Answer Pending Moderation
Hello,
first of all my childs product has no images
http://prntscr.com/uo55it

This is as per VirtueMart product view page but we need to check what is in the database for child products.

i did the sql query, i get this, which is wrong

http://prntscr.com/uo558b

For some reason the query is fetching this record for export. We need to find why that is happening.

my vm versions is VirtueMart 3.8.2 10325
any chance to be a VM bug?

It looks like there are old records for your child product and that is used in export. Please run the below query and see how many records you see for child product. Replace XXX with virtuemart_product_id of child product and #__ with table prefix as per your database before running the query. Can you post a screenshot of what you see with the query?


SELECT `file_url`, `file_mimetype` FROM `#__virtuemart_medias` LEFT JOIN `#__virtuemart_product_medias` ON `#__virtuemart_product_medias`.`virtuemart_media_id` = `#__virtuemart_medias`.`virtuemart_media_id` WHERE `virtuemart_product_id` = XXX
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 16
Accepted Answer Pending Moderation
i run it
it the same result as before
http://prntscr.com/up260y
the wrong image again
  1. more than a month ago
  2. RO CSVI
  3. # 17
Accepted Answer Pending Moderation
i did a save on every chilld and this is fixed, because i couldn't wait
if this comes up again i will let you know
  1. more than a month ago
  2. RO CSVI
  3. # 18
Accepted Answer Pending Moderation
Hello,
That shows that there is only one image for that child product in database. Since the child product has its own image it does not use the parent product image. I am really not sure why VirtueMart shows the child product as no image. As per RO CSVI, what is in database is what exported to the file. You can write in VirtueMart forum to find out on why the view shows no image when there is actually an image for child product in database.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 19
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!