1. piosaliani
  2. RO CSVI
  3. Wednesday, 09 May 2018
  4.  Subscribe via email
Hello,
I already have 367 products in virtuemart.
I have to import another 350 products.
The categories are already present in virtuemart.
I configure the template to export the products in csv, following the example of the demo.
I add the following fields:

virtuemart_product_id
product_sku
product_name
product_desc
product_price
category_path
FILE_URL
published
product_in_stock
product_parent_id
custom_title
custom_value

I open the csv file with Notepad ++, I copy the last line and I paste it immediately after, I change virtuemart_product_id (from 603 to 604) and the product_sku.

I create the template for the import, I configure it following the example of the demo, inserting "virtuemart_product_id" in "Import based on", I insert the same fields of the template for the export, I import the file, the import goes successful.

The product is not seen on the site, and I do not even see it in the back-end.

Prices have disappeared in the front-end (the "call for price" button appears)

I open the MySql database and I see that the record has been added to the "virtuemart_products_it_it" table. No records have been added to the "virtuemart_products" table.

Do I have to create other templates to add all the products correctly?

Thanks
Pio
Accepted Answer Pending Moderation
Hello Pio,

Since you had troubles importing before, it is recommended to delete existing products in VirtueMart, so you are sure the import is clean.
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. # 1
Accepted Answer Pending Moderation
Thank you so much Tharuna,
you're the best in assistance.
Do you recommend to delete all products in virtuemart before importing?

Thank you
Pio
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello Pio,
There is a problem with your import file. If you check for product with SKU B_202_POL_CH_V1, the child product entries B_202_POL_CH_V1_57 and B_202_POL_CH_V1_58 are duplicated which in turn creates two extra rows in database and has caused the whole confusion with stockable custom fields entries. You need to remove these duplicates and correct the parent product custom_title and custom_value fields and run the import again. Your issue should be fixed after that.
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
Hi tharuna,
I uploaded the file ArtExpWeb.csv, but on the site lnx.cappelleriaartigianale.it, some child products are not imported.
If you search on the site the product with product_sku "BT680_V_UNI", http://lnx.cappelleriaartigianale.it/index.php/uomo/uomo-invernale/berretto-tessuto/berretto-city-dis-5526-5147-detail, the child product with product_sku "BT680_V_UNI_59" (the child product "Size 59" see attachment size59.jpg) is not present.
The parent product with product_sku "BT682_V4" on the site, http://lnx.cappelleriaartigianale.it/index.php/uomo/uomo-invernale/berretto-tessuto/berretto-mod-roma-dis-5147-2-detail, not has the child product with product_sku "BT682_V4_59" (size 59).
The parent product with product_sku "BT682_V4" instead has the size 62 associated with another parent product.
In fact, if you click on size 62, another parent product is displayed with product_sku "BT689_V1" (see attachment BT682_V4.jpg).

Thanks
Pio
Attachments (4)
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello Pio,
Thank you for sending the ftp details. The issue with your images is that VirtueMart converts the file extension of images to small letters in its code as .jpg and then looks if the image exists in the folder. Since your image extensions are in capital letters .JPG, VirtueMart thinks there is no image and is shows no image instead of the actual image. This is an issue with VirtueMart and nothing to do with CSVI 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. # 5
Accepted Answer Pending Moderation
Hello,
I've just sent you the ftp.

Thanks
Pio
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello Pio,
Can you also send me the FTP details of your site? I will debug and see why we don't see images on VirtueMart when the images are actually there.
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
Hello,
no, il problema riguarda tutte le immagini tranne quella dell'articolo con sku "PIO659".

Thanks
Pio
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hello Pio,
Thank you for sending the requested details. I had a look at your site and tried an import myself and the image was not seen. I could not see anything wrong with your import or VirtueMart settings. So i removed the image from VirtueMart for the product and then did an import. That made the image to be shown. I tried to do the import again to check if the update breaks it but that did not happen. The image is still there. Is this the only one product you have issue with the image?
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
Hello Tharuna,
I've just sent you the private message.

Thanks
Pio
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Hello Pio,
Can you send me a private message with your site administrator login details? I will take a look and see what i find.
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. # 11
Accepted Answer Pending Moderation
Hello,
I checked, but the path seems right
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
Hello Pio,
I ran the import here with your image and there is no problem with the image or the product. What is the Product Media URL value set in VirtueMart configuration page and on Templates tab? Can you check if it is same as you have set in import images/virtuemart/product/?
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
Hello,
I repeated the import but I still do not see the image.
I attach the required files.

Thanks
Pio
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
Hello Pio,
There is nothing wrong i could see with your import file and debug log. The image seems to have been linked to product. Can you try running the import again? Check if you can see the image.

If you still see the issue, please send me your template XML file and image B_202_D_2000_MF_V1.JPG. I will run a test import here and check. To get the template XML file go to CSVI maintenance menu, select CSVI Pro in first option and Backup templates in second option. Select your import template and click continue. Post the downloaded XML 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. # 15
Accepted Answer Pending Moderation
Hello,
The image B_202_D_2000_MF_V1.JPG is present in the images/virtuemart/product folder.
Attached you can see the log file concerning the upload of the product_old.csv file.

Thanks
Pio
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 16
Accepted Answer Pending Moderation
Hello,
we uploaded the product.csv file, with new products, but the largest image is not displayed on the site and in the back-end (front-end.jpg, back-end.jpg)

Your debug log shows that the image for the product with SKU B_202_D_2000_MF_V1(from your screenshot) has been updated in VirtueMart medias table and also linked to the product. See the query below from your debug log. Do you have the image B_202_D_2000_MF_V1.JPG in the location images/virtuemart/product/?

UPDATE `v64ze_virtuemart_medias` SET `virtuemart_vendor_id`='1',`file_title`='',`file_description`='',`file_meta`='',`file_class`='',`file_mimetype`='image/jpeg',`file_type`='product',`file_url`='images/virtuemart/product/B_202_D_2000_MF_V1.JPG',`file_url_thumb`='images/virtuemart/product/B_202_D_2000_MF_V1.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` = '195'
2018-05-29 09:59:00 14 [DEBUG] Query for ProductMedia
2018-05-29 09:59:00 14 [QUERY] SELECT `id` FROM `v64ze_virtuemart_product_medias` WHERE `virtuemart_product_id` = 2827 AND `virtuemart_media_id` = 195
2018-05-29 09:59:00 14 [DEBUG] Executed store
2018-05-29 09:59:00 14 [QUERY] INSERT INTO `v64ze_virtuemart_product_medias` (`virtuemart_product_id`,`virtuemart_media_id`,`ordering`) VALUES ('2827','195','1')


as happened instead for the file product_old.csv.

What is the relation with product_old.csv file? I dont see the product B_202_D_2000_MF_V1 in product_old.csv 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. # 17
Accepted Answer Pending Moderation
Hello,
we uploaded the product.csv file, with new products, but the largest image is not displayed on the site and in the back-end (front-end.jpg, back-end.jpg), as happened instead for the file product_old.csv.

Best regards
Attachments (5)
  1. more than a month ago
  2. RO CSVI
  3. # 18
Accepted Answer Pending Moderation
Hello Pio,
In the product.csv file attached in your last message i dont see custom_ordering set for child products but it was there in the previous file you sent with your message to check the file. Can you run import with your previous file and see how it goes?
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. # 19
Accepted Answer Pending Moderation
Hello Tharuna,
the problem has not been resolved

not_increasing_order2.jpg

Thanks
Pio
Attachments (3)
  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!