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
Accepted Answer Pending Moderation
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 :product_desc:product_s_desc
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. # 1
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
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
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.
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. # 4
Accepted Answer Pending Moderation
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.
Kind regards,

RolandD

=========================
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. # 5
Accepted Answer Pending Moderation
Thanks Guys!
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Thanks guys!

cheers
kim
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
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.
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. # 10
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Hello Kim,
Which export type did you use? Can you post the debug log of your export 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. # 12
Accepted Answer Pending Moderation
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.
Kind regards,

RolandD

=========================
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. # 13
Accepted Answer Pending Moderation
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
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
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.
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. # 15
Accepted Answer Pending Moderation
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
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 16
Accepted Answer Pending Moderation
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.
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. # 17
Accepted Answer Pending Moderation
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
Attachments (3)
  1. more than a month ago
  2. RO CSVI
  3. # 18
Accepted Answer Pending Moderation
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?
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. # 19
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 20
  • Page :
  • 1
  • 2
  • 3


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