PHP Pro Bid

  • Status Deferred
  • Percent Complete
    0%
  • Task Type Bug Report
  • Category User End
  • Assigned To
    Mr Super User
  • Operating System
  • Severity Critical
  • Priority Very Low
  • Reported Version 7.8
  • Due in Version Undecided
  • Due Date Undecided
  • Votes
  • Private
Attached to Project: PHP Pro Bid
Opened by Antar - 27.02.2017
Last edited by Mr Super User - 01.11.2017

FS#370 - Custom fields not being searched from main search bar or keywords

I set up a custom field for books category called ISBN, the field is set to be searchable in the settings and is active.

I cannot view the listing by searching that ISBN number in the main site keyword search although it is displayed in the item specs.

The only way to search and get a hit from the database from any custom field is to use the side menu and search that specific field!

Why are custom fields not searchable from the main site search box? It totally defeats the purpose of having a custom searchable field such as UPC or ISBN.

Users who search the website for a book using a UPC or ISBN will not be able to find anything!

Antar commented on 27.02.2017 18:24
Antar commented on 28.02.2017 16:46

This is true for really basic e-commerce (industry standard fields) such as VIN for cars, HIN for boats, UPC 12, EAN 13, ISBN, MPN, MODEl Numbers, Brands, Authors for books etc...

What you end up having when such basic fields are not searchable from a site's main bar, is sellers tend to figure this out very quickly and stick the UPC and other codes into the title of the products or the subtitles and like the basic SQL theory, garbage in, garbage out. You get a site that has data where it does not belong.

Take this listing as an example: http://www.ebay.com/itm/Canon-EOS-5D-Mark-IV-DSLR-Camera-Body-Spring-Sale-/162197304001?hash=item25c3b672c1:g:8ZMAAOSw2gxYoKWQ

When the listing shows up, copy the MPN (1483C002) and paste in ebay.com index page... You see the sellers that stick the 1483C002 in their titles and others who know the proper way to do it and have the MPN field filled out.

Now, take the same mpn 1483C002 and pste in Amazon.com index page, Bestbuy.com, bandh.com and so on. All are searching theses fields from the sites root search box.

Without this, the listing will get buried on search engines.

The cheap alternative is to enable phpbidpro to search in the description where you know how that will work when you have thousands of records! Not the way to do it either.

Antar commented on 28.02.2017 16:48

I would think it would be better logic to leave that up to the users to decide on what can be searched from the site's root. You already do in the custom fields area so why not add the ability to have the user do that and declare them searchable site wide from the same admin page. From an SQL perspective, it would not make sense to have the site's main sql search statement look for data inside custom fields such as width, condition, weight and so on. At the same time, take a look at your competition and e-commerce software in general and you will see they are all including UPCs and MPNs for example in site searches. It is the industry standard. ISBN, UPC, EAN, and even VINs are very important aspects of products data and yes they are searchable from eBay's main search.

Loading...

Available keyboard shortcuts

Tasklist

Task Details

Task Editing