Hi Guys
Is there an any way to import product descriptions into Virtuemart? Both long and short would be great.
I'm not sure weather I need to use a seperate template for this or can I add to my current one which is...
product_sku : product_name : manufacturer_name : product_price : category_name : category_path : published : product_in_stock : shopper_group_name
If I need a new template then where can I find one?
Thanks in advance
cheers
kim
- coolmango
- RO CSVI
- Tuesday, 31 October 2017
- Subscribe via email
0
Accepted Answer
Accepted Answer
Pending Moderation
Hi Tharuna
You gave me the clue that solved the problem.
If the published column is blank then it reads as 1 or YES. Because I have 3 cells for each product (3 different prices) and only a 0 or NO in the first cell, the two blank cells overwrite the first cell. I put a 0 in the other two and now it stays unpublished.
Great! Problem solved.
thank you!
cheers
kim
You gave me the clue that solved the problem.

If the published column is blank then it reads as 1 or YES. Because I have 3 cells for each product (3 different prices) and only a 0 or NO in the first cell, the two blank cells overwrite the first cell. I put a 0 in the other two and now it stays unpublished.
Great! Problem solved.
thank you!

cheers
kim
- more than a month ago
- RO CSVI
- # Permalink
Accepted Answer
Pending Moderation
Hello Kim,
Thats correct. 0 is for unpublished and 1 is for published.
published field in your file is empty. if you need to unpublished set this field value to 0 or no or N or n and then try the import. If you still have any problem post the import debug log to check.
BTW, should a '0' mean unpublished and a '1' mean published?
Thats correct. 0 is for unpublished and 1 is for published.
Any clues?
published field in your file is empty. if you need to unpublished set this field value to 0 or no or N or n and then try the import. If you still have any problem post the import debug log to check.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hi Thuruna
I've tried putting in either a 'No', 'N' or '0' and it still publishes every time. The only way it didn't publish is if I deleted the published column, which isn't ideal.
The import doesn't generate a debug file even though I have the template set to Enable Logging.
Thanks
cheers
kim
I've tried putting in either a 'No', 'N' or '0' and it still publishes every time. The only way it didn't publish is if I deleted the published column, which isn't ideal.
The import doesn't generate a debug file even though I have the template set to Enable Logging.
Thanks
cheers
kim
Accepted Answer
Pending Moderation
Hello Kim,
Would like to see what is going on with your import along with your debug log issue. Can you post the template XML file to check? To get your template XML file, in RO CSVI maintenance menu select CSVI Pro on first option, backup templates on second option, select your import template and download the XML file. Post the XML file.
Would like to see what is going on with your import along with your debug log issue. Can you post the template XML file to check? To get your template XML file, in RO CSVI maintenance menu select CSVI Pro on first option, backup templates on second option, select your import template and download the XML file. Post the XML file.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hello Kim,
The debug log posted is empty so there is nothing i could check. Can you run the import and post the debug log of that latest import? Also if possible send the template XML file as requested in my previous reply.
The debug log posted is empty so there is nothing i could check. Can you run the import and post the debug log of that latest import? Also if possible send the template XML file as requested in my previous reply.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hi Tharuna
I attached the XML following your instructions ...it must not have attached properly. So here it is again attached. (com_csvi.log.211.zip)
Hopefully worked this time.
BTW, there was no CSVI Pro in the first choice, only RO CSVI ...so I used that one.
The debug file is com_csvi.log.215.zip
Thanks again
cheers
kim
I attached the XML following your instructions ...it must not have attached properly. So here it is again attached. (com_csvi.log.211.zip)
Hopefully worked this time.

BTW, there was no CSVI Pro in the first choice, only RO CSVI ...so I used that one.
The debug file is com_csvi.log.215.zip
Thanks again

cheers
kim
Attachments (2)
Accepted Answer
Pending Moderation
Hello Kim,
That was not XML file but again an incomplete debug log. Please try to post template XML again or you can mail it to tharuna@rolandd.com.
Thats correct. It is RO CSVI and not CSVI Pro.
Debug log shows that first product has been set to unpublished and last two products are set to published. Where do you have value of the published field set? Can you post the latest import file too? You can mail it to me at the above given email if you have difficulty in posting it here.
I attached the XML following your instructions ...it must not have attached properly. So here it is again attached. (com_csvi.log.211.zip)
That was not XML file but again an incomplete debug log. Please try to post template XML again or you can mail it to tharuna@rolandd.com.
BTW, there was no CSVI Pro in the first choice, only RO CSVI ...so I used that one.
Thats correct. It is RO CSVI and not CSVI Pro.
The debug file is com_csvi.log.215.zip
Debug log shows that first product has been set to unpublished and last two products are set to published. Where do you have value of the published field set? Can you post the latest import file too? You can mail it to me at the above given email if you have difficulty in posting it here.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »