tfbpa

I wanted to do something simular, I wanted to have the admin side display the model numbers in order and after messing around a bit I found where to make necessary changes. Only 5 small changes are needed in file *catalog*/admin/optional_related_products.php Find $products = tep_db_query("select p.products_id, p.products_model, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.products_id = p.products_id and pd.language_id = '" . $languages_id . "' order by pd.products_name"); replace with: $products = tep_db_query("select p.products_id, p.products_model, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.products_id = p.products_id and pd.language_id = '" . $languages_id . "' order by p.products_model"); Do that for all 5 instances and now all is ordered by p.products_model instead of pd.products_name

Works like a charm Jack! :D I have made a small change, because I wanted the product model before my websites name, so second code is now $sortOrder['title'][$pageTags['sortorder_root']] = $the_product_info['products_model'] . ' - ' . $pageTags['page_title'] ; Thanks again Jack, your effort is much appreciated! Paul

<deleted> must test properly first...

I am trying to include the model number in the title tag, but am having some difficulties with it. Since I do not use the manufacturer anywhere, I thought it should be easy to modify those references with the model number, but alas, it is not working... I am no programmer at all, so that might be the reason :P What I tried is to change this $manStr = "select mi.manufacturers_htc_title_tag as htc_title_tag, mi.manufacturers_htc_desc_tag as htc_desc_tag, mi.manufacturers_htc_keywords_tag as htc_keywords_tag from " . TABLE_MANUFACTURERS . " m LEFT JOIN " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id where m.manufacturers_id = '" . (int)$_GET['manufacturers_id'] . "' and mi.languages_id = '" . (int)$languages_id . "'"; into $manStr = "select products_model as htc_title_tag from " . TABLE_PRODUCTS . " where products_id = '" . (int)$_GET['products_model'] . "' and language_id ='" . (int)$languages_id . "'"; and $manStr = "select mi.manufacturers_htc_title_tag as htc_title_tag, mi.manufacturers_htc_desc_tag as htc_desc_tag, mi.manufacturers_htc_keywords_tag as htc_keywords_tag from " . TABLE_MANUFACTURERS . " m LEFT JOIN " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id where m.manufacturers_id = '" . (int)$the_product_info['manufacturers_id'] . "' and mi.languages_id = '" . (int)$languages_id . "' LIMIT 1"; into $manStr = "select products_model from " . TABLE_PRODUCTS . " where products_id = '" . (int)$the_product_info['products_model'] . "'"; But unfortunately this doesn't work and breaks lots of things... Again, I have never coded before so I probably made lots of mistakes and was hoping that someone can shed some light on how to add the model number into the title tag by replacing the code for manufacturer. Thanks, Paul

I had the same problem, not sure why because the age is selected in english.php, but anyway I just hard-coded it. Is also easier when you have many different languages Look for the following code in both files $startYear=$today['year']-MAX_SELL_AGE; $endYear=$today['year']-MIN_SELL_AGE; and just fill in the years, for example like $startYear=$today['year']-100; $endYear=$today['year']-1;

it IS possible to delete products from the database by using Easy Populate See easypopulate.php around line 141 // Set the v_status field to "Delete" if you want to remove the item from the system define ('EP_DELETE_IT', 'Delete'); so this means that all the way at the end of the excel file under "v_status" you have to overwrite "Active" with "Delete"! :D

Sigh... was all my fault, somehow I forgot to change includes\database_tables.php All is working like a charm now! :D Thanks for the contribution!

Mmm, maybe I should think before I post... Since there always will and always should be a link somewhere to .../?language=en, even a fix to portafixe's code will do no good. So now my hope is that it is possible to exclude .../?language=en from being indexed by using addon "Google Duplicate Content Manager". Support thread located here http://www.oscommerce.com/forums/index.php?sho...p;gopid=1371080

Have done some thinking and maybe it's possible to change portafixe's fix to exclude the "en" language. Only problem is that I don't have a clue how to do that since I am no programmer... Can anybody help me? Here is portafixe's code: if ($this->not_null($parameters)) { $link .= $this->parse_parameters($page, $parameters, $separator); if (!(strstr($link,'language='))){ if ((strstr($link,'?')) || (strstr($link,'&'))){ $link .= '&language=' . URL_LANGUAGE; }else{ $link .= '?language=' . URL_LANGUAGE; } } } else { $link .= $page; $link .= '?language=' . URL_LANGUAGE; }

I am using Ultimate SEO Urls 2.6 together with the fix from portafixe, since I have a website which targets 7 languages and all languages should be indexed. The problem with that fix is that there now is duplicate content with my default urls (english) and ..../?language=en I found this addon, google duplicate content manager, which is very helpful for not indexing unwanted pages and was wondering if it is possible to specify that ONLY pages with ....?language=en have a noindex meta tag, while all other languages will still be indexed. Any ideas? Thanks.

I am using the 2.6 version + added the language fix from portafixe, many thanks for that! :D It is indeed very nice to have the different language pages indexed, well, to be honest it's even a must for me. Only now there is one problem... My default language is English and all links work without the attached ...?language=en to the url, but now there is a duplicate content since all pages are also available WITH the ...?language=en I have tried to use the addon "Google Duplicate Content Manager", which can add a meta tag noindex to the language pages, but then the essential fix from portafixe is not beneficial anymore. Does anybody have a fix for this? Thanks.

Hi all, I am trying to install the contribution, but am having some difficulties installing it. The error I see on my product page is this: 1146 - Table 'handmade_jewel.TABLE_PRODUCTS_RELATED_PRODUCTS' doesn't exist SELECT pop_products_id_slave, products_name, products_model, products_price, products_quantity, products_tax_class_id, products_image FROM TABLE_PRODUCTS_RELATED_PRODUCTS, products_description pa, products pb WHERE pop_products_id_slave = pa.products_id AND pa.products_id = pb.products_id AND language_id = '4' AND pop_products_id_master = '206' AND products_status='1' ORDER BY rand() [TEP STOP] I use PHP version 4.4.8 and MySQL 4.1.22-standard I did not get any errors when installing the database, but somehow it is not working. Any ideas?