SKU search doesn't search option SKU's

[igavemybest]

When a an option has an SKU modifier, how do I get the SKU search to search those also? I would think this would be an obvious thing.

[mazhar]

If you are asking about SKU then read the following post
viewtopic.php?f=45&t=6972

[Robbie@FireFold]

If you are asking about SKU then read the following post
viewtopic.php?f=45&t=6972

Mazhar,

Is there any easy way to get this fix on all(if not most) search boxes?

Searching by SKU is pretty much what FireFold does.

[54x54]

Hi Mahzar, Judy; appealing o your expertise here:
On my business field the Search format is almost mandatory like this DHTML script:
http://www.dynamicdrive.com/dynamicinde ... /index.htm, and this is the example implementation http://www.wheelsandcaps.com/
I'm starting to create my products DB which I'm painlessly extracting and updating from my website Store Front 5.0 architecture and I would like to implement 2 crucial formats
1) Search by make and Model using the script above
2) And this important one! If a hubcap is the same from 1994-2000 and apply to several models under the same Manufacturer i.e. Ford, how can I get an script to enclose the period's bracket for the search in Advance Search?.
SF5.0 that support a query <!--1994,1995,1996,1997,1998,1999,2000,--> embedded on the description field as you can see in my current Store Search Box http://www.ehubcap.com/search_hubcaps.asp
and here is my dilemma on AC7 developing ehubcap Store http://65.98.245.145/Hubcaps-and-Center-Caps-C7.aspx, year on brackets but advance search wont support that script element
Hope you guys understand my non technical inquiry
thank you

[mazhar]

1) Search by make and Model using the script above

Well what you are asking sounds like some custom fields for products like product make , model blah blah... so you can use the product template for this purpose. But as i have seen the online demo provided by you and it contains the parent child relations. For example for some specific make there will be some specific vehicle types and for some vehicle type there will be some specific models and this can't be done with product templates.
So i think for this you have to create some custom tables for the above information like for make, vehicle type and model and they will contain this information for each product and will maintain the parent child hierarchy as well. You will have to write some code responsible for loading data to and from these tables. And also you may have to make some store side changes so that the custom information for each products could be shown to the customer
As for as the front end is concerned their is pretty good control which can be used for this purpose and is present in the AJAX library with AbleCommerce. Check the online demo of this from here
http://www.asp.net/AJAX/AjaxControlTool ... pDown.aspx

[jmestep]

I understand what you are wanting and the link mazhar posted is a good one. I believe that demo uses an xml file or you can use additional tables as Mazhar suggests. I tried a sample scenario using product variants, but they didn't filter each select box and the customer wouldn't know that combination wasn't available until they got a message when they tried to add it to the cart. I had started on something similar for a 5.5 store where I added three fields to the product table- you want to avoid changing the tables, normally-- and then ran SQL queries based on the what the customer selected. I've spent several hours off and on looking at it for a friend and you need something pretty customized to do it. The dropdowns wouldn't be too hard to implement, but setting up the parameters for the searches for each product would be hard to maintain unless a manufacturer can give you some kind of a spreadsheet that could be converted to xml or tables.

[54x54]

My hail to Mahzar and angel Judy, right now I watching the video tutorial for the second time to get a feel, I'm not a programmer but do a little design though, I also forwarded it to my programmer Sean from http://www.WMSmerchantservices.com and I'm confident he'll pick the scent, since he's an amazing one too
thank you all
Jose

[Sean@WMS]

As my client, Jose, has posted on this topic titled "SKU search doesn't search option SKU's", but that's not at all what his question is about, I've started a new topic here:
viewtopic.php?f=42&t=7808