Forums / General Questions / Price is Displaying as "0" (zero)

Price is Displaying as "0" (zero)

Started by bobthemolder on 6 Jul 2012, 2:33 AM · Views: 480

Results 1 to 4 of 4
6 Jul 2012, 2:33 AM
#1
bobthemolder avatar

bobthemolder

Zen Follower

Join Date:
Nov 2008
Posts:
164
Plugin Contributions:
0

Price is Displaying as "0" (zero)

Using a new install of V150.

I have the products all set up, displaying properly, etc - only the price is displaying as zero. Under Admin -> Products Price Manager it correctly displays the price in the Price box, but not anywhere else.

The product IS set to in-stock.
The product IS NOT set to price by attribute.
The product IS NOT set to Free.
The product IS NOT set to Call for Price.
QTY Min = 1.
QTY Max = 0.
Products_quantity is set to 999.
Store Status = 0.

I'm at a loss as to what else could be causing it to display as zero. Any ideas?

6 Jul 2012, 2:53 AM
#2
joejoejoe avatar

joejoejoe

Zen Follower

Join Date:
Oct 2011
Location:
AZ
Posts:
383
Plugin Contributions:
0

Re: Price is Displaying as "0" (zero)

There's a short tutorial for when that happens, you might find something there:

http://www.zen-cart.com/content.php?138

Good Luck.

6 Jul 2012, 10:29 AM
#3
bobthemolder avatar

bobthemolder

Zen Follower

Join Date:
Nov 2008
Posts:
164
Plugin Contributions:
0

Re: Price is Displaying as "0" (zero)

joejoejoe:

There's a short tutorial for when that happens, you might find something there:

http://www.zen-cart.com/content.php?138

Good Luck.
I hadn't seen that yet - Thanks Joe. I had been through most of those settings and none of the steps solved the problem however.

6 Jul 2012, 10:41 AM
#4
bobthemolder avatar

bobthemolder

Zen Follower

Join Date:
Nov 2008
Posts:
164
Plugin Contributions:
0

Re: Price is Displaying as "0" (zero)

I did a fresh install in a subdir and compared the DB and the only differences were the additional columns in zen_products I had from a shipping module (CanadaPost I believe) in v139. I removed those columns and prices are now displaying properly. The columns in question were:

products_weight_type enum('lbs','kgs') NOT NULL default 'lbs',
products_dim_type enum('in','cm') NOT NULL default 'in',
products_length decimal(6,2) NOT NULL default '12.00',
products_width decimal(6,2) NOT NULL default '12.00',
products_height decimal(6,2) NOT NULL default '12.00',
products_ready_to_ship enum('0','1') NOT NULL default '1'

I've copied the database a bunch of times before, to sites without the CanadaPost module installed without any problems. Even another v150 site. It's strange that it broke it here, but since the fields aren't being used anyways - I can live with them being removed.

Problem solved I guess.