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.
- Configuration Price is set to enabled.
- Products are associated with -anonymous- and -default- shopper groups, they also have the pricing enabled.
- I'm not customizing the View files for this theme
- For logged in users the prices are shown.
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:
UPDATE `[prefix]_virtuemart_product_prices` SET `virtuemart_shoppergroup_id`=NULL WHERE 1
And product prices will show up for the front-end anonymous user.
same here! :'(
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..
I see that it's a problem in product.php
but the file it's very different from verison B..
Working for me, Check a little bit more your configuration, maybe something changed on the configuration during the update.
Regards
@bytelord What else do you think I'm missing? What configurations/options?
OK for me, too. All pricing options selected for my test installation, no overrides.
@jenkinhill For you too is working?
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. ?
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.
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]
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:
(
[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
)
@notdan Thank you! Your solution works!
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
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
No overrides and configuration is ok.. :-\
it's better wait for a next release this is not "so normal".
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:
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.
A simple SQL script fixes the issue!
Please read the solution in the first post I made!
Cheers!
Hey notdan can you run me through how you did this?
Quote from: notdan on October 23, 2012, 13:25:12 PM
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.
UPDATE `[prefix]_virtuemart_product_prices` SET `virtuemart_shoppergroup_id`=NULL WHERE 1
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????
Re: Joomla 2.5.7 / Virtuemart 2.0.12f cannot save prices in backend!
Please HELP!!!
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
@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.
Quote from: 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.
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!
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???
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?
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!
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
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!
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`
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.
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.
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?
Quote from: myopicseer on October 28, 2012, 15:05:06 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]
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? ???
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
Quote from: Milbo on October 29, 2012, 14:43:01 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.
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?
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
Thanks Globacide!
Sagepos, I need to see your db, else I cant help you.
Milbo,
What do you need access to? cpanel, administrator, FTP? Where do I send the login info?
Send reply to: bnmoore@gmail.com
Sagepos
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.
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!
Not solved for some.
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?
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.
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
Hi,
I am having the same issue any word on a fix yet ?
Thanks
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
2.0.13 test , test version is out - maybe try that.
I just did and my prices returned. -
hi john
and why is not shwing on my joomla control panel ... because earlier if there was any update it was showing .. UPDATE AVAILABLE !!!
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
i have done the installations but still not showing any change... what next????????
Quote from: 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?
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.
Quote from: 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. 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.
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
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.
QuoteThe "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.
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.
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.
realized that when the cart is empty everything works fine. it's only if there are products in the cart. any ideas>
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?
Same over here, the price is gone
When logged in we see the price again
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]
Quote from: 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 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)
That is the Product Editor, Product Information tab.
Quote from: jenkinhill on January 25, 2013, 18:39:47 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.
I found it
maybe u can share your progress with others... i am having the same problem, prices are not displayed, dont know what to do...
Quote from: 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...
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. :)
helped,thanks :)
Quote from: rishard on January 28, 2013, 20:16:53 PM
Quote from: 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...
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
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.
I have used this to fix sites where the user wrongly stored shoppergroup specific prices:
UPDATE ###_virtuemart_product_prices SET virtuemart_shoppergroup_id=NULL
Quote from: Milbo on January 29, 2013, 14:52:31 PMOf course replace +_ with your table prefix. But this is not a real solution.
Really it is dirty hack.
Quote from: Milbo on January 29, 2013, 14:52:31 PM
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.
Quote from: 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
There only one problem - you should run it each time after import unfortunately!
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)
You can specify shopper_group_id in CSVI when importing.
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.
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]
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
Quote from: 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
Thanks for sharing. That saved me a good hour or two.
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...
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]
Quote from: 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]