Author Topic: No prices shown after import with CSVImproved  (Read 1638 times)

elviospiteri

  • Beginner
  • *
  • Posts: 4
No prices shown after import with CSVImproved
« 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

jenkinhill

  • Global Moderator
  • Super Hero
  • *
  • Posts: 20627
  • Web developer and consultant
    • Jenkin Hill Internet
Re: No prices shown after import with CSVImproved
« Reply #1 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/
Kelvyn
Jenkin Hill Internet,
Keswick, Lake District

Unsolicited PMs/emails will be ignored.

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Currently using VM2.6.8 on Joomla 2.5.24 PHP 5.4.21

Currently testing VM2.9.9 on J3.3.3

elviospiteri

  • Beginner
  • *
  • Posts: 4
Re: No prices shown after import with CSVImproved
« Reply #2 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

PRO

  • Global Moderator
  • Super Hero
  • *
  • Posts: 9891
Re: No prices shown after import with CSVImproved
« Reply #3 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
"Banquet Tables Pro"
I do NOT do development work for hire.
My Custom Field Plugin Now with =Price
http://forum.virtuemart.net/index.php?topic=99678
My Shipping Plugin
http://forum.virtuemart.net/index.php?topic=100630.0

elviospiteri

  • Beginner
  • *
  • Posts: 4
Re: No prices shown after import with CSVImproved
« Reply #4 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

PRO

  • Global Moderator
  • Super Hero
  • *
  • Posts: 9891
Re: No prices shown after import with CSVImproved
« Reply #5 on: February 07, 2013, 16:46:30 pm »


have you reported this in the csvi forums?

 
"Banquet Tables Pro"
I do NOT do development work for hire.
My Custom Field Plugin Now with =Price
http://forum.virtuemart.net/index.php?topic=99678
My Shipping Plugin
http://forum.virtuemart.net/index.php?topic=100630.0

elviospiteri

  • Beginner
  • *
  • Posts: 4
Re: No prices shown after import with CSVImproved
« Reply #6 on: February 10, 2013, 14:53:08 pm »
Yes I did but I got no reply till today

PRO

  • Global Moderator
  • Super Hero
  • *
  • Posts: 9891
Re: No prices shown after import with CSVImproved
« Reply #7 on: February 10, 2013, 16:02:49 pm »
Yes I did but I got no reply till today

and what did he say?
"Banquet Tables Pro"
I do NOT do development work for hire.
My Custom Field Plugin Now with =Price
http://forum.virtuemart.net/index.php?topic=99678
My Shipping Plugin
http://forum.virtuemart.net/index.php?topic=100630.0

brilliantimpact

  • Beginner
  • *
  • Posts: 13
Re: No prices shown after import with CSVImproved
« Reply #8 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.

RolandD

  • Sr. Member
  • ****
  • Posts: 776
    • Home of CSVI
Re: No prices shown after import with CSVImproved
« Reply #9 on: March 14, 2013, 08:25:39 am »
Quote
Yes 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 for details.
Regards,

RolandD

CSVI
http://www.csvimproved.com/

VirtueMart Forum

Re: No prices shown after import with CSVImproved
« Reply #9 on: March 14, 2013, 08:25:39 am »