Solr Search Functionality Requirements:-
Sample product data provided :-
[login to view URL]
Files :- Create SQL tables using these files
Master Product Table :- [login to view URL]
Reseller Price and Stock Files :
[login to view URL], [login to view URL],[login to view URL]
There could be approx 400 of these dealer files, each requires a join to the main [login to view URL] and search results should only be displayed from the products relative to each dealer file.
Dataimports : Provide Dataimports to import from MS SQL 2000 from the tables above.
Product Searches :
1) Product Code :-
If someone searches on a Mfg Product Code OR Sapcode (Distributor Code) it should do an exact match and return a single record, examples :-
KK684ET#ABU
1601665
However so users might put in an incomplete code such as KK684ET, so this needs to be allowed for.
2) Text Searches :-
a) Allow for removal of plurals, ie Keyboards, iPads, Scanners
b) A term replacement facility, we have users searching for these examples :-
"all in one" when the term used in the products is "multifunction "
"Television" when the term used in the products is "TV"
"harddrives" when the term used in the products is "Hard drive"
"cat-5", when the term used in the products is "Category 5"
"100GB" when the term used in the products is "100 GB"
c) When someone searches for iPad, ensure the iPad's are top of results rather than iPad accessories
d) Spell checking and recommendation, ie Google like
Search results would return all the information from the joined tables, ie
product info from the [login to view URL], price & stock from the Solr_Dealer_?.txt
Searches should include facet results for categories ie ID1,Index1,ID2,Index2,ID3,Index3 and also Brand.
3) Category and Brand excludes from search:-
SEE DOCUMENT IN ZIP FILE
## Deliverables
Sample data file attached