VM 2.0.18a Price details dissapear unless logged in

[bob@robertclinton.com]

Using Price overrides to create volume discounts.
http://shampoohood.com.s69818.gridserver.com/product

Price and volume discount overrides display when logged in:
Price:
Base price: $19.99
Sales price: $19.99
Sales price without tax: $19.99

All price info disappears when logged out.

http://shampoohood.com.s69818.gridserver.com/log-in
u: user
p: demo

Anybody know anything about this???

[randomdev]

Hey Bob,

If its the same problem I had you have to go into your mysql database and set all your shoppergroup_id to NULL in the product_prices table (search the forum for a better description).
(the prices were set only for logged in shoppers)

[bob@robertclinton.com]

Thanks Random-

Took a look at the table:

   virtuemart_shoppergroup_id    int(11)          Yes    NULL

Opened it up and found

Name = virtuemart_shoppergroup_id
   
Type = INT
Length/Values    = 11
Default = NULL   
Collation    
Attributes    
Null    (checked)
A_I    
Comments

Do these look right? Is there something else to look for?

I'd love to get this working. The new VM has price overrides that I need for volume discounts and I haven't found a better way to do that.

Thanks again,

- Bob

[randomdev]

If all the shoppergroup_id values in the table are showing is NULL then your problem is not the same as mine (mine had a 2 for all the products prices)

If you create a new product does the price display? Do your existing products have a shoppergroup assigned to the prices in backend?

[bob@robertclinton.com]

Thanks Random D for all your interest and help!

I ended up uninstalling and reinstalling VM. Did not assign any shopper groups. Works fine now. The Price overrides work great for quantity discounts. Now I need a quantity based shipping price method.

All the best,

- Bob

[jenkinhill]

Now I need a quantity based shipping price method.

http://forum.virtuemart.net/index.php?topic=100630.0

http://forum.virtuemart.net/index.php?topic=112127.0

[bob@robertclinton.com]

Thanks jenkinhill-

Used this plugin...

http://joomdonation.com/plugins/price-shipping.html

Works like a charm.

- Bob