Resolved Import Product Description for Virtuemart

Hello Kim,

In addition to what Tharuna has said, if you use the text enclosure and field delimiter, you can use whatever characters you want. The default are comma as a field separator and double quotes as text enclosure, these are fine to use and there is no real reason to deviate from that.

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

Hello 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)

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.

Hi Tharuna

Thanks for the quick response.

Currently we are using category_path rather than just category_name. e.g: Scotland/Speyside
So should I add the second category as a path also? e.g: Scotland/Speyside|Scotland/Old & Rare

And once the file is uploaded and 2nd category is in do I still leave the template as Append Categories : Yes?

Thanks again

cheers
kim

......................................................................
Hello Kim,
Yes, you can import multiple categories for a product by separating them using | example category1|category2|category3 in your import file.

If one category is already in database and you want to append another one then in your import template on Options tab set Append categories as Yes and run the import. This will add new category to a product along with old one. Click on Advanced button on top if you do not see this option in your template.

Hello Kim,

Currently we are using category_path rather than just category_name. e.g: Scotland/Speyside
So should I add the second category as a path also? e.g: Scotland/Speyside|Scotland/Old & Rare

Yes thats right, in category_path field you can add your second category as a path separated by |.

And once the file is uploaded and 2nd category is in do I still leave the template as Append Categories : Yes?

If you have no more categories to add then you can set Append categories to No.

Hello Kim,
Can you please post us your latest debug log and sample import file to check?

Thanks Tharuna, worked a treat.

cheers
kim

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.

Hi Tharuna

Here you go.

thanks

cheers
kim

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.

Hi Tharuna

I have small glitch when uploading the products CSV file into VirtueMart.

If a product has been unpublished in VirtueMart, then I upload a file that contains that product, the product becomes published. This is regardless whether the publishing column is blank or if it contains a '0' or a '1'.

BTW, should a '0' mean unpublished and a '1' mean published?

Any clues?

Thanks

cheers
kim

Hello Kim,

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.

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

Hello kim,

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_desc

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

Hi Tharuna

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'.

Thanks in advance

cheers
kim

Hello Kim,

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.

Thanks Guys!

Thanks guys!

cheers
kim

Hi Guys
I have another question.
My clients has 3 seperate prices structures for the one product, general public, members and wholesalers. From what I've read on the forum this is done through shopper groups. All good.
However the solution that was given when uploading the CSV (the import template mentioned above) was to have the main line of info, which contains Product Price (general public), but to then add a 2nd line for the Members Price (with Members selected as the Shopper Group) and then a 3rd line with the Wholesale Price (with Wholesale selected as the Shopper Group). The 3 lines have the same SKU number. This works fine when importing putting the 3 different prices in the right places for the one product.
The problem is that this causes a problem with his accounting and stock software as it treats them as 3 seperate items.

Is there anyway of doing this all on one line, designating each price to it's rightful shopper group?

Thanks in advance

cheers
kim