1. CnP
  2. RO CSVI
  3. Sunday, 19 January 2020
  4.  Subscribe via email
Hello,

I exported these fields

picture_url
product_desc
product_url
product_sku
product_name
manufacturer_name
product_price

but CSVI exported the same image for all and there should be different images for each listing.

RO CSVI 7.14.0
VirtueMart 3.6.10 10211
Joomla! 3.9.14
Attachments (2)
Accepted Answer Pending Moderation
Hello,
The products you are exporting have images of their own? If RO CSVI does not find an image for a child product it will get the image of parent product on export for picture_url field. In your case the image images/virtuemart/product/10393.jpg is set for product_id which has 0 as virtuemart_product_id. Can you add file_url field to your export fields and run the export? Post the export file here to check.

You can also do VirtueMart Media export with product_sku and file_url field and send me the export file. I can check the product for which the image images/virtuemart/product/10393.jpg is set in database.
Kind regards,

Tharuna

=========================
If you use our extensions, 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
None of these have child products and all have their own images.
When you, for example, take the URL from row 9 from the sheet,

https://www.chromeandparts.com/universal/universal-wheels-accessories/universal-axle-covers/universal-front-axle-covers/dome-2-piece-front-axle-hub-hat-only

and click to show the image in a new tab, you will get

https://www.chromeandparts.com/images/virtuemart/product/10140.jpg

but in the sheet you have

https://www.chromeandparts.com/images/virtuemart/product/10393.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
Ok so we need to check why the image is not exported in your case. Can you do a VirtueMart media export and send me the export file? To do this you need to create a new export template with operation selected as Media. Add product_sku, file_url and file_mimetype as export template fields and run the export. Please post the export file here so i can check.
Kind regards,

Tharuna

=========================
If you use our extensions, 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 exported the whole products.
It seems to be ok. only 6 of the 10393 in it.
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
Thank you for the file, that helped to find the issue. The example product link you posted in your previous reply with SKU 10140 has an image for itself in the VirtueMart Media export file but file_mimetype field is empty for that image and that is creating issue with picture_url field in VirtueMart Product export. When selecting an image for picture_url RO CSVI runs a query which checks if it is an image by using condition if 'file_mimetype' = 'image/%'. That is done because VirtueMart stores other documents for a product in its media table. Since file_mimetype is empty, query does not select the actual product image and returns there is no image for the product and so RO CSVI looks for parent image. If the product 10140 has no parent then image selected for parent is for virtuemart_product_id as 0. As per your VirtueMart Media export file there are many images which do not have product_sku which means that virtuemart_product_id is 0 in database. Probably the first row in database with virtuemart_product_id as 0 is 10393.jpg and so that is used in export file. You need to save file_mimetype for the images to solve this problem.

Let me know if you need any more clarification.
Kind regards,

Tharuna

=========================
If you use our extensions, 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
Understand.
With
You need to save file_mimetype for the images to solve this problem
you mean I import the same images name under file_mimetype as the picture_url image name?
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello,
you mean I import the same images name under file_mimetype as the picture_url image name?

No i mean that you can import file_mimetype field for your images as image/png or image/jpeg or any other according to your image. You can do that using VirtueMart Media import by having file_url and file_mimetype fields. You can do an VirtueMart media export of these fields, update the export file and import the file.
Kind regards,

Tharuna

=========================
If you use our extensions, 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
So, in the file_mimetype should be the file ext of the image. For example if the images is .jpg the value in the file_mimetype should be image/jpg and not xxx.jpg or image/xxx.jpg?
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hello,
So, in the file_mimetype should be the file ext of the image.

Yes thats correct.

For example if the images is .jpg the value in the file_mimetype should be image/jpg and not xxx.jpg or image/xxx.jpg?

Yes you need to use image/jpg in file_mimetype field if images is .jpg.
Kind regards,

Tharuna

=========================
If you use our extensions, 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
What do I have to enable?

Under File:

Autodetect delimiters
Use file extension
I'm Mac
Use file for configuration
Add extra fields
Skip first line
Overwrite existing data
Skip new items
Skip empty custom fields

and under Process images Yes or No?
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Hello,

You don't really need to enter the mimetypes yourself, RO CSVI can read it from the file you are importing. All you need in your import file is the file_url.

As to what you need to enable, this is no different than all your other imports, you can leave the defaults unless you are doing something out of the defaults. Yes, the process images must be set to Yes otherwise nothing is done with the image.

If you wonder what these options all mean, there is a Help button in the top right corner of the page.

You may want to try it with 1 or 2 images first before you do them all.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Hi Roland,

so, I export the file_url first and then import them again?
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
Hello,
Yes export the file_url field and import it. RO CSVI will update the file_mimetype type on import.
Kind regards,

Tharuna

=========================
If you use our extensions, 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
Thank you.
I did import only the file_url, but I get errors on all.

Can you please check?

Thanks
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
Hello,

You do not have Process images enabled. It may have been missed in my message but I wrote:
Yes, the process images must be set to Yes otherwise nothing is done with the image.

This is the issue as far as I can see. Please enable that option and run the import again. Let us know how it goes.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 15
Accepted Answer Pending Moderation
Hello,

still not working.
Now I get

Skipped Notice Item images/stories/virtuemart/product/images/virtuemart/product/10011.jpg not added because ignore non-existing items enabled


and I do not see anything
non-existing items
field to disable.
  1. more than a month ago
  2. RO CSVI
  3. # 16
Accepted Answer Pending Moderation
Hello,
In your import template on File tab check if you have Skip new items field to Yes. If so change it to No, save the template and run the import again.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 17
Accepted Answer Pending Moderation
Hello and thank you again, but after successfully importing, still the same. Nothing updated.
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 18
Accepted Answer Pending Moderation
Hello,

The reason it fails is because RO CSVI is looking for the following image
The file /home/chromean/public_html/images/stories/virtuemart/product/images/stories/virtuemart/product/images/virtuemart/product/10011.jpg has not been found.
As you can see it has a double path, so it cannot find the file. Can you edit your template and set the Location product files to images/stories/virtuemart/product/ and then run the import again.

Let me know how it goes.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 19
Accepted Answer Pending Moderation
With

images/stories/virtuemart/product/


you mean the location of the images on the folder in my setup?

This would be
images/virtuemart/product/
as can seen in the excel sheet.
Or is this path you recommend something internal?
  1. more than a month ago
  2. RO CSVI
  3. # 20
  • Page :
  • 1
  • 2


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