Resolved Import Product Description for Virtuemart

Hello Kim,
To import multiple product prices and shopper groups use VirtueMart price import template instead of VirtueMart Product import. You can use the same file for both the imports but make sure that you add only the needed fields for the corresponding import templates.

Thanks Tharuna

I did a sample export first using the fields:
product_price product_sku shopper_group_name
But this still gives me 3 lines per product. Is there a way to have only one line per product containing the 3 different prices? Or am I missing something?

thanks again

cheers
kim

Hello Kim,
Which export type did you use? Can you post the debug log of your export to check?

Hello Kim,

Have a look at the Use of Group by and Sort by fields to manage your output of only one line.

If your product has 3 different prices, there will be 3 different lines. That is because they are simply different. The price is different but probably quantities are different as well.

It is not possible to get the multiple prices on one line because there are a number of fields that determine the price, that is also why they are exported as individual lines.

Hi Guys
I've been using the import template in SCVI for a while and was working fine. Recently it has not been uploading as well.
I'm not getting any error or bug messages. The CSV file uploads ok but not all the info is inserted into Virtuemart or Joomla.

The first instance is a product list (see screen grab Product List Sample Pic.jpg):
Does not load the Guest Shopper Group price. Everything else does.

The second instance is a Shopper's List (see screen grab Shoppers List Sample Pic.jpg):
Does not load passwords, phone numbers or any address info.
Also will not load any info for a Wholesaler (only loads Default Shopper Group)
This list has roughy 2500 entries but will only load about 250. (not the first 250 either)

These things used to work but now they don't.

Any idea why this might happen?

thanks
cheers
kim

Hello Kim,
In the screenshots you attached, Shoppers List Sample Pic.jpg is not clear to see the contents in it. You did not mention any details of your import, Which import you are using? Can you post your import debug log and sample import file to check? To get the debug log check How to get debug information? document.

Hi Tharuna

I'm running CSVI Pro 7.11.0 - VirtueMart 3.4.2 - Joomla! 3.9.5
The Product Info Import template, which I've made, uses the CSVIpro fields.
Does not load the Guest Shopper Group price. Everything else does. This template was working fine, now it doesn't
1 product_sku
2 product_name
3 manufacturer_name
4 product_price
5 category_path
6 published
7 product_in_stock
8 shopper_group_name
9 product_s_desc
10 product_desc

The Shoppers Info import template, which I've also made, uses the CSVIpro fields (also see Shopper Import Test.csv attatched).
This is the first time I've used it.
Does not load passwords, phone numbers or any address info.
Also will not load any info for a Wholesaler (only loads Default Shopper Group)
This list has roughy 2500 entries but will only load about 250. (not the first 250 either).
1 customer_number
2 shopper_group_name
3 email
4 username
6 password
7 company
8 title
9 first_name
10 last_name
11 address_1
12 address_2
13 zip
14 city
15 country
16 state
17 phone_1
18 phone_2
19 usergroup_name

If you need any more info please let me know.

Thanks in Advance

cheers
kim

Hello kim,

The Product Info Import template, which I've made, uses the CSVIpro fields.
Does not load the Guest Shopper Group price. Everything else does. This template was working fine, now it doesn't

Can you also attach the debug log of this import to check?

The Shoppers Info import template, which I've also made, uses the CSVIpro fields (also see Shopper Import Test.csv attatched).
This is the first time I've used it.
Does not load passwords, phone numbers or any address info.
Also will not load any info for a Wholesaler (only loads Default Shopper Group)
This list has roughy 2500 entries but will only load about 250. (not the first 250 either).

Are you sure that CSVI imports only Default shopper group and not Wholesaler? Because there is an error in the debug log which says "Shopper group name Default Shopper Group not found" and shows user has been imported but not linked to any shopper group. With Wholesale shopper group, user has been imported and linked to shopper group too.

Hi Tharuna

The Product Info Import template:
It says 'No debug log found' after import. I've attached the CSV file in case you need to see it. The real file has about 600 products with 3 prices each.

The Shoppers Info import template:
I tried the import of the sample again and this time it worked, showing the Default Shopper and the Wholesaler. However, If I try the real file (with 2500 shoppers) I get an Error 500 message.
I've split that file into lots of 200 shoppers (only imported 2 so far) it seems to import them but lists all the shoppers as Default (whether they are a Default or Wholesaler). It also doesn't import their phone numbers or addresses consistently (sometime it does and some times it doesn't). Neither the sample or real file of 200 shopper brings in their passwords. I've attached the debugs for the 2 x 200 shopper files (77 & 78).

Hope that all makes sense. Let me know if it doesn't.

Thanks again

cheers
kim

Hello Kim,

The Product Info Import template:
I've attached the CSV file in case you need to see it. The real file has about 600 products with 3 prices each.

From the file i can see that you have multiple rows with different prices for one product and for different shopper groups. If you have used VirtueMart Product import template then same product will be updated for price. So to import multiple prices for a product you need to use VirtueMart Price import instead of VirtueMart Product import. Debug log would have given us more information on what has happened during import.

It says 'No debug log found' after import.

Take a look at How to get debug information? document to get the debug log.

I tried the import of the sample again and this time it worked, showing the Default Shopper and the Wholesaler. However, If I try the real file (with 2500 shoppers) I get an Error 500 message.
I've split that file into lots of 200 shoppers (only imported 2 so far)

You don't need to do that. You can set the Number of lines to import in each batch to 200 in your import template and on Limit tab. You can check Manage Timeout document to check on setting this lines per import.

it seems to import them but lists all the shoppers as Default (whether they are a Default or Wholesaler). It also doesn't import their phone numbers or addresses consistently (sometime it does and some times it doesn't). Neither the sample or real file of 200 shopper brings in their passwords. I've attached the debugs for the 2 x 200 shopper files (77 & 78).

Yes with your debug log i can see details of few users have been imported and most of them are not. Can you send me the import file named Members list 1.csv to check?

Hi Tharuna

I've seemed to have solved the Wholesalers problem. It was client spelling error I didn't spot.
It still won't load up the address, phone and password info though.

cheers
kim

Hello Kim,
Please send the import file as requested. I will run the import the file on my local server and check.

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

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?

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

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?

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

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.

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?