[DONE v1.3.9d] Featured Products in Admin Area Timeout

[jdw1979]

I have 30,000 products in the inventory on my site. When I try to add featured products, the area times out and I am left looking at the nav-bar and a big blank white area. Help!

Dale

[jdw1979]

My best guess as to how to deal with this is to actually go into phpMyAdmin and make the changes to the "featured" table in the database. Is there any other tables in the database that deals with these features?

Dale

[Ajeh]

Because the Featured and Specials generate a dropdown of all products so that they can be added and this can be overwhelming in size on sites with large numbers of Products ... there is an input box for manually entering the products_id ...

Also, see if you can access the Catalog ... Products Price Manager ... or is that timing out too?

[jdw1979]

The Catalog isn't timing out, but the Products Price Manager is. Where is that input box for the products_id? I didn't see it in the featured products area, or any of the other areas. Thanks for your help, by the way.

Dale

[Ajeh]

What version of Zen Cart are you running?

When you go to Catalog ... Specials ... you should see on the right panel:

Select
Product ID to be Manually Added as a Special

Hit the button and enter your products_id that you want to add a Special to ... the same is on Featured Products ...

Without actually seeing your site, it is hard to say if the time outs are due to the 30,000 products or a slow server ...

Many of these dropdowns with all of your products listed are timing out because while they can grab the list very quickly, that list of 30,000 products has to download via the browser to you and that is the part that is timing out ...

[jdw1979]

Attached is a screenshot of what I'm looking at in the Admin on the specials page. I'm using Zen Cart version 1.3.8a, and I'm hosted by Godaddy...with what is supposed to be the best hosting package they offer.

Dale

[Ajeh]

NOTE: the same can be done for Specials in the:
/admin/specials.php

NOTE: the change is a little different for the FILENAME ...

    default:
      if (is_object($sInfo)) {
        $heading[] = array('text' => '<b>' . $sInfo->products_name . '</b>');

      if ($sInfo->products_priced_by_attribute == '1') {
        $specials_current_price = zen_get_products_base_price($sInfo->products_id);
      } else {
        $specials_current_price = $sInfo->products_price;
      }

        $contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_SPECIALS, 'page=' . $_GET['page'] . '&sID=' . $sInfo->specials_id . '&action=edit') . '">' . zen_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . zen_href_link(FILENAME_SPECIALS, 'page=' . $_GET['page'] . '&sID=' . $sInfo->specials_id . '&action=delete') . '">' . zen_image_button('button_delete.gif', IMAGE_DELETE) . '</a>');
        $contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_PRODUCTS_PRICE_MANAGER, 'action=edit&products_filter=' . $sInfo->products_id) . '">' . zen_image_button('button_products_price_manager.gif', IMAGE_PRODUCTS_PRICE_MANAGER) . '</a>');
        $contents[] = array('text' => '<br>' . TEXT_INFO_DATE_ADDED . ' ' . zen_date_short($sInfo->specials_date_added));
        $contents[] = array('text' => '' . TEXT_INFO_LAST_MODIFIED . ' ' . zen_date_short($sInfo->specials_last_modified));
        $contents[] = array('align' => 'center', 'text' => '<br>' . zen_info_image($sInfo->products_image, $sInfo->products_name, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT));
        $contents[] = array('text' => '<br>' . TEXT_INFO_ORIGINAL_PRICE . ' ' . $currencies->format($specials_current_price));
        $contents[] = array('text' => '' . TEXT_INFO_NEW_PRICE . ' ' . $currencies->format($sInfo->specials_new_products_price));
        $contents[] = array('text' => '' . TEXT_INFO_DISPLAY_PRICE . ' ' . zen_get_products_display_price($sInfo->products_id));

        $contents[] = array('text' => '<br>' . TEXT_INFO_AVAILABLE_DATE . ' <b>' . (($specials->fields['specials_date_available'] != '0001-01-01' and $specials->fields['specials_date_available'] !='') ? zen_date_short($specials->fields['specials_date_available']) : TEXT_NONE) . '</b>');
        $contents[] = array('text' => '<br>' . TEXT_INFO_EXPIRES_DATE . ' <b>' . (($specials->fields['expires_date'] != '0001-01-01' and $specials->fields['expires_date'] !='') ? zen_date_short($specials->fields['expires_date']) : TEXT_NONE) . '</b>');
        $contents[] = array('text' => '' . TEXT_INFO_STATUS_CHANGE . ' ' . zen_date_short($sInfo->date_status_change));
        $contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_CATEGORIES, '&action=new_product' . '&cPath=' . zen_get_product_path($sInfo->products_id, 'override') . '&pID=' . $sInfo->products_id . '&product_type=' . zen_get_products_type($sInfo->products_id)) . '">' . zen_image_button('button_edit_product.gif', IMAGE_EDIT_PRODUCT) . '<br />' . TEXT_PRODUCT_EDIT . '</a>');

        $contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_SPECIALS, 'action=pre_add' . ((isset($_GET['page']) && $_GET['page'] > 0) ? '&page=' . $_GET['page'] : '')) . '">' . zen_image_button('button_select.gif', IMAGE_SELECT) . '<br />' . TEXT_INFO_MANUAL . '</a><br /><br />');
      } else {
        $heading[] = array('text' => '<b>' . TEXT_NONE . '</b>');
        $contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_SPECIALS, 'action=pre_add' . ((isset($_GET['page']) && $_GET['page'] > 0) ? '&page=' . $_GET['page'] : '')) . '">' . zen_image_button('button_select.gif', IMAGE_SELECT) . '<br />' . TEXT_INFO_MANUAL . '</a><br /><br />');
      }
      break;

[jtlswan]

Sorry Linda,

Change all of it? or just add the red?

JTLS

[jtlswan]

Sorry, was editing under wordpad instead of notepad and couldn't compare...I got it...thank you, I'm trying it now to see how it works, let you know in a few...Thanks!

[jtlswan]

Well, as usual, you rock Linda...It worked without a hitch!

Thank you, thank you, thank you!

JTLS