VirtueMart Forum

VirtueMart 2 + 3 + 4 => Product pricing => Topic started by: elviospiteri on February 05, 2013, 23:28:51 PM

Title: No prices shown after import with CSVImproved
Post by: elviospiteri on February 05, 2013, 23:28:51 PM
I have this problem with Virtuemart 2.0.18a that when I import products using CSVImproved the prices are not shown on the website but in Virtuemart they are entered correctly. Can anyone help me with this situation because I have to go throughout all the products and change the shoppergroup. This I have to do after each import and it is annoying.

Thanks very much
Title: Re: No prices shown after import with CSVImproved
Post by: jenkinhill on February 06, 2013, 15:20:26 PM
Probably you are setting a shopper group in your csv import or need to include a null shopper group. Check with RolandD on http://csvimproved.com/
Title: Re: No prices shown after import with CSVImproved
Post by: elviospiteri on February 06, 2013, 16:59:37 PM
Hello my friend,

This is what I`m importing
product_sku
category_path
product_name
product_price
product_in_stock
product_unit
published
product_s_desc
manufacturer_name

Do I need to add another field with "shoppergoup" and set it as NULL (i.e. an empty field) ?

Thanks very much
Kind regards

Elvio
Title: Re: No prices shown after import with CSVImproved
Post by: PRO on February 06, 2013, 17:45:27 PM
csv imroved always set a shoppet group for my imports WHEN i "created" new products via CSV improved

backup first
update #_virtuemart_product_prices set virtuemart_shoppergroup_id= replace(virtuemart_shoppergroup_id,'THIS-NUMBER', 'NULL');

change THIS-NUMBER   and add your db prefix
Title: Re: No prices shown after import with CSVImproved
Post by: elviospiteri on February 06, 2013, 23:22:15 PM
Thanks very much PRO, but that is not a permanent solution. When I update the table shopper_group_id manually it works, but when I reupload again the CSV file new products are defaulting to value 2 although the default value of the table is 'NULL'.
Regards
Title: Re: No prices shown after import with CSVImproved
Post by: PRO on February 07, 2013, 16:46:30 PM


have you reported this in the csvi forums?

Title: Re: No prices shown after import with CSVImproved
Post by: elviospiteri on February 10, 2013, 14:53:08 PM
Yes I did but I got no reply till today
Title: Re: No prices shown after import with CSVImproved
Post by: PRO on February 10, 2013, 16:02:49 PM
Quote from: elviospiteri on February 10, 2013, 14:53:08 PM
Yes I did but I got no reply till today

and what did he say?
Title: Re: No prices shown after import with CSVImproved
Post by: brilliantimpact on March 13, 2013, 23:16:44 PM
Bump on this?  I'm having the exact same problem and running the script didn't solve the problem for me.
Title: Re: No prices shown after import with CSVImproved
Post by: RolandD on March 14, 2013, 08:25:39 AM
QuoteYes I did but I got no reply till today
He did get a reply just not the same day as he is using the CSVI Free version. His issue was also solved by updating to CSVI Free 4.5. See thread (http://www.csvimproved.com/forum?view=topic&catid=24&id=30815&limitstart=0) for details.