Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

tracking item numbers


jadek

Recommended Posts

Posted

my site automatically assigns an "item" number to each product. When folks call my order line, I have to search the site product by product to get the item number. how do i get rid of this? my search engine does not pick up the item number. please help!!!

 

www.deedlebags.com

Posted
my site automatically assigns an "item" number to each product.  When folks call my order line, I have to search the site product by product to get the item number.  how do i get rid of this?  my search engine does not pick up the item number.  please help!!!

 

www.deedlebags.com

 

easiest would be to add the item number to your search engine in admin ... it's just a mini-mod!

 

find this in admin/categories.php:

    $products_count = 0;
   if (isset($HTTP_GET_VARS['search'])) {

 

there you will see a where clause, with the columns the search input will search in ...

add this to it:

or p.products_model like '%" . tep_db_input($search) . "%'

:-)

Monika

 

addicted to writing code ... can't get enough of databases either, LOL!

 

my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum

 

Interactive Media Award July 2007 ~ category E-Commerce

my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...