CRE Loaded Community



Board index » CRE Loaded 6.2 » Tips & Tricks

All times are UTC - 5 hours




Post new topic Reply to topic  [ 1 post ] 
Author Message
 Post subject: Search Tricks
PostPosted: Fri Feb 12, 2010 12:57 am 
Offline
CRE Newbie
User avatar

Joined: Thu Jun 11, 2009 4:47 pm
Posts: 10
I'm always hunting for simple tweaks to maximize my searching capabilities.

Here's new one: Admin> Products>Search> "Product ID"
Helps you find a product by Product ID number.

Very simple:

/admin/categories.php

Around line 3519 find

WHERE p.products_id = pd.products_id
and pd.language_id = " . (int)$languages_id . "
and p.products_id = p2c.products_id
and (pd.products_name like '%" . tep_db_input($search) . "%' or
p.products_model like '%" . tep_db_input($search) . "%')
ORDER BY p.sort_order, pd.products_name");

line after:
and (pd.products_name like '%" . tep_db_input($search) . "%' or

add:
p.products_id like '%" . tep_db_input($search) . "%' or

In between first line and next lines:
p.products_model like '%" . tep_db_input($search) . "%')
ORDER BY p.sort_order, pd.products_name");


Finished it looks like this:

WHERE p.products_id = pd.products_id
and pd.language_id = " . (int)$languages_id . "
and p.products_id = p2c.products_id
and (pd.products_name like '%" . tep_db_input($search) . "%' or
p.products_id like '%" . tep_db_input($search) . "%' or
p.products_model like '%" . tep_db_input($search) . "%')
ORDER BY p.sort_order, pd.products_name");


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 

Board index » CRE Loaded 6.2 » Tips & Tricks

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
It is currently Fri Jul 30, 2010 12:02 pm
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group

Login

Top Listing

1. Credit Card with CCV
    Category: Payment Modules
    
2. CC7333_ATS
    Category: Templates
    
3. Points & Rewards PLUS!...
    Category: Add-Ons
    
4. One Page Checkout...
    Category: Fixes
    
5. Configuration Server...
    Category: Fixes
    
Show more...

Follow Us on Twitter

@likeOMGitsFEDAY we do offer a wiki and other resources at www.creloaded.org
@smellgoodslady 6.2 is old code, we are at 6.4 now. come and get the latest.
@smellgoodslady what version/release are you running?
CRE Secure in the news: Payment News Article about Hosted Payment Pages reducing PCI friction - http://is.gd/ba0CH
@smellgoodslady yes it should work for 6.2 as well. let me know of you have any issues.

CRE Loaded Community Chat hosted by CRE Loaded.

Join now


Chat about what's on your mind. More about public chats.


© CRE Loaded is a product of Chain Reaction Ecommerce, Inc. Usage & Privacy Policy