Linked Products Report [Support Thread]

[lat9]

A couple of file changes. First, /YOUR_ADMIN/includes/languages/english/stats_products_linked.php, adding the line below:

define ('ERROR_MISSING_PRODUCT_TYPE', '<span style="color: red;">Error:</span> Unknown product type (%1$s) for the product named <em>%2$s [%3$s]</em>.');  //-%1$s: product_type, %2$s: products_name, %3$s: products_id

Then, /YOUR_ADMIN/stats_products_linked.php, changing this section:

  foreach ($linked_products as $products_id => $product_info) {
    if ($master_category_id == $product_info['master_category_id']) {
?>
              <tr class="dataTableRow">
<?php
      if (strpos ($category_names->get_name ($master_category_id), '==>') === 0) {
?>
                <td class="dataTableContent"><span class="unknown"><?php echo $category_name; ?></span></td>
<?php
      } else {
?>
                <td class="dataTableContent"><a href="<?php echo $categories_base_link . "?cPath=$master_category_id"; ?>"><?php echo $category_name; ?></a></td>
<?php
      }
?>
                <td class="dataTableContent"><a href="<?php echo zen_href_link ($product_type_handlers[$product_info['products_type']], 'product_type=' . $product_info['products_type'] . "&amp;cPath=$master_category_id&amp;pID=$products_id&amp;action=new_product"); ?>"><?php echo $product_info['name']; ?></a></td>
                <td class="dataTableContent">

to look like the following (changes in red):

  foreach ($linked_products as $products_id => $product_info) {
    if (!isset ($product_type_handlers[$product_info['products_type']])) {
      $products_link_name = sprintf (ERROR_MISSING_PRODUCT_TYPE, $product_info['products_type'], $product_info['name'], $products_id);
      
    } else {
      $products_link_name = '<a href="' . zen_href_link ($product_type_handlers[$product_info['products_type']], 'product_type=' . $product_info['products_type'] . "&amp;cPath=$master_category_id&amp;pID=$products_id&amp;action=new_product") . '">' . $product_info['name']. '</a>';
      
    }
    if ($master_category_id == $product_info['master_category_id']) {
?>
              <tr class="dataTableRow">
<?php
      if (strpos ($category_names->get_name ($master_category_id), '==>') === 0) {
?>
                <td class="dataTableContent"><span class="unknown"><?php echo $category_name; ?></span></td>
<?php
      } else {
?>
                <td class="dataTableContent"><a href="<?php echo $categories_base_link . "?cPath=$master_category_id"; ?>"><?php echo $category_name; ?></a></td>
<?php
      }
?>
                <td class="dataTableContent"><?php echo $products_link_name; ?></td>
                <td class="dataTableContent">

That should result in an error message if the product's type value is not properly recorded in the database.

[izar74]

Hi Lat9,

thanks for the help. Now it display the following:

Error: Unknown product type () for the product named Astasuganda [239].

I've checked the database and the last produts inserted is the one with the error but all the fields are correct, even the products_type (set to 1 as all the products).

Is something related to Database??

[lat9]

Hi Lat9,

thanks for the help. Now it display the following:

Error: Unknown product type () for the product named Astasuganda [239].

I've checked the database and the last produts inserted is the one with the error but all the fields are correct, even the products_type (set to 1 as all the products).

Is something related to Database??

It's certainly something related by my mishandling of the information in the database! Is that last-product-added (ID 239) linked?

[izar74]

It's certainly something related by my mishandling of the information in the database! Is that last-product-added (ID 239) linked?

Yes it is linked in one more category