Resolved Import Issue: virtuemart_products table is not populating

Hello Syed,
There is an update query running for virtuemart_products table as per your debug log and that is because of virtuemart_product_id field in your import file. Using the fields ending with _id will only do the update of records as it says that the record is already there in the database tables. CSVI imports products based on product_sku field so you can removed the virtuemart_product_id from your import file and then run the import.

Thanks Tharuna -

I will do that and will get back to you with the updates.

thanks much.

I have removed the virtuemart_product_id and PRODID mapping but the products are still not there in the virtuemart_products table?

Hello,
Can you post debug log of your last import to check? Also your import template XML file. To get template XML file go to CSVI maintenance page, Select CSVI Pro on first option and Backup template on second option. Select your template and click continue. Download the XML file and post it.

Please find attached the latest log and the template XML file.

Hello,
Your files are missing in the post. Can you compress and post them?

There is some file size issue, i am attaching them separately. Here is the XML Template File.

It wont let me attach the 800KB log file?

Hello,
Try the import with 5 products so you get a smaller debug log and it is easy to attach.

PFA the log file.

Got the files?

Hello,
Yes got the files and your recent debug log shows there is still virtuemart_product_id in your import though your template don't have product_id mapped. Is this the latest debug log?

This is the latest log, i had removed the PRODID and virtuemart_product_id - I am not sure why this is still there?

May be its in the cache? I am trying to completely redo this. will update shortly.

Hello,

This is the latest log, i had removed the PRODID and virtuemart_product_id - I am not sure why this is still there?

I really doubt if its the latest debug log. The debug log file name you posted in your first post is com_csvi.log.7 and the last one posted is com_csvi.l.log.6 which seems to be debug log of old import. Please find the latest debug log file and post it.

I did a fresh install by removing the virtuemart_product_id and that seemed to have worked, will try importing the whole file now, thanks. There is one additional question though. how do I import the product images? I had added product_id field (PRODID) such that I can use the same to import the images data as well. But now since we have removed PRODID, how will I ensure that correct images go for correct product? Do I use the SKU for that? If yes, could you please guide a bit on this.

thanks much.

Hello,

how do I import the product images? I had added product_id field (PRODID) such that I can use the same to import the images data as well. But now since we have removed PRODID, how will I ensure that correct images go for correct product?

You need to file_url field for importing images and file_url_thumb for thumbnails for a product. By default CSVI will import images with same names as given in the import file.

Do I use the SKU for that? If yes, could you please guide a bit on this.

Yes, You can also use SKU for image names. In your template settings on Images tab, you can set "Image name based on" field to product SKU. If you don't see this option click on Advanced button on top corner. This setting will use product SKU as image name.

Great, thanks. You Rock!

Hi Tharuna -

I am encountering an issue related to the product images. There are about 50000 products I am trying to import.

1- When I set the option Process Images to NO, it stores the direct image url( external url ), in the DB. I have checked in the DB and the image URL is there, however, when VM loads the image, it prefixes the /images/stories/products and hence no image or thumbnail appears and it displays error VMError, File not found etc.
2- When I set it to process images and download image to the server, it takes forever to process because of too many images that require to be downloaded.

Could you please let me know what do I have to to ensure that in Step 1, image URL get stored in the DB and is loaded properly in the backend and frontend.

Thanks for all your help with this.

thanks and best regards,
Syed

Hello Syed,

1- When I set the option Process Images to NO, it stores the direct image url( external url ), in the DB. I have checked in the DB and the image URL is there, however, when VM loads the image, it prefixes the /images/stories/products and hence no image or thumbnail appears and it displays error VMError, File not found etc.

You cannot store external URLs in database tables, and Yes, VirtueMart adds the default path to the image and so no image can be seen.

2- When I set it to process images and download image to the server, it takes forever to process because of too many images that require to be downloaded.

The only way is that you have to download the image to server. Importing images of 50000 products will take time. Have a look at Manage Timeout document to know to handle timeout error in case you get into it.

Could you please let me know what do I have to to ensure that in Step 1, image URL get stored in the DB and is loaded properly in the backend and frontend.

You cannot use step1 to process your images. You need to have images in VirtueMart product default path so VirtueMart can load your images.