tomslattery
Member
Posted 2 years ago #
Hi!
I am developing a company intranet using WP. At the core of the site is pricing for the company's products. It comes to me in the form of a pretty lengthy Excel spreadsheet. I'm wondering of there is anything that can take that data and turn it into something viewable in the WP world.
My initial thought was to just paste the sheet into a page/post. But if somebody searches the site for a particular product number, I'm assuming the result will be the entire spreadsheet pasted into one page.
My goal is that the user can search by the product number and get that single result.
Thanks!
~TPS
My goal is that the user can search by the product number and get that single result.
That would imply either a post, or a page, for each product.
Might give this a look:
http://wordpress.org/extend/plugins/csv-importer/
s_ha_dum (was apljdi)
Member
Posted 2 years ago #
You could pull that spreadsheet into a new database table then create a page for searching and displaying data from that table. It shouldn't be too hard. You'd need a mechanism to update the product list though.
tomslattery
Member
Posted 2 years ago #
My initial test of the CSV importer concept has proven to be very useful. However, most of the fields I am importing become custom fields which do not display on the post.
Where my 'post' field is the product number, the additional fields deal with pricing and related information to that particular product.
I'm wondering how to get that additional information visible in the post.
Thanks!
~TPS
