No Prices in Admin>Products/Categories

Hi All, I've just installed the new 1.3.7 Zencart (new install.. not upgraded yet )
So I'm looking at the 1.3.6 and the 1.3.7 on my server. I don't see the products prices listed in the admin under categories/products under the prices/special/sale column. I'm just wondering if this should show. I have the Super Orders mod installed on both catalogs and it works ok, The Email Archive mod is also installed and I'm working on an issue with the email resend there, (see another thread where I posted for that information) but all in all it works fine and both catalogs are fully functional, just thinking I boobed up on something with the prices not showing in the column. I can't find a switch for it in the admin anywhere.
:thumbsup: << This smiley should be in the top choices for ZenCart, ZC really saved my azz a lot of work and trouble. Thanks All.

I noticed the same problem (on v1.36)... I don't have super orders or any other price module installed.

I made a quick fix:

locate the file : /admin/includes/modules/category_product_listing.php

do a search for the following function call : 'zen_get_products_display_price'

replace the php code in that <td> cell with the following code:

print("$" . sprintf("%.2f", $products->fields['products_price']));

that solved the problem for me. Hope this helps.

I am not sure if this fix will be over written when you update your shopping cart, for your information.

Justin Wrote;
""
I noticed the same problem (on v1.36)... I don't have super orders or any other price module installed.
I made a quick fix:
locate the file : /admin/includes/modules/category_product_listing.php
do a search for the following function call : 'zen_get_products_display_price'
replace the php code in that <td> cell with the following code:
print("$" . sprintf("%.2f", $products->fields['products_price']));
that solved the problem for me. Hope this helps.
I am not sure if this fix will be over written when you update your shopping cart, for your information.
""

Thanks for that info, definately helpful. I'll give it a try asap.

SnowBlind

You should not need to touch the code to see prices ...

It sounds like either code is out of date or overwritten with code that changes the display or functionality of obtaining the prices ...

Check your admin code against the original code in v1.3.7 ...

I used winmerge to compare the files the only difference is the general.js file,
and that difference is the rowover functions as implemented in the superorders
install. Basically it's;

function rowOverEffect(object) {
if (object.className == 'dataTableRow') object.className = 'dataTableRowOver';
if (object.className == 'paymentRow') object.className = 'paymentRowOver';
if (object.className == 'purchaseOrderRow') object.className = 'purchaseOrderRowOver';
if (object.className == 'refundRow') object.className = 'refundRowOver';
}

function rowOutEffect(object) {
if (object.className == 'dataTableRowOver') object.className = 'dataTableRow';
if (object.className == 'paymentRowOver') object.className = 'paymentRow';
if (object.className == 'purchaseOrderRowOver') object.className = 'purchaseOrderRow';
if (object.className == 'refundRowOver') object.className = 'refundRow';
}

Not sure about coding but it doesn't look to have an effect on the prices column. Also the 1.3.6 and 1.3.7 catalogs both have the same problem on my server, both have super orders and email archive search installed so there are different files that are only in the installed folder and not in the unpacked preinstalled folder, obviously.. I'll install another without any addons and see if it does the same.

Ok, did another fresh install. I could see the prices in this fresh install until I restarted the server (full reboot) then I went into the admin and poof, the prices were gone. I suspect this is a php bug, since the prices were there and then disappeared, and that Justin's code fixes/patches the issue.:D I'll have to collect some log info to confirm, but right now it's not that great an issue IMHO.

BTW, I did not mention that the superorders changes to the order.php (which have nothing to do with pricing as I can see) are simply;

    // BEGIN Super Orders edit
    // add CC data as a line item to SO payment system
    if (zen_not_null($this->info['cc_type']) || zen_not_null($this->info['cc_owner']) || zen_not_null($this->info['cc_number'])) {
      require(DIR_WS_CLASSES . 'super_order.php');
      $so = new super_order($insert_id);
      $so->cc_line_item();
    }
    // END Super Orders edit

So I really don't think SO is the cause.