after easypopulate, how to take away the model number?

[vandiike]

Hi, just populated the database, went smooth.
Now, how to take away the model number that is used as the index.
In all my products a number is displayed, which is irrelevant.

Thanks for your help.,


Mike

[vandiike]

sorry, and this of course refers to useing easy populate



Mike

[vandiike]

Well, it seams that there is no otherway than go into phpmyadmin and delete all model numbers manually.

[vandiike]

What I thought would be the better way. Locate the string where the actual adding of model number to product name takes place and delete it. I looked in product_info_tpl.php but could not find any trace of it.

[michael_s]

The problem is that if you ever want to use easypopulate again, you will not be able to.

How about just changing your product info pages and breadcrumb trail to not use the model number?

[vandiike]

That would be nice. Any leads?
To delete them perm, use in phpmyadmin;

UPDATE products SET products_model = NULL;

[michael_s]

No, the model number would still be in the database, you just wouldnt display it on your site. So, edit the product_info.tpl.php not to display it. Edit the breadcrumb trail not to display it.

You are not touching the database, just changing what you display from the query. It is a more simple solution that will allow you to continue to use easypopulate as well as give you the output you want, namely, no model numbers.

[vandiike]

It worked ok, thanks.

Here is how to do it:

in templates/content/product.info.tpl.php -delete from query: p.products_model,
in includes/application_top.php around line 500 edit out the: add the products model to the breadcrumb trail

// add the products model to the breadcrumb trail
// if (isset($HTTP_GET_VARS['products_id'])) {
// $model_query = tep_db_query("select products_model from " . TABLE_PRODUCTS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'");
// if (tep_db_num_rows($model_query)) {
// $model = tep_db_fetch_array($model_query);
// $breadcrumb->add($model['products_model'], tep_href_link(FILENAME_PRODUCT_INFO, 'cPath=' . $cPath . '&products_id=' . $HTTP_GET_VARS['products_id']));
// }
// }

Cheers

Mike