Price is Displaying as "0" (zero)

[bobthemolder]

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?

[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.

[bobthemolder]

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.

[bobthemolder]

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.