Adding a searchable database: Found a solution but my theme no likey. Is there something better?

[ad_1]

Hey everyone,

I have a health and nutrition blog on WP and my theme is Acabado. I’m looking for a way to add a searchable database of nutrition info to my site. (The data is in a CSV file and has appx 1300 rows and 6 columns.)

Basically, the goal is for a visitor to type in the name of a food into the search bar and receive results showing nutritional info for that food from the CSV file. For example:

**Search Query:** Apples

**Search Result:** 1 cup of apples has 25g of carbs, 1g of protein, and 0g of fat.

(It’s also important for these results to be crawled by search engines.)

I found a plugin called [Multiple Pages Generator]) (MPG) which seems to be able to do exactly what I’m looking for. However, it doesn’t create physical pages, so you have to do [some tweaking]) to get WP to show the results. It involves editing the Search.php file and using a child theme, which I got completely lost with.

I reached out to MPG owner Themeisle for help and they suggested I contact Acabado’s developers since they are not familiar with it, however the Acabado developers do not offer 1:1 tech support.

Here are the options I see from here:

1. Keep Acabado as my theme and pay a WP pro to edit the Search.php file and whatever else necessary (and screen record it so I can learn for the future).
2. Change my theme from Acabado to one that is known to work well with MPG so I can edit the Search.php file myself using MPG’s instructions.
3. Drop MPG and find another plugin or hire a developer to custom code for me.

What do you all think? Is there another solution my newbie brain does not know about yet?

[ad_2]
1 Comment
  1. 1: create a custom post type called “nutrition facts” or something like that.

    2: add custom meta boxes for each of the columns except for the name

    3: use “wp all import” (plugin, you might need the pro version, csnt remember right now) to import the csv, map each column to its correct meta box, and create a post in our new custom post type for each row

    4: make a single-post template for that post type where you list each of the custom meta boxes you created earlier

 

This site will teach you how to build a WordPress website for beginners. We will cover everything from installing WordPress to adding pages, posts, and images to your site. You will learn how to customize your site with themes and plugins, as well as how to market your site online.

Buy WordPress Transfer