1. coolmango
  2. RO CSVI
  3. Tuesday, 31 October 2017
  4.  Subscribe via email
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
Accepted Answer
Accepted Answer Pending Moderation
Hi Tharuna

You gave me the clue that solved the problem. :D

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
  1. more than a month ago
  2. RO CSVI
  3. # Permalink
Accepted Answer Pending Moderation
Hello Kim,
Please send the import file as requested. I will run the import the file on my local server and check.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 21
Accepted Answer Pending Moderation
Hi Tharuna

Sorry, I meant to attach that and forgot. :)

here you go.
The fields, ABN, newsletter, creditApproved, creditLimit, approved and active are not necessary.

thanks again
kim
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 22
Accepted Answer Pending Moderation
Hello Kim,
Do you have Wholesalers user group created from Users >> Groups page? That is the reason your users are not imported. Can you confirm you have this user group created?
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 23
Accepted Answer Pending Moderation
Hi Tharuna

Yes, I have a Wholesalers user group in Joomla.
In Joomla Users there are 2 groups, Wholesalers and Registered.
In Virtuemart they correspond to Wholesale and Default Shoppers (COM_VIRTUEMART_SHOPPERGROUP_DEFAULT). I had to change Default Shopper Group to COM_VIRTUEMART_SHOPPERGROUP_DEFAULT in the csv file so the tag in Virtuemart would show.
All the shoppers have imported just not all the info.
The weird thing is that the template imports address info into some and not others, (Wholesale or Default Shoppers). It seems random, though none of them have the phone numbers or passwords imported.
I've split the shopper list for import into 13 seperate files (200 each) as the full 2500 file will not import (500 error message).
I actually only need to do this once as an initial import (transferring info from old site to new Joomla site) as shoppers will register individually after that on the new site.

Hope this helps

cheers
kim
  1. more than a month ago
  2. RO CSVI
  3. # 24
Accepted Answer Pending Moderation
Hello Kim,
Yes, I have a Wholesalers user group in Joomla.
In Joomla Users there are 2 groups, Wholesalers and Registered.
In Virtuemart they correspond to Wholesale and Default Shoppers (COM_VIRTUEMART_SHOPPERGROUP_DEFAULT). I had to change Default Shopper Group to COM_VIRTUEMART_SHOPPERGROUP_DEFAULT in the csv file so the tag in Virtuemart would show.
All the shoppers have imported just not all the info.
The weird thing is that the template imports address info into some and not others, (Wholesale or Default Shoppers). It seems random, though none of them have the phone numbers or passwords imported.

I tried importing your file on my local server and could see all users imported. Can you send me a private message of your site administrator login details? I will take a look at your site.

I've split the shopper list for import into 13 seperate files (200 each) as the full 2500 file will not import (500 error message).
I actually only need to do this once as an initial import (transferring info from old site to new Joomla site) as shoppers will register individually after that on the new site.

Did you try batch import as explained in Manage timeout document? I sent link to this document in my previous post. Didn't that work for you?
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 25
Accepted Answer Pending Moderation
Hi Tharuna

I've sent you login details via your contact page.

Yes, I tried the batch import but that didn't work either. Hopefully you can find the gremlin. :)

thanks
kim
  1. more than a month ago
  2. RO CSVI
  3. # 26
Accepted Answer Pending Moderation
Hello Kim,
I've sent you login details via your contact page.

Will take a look at your site and give an update on what i find.

Yes, I tried the batch import but that didn't work either. Hopefully you can find the gremlin. :)

2500 lines to import is not a huge one but since that is not working for you, you can try setting your import as a cron job and see how it goes.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 27
Accepted Answer Pending Moderation
Hello Kim,
I had a look at your site and could see the all Joomla users created but i am not able to check the VirtueMart shopper groups as i don't have access to that page. Is it possible that i get access to that page?

Also for batch imports, I wanted to know what was the limit you had set in Lines per import on Limit tab? Did you try setting it to 100 or 50 and you see the same 500 error?
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 28
Accepted Answer Pending Moderation
Hi Tharuna

You access has bee fixed so you should be ok now.

I originally tried 200 lines at a time and the 100 for the batch, without any error messages, but it still seems to randomly select who get addresses and phone numbers. Some get neither. It's a puzzle.

Thanks for looking.
cheers
kim
  1. more than a month ago
  2. RO CSVI
  3. # 29
Accepted Answer Pending Moderation
Hello Kim,
I picked few random users from your import file, checked address details at VirtueMart shoppers page and see the address details added. Can you give emails of few users for whom address and phone numbers are not added? That will help me to track the issue.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 30
Accepted Answer Pending Moderation
Hello Kim,
Also i wanted to tell you that address and phone numbers of few users are not there in your import file. I am talking about Members list 1.csv file which you sent us earlier. I hope you are not talking about those users.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 31
Accepted Answer Pending Moderation
Hi Tharuna

Seems your right about the addresses (my apologies), it's phone numbers and passwords that aren't loading.
This is for both Default Shopper Group and Wholesale.

On the file Members list 1.csv (a few examples)
anthony.cowie@gmail.com: Imported Address but not Phone (file contains only 1 ph. number)
antony@rsq.com.au: Imported Address but not Phone (file contains only 1 ph. number)
ajm@audaxlegal.com: Imported Address but not Phone (file contains 2 ph. numbers)

On the file Members list 3.csv (attached)
dalli@iprimus.com.au: Imported Address but not Country, State or Phone (file contains only 1 ph. number)
This could just be a one off though.

thanks for you help
cheers
kim
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 32
Accepted Answer Pending Moderation
Hello Kim,
Seems your right about the addresses (my apologies), it's phone numbers and passwords that aren't loading.
This is for both Default Shopper Group and Wholesale.

Passwords are added for all users you are just not seeing them. That is not an issue because by default password fields don't show the value in the fields.

On the file Members list 1.csv (a few examples)
anthony.cowie@gmail.com: Imported Address but not Phone (file contains only 1 ph. number)
antony@rsq.com.au: Imported Address but not Phone (file contains only 1 ph. number)
ajm@audaxlegal.com: Imported Address but not Phone (file contains 2 ph. numbers)

On the file Members list 3.csv (attached)
dalli@iprimus.com.au: Imported Address but not Country, State or Phone (file contains only 1 ph. number)
This could just be a one off though.

I found a strange issue on your site. I wanted to check if user details were added in your site database so i created a CSVI custom table export template on your server and exported all the users details saved. To my surprise i see that each user has been duplicated several times in the database and the first record of these users don't have phone numbers added. This first record is the one selected by default and shown in VirtueMart Shoppers page. That explains why you don't see phone numbers for these users. I need to find out why you have so many duplicates in your database. Can you send me a private message of your database access details? I will clean the table and run the import again to see how these duplicates happens.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 33
Accepted Answer Pending Moderation
Hi Tharuna

I've sent you a message via your contact page.

cheers
kim
  1. more than a month ago
  2. RO CSVI
  3. # 34
Accepted Answer Pending Moderation
Hello Kim,
Have sent a reply to your email with screenshot of issues i see in your VirtueMart userinfo table. Take a look and let me know.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 35
Accepted Answer Pending Moderation
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.
  1. more than a month ago
  2. RO CSVI
  3. # 36
Accepted Answer Pending Moderation
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.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 37
Accepted Answer Pending Moderation
Thanks Tharuna, worked a treat.

cheers
kim
  1. more than a month ago
  2. RO CSVI
  3. # 38
Accepted Answer Pending Moderation
Hello Kim,
Can you please post us your latest debug log and sample import file to check?
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 39
Accepted Answer Pending Moderation
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
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 40
  • Page :
  • 1
  • 2
  • 3


There are no replies made for this post yet.
Be one of the first to reply to this post!