Community Add-Ons

Editing product had not category. Fixed.

When clicking in any row of Product Name column, the page points to product edit page but the category of the product in this link is "missing" and it does not match to the real category that the products belongs to. You can check it above, seeing that it marks "New product in Top".

To solve this, just a few changes quite easy:

Find this:

$product_query = tep_db_query("SELECT products_name FROM products_description WHERE products_id = '" . (int)$id . "' AND language_id = '" .

($language_id > 0 ? (int)$language_id : '3') . "'");
$product = tep_db_fetch_array($product_query);

Below it you must add this:

$product_query2 = tep_db_query("SELECT categories_id FROM products_to_categories WHERE products_id = '" . (int)$id . "'");
$product2 = tep_db_fetch_array($product_query2);


And find this:

<td class="dataTableContent" align="center" width="30"><? echo $id; ?></td>
<td class="dataTableContent"><a href="<? echo tep_href_link(FILENAME_CATEGORIES, '&pID=' . $id . '&action=new_product') . '">' .

$product['products_name']; ?></a></td>
<td class="dataTableContent">

Replace with this:

<td class="dataTableContent" align="center" width="30"><? echo $id; ?></td>
<td class="dataTableContent"><a href="<? echo tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $product2[categories_id] . '&pID=' . $id .

'&action=new_product') . '">' . $product['products_name']; ?></a></td>
<td class="dataTableContent">

Sorry by muy poor English, I'm spanish.


En Español:

Al editar un producto, este no tiene categoria.

Cuando pinchas en cualquier fila de la columna Product Name, la pagina se va a la edicion del producto, pero sin categoria, es decir, esta como perdida, y en

el texto grande de arriba no se muestra la categoria real al que pertenece el producto, esto se puede comprobar viendo que arriba pone "Nuevo Producto en

Principio". Solucion facil y rapida de instalar.

To Get the admin working correctly then just add the following two lines of code to the following file.

admin/includes/languages/english.php

Add code to bottom before the final ?>

// Missing Images Report
define('BOX_REPORTS_MISSING_PICS', 'Missing Images');


Complete Package with admin Fix

To insert Missing_Pics into the Admin Panel

## After:

'<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CATALOG_CATEGORIES_PRODUCTS_ATTRIBUTES . '</a><br>' .

## Add this:

'<a href="' . tep_href_link('../missing_pics.php', '', 'NONSSL') . '" class="menuBoxContentLink">Missing Pics </a><br>' .

a function which can also be bundled with these and removes duplicate images for categories
the file is just this function......

/************************************
*Functions * find and delete duplicate pictures from the database
************************************/

function goFindDuplicates() {
$image_query = tep_db_query("select products_id, products_image, products_subimage1, products_subimage2, products_subimage3,products_subimage4,products_subimage5,products_subimage6,products_subimage7,products_subimage8, products_subimage9 from products order by products_id ");
$m = array("0","1","2","3","4","5","6","7","8","9"); // original array, all different
$m2 = array("products_image","products_subimage1","products_subimage2","products_subimage3","products_subimage4","products_subimage5","products_subimage6","products_subimage7","products_subimage8","products_subimage9"); // original array, all different
$index = 1;
while ( $m= tep_db_fetch_array($image_query)) {
$xa[0]=$m['products_image'];
if ($m['products_subimage1'] != '') $xa[1]=$m['products_subimage1'];
if ($m['products_subimage2'] != '') $xa[2]=$m['products_subimage2'];
if ($m['products_subimage3'] != '') $xa[3]=$m['products_subimage3'];
if ($m['products_subimage4'] != '') $xa[4]=$m['products_subimage4'];
if ($m['products_subimage5'] != '') $xa[5]=$m['products_subimage5'];
if ($m['products_subimage6'] != '') $xa[6]=$m['products_subimage6'];
if ($m['products_subimage7'] != '') $xa[7]=$m['products_subimage7'];
if ($m['products_subimage8'] != '') $xa[8]=$m['products_subimage8'];
if ($m['products_subimage9'] != '') $xa[9]=$m['products_subimage9'];
$uniqueArray = array_unique($xa);//only unique values
$dupArray = array_diff_assoc($xa, $uniqueArray);//duplicated values
foreach ($dupArray as $value) {
//do whatever you want here like build an assoc array.
$index = array_search($value,$xa) ;
if ($index == 0) { $xa[0]= 'ax'; // hose
$index = array_search($value,$xa); // reset
}
// echo $m['products_id'] . ", duplicate value='$value' @ " . $m2[$index] . "<br>";
// echo "update products set " . $m2[$index] . " = '' where products_id = " . $m['products_id'] . '<br>';
tep_db_query("update products set " . $m2[$index] . " = '' where products_id = " . $m['products_id'] );
}
}
}

This should have a feature to replace missing images with a default image that you set to fix broken links. Like an "Image Comming Soon" picture. Someone willing to give it a shot?

http://forums.oscommerce.com/index.php?showtopic=245994

This is based on my ORIGINAL 2.0 files and includes a few new tweaks. This includes ALL files.

DO NOT INSTALL THE "FIXES" BELOW.
There is a "missing_pics.php" language file included in the original contribution and jchasick's "fixes" involve removing all of the comments, which are necessary for those who want to configure their script. He also managed to screw up the code formatting making it almost unreadable.

** I'm glad that people can help to make contributions better, but please, if you don't know what you're doing, don't touch the contributions. **

nice contribution - this file is an update to the admin/missing_pics.php file with some fixes

I went a step further and rewrote it from the ground up, alas the version 2.0. The original version pounds the web server with requests instead of simply checking if the file exists on the server, so it was easier to just start over. This version is much quicker and less stressful on your web server and I've cleaned up the interface a little bit.

This version is also customizable if you use UltraPics or one of the other image contributions. You can configure it to pull in all product images instead of just the main image. Instructions are included on how to do just that.

This is a full package with new file names. Replace report-pic-missing.php with missing_pics.php and follow the new install instructions to update.

This version adds changes to:

admin/includes/filenames.php, admin/includes/boxes/reports.php
admin/includes/languages/english.php

to better conform to OSC standards and to make this report accessible via your admin panel. All credit goes to the original author.

This one now uses the template system of oscommerce. You no longer need to enter the database and passwords in this file. The only thing you need to do is enter you web server's image URL base.

Please delete the old one and replace with this one.

A fast report that displays products that have missing and unassigned images.

This is useful to hand over to a graphics person who can then review the list of missing images, create them and upload them to the server.

Also good to hand over to the person in charge of the inventory so that they know which products need to have images assigned to them.

The bottom of the report also display total counts for missing images an unassigned images.

This is very easy to install with one code change in the file attached to the package.