WPSolr logo
  • Intelligence layer for WordPress
    • Multi-media Knowledge Base
    • Search
      • Algolia
      • Apache Solr
      • Elasticsearch
      • Google AI Commerce
      • OpenSearch
    • AI Search
      • OpenSearch AI
      • PostgreSQL AI
      • Vespa AI
      • Weaviate AI
    • Grounded Answers with RAG
    • AI Recommendations
      • Amazon Personalize AI
      • Recombee AI
    • AI Personalized Search & Recommendations
      • Algolia AI
      • Google AI Commerce
  • Our Work
    • WPSOLR vs other plugins
    • Brands & Agencies we  💛
    • WPSOLR Customer Success Stories
    • Documentation & Guides – Everything to get started fast
    • Youtube – 100 practical videos from setup to live site demos
    • Forums – Direct support from our team
    • Blog
  • Pricing
  • My licenses
  • Meet
  • Tel
    • US : (951) 612-8259
    • France : 01 62 04 55 85
  • Intelligence layer for WordPress
    • Multi-media Knowledge Base
    • Search
      • Algolia
      • Apache Solr
      • Elasticsearch
      • Google AI Commerce
      • OpenSearch
    • AI Search
      • OpenSearch AI
      • PostgreSQL AI
      • Vespa AI
      • Weaviate AI
    • Grounded Answers with RAG
    • AI Recommendations
      • Amazon Personalize AI
      • Recombee AI
    • AI Personalized Search & Recommendations
      • Algolia AI
      • Google AI Commerce
  • Our Work
    • WPSOLR vs other plugins
    • Brands & Agencies we  💛
    • WPSOLR Customer Success Stories
    • Documentation & Guides – Everything to get started fast
    • Youtube – 100 practical videos from setup to live site demos
    • Forums – Direct support from our team
    • Blog
  • Pricing
  • My licenses
  • Meet
  • Tel
    • US : (951) 612-8259
    • France : 01 62 04 55 85
  • Intelligence layer for WordPress
    • Multi-media Knowledge Base
    • Search
      • Algolia
      • Apache Solr
      • Elasticsearch
      • Google AI Commerce
      • OpenSearch
    • AI Search
      • OpenSearch AI
      • PostgreSQL AI
      • Vespa AI
      • Weaviate AI
    • Grounded Answers with RAG
    • AI Recommendations
      • Amazon Personalize AI
      • Recombee AI
    • AI Personalized Search & Recommendations
      • Algolia AI
      • Google AI Commerce
  • Our Work
    • WPSOLR vs other plugins
    • Brands & Agencies we  💛
    • WPSOLR Customer Success Stories
    • Documentation & Guides – Everything to get started fast
    • Youtube – 100 practical videos from setup to live site demos
    • Forums – Direct support from our team
    • Blog
  • Pricing
  • My licenses
  • Meet
  • Tel
    • US : (951) 612-8259
    • France : 01 62 04 55 85

How to index and search custom fields stored in custom tables ?

1592 views 2 November 30, 2016 Updated on July 13, 2019 admin

The problem

Let say you’re using a plugin that does not store it’s post fields in custom fields meta.
But you’d like to filter those fields, sort them, translate them, as WPSOLR does for all other custom fields.

For instance, WooCommerce product attributes and variations are stored in a custom table. The solution described below is used internally by the WPSOLR PRO WooCommerce pack to index and search them, as if they were plain custom fields of the product custom type.

The solution

As usual in WordPress, the salvation comes from code hooks. And WPSOLR comes with its own hooks.

1) Make your fields appear in the list of indexed field definitions

Use the filter Options Custom fields to add your field to the list:


array_push( $custom_fields, 'my_price' );
array_push( $custom_fields, 'my_multi_value_text' );
array_push( $custom_fields, 'my_sortable_text' );
array_push( $custom_fields, 'my_sortable_date' );

2) Select a type for your fields in screen 2.2

For field ‘my_price’, select ‘Float number’.
For field ‘my_multi_value_text’, select ‘Text, multi valued, not sortable’.
For field ‘my_sortable_text’, select ‘Text, sortable’.
For field ‘my_sortable_date’, select ‘Date, sortable’.

3) Fill your field with the post content

For that, use the filter Index custom fields:


$solarium_document_for_update[ 'my_price_f' ] = 10.2;
$solarium_document_for_update[ 'my_multi_value_text_str' ] = array('blue', 'red');
$solarium_document_for_update[ 'my_sortable_text_s' ] = 'red';
$solarium_document_for_update[ 'my_sortable_date_dt' ] = (any date here);

Conclusion

With a few lines of code, you were able to add your plugin field definitions and content in WPSOLR.
Now, you can search, filter, sort, those fields as if they were standard custom fields.

Tags:Code examplenot reviewed

Was this helpful?

2 Yes  1 No

Didn't find your answer? Contact Us

Success Stories

Built for brands and agencies worldwide

Adobe
Software Development
10K+ employees
Harvard University
Higher Education
798K alumni
University of Essex
Higher Education
101K alumni
Tally
Software development
501-1K employees
WebFX
Advertising Services
501-1K employees
DEFINITION 6
Advertising Services
1K-5K employees
Proto Thema
Newspaper Publishing
51-200 employees
The Fold London
Retail Apparel and Fashion
11-50 employees
Georgia-Pacific LLC
Paper and Forest Product Manufacturing
10K+ employees
Agencies, Software, Universities, Media, Newspapers, Publishers, Retails, Manufacturing, E-Commerce. And many more »

Recommended content

Powered by WPSOLR Enterprise with Recombee

Understand Where Your Store Is Losing Sales
Join our Affiliate Program!
Features
Search Hosting for WordPress
Multi-media Knowledge Base
Integration Hub
Search
Facets (Filters)
Search Add-ons
Recommendations
Grounded Answers with RAG
Keyword search engines
Comparison grid
Apache Solr & Solr Cloud
Elasticsearch
OpenSearch
Algolia
AI search engines
Comparison grid
PostgreSQL pgvector
Weaviate
Google Retail
Vespa.ai
OpenSearch vector
AI recommendation engines
Comparison grid
Recombee
Amazon Personalize
AI personalization engines
Comparison grid
Google Retail
Algolia
Buy and Learn
Pricing
Privacy policy
Terms and Conditions
© 2026 Eostis SARL. All Rights Reserved.
More
My licenses
Support
Documentation
Blog
Recommendations powered for you by WPSolr
Manage Consent
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
  • Manage options
  • Manage services
  • Manage {vendor_count} vendors
  • Read more about these purposes
View preferences
  • {title}
  • {title}
  • {title}