[Bodav]

2 years, 7 months ago #27677

exactly. yes
i can only search for 1 word, first or last name.
order number is not working, maybe i should sync it as number and not text?

[wpsolr]

2 years, 7 months ago #27678

Order number is the post_id. It is indexed, but used for filtering only, not for searching.
(It worked with Algolia though for any reason).

Some default post fields are searchable, like title and description, but in general searchable fields are custom fields (like the product sku).

[Bodav]

2 years, 7 months ago #27679

so search by first and last name should work no?
it works with first or last, but not first+last

[Bodav]

2 years, 7 months ago #27680

or a phone number for example

[wpsolr]

2 years, 7 months ago #27681

so search by first and last name should work no?
it works with first or last, but not first+last

Can you create an order with only English characters (to check if the English analyser is the problem), and try to find it?

[Bodav]

2 years, 7 months ago #27682

i just did that test,
i can still only search for only first or only last name. i searhed for gabi simons
WPSOLR Log query =>
Url: “/wp-admin/edit.php?ac-actions-form=1&orderby=date&order=desc&s=gabi+simons&post_status=all
&post_type=shop_order&m=0&layout=60129b0ba53cf
&_customer_user&order_delivery_date_filter&orddd_custom_startdate
&orddd_custom_enddate&cfw_order_bump_filter&action=-1&paged=1&action2=-1”
Index: “freshuk_index1”
Nb results shown: 0
Total nb results: 0
Speed: 584 ms
Query: {
“from”: 0,
“size”: 300,
“sort”: {
“date”: {
“order”: “desc”
}
},
“highlight”: {
“require_field_match”: false,
“pre_tags”: [
“”
],
“post_tags”: [
“”
],
“fields”: {
“title”: {
“fragment_size”: 50,
“number_of_fragments”: 1
},
“content”: {
“fragment_size”: 50,
“number_of_fragments”: 1
},
“comments”: {

Last seen: 2021-09-09 13:51:12 Asia/Jerusalem
Total events: 1

[wpsolr]

2 years, 7 months ago #27683

I just tested orders search with success on Elasticsearch:
– first name + last name
– phone (even partial)
– order# (contrary to my previous answer, it works!)

Did you setup your search with screen 2.3 (boosts)?

• This reply was modified 2 years, 7 months ago by wpsolr.

[Bodav]

2 years, 7 months ago #27685

tried with and without boosts.
should i put first name , last name, phone number in the boosts? with which value?
also, i don’t have the order number in the boosts field

[wpsolr]

2 years, 7 months ago #27686

I made my tests without the boosts.

[wpsolr]

2 years, 7 months ago #27687

I’d need the full query to tell you more. You sent me queries stopping at “comments”: {

[Bodav]

2 years, 7 months ago #27688

what do you mean? the log stops at comments…

[Bodav]

2 years, 7 months ago #27689

i disabled all boosts like you said and now search is working with full name and order number!!
so now we are left with the things in the trello..same as algolia but cheaper:)

[Bodav]

2 years, 7 months ago #27690

and everything is working with redis also..
amazing speed

[wpsolr]

2 years, 7 months ago #27691

Great.

[Bodav]

2 years, 7 months ago #27692

so can i will keep in trello from the point we stopped there, this time we will stick with elastic.
the product categories still got some issue so we’re at the same spot