Solr Search Index SQL table

We need to index data from SQL server to SOLR 8  using C# and Solr.NET API.

Which SQL table specifically we need to do an index for the end customer better search and also for writing solr search query. We think that it should be the Product Table.

But any idea or suggestion on this would be helpful.

There is a stored procedure in the database: ProductLoadAllPaged
See what tables/queries it uses.

Thanks for your reply,

Suppose one new product is created in admin area by the store owner.

How to index only that particular item, any idea, please

I don't know what you mean.  Indexes are on the table (columns) and are maintained automatically by the DB system as new records in table get created, or existing records whose columns are in the indexes change.

[email protected] wrote:

You need to develop separate plugin that capture entity inserted event. On this event you need to re-index your solr. it may be calling by functions or httpclient call...it depends on you.

for more info on Entity event please check below.

https://docs.nopcommerce.com/en/developer/tutorials/entity-event.html


Thank you.