VirtueMart Forum

VirtueMart 2 + 3 => Virtuemart Development and bug reports => Topic started by: enoon on October 22, 2012, 21:26:01 pm

Title: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: enoon on October 22, 2012, 21:26:01 pm
Hi,

I have the latest versions to date:

Joomla 2.5.7
Virtuemart 2.0.12f

Problem is that the prices in the front-end are not showing up.


Is it a bug in the latest version (I just did an update) or are there any other configurations that I'm missing?

SOLUTION:
Go to your sql editor and run:
Code: [Select]
UPDATE `[prefix]_virtuemart_product_prices` SET `virtuemart_shoppergroup_id`=NULL WHERE 1

And product prices will show up for the front-end anonymous user.
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: gpessoa on October 23, 2012, 00:05:20 am
same here! :'(
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: lipes on October 23, 2012, 03:01:11 am
Yep is true is not displaying the price in front end.
Can  you enter in the Admin Product area?
I am with problems with that too..
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: lipes on October 23, 2012, 03:57:16 am
I see that it's a problem in product.php
but the file it's very different from verison B..
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: bytelord on October 23, 2012, 05:35:23 am
Working for me, Check a little bit more your configuration, maybe something changed on the configuration during the update.

Regards
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: enoon on October 23, 2012, 08:51:07 am
@bytelord What else do you think I'm missing? What configurations/options?
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: jenkinhill on October 23, 2012, 10:06:45 am
OK for me, too. All pricing options selected for my test installation, no overrides.
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: enoon on October 23, 2012, 11:43:05 am
@jenkinhill For you too is working?
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: John2400 on October 23, 2012, 13:22:15 pm
Hi for me ,

On one site works OK , the other has no pricing at all. I only have the default user (group Blank)

I'm still working my way through the differences. Both sites had all the same updates. ?
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: notdan on October 23, 2012, 13:25:12 pm
hi, just had the same problem, vm was updated to 2.0.12f, no prices were displayed for anonymous ones anymore. i entered a new product (which was displayed as it should, for anonymous and logged-in users), and there was a difference in sql:

found out that in sql, vm_shoppergroup_id was set to 2 for all the old products instead of null (the new one). changed it and all prices were displayed again.
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: John2400 on October 23, 2012, 13:34:32 pm
For me ,

I set the shopper group and changed it several times to different groups. For the test product shovel.

No matter what I set - it always displayed this - I have updated 2.0.12f again just to make sure.

notdan: Thanks I added a product a new one and yes that individual product displayed the product price correctly.

[attachment cleanup by admin]
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: enoon on October 23, 2012, 13:54:47 pm
I've deleted all the records from virtuemart_product_shoppergroups and added all the products to both shopper groups -default & -anonymous- also the debug shows mes this, which to me at least lokks right, still the price for guest user is not displaying:

Code: [Select]
(
    [virtuemart_shoppergroup_id] => 2
    [virtuemart_vendor_id] => 1
    [shopper_group_name] => -anonymous-
    [shopper_group_desc] => Shopper group for anonymous shoppers
    [custom_price_display] => 1
    [price_display] => O:10:"JParameter":5:{s:7:"*_raw";s:757:"show_prices=1
basePrice=1
basePriceText=1
basePriceRounding=2
variantModification=1
variantModificationText=1
variantModificationRounding=2
basePriceVariant=1
basePriceVariantText=1
basePriceVariantRounding=2
basePriceWithTax=1
basePriceWithTaxText=1
basePriceWithTaxRounding=2
basePriceWithTax=1
basePriceWithTaxText=1
basePriceWithTaxRounding=2
discountedPriceWithoutTax=1
discountedPriceWithoutTaxText=1
discountedPriceWithoutTaxRounding=2
salesPrice=1
salesPriceText=1
salesPriceRounding=2
priceWithoutTax=1
priceWithoutTaxText=1
priceWithoutTaxRounding=2
salesPriceWithDiscount=1
salesPriceWithDiscountText=1
salesPriceWithDiscountRounding=2
discountAmount=1
discountAmountText=1
discountAmountRounding=2
taxAmount=1
taxAmountText=1
taxAmountRounding=2";s:7:"*_xml";N;s:12:"*_elements";a:0:{}s:15:"*_elementPath";a:1:{i:0;s:65:"/home/ntgshop/public_html/libraries/joomla/html/parameter/element";}s:7:"*data";O:8:"stdClass":31:{s:11:"show_prices";i:1;s:9:"basePrice";i:1;s:13:"basePriceText";i:1;s:17:"basePriceRounding";i:2;s:19:"variantModification";i:1;s:23:"variantModificationText";i:1;s:27:"variantModificationRounding";i:2;s:16:"basePriceVariant";i:1;s:20:"basePriceVariantText";i:1;s:24:"basePriceVariantRounding";i:2;s:16:"basePriceWithTax";i:1;s:20:"basePriceWithTaxText";i:1;s:24:"basePriceWithTaxRounding";i:2;s:25:"discountedPriceWithoutTax";i:1;s:29:"discountedPriceWithoutTaxText";i:1;s:33:"discountedPriceWithoutTaxRounding";i:2;s:10:"salesPrice";i:1;s:14:"salesPriceText";i:1;s:18:"salesPriceRounding";i:2;s:15:"priceWithoutTax";i:1;s:19:"priceWithoutTaxText";i:1;s:23:"priceWithoutTaxRounding";i:2;s:22:"salesPriceWithDiscount";i:1;s:26:"salesPriceWithDiscountText";i:1;s:30:"salesPriceWithDiscountRounding";i:2;s:14:"discountAmount";i:1;s:18:"discountAmountText";i:1;s:22:"discountAmountRounding";i:2;s:9:"taxAmount";i:1;s:13:"taxAmountText";i:1;s:17:"taxAmountRounding";i:2;}}
    [default] => 2
    [ordering] => 0
    [shared] => 1
    [published] => 1
    [created_on] => 0000-00-00 00:00:00
    [created_by] => 0
    [modified_on] => 2012-10-22 19:13:50
    [modified_by] => 42
    [locked_on] => 0000-00-00 00:00:00
    [locked_by] => 0
)

Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: enoon on October 23, 2012, 14:03:28 pm
@notdan Thank you! Your solution works!
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: cezaryk on October 23, 2012, 14:15:36 pm
Hi!
There are two fields changed in "f" version:

***** install_org.sql
  `product_currency` smallint(1),
  `product_price_publish_up` datetime,
  `product_price_publish_down` datetime,
  `price_quantity_start` int(11) unsigned,
***** INSTALL.SQL
  `product_currency` smallint(1),
  `product_price_vdate` datetime,
  `product_price_edate` datetime,
  `price_quantity_start` int(11) unsigned,
*****

And they are used in .../models/product
Code: [Select]
if($front){
if(count($virtuemart_shoppergroup_ids)>0){
$q .= ' AND (';
foreach($virtuemart_shoppergroup_ids as $sgrpId){
$q .= ' `virtuemart_shoppergroup_id` ="'.$sgrpId.'" AND ';
}
$q = substr($q,0,-4);
$q .= ' OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") ';
}
$q .= ' AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "' . $db->getEscaped($this->_nullDate) . '" OR `product_price_publish_up` <= "' .$db->getEscaped($this->_now) . '" )
        AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "' .$db->getEscaped($this->_nullDate) . '" OR product_price_publish_down >= "' . $db->getEscaped($this->_now) . '" ) )';
}

Hope it helps  ;)
Best Regards
Cezar
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: lipes on October 23, 2012, 14:16:44 pm
No overrides and configuration is ok..  :-\
it's better wait for a next release this is not "so normal".
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: patrik60 on October 23, 2012, 14:44:13 pm
Prices are shown when I make just an update. But when I either reset all tables and replace them with sample data or when I make a fresh install (after deleting all tables) and install sample data I get the following errors:

Code: [Select]
Installer::install: /home/******/public_html/virtuemart/administrator/components/com_virtuemart/install/install_sample_data.sql SQL Fehler DB-Funktion mit Fehlercode 1054 fehlgeschlagen!
Unknown column 'product_price_vdate' in 'field list' SQL=-- -- Dumping data for table `v3idw_virtuemart_product_prices` -- INSERT INTO `v3idw_virtuemart_product_prices` (`virtuemart_product_price_id`, `virtuemart_product_id`, `product_price`, `override`, `product_override_price`, `product_tax_id`, `product_discount_id`, `product_currency`, `product_price_vdate`, `product_price_edate`, `virtuemart_shoppergroup_id`, `price_quantity_start`, `price_quantity_end`) VALUES (1, 5, '24.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (2, 1, '4.49000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (3, 2, '39.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (4, 3, '24.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (5, 4, '17.99000', 1, '77.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (6, 6, '4.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (7, 7, '149.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (8, 8, '220.90000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (9, 9, '48.12000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (10, 10, '74.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (11, 11, '2.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (12, 12, '14.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (13, 13, '79.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (14, 14, '49.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (15, 15, '59.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0), (16, 16, '3.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0);
SQL =

--
-- Dumping data for table `#__virtuemart_product_prices`
--

INSERT INTO `#__virtuemart_product_prices` (`virtuemart_product_price_id`, `virtuemart_product_id`, `product_price`, `override`, `product_override_price`, `product_tax_id`, `product_discount_id`, `product_currency`, `product_price_vdate`, `product_price_edate`, `virtuemart_shoppergroup_id`, `price_quantity_start`, `price_quantity_end`) VALUES
(1, 5, '24.99000', 0, '0.00000', NULL, NULL, '144', 0, 0,  NULL, 0, 0),
(2, 1, '4.49000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0),
(3, 2, '39.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0),
(4, 3, '24.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0),
(5, 4, '17.99000', 1, '77.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0),
(6, 6, '4.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0),
(7, 7, '149.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0),
(8, 8, '220.90000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0),
(9, 9, '48.12000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0),
(10, 10, '74.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0),
(11, 11, '2.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0),
(12, 12, '14.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0),
(13, 13, '79.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0),
(14, 14, '49.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0),
(15, 15, '59.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0),
(16, 16, '3.99000', 0, '0.00000', NULL, NULL, '144', 0, 0, NULL, 0, 0);

vmError: Problems execution of SQL File /home/******/public_html/virtuemart/administrator/components/com_virtuemart/install/install_sample_data.sql

Prices are no longer shown in the FE.

Going back to 2.0.12e and reset and replace again all tables with sample data, prices are shown again. Please check these sql errors.
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: enoon on October 23, 2012, 20:15:51 pm
A simple SQL script fixes the issue!

Please read the solution in the first post I made!

Cheers!
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: maspegren on October 23, 2012, 20:38:30 pm
Hey notdan can you run me through how you did this?

found out that in sql, vm_shoppergroup_id was set to 2 for all the old products instead of null (the new one). changed it and all prices were displayed again.
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: enoon on October 23, 2012, 21:00:07 pm
Code: [Select]
UPDATE `[prefix]_virtuemart_product_prices` SET `virtuemart_shoppergroup_id`=NULL WHERE 1
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f price gets not stored whne adding new prod
Post by: TeleEnte on October 24, 2012, 13:37:04 pm
Re: Joomla 2.5.7 / Virtuemart 2.0.12f price gets not stored whne adding new products.

I cannot save the price of the products anymore. What happens????
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f cannot save prices in backend!
Post by: TeleEnte on October 24, 2012, 13:46:14 pm
Re: Joomla 2.5.7 / Virtuemart 2.0.12f cannot save prices in backend!

Please HELP!!!
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: teucg on October 25, 2012, 01:28:15 am
What claimed to be
The Solution:
Go to your sql editor and run:

UPDATE `[prefix]_virtuemart_product_prices` SET `virtuemart_shoppergroup_id`=NULL WHERE 1


Is making everything show up that was hidden for the Anonymous user, except for the price...

The actual price is still not showing up

This ISSUE is not solved
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: enoon on October 25, 2012, 08:58:45 am
@teucg It worked for my situation. If this did not solve your problem please open another thread describing the versions you are using and your current configuration.
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: grevaeg on October 25, 2012, 09:33:31 am
hi, just had the same problem, vm was updated to 2.0.12f, no prices were displayed for anonymous ones anymore. i entered a new product (which was displayed as it should, for anonymous and logged-in users), and there was a difference in sql:

found out that in sql, vm_shoppergroup_id was set to 2 for all the old products instead of null (the new one). changed it and all prices were displayed again.

Hey guys, whats the table name? cant happen to find it in sql =(

Can someone post a screenshot of correct table and settings? kinda new to this.

Thanks in advance!
Title: I even cannot save prices in backend nor store images via upload since the last
Post by: TeleEnte on October 25, 2012, 12:48:33 pm
I even cannot save prices in backend nor store images via upload since the last updates! I really have the feeling each update is a hugh step backwards.

2.0.12d : everything was fine for my understanding
2.0.12e : image upload did not work anymore. Had to upload via ftp
2.0.12f : images upload STILL doesnt work anymore PLUS cannot save prices anymore. WHAT THE HELL is this????

Why you offer an update, if its a step back in really importan function???? Who is testing the updates? Why nobody answers to this treat? Why I CANNOT OPEN A NEW TREAT????

I am getting really nervous. How can I sell if I cannot save prices???
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: sagepos on October 25, 2012, 15:04:13 pm
I set the shopper_id to null as suggested in the previous post, however, I still have the same problem.  When I login, I have prices.  When I don't login, I only have some prices, not all.
shopper_id is set to null for all my items.  What is still missing?  Is there something besides the shopper_id issue that I missed?
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: Globacide Solutions on October 26, 2012, 02:25:44 am
Hello,

After thorough investigation on this issue (which applies to ALL 2.0.12f installations), here are our findings:

In 2.0.12f they have changed two field names, in the #__virtuemart_product_prices table:

product_price_vdate -> to product_price_publish_up
product_price_edate -> to product_price_publish_down

There seem to be two issues arising from this:

1. Installing the sample data fails (this happens on every installation)

The reason behind this issue is that, although they've updated the installation SQL, and all the files using those fields, to use the new names, the VM team forgot to also update the sample data SQL file with the new field names. Thus, executing the SQL fails.

To fix this, you need to do the following:

Extract the com_virtuemart.2.0.12f_extract_first.zip package.
Extract the com_virtuemart.2.0.12f.zip package, found inside.

Edit the following files:
install/install_sample_data.sql
administrator/components/com_virtuemart/install/install_sample_data.sql

Find line 258 that reads:
INSERT INTO `#__virtuemart_product_prices` (`virtuemart_product_price_id`, `virtuemart_product_id`, `product_price`, `override`, `product_override_price`, `product_tax_id`, `product_discount_id`, `product_currency`, `product_price_vdate`, `product_price_edate`, `virtuemart_shoppergroup_id`, `price_quantity_start`, `price_quantity_end`) VALUES

AND change it to:
INSERT INTO `#__virtuemart_product_prices` (`virtuemart_product_price_id`, `virtuemart_product_id`, `product_price`, `override`, `product_override_price`, `product_tax_id`, `product_discount_id`, `product_currency`, `product_price_publish_up`, `product_price_publish_down`, `virtuemart_shoppergroup_id`, `price_quantity_start`, `price_quantity_end`) VALUES

Please note that this needs to be done on both files.

You can then simply re-pack the unpacked folder as zip, and re-install as usual.

You can also get the already fixed package here (http://www.globacide.com/com_virtuemart.2.0.12f.zip).

Please also note that if the Install Sample Data button does not appear after installation, you might need to do the following:
VirtueMart -> Configuration -> Enable database update tools -> Save
VirtueMart -> Tools -> Tools & Migration -> Reset all tables and install sample data

2. Product prices are not displaying any more (happens occasionally)

The reason is that, although the installation/update script tries to alter the corresponding table, and update the field name to their new values (product_price_publish_up and product_price_publish_down), sometimes it might fail, due to MySQL permissions, or some other reasons, and VirtueMart's new code can not identify these product price fields correctly.

To fix this, you need to use a database manager, such as phpMyAdmin, and manually rename the fields.

So, you would need to follow these steps:

- go to cPanel -> Databases -> phpMyAdmin
- select the database of your VirtueMart site, from the top-left drop-down list
- from the table list, on the left side, click on the [prefix]_virtuemart_product_prices table (where [prefix] is your specific Joomla! site prefix)
- click on the Structure tab
- check the checkboxes corresponding to the fields product_price_vdate and product_price_edate
- click on the Change link, below the fields list
- on the Column row, change the field values as following: publish_price_vdate to product_price_publish_up, and product_price_edate to product_price_publish_down
- click Save

Hope this helps someone!
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: simpsoncraig25 on October 26, 2012, 19:41:37 pm
Im not sure this fixed the issue either!

my prices dont show, and ive already installed update, wasnt sure i could sdo again.... ive checked out the table fields as you have described and they are already named correctly but do have a field type as date time....

i changed these to decimal and still no luck!!!!


i need prices please...

regards craig
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: simpsoncraig25 on October 26, 2012, 21:31:06 pm
found fix and as "NOTDAN" said

""product (which was displayed as it should, for anonymous and logged-in users), and there was a difference in sql:

found out that in sql, vm_shoppergroup_id was set to 2 for all the old products instead of null (the new one). changed it and all prices were displayed again.""

login in to ur sql editor and edit vm_shoppergroup_id to null.

cheers!
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: myopicseer on October 28, 2012, 14:53:40 pm
Having updated on my pci compliant host to vm 2.0.12f from the prior version, I lost all pricing (except when logged in to the frontend as admin, of course, and I can see all prices).

Compared my old (non pci compliant host) database value to my new pci compliant host's database (both sites are vm 2.0.12.f) and there is a difference in the value here:

tableprefix_virtuemart_shoppergroups (table) -> price_display (field):

Original Non PCI Hosting Account Value is "NULL"
New PCI Hosting Account with a different Host (Penguin Hosting) is a hyperlink value that I cannot edit, "[BLOB 1.9 KiB]".  If I click it, it wants to download a filetype .bin

So I dropped all entire table, and exported my shoppergroups table from the other dababase that had "NULL" as their price_display field values.  Still no prices showing in the frontend.  I then clicked the shopper group configuration in the backend of VM, and ticked to customize and to show all prices fro both of my existing shopper groups (anonymous and default) and saved.  Still no prices displaying, BUT, the field value in the respective shopper groups in the database set back to "[BLOB 1.9 KiB]" after saving. 

Have two days to launch this project ecom site, and now the client is wondering why their prices all of sudden won't show, and so am I.  No answers.

SIDE NOTE:

My #_virtuemart_product_prices were renamed correctly in my database when I upgraded, because I do have the fields:
'product_price_publish_up`and `product_price_publish_down`
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: myopicseer on October 28, 2012, 15:05:06 pm
ENOON's recommended solution DID work for me.  ENOON says to run an sql statement in phpMyAdmin to change one value in the database, and it does work:

UPDATE `w3nfy_virtuemart_product_prices` SET `virtuemart_shoppergroup_id`=NULL WHERE 1

The only difference is, you NEED TO DOUBLE CHECK to make sure if the existing value is in fact "1".  In my case, it was "2".  So you change the value of the WHERE parameter to match the value you find set in your virtuemart_shoppergroup_id field, in my case:

UPDATE `w3nfy_virtuemart_product_prices` SET `virtuemart_shoppergroup_id`=NULL WHERE 2

Why this occurs with this upgrade of VM, and why it apparently does not impact everyone identically, I have no idea, but it appears to be something that has to be addressed by the VM developers going forward with VM 2 updates.
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: Labomba on October 29, 2012, 12:37:46 pm
I have 2 shopper groups: -Anonymous- and -default-, after changing the value id to 1 for group default the prices for anonymous are not displayed.
How to set virtue-mart to display prices from both groups, change the article and adding it to the 2 groups doesn't change anything.
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: sagepos on October 29, 2012, 14:23:30 pm
The solution to: UPDATE `w3nfy_virtuemart_product_prices` SET `virtuemart_shoppergroup_id`=NULL
did not work for me.  All my items show NULL and prices are still not showing for anonymous or default customer groups.
What else is missing? 
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: Milbo on October 29, 2012, 14:43:01 pm
Why this occurs with this upgrade of VM, and why it apparently does not impact everyone identically, I have no idea, but it appears to be something that has to be addressed by the VM developers going forward with VM 2 updates.

The reason is quite simple. This version has already the multiprices partly implemented. I removed it, but all parts. This part works absolutly well, if you have a fresh installation of vm2. But if you migrated from vm1, old data is interfering. In vm1 all prices had to have a shoppergroup. So they are stored with a shoppergroup, usually the default shopppergroup, which is normally the vm1 shoppergroup with id 1. In vm2, we have a shoppergroup for non logged in users, so that we can use rules for non logged in users (the anonymous ones).
So vm2 is now displaying the old prices and already checking for the shoppergroups. It takes the old value 1, which is now the default group again. So anonymous dont have a price.

To change this, the best way is imho indeed to set the "UPDATE `w3nfy_virtuemart_product_prices` SET `virtuemart_shoppergroup_id`=NULL"

So we come to the problem of Sagepos, because for him it is not working. I have no clue, he may try 0. He should also use the latest product model of the svn. Please try the attached file, path is BE/models (or administrator/components/com_virtuemart/models), overwrite the existing one. It contains whole multiprices concerning the model, but it is written more robust.

[attachment cleanup by admin]
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: lipes on October 29, 2012, 15:05:11 pm
Hi.
In my case i did not upgrade from VM1. I did a fresh VM2 install some months ago (maybe since January i am doing some fresh instalations) and then taked all updates. 
When i did the last update from 2.0.12B to F .... the front end prices go away...
So i get back to version B and prices are fine yet... uff!  :-[
Should we all do that Update in SQL or wait for next stable release without do that?  ???
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: sagepos on October 29, 2012, 18:04:56 pm
The plot thickens...
I double checked the database to make sure all the `virtuemart_shoppergroup_id`=NULL and they did.
I then went to Control Panel/Configuration/Pricing and saw that I had Base Price only selected.  It was still not showing though.
I checked Final Sale Price and opened the website again.  Now I had prices.  However, Final Sale Price only.
I went back and checked Standard Price and then opened the website again, no Standard prices showed, only Final Sales Price.
I am happy to have Final Sale Price showing but any suggestions what the issue would be about the others?
This is a new VM2, it never was a VM1.
I also updated to the new product.php
I only have two shopper groups, anonymous and default.
Before v2.12f, all the prices worked fine.  ???

Thanks,
Sagepos
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: Parsimonious on October 29, 2012, 18:28:04 pm

To change this, the best way is imho indeed to set the "UPDATE `w3nfy_virtuemart_product_prices` SET `virtuemart_shoppergroup_id`=NULL"


I also did not migrate, but did a fresh install a few months ago (July?) So it seems the reason Milbo stated is not entirely correct, but the solution seemed to work for me too.

I have Joomla 2.5.7, and Virtuemart 2.12f. Only 2 shopper groups anonymous (id=1) registered (id=2) registered is set as default. I do not have shoppergroup specific price display checked.
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: Milbo on October 29, 2012, 20:11:17 pm
Oha, thanks for the correction.

Then in some older versions of vm2.0. we had the old method. sagepos do you have maybe the shoppergroup specific price display activated? Be sure disable it first, it can make a lot confusion.
Works the model I sent?
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: sagepos on October 29, 2012, 22:27:10 pm
Shopper group speciffic price display is not activated.
I have Baseprice, Final Sales Price, and Standard Price activated and only Sales Price is actually showing?
When you say 'model' are you referring to products.php?  I did install products.php and everything seems to be working fine other than the prices not showing.

Sagepos
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: ecweb on October 31, 2012, 01:02:48 am
Thanks Globacide!
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: Milbo on October 31, 2012, 10:59:09 am
Sagepos, I need to see your db, else I cant help you.
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: sagepos on October 31, 2012, 13:47:43 pm
Milbo,

What do you need access to? cpanel, administrator, FTP?   Where do I send the login info?
Send reply to: bnmoore@gmail.com

Sagepos
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: erosmessina on October 31, 2012, 16:37:42 pm
Hi Guys,

I ve read all your post but my problem seems to persist. I have multivendor set up in VM and when I go and add a product from the frontend it doesn t show the price. From phpadmin I seem to have the shopper_group_id set to null but I have to manually go and set each item to NULL when it shows 1 as a result. Can someone tell me how do I set the table or write a file so that the prices show automatically instead of going and manually correct it all the time?

Best,

Eros.
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: GeeJee on October 31, 2012, 20:49:30 pm
Can we please just have an update to solve this problem.
I don't want to play with my database (bad experiences with that).
This problem is now for 10 days, without any update from virtuemart!
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: AH on October 31, 2012, 21:56:57 pm
Not solved for some.
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: WVQ on November 01, 2012, 19:32:14 pm
The problem persists only in one of my sites. I have two sites almost identical. One works fine and the other doesn't show the prices. I have put into practice all what people suggests on previous posts but doesn't work.

Does anybody from the VM team has an idea about expected update date?
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: RevoLion on November 06, 2012, 00:38:13 am
I have done the suggestions above, but my prices and add to cart buttons and custom fields are gone now that I have done an update. Why would they release an update without testing it first. We spend so much time creating a nice VM website and then do an update that messes it all up and gets clients mad at us. Please help me to fix as my client is pissed, I have done everything suggestion with still no luck. I love VM, just need to figure out how to fix.... desperately.
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: randy222 on November 08, 2012, 22:50:09 pm
HI. I insert the products with CSVI, but the prices do not vedono.Se write them in but I do see them, you can also see the prices of the drill stairs etc. .. I understand that to help freelancers and agencies do not you do a quick update, but this is not correct-sorry THANKS
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: tommy_armitage on November 10, 2012, 16:51:01 pm
Hi,

I am having the same issue any word on a fix yet ?

Thanks
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: jaymokurtz12 on November 12, 2012, 08:15:55 am
hi
am having the same problem after updating VirtueMart to version 2.0.12f .. prices not showing and customised fields also not showing on frontend but showing on backend.

HOW DO I SOLVE THIS PROBLEM??? Anybody who can help ? i really need to finish this project

thanx in advance
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: John2400 on November 12, 2012, 08:21:45 am
2.0.13 test , test version is out - maybe try that.

I just did and my prices returned. -
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: jaymokurtz12 on November 12, 2012, 08:33:50 am
hi john
 and why is not shwing on my joomla control panel ... because earlier if there was any update it was showing .. UPDATE AVAILABLE !!!
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: John2400 on November 12, 2012, 08:43:49 am
beta - or test versions - do not show there - remember test version- this is just a trial.

And when you do test - don't worry too much about the number or update you see there.

http://dev.virtuemart.net/projects/virtuemart/files
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: jaymokurtz12 on November 12, 2012, 09:38:15 am
i have done the installations but still not showing any change... what next????????
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: Milbo on November 12, 2012, 19:34:01 pm
The problem persists only in one of my sites. I have two sites almost identical. One works fine and the other doesn't show the prices. I have put into practice all what people suggests on previous posts but doesn't work.

Does anybody from the VM team has an idea about expected update date?

Absolutly crazy, or? At least this post shows that we do a lot tests but sometimes the 50th installations shows suddenly a new problem.

The new version is on the way, atm 2.0.13.
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: Milbo on November 12, 2012, 21:47:55 pm
I have done the suggestions above, but my prices and add to cart buttons and custom fields are gone now that I have done an update. Why would they release an update without testing it first. We spend so much time creating a nice VM website and then do an update that messes it all up and gets clients mad at us. Please help me to fix as my client is pissed, I have done everything suggestion with still no luck. I love VM, just need to figure out how to fix.... desperately. www.thehummingbirdstore.com

Yes, I can imagine, this is really fu... you maybe ask yourself, why the heck they did not directly add this line (deleting the shoppergroups)? The problem is that we added the multiple prices per product, but only partly, cause some gui stuff was missing. But we know that people already work on stores and migrated their old stuff, so we thought okey, new users have it empty anyway and if there is something in it, then it is someone migrated from vm1 and is now waiting that we add this feature. Damn, I did not thought about the people who come from vm1, but single priced. And on the other hand we "removed" it,.. just the loading of the prices is in it.

On the other hand... we had 70k downloads of the F version (Consider the data of ARS also). Compared to this,... lets assume this are 40k real downloads, real stores running or people working on it. Then we have 15 people writing here and maybe 400 with the same problem and just reading. Looks like most people were able to solve it, so it is still a problem for maybe 40 people. This is a quote of 0.1% !! I think this quote is quite well and much better than most people think, if they read in the forum.
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: tommyslade on December 05, 2012, 15:42:14 pm
Hi,
I have just upgraded from 2.0.8 to 2.0.14 and can see the prices fine in the category layout but not on the actual product details page. Please advise on how I can fix this. The site is due to go live any day now. This needs fixing first. www.roofsuperstore.co.uk

Thanks,

Tom
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: marriage_minded_man on December 09, 2012, 05:18:32 am
Newbie here. I'm exhausted from reading this thread.

I have recently installed, VM 2.0.14 with Joomla 2.5.8.

The "Base Price" only shows for logged in users and not anonymous users. But when logged in, the "Base Price", shows fine.

I can reinstall the whole thing, just tell me exactly what to do in order to get a fresh, clean working install with this problem fixed. Thanks.
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: jenkinhill on December 09, 2012, 23:22:09 pm
Quote
The "Base Price" only shows for logged in users and not anonymous users. But when logged in, the "Base Price", shows fine.

That is correct. The base price is only to be seen by the shop administrator, and is used as the cost price from which the selling price is calculated after adding in profit margin etc.
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: marriage_minded_man on December 10, 2012, 02:00:37 am
Yes you are right, the base price seems to show only for admins logged in. However the base price with tax shows for all. What's the logic here? I don't understand. Why would you show the base price to admins only and then show the base price with tax to everyone else, when there is clearly a checkbox option in the backend to show "Baseprice" under configuration-->Pricing???

I need to be able to display the following:

MSRP: $x.xx
Our Regular Price: $x.xx
Our Sales Price: $x.xx

With the "Our Regular Price" slashed, when there is a sale price entered or a sales rule applied.

Can I add a custom MSRP field that will always display just for display purposes?

I can then use the "Base Price With Tax" (that shows to everyone, since for some reason I can't show the Base Price), as the "Our Regular Price", and when there is a sale "override" or "sale rule applied" the price gets slashed and Sales Price gets displayed?

Only problem is when there is no override/sale the wording defaults to "Sales Price" wording and does not stay consistent.

There will be no taxes on these products sold, so I don't need to worry about calculating taxes.

I hope I'm making sense. I'm really frustrated. Please help.
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: ggarmo on January 21, 2013, 21:13:07 pm
Hello All,

I am having a similar issue. I cannot save any product prices whatsoever. I know the database is communicating because if i change in phpmyadmin it reflects in backend and frontend. However, whenever i try to save from administrator nothing happens. I have fixed shopper group to NULL as it was all messed up after an update. My main reason for trying to figure this out is because I believe it is related to my issue of when you try to visit the cart I get this error:

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

After the update to 2.0.18 then downgrade to 2.0.16 because of major issues we arent even operational anymore. Entire site is basically useless.
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: ggarmo on January 22, 2013, 17:04:32 pm
realized that when the cart is empty everything works fine. it's only if there are products in the cart. any ideas>
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: rishard on January 24, 2013, 15:14:44 pm
Joomla 2.5.8, VirtueMart 2.0.18.

After upgrade VirtueMart 2.0.18a does not show the price to not authorized buyers. Advise what to do?
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: ocean1 on January 24, 2013, 23:08:13 pm
Same over here, the price is gone
When logged in we see the price again
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: jenkinhill on January 24, 2013, 23:36:27 pm
Check the shopper group set to show the prices to. If prices should be shown to all site users then the group should be left as "Please Select".


[attachment cleanup by admin]
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: rishard on January 25, 2013, 17:43:51 pm
Check the shopper group set to show the prices to. If prices should be shown to all then the group should be left as Please Select.

I'm sorry, how do I find this tab?

(http://pix.academ.org/img/2013/01/25/edd9de4cd51aa873142c2401dc46b9c8.png)
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: jenkinhill on January 25, 2013, 18:39:47 pm
That is the Product Editor, Product Information tab.
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: rishard on January 25, 2013, 18:54:01 pm
That is the Product Editor, Product Information tab.

OK, this works!
Thank you :)
Tell please, how I should act, if it is a lot of products?
I should as to edit everyone?

P.S. Joomla 2.5.8, VirtueMart 2.0.18a, php 5.3.15.
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: ocean1 on January 27, 2013, 21:15:56 pm
I found it
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: 77777 on January 28, 2013, 20:03:29 pm
maybe u can share your progress with others... i am having the same problem, prices are not displayed, dont know what to do...
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: rishard on January 28, 2013, 20:16:53 pm
maybe u can share your progress with others... i am having the same problem, prices are not displayed, dont know what to do...

The solution is found, description here (http://masterpro.ws/csv-improved-nastrojka-importa-iz-csv-fajla-v-virtuemart-prodolzhenie). Sorry, the article is in russian language. But the syntax of the sql-query is read easily. :)
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: 77777 on January 28, 2013, 21:08:06 pm
helped,thanks :)
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: Milbo on January 29, 2013, 14:52:31 pm
maybe u can share your progress with others... i am having the same problem, prices are not displayed, dont know what to do...

The solution is found, description here (http://masterpro.ws/csv-improved-nastrojka-importa-iz-csv-fajla-v-virtuemart-prodolzhenie). Sorry, the article is in russian language. But the syntax of the sql-query is read easily. :)

Thank you, the sql is
Code: [Select]
UPDATE #__virtuemart_shoppergroups SET `default` = 0 WHERE `default` = 1
Of course replace +_ with your table prefix. But this is not a real solution. You have then no standard shoppergroup. You should set a new default shoppergroup then.

The problem is imho that people have stored prices with shoppergroups.
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: jenkinhill on January 29, 2013, 15:14:30 pm
I have used this to fix sites where the user wrongly stored shoppergroup specific prices: 

UPDATE ###_virtuemart_product_prices   SET virtuemart_shoppergroup_id=NULL
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: Hubbitus on January 29, 2013, 15:39:38 pm
Of course replace +_ with your table prefix. But this is not a real solution.
Really it is dirty hack.

You have then no standard shoppergroup. You should set a new default shoppergroup then.
No! The key there to do not have default group on import because if it exists it had picked up by CVSI importer.
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: Hubbitus on January 29, 2013, 15:41:20 pm
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!
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: 77777 on January 29, 2013, 22:03:50 pm
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)
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: jenkinhill on January 30, 2013, 15:38:01 pm
You can specify shopper_group_id in CSVI when importing.
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: Stonedfury on January 31, 2013, 19:07:01 pm
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.
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: Stonedfury on January 31, 2013, 20:03:30 pm
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]
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: ggarmo on February 07, 2013, 21:46:38 pm
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
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: jusionark on February 19, 2013, 07:45:38 am
I found it
Yeah.I found it too
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: gavfrog on February 20, 2013, 18:22:59 pm
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.
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: joompiter on March 07, 2013, 11:32:22 am
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...
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: remeedella on March 19, 2013, 20:07:06 pm
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]
Title: Re: Joomla 2.5.7 / Virtuemart 2.0.12f anonymous user price not showing in front-end
Post by: remeedella on March 19, 2013, 20:08:37 pm
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]