not price in frontend

[tonnerria]

hello,
I migrated to virtuemart1 virtuemart2 my products are online, but the price is not. Chauque product was automatically set for wholesale prices. But I do not want to put the group pricing. how?
I note that if I take product-not to put the customer group price display frontend. However, it should be done more quickly

thank you for your response

Nath

[jenkinhill]

If you want the prices to be seen by everyone then no shopper group should be selected for price display (which is the default). You can set this for all current products using sql  -  http://forum.virtuemart.net/index.php?topic=112968.msg380135#msg380135

[tonnerria]

hello,

I did not understand everything,
once phpmyadmin, I selected # # # virtuemart_product_prices
and what do I do?

thank you

Nath

[jenkinhill]

Make sure you replace the ### in the sql fie with your own database prefix (eg jos_ )

To run the query see https://forums.digitalpoint.com/threads/how-to-run-a-sql-file-in-phpmyadmin.108017/   

BUT back up the database first (export all)

[tonnerria]

hello,

and thank you for your follow up,
I went to phpmyadmin, but I do not know what to do toujour, see attached image.
I click on table virtuemart_product_prices and what do I do?
I will wish to click on "change" virtuemart_shoppergroup_id and whrite " NULL" but the page is not displayed

cordially
nathalie

[attachment cleanup by admin]

[tonnerria]

hi

virtuemart_product_price where 1 ---> I need to change?

[attachment cleanup by admin]

[jjk]

Copy the SQL query Jenkinhill gave in this forum post
http://forum.virtuemart.net/index.php?topic=112968.msg380135#msg380135
into phpmyadmin query window shown in the attached image of your last post, replace the ### characters (prefix) with the ones in front of your database table names and click on 'Exècuter'.

...but just in case the result doesn't solve your problem, make a backup first or try it on a copy of your current Joomla/VM installation.

[attachment cleanup by admin]

[tonnerria]

hello!

oh yes! ok! i understand now, thank you very much

nath