News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

not price in frontend

Started by tonnerria, March 30, 2013, 14:21:33 PM

Previous topic - Next topic

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
Nathalie

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
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

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

tonnerria

hello,

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

thank you

Nath
Nathalie

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)
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

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

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]
Nathalie

tonnerria

hi

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

[attachment cleanup by admin]
Nathalie

jjk

#6
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]
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations

tonnerria

hello!

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

nath
Nathalie