Author Topic: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end  (Read 100073 times)

Hubbitus

  • Beginner
  • *
  • Posts: 2
I have used this to fix sites where the user wrongly stored shoppergroup specific prices: 

UPDATE ###_virtuemart_product_prices   SET virtuemart_shoppergroup_id=NULL
There only one problem - you should run it each time after import unfortunately!

77777

  • Beginner
  • *
  • Posts: 4
will this be okay in next versions of VM? I am running shop with more than 8000 products,and is really not easy to run the script every hour after import... anyway we are down for more than a week (!)  8)

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 28324
  • Always on vacation
    • Jenkin Hill Internet
You can specify shopper_group_id in CSVI when importing.
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

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

Currently using VirtueMart  4.0.2 10661 on Joomla 3.10.9 PHP 7.4.29

Stonedfury

  • Jr. Member
  • **
  • Posts: 266
    • Stonedfury
  • Skype Name: Stonedfury
  • VirtueMart Version: 2.0.24
I ran the sql and I am working on putting fresh files. Unsure on what files to put in fresh but I have uploaded the entire mytemplate and the view part of virtuemart.

Then went back and uploaded entire com_virtuemart and still 0 with strike through.
No such thing as a stupid question, only a stupid answer. I won't ask if I know the answer or found it using the search as you suggested.

Stonedfury

  • Jr. Member
  • **
  • Posts: 266
    • Stonedfury
  • Skype Name: Stonedfury
  • VirtueMart Version: 2.0.24
I ran the sql did file uploads and database fixes. What fixed it? A setting I would have never considered.
"Apply default rules" in the tax field


[attachment cleanup by admin]
No such thing as a stupid question, only a stupid answer. I won't ask if I know the answer or found it using the search as you suggested.

ggarmo

  • Beginner
  • *
  • Posts: 11
anyone have any idea why i receive this error when trying to view cart with a product added?

Fatal error: Call to undefined method VirtueMartModelProduct::getProductPrices() in /.../components/com_virtuemart/helpers/cart.php on line 1288

jusionark

  • Beginner
  • *
  • Posts: 1

gavfrog

  • Beginner
  • *
  • Posts: 2
I have used this to fix sites where the user wrongly stored shoppergroup specific prices: 

UPDATE ###_virtuemart_product_prices   SET virtuemart_shoppergroup_id=NULL
Thanks for sharing. That saved me a good hour or two.

joompiter

  • Beginner
  • *
  • Posts: 5
I did not read the whole thread, but having a similar problem, I did the following since an anonymous user was not asociated to the the default shopper group:
 
Have a look where virtuemart_user_id 0 is in #__virtuemart_vmuser_shoppergroups.
If so, set the virtuemart_shopper_group_id to your standard shopper_group_id.

If not, insert a pair (0,your standard shopper_group_id).

Perhaps this is missing when choosing a new standatd shopper group. I did not further analyze...

remeedella

  • Jr. Member
  • **
  • Posts: 62
Hey guys, I'm good at screwing things up and finding random work arounds. The following actually worked for me and might solve this for some of you if you have a simple setup.
I've read through this whole thread and I've tried the sql query on a fresh 2.0.18! install and shopper id's were already at 0 beforehand, I tried to NULL and it nulled but changed nothing..

What I need to do is allow guests to see prices without logging in yet, I want to be able to see prices change on the fly as a guest when adjusting quantity to put in cart and when adding +- custom field variants. I want guests and members to see prices alike. Right now everything is perfect when logged in, a guest only see's this "Price:"  and price per lb because im using that customprice additionally. For some reason that shows but not regular price. Here's my ghetto solution, view attached image

I also was able to leave anonymous shopper group show prices and all that disabled and default.

When you see how I configured pricing it achieves what I want but may not work for people with lots of different price setups required. It basically hides the labels of things I don't need and only shows my customprice and the regular price before it by hiding what needs not to show but does pull up the basic correct price however I will need to style it because of course the price appears one line below so I need to align it accordingly.


[attachment cleanup by admin]

remeedella

  • Jr. Member
  • **
  • Posts: 62
Hey guys, I'm good at screwing things up and finding random work arounds. The following actually worked for me and might solve this for some of you if you have a simple setup.
I've read through this whole thread and I've tried the sql query on a fresh 2.0.18! install and shopper id's were already at 0 beforehand, I tried to NULL and it nulled but changed nothing..

What I need to do is allow guests to see prices without logging in yet, I want to be able to see prices change on the fly as a guest when adjusting quantity to put in cart and when adding +- custom field variants. I want guests and members to see prices alike. Right now everything is perfect when logged in, a guest only see's this "Price:"  and price per lb because im using that customprice additionally. For some reason that shows but not regular price. Here's my ghetto solution, view attached image

I also was able to leave anonymous shopper group show prices and all that disabled and default.

When you see how I configured pricing it achieves what I want but may not work for people with lots of different price setups required. It basically hides the labels of things I don't need and only shows my customprice and the regular price before it by hiding what needs not to show but does pull up the basic correct price however I will need to style it because of course the price appears one line below so I need to align it accordingly.

[attachment cleanup by admin]