Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

All Products v 4.7


Recommended Posts

I've been reading the support threads for this Contrib but can not figure out how to correct the 3 issues I have based on version 4.7. Here are the 3 things I'm stuck on:


1. On my index page the link shows as BOX_INFORMATION_ALLPRODS and nothing I try changes that. I checked the english.php file but see nothing wrong there. It's identical to other coding that work fine. The link works, I'm just trying to change link text to "Product Index".


2. The 2nd issue is on the alphabetical listing. For letters in which there are no products it dispays "TEXT_NO_PRODUCTS". Again I've seen reference to this in the forum but nothing to correct that.


3. Products in more than 1 category are displayed multiple times in the All Products pages. I saw the following post but can not find the file that would be in to correct the problem.


Ok, here's the fix... The bold lines are the ones I added...


$duplicates = array();


$languages_query = tep_db_query("select languages_id, name, code, image, directory from " . TABLE_LANGUAGES . " order by sort_order");

while ($languages = tep_db_fetch_array($languages_query)) {

$languages_array[] = array('id' => $languages['languages_id'],

'name' => $languages['name'],

'code' => $languages['code'],

'image' => $languages['image'],

'directory' => $languages['directory']);


for ($i=0; $i<sizeof($languages_array); $i++) {

$this_language_id = $languages_array[$i]['id'];

$this_language_name = $languages_array[$i]['name'];

$this_language_code = $languages_array[$i]['code'];

$this_language_image = $languages_array[$i]['image'];

$this_language_directory = $languages_array[$i]['directory'];

echo " <tr>\n";




$products_query = tep_db_query("select p.products_id, p.products_model ,pd.products_name, p.products_thumbnail, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p , " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_id = p2c.products_id and c.categories_id = p2c.categories_id and products_status = '1' order by pd.products_name");



$products_array = array();

while($products = tep_db_fetch_array($products_query))


$id = $products['products_id'];

if( !isset( $duplicates[ $id ] ) ) {

$duplicates[ $id ] = true;

$products_array[] = array('id'=> $products['products_id'],

'name' => $products['products_name'],

'image' => $products['products_thumbnail'],

'manufacturer' => $products['manufacturers_name'],

'price' => $products['products_price'],

'tax' => $products['products_tax_class_id'],

'special' => $products['specials_new_products_price']);




Can anyone help with these issues?


Thanks in advance!

Link to comment
Share on other sites

For those of you that may be having the same issues, I have worked around or corrected 2 of my 3 problems. I thought I'd pass it on since, so far, no one seems to be able to give support on these.


1. The issue with BOX_INFORMATION_ALLPRODS showing as the link instead of "Product Index", per the installation instructions 5a) ADD this to catalog/includes/languages/english.php. I am sure it depends on how osCommerce was installed but I had to add this step to my english in another directory. Mine was in /includes/languages/english.php (In my root directory, NOT in my catalog/includes).


2. Since I couldn't get advise on why pages in the alphabetical listing without items showed "TEXT_NO_PRODUCTS" instead of No Items Found" or something similar I decided to correct that by just adding items to my catalog that started with a Q & Z. I know this may not work for everyone but thought it was an easy fix.


I'm still in need of figuring out how to eliminate the duplicate items in my product list. I see so many responses to questions that seem far more complicated so I can't figure out why no one can help with this.


Any help is GREATLY appreciated!

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...