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: 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