Categories
View Replies (48)

Resolved Import Product Description for Virtuemart

  1. coolmango
    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
0
Accepted Answer
coolmango
coolmango
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
Responses (48)
coolmango
coolmango
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. # 41
tharuna
tharuna
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 our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 42
tharuna
tharuna
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 our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 43
coolmango
coolmango
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)
Members list 3.csv
  1. more than a month ago
  2. RO CSVI
  3. # 44
tharuna
tharuna
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 our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 45
coolmango
coolmango
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. # 46
tharuna
tharuna
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 our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 47
  • Page :
  • 1
  • 2
  • 3


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