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
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
Accepted Answer
Pending Moderation
Hello Kim,
Happy to hear that it worked
You can use text enclosure around your content in your import file or use HTML symbol for comma in your description which would be
Have a look at VirtueMart product export document to know on how to export the product details.
It worked a treat! Thanks very much, saved me a few headaches.
Happy to hear that it worked
I take it you can't use commas in the description as it throws out the CSV. ...a minor detail.
Any way around that you know of?
You can use text enclosure around your content in your import file or use HTML symbol for comma in your description which would be
,I also meant to ask, is there a similar process to export the same CSV structure?
All I can find on the support pages are 'Advanced custom table export' and 'Creating own HTML export file'.
Have a look at VirtueMart product export document to know on how to export the product details.
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
It worked a treat! Thanks very much, saved me a few headaches.
I take it you can't use commas in the description as it throws out the CSV. ...a minor detail.
Any way around that you know of?
thanks again!
cheers
kim
It worked a treat! Thanks very much, saved me a few headaches.
I take it you can't use commas in the description as it throws out the CSV. ...a minor detail.
Any way around that you know of?
thanks again!
cheers
kim
Accepted Answer
Pending Moderation
Hello kim,
You need to use product_desc and product_s_desc fields to import long and short descriptions.
You don't need a new template, you can use your descriptions fields in current import template like below provided that you are using VirtueMart product import template.
Is there an any way to import product descriptions into Virtuemart? Both long and short would be great.
You need to use product_desc and product_s_desc fields to import long and short descriptions.
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?
You don't need a new template, you can use your descriptions fields in current import template like below provided that you are using VirtueMart product import template.
product_sku : product_name : manufacturer_name : product_price : category_name : category_path : published : product_in_stock : shopper_group_name 
roduct_descroduct_s_descKind 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!