Print Page - VM 2.0.18a Price details dissapear unless logged in

Title: VM 2.0.18a Price details dissapear unless logged in
Post by: bob@robertclinton.com on January 17, 2013, 00:42:41 AM

Using Price overrides to create volume discounts.
http://shampoohood.com.s69818.gridserver.com/product (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 (http://shampoohood.com.s69818.gridserver.com/log-in)
u: user
p: demo

Anybody know anything about this???

Title: Re: VM 2.0.18a Price details dissapear unless logged in
Post by: randomdev on January 17, 2013, 03:38:46 AM

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)

Title: Re: VM 2.0.18a Price details dissapear unless logged in
Post by: bob@robertclinton.com on January 17, 2013, 04:09:36 AM

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

Title: Re: VM 2.0.18a Price details dissapear unless logged in
Post by: randomdev on January 17, 2013, 05:15:36 AM

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?

Title: Re: VM 2.0.18a Price details dissapear unless logged in
Post by: bob@robertclinton.com on January 17, 2013, 15:40:05 PM

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

Title: Re: VM 2.0.18a Price details dissapear unless logged in
Post by: jenkinhill on January 17, 2013, 17:05:36 PM

QuoteNow 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

Title: Re: VM 2.0.18a Price details dissapear unless logged in
Post by: bob@robertclinton.com on January 17, 2013, 23:18:53 PM

Thanks jenkinhill-

Used this plugin...

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

Works like a charm.

- Bob

VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: bob@robertclinton.com on January 17, 2013, 00:42:41 AM