smuralisankar
asked on
Creating a database from excel for a wordpress site
I would like to create a site like getapp, software advice, capterra, toptenreviews.
I have crawled the list of URLs on these sites to get a better understanding on how the site is structured.
I have sorted out the types of pages (vendor profile pages, category pages, search results page, alternative to page, comparison page, etc). I have a list of vendors for each category and a list of tags. I have the entire list of URLs/pages and have grouped them according to the type of page.
I think wordpress might be the best solution to go for here. I would like to customize wordpress to make it do what is needed here.
I do have a few themes and plugins that would help out (like reviews, listings, comparisons, ratings, etc).
I have the entire database ready for use in an excel file.
A lot of these sites don't really have detailed information on these vendors. I went to each of the vendor's site and make sure that I got every single feature they have and more detailed info. I made a very through profile and comparison.
I would like to use this excel file for creating the backend (database) of the site that I am going to build.
How do I turn this into a database that can be used for a wordpress site?
I have crawled the list of URLs on these sites to get a better understanding on how the site is structured.
I have sorted out the types of pages (vendor profile pages, category pages, search results page, alternative to page, comparison page, etc). I have a list of vendors for each category and a list of tags. I have the entire list of URLs/pages and have grouped them according to the type of page.
I think wordpress might be the best solution to go for here. I would like to customize wordpress to make it do what is needed here.
I do have a few themes and plugins that would help out (like reviews, listings, comparisons, ratings, etc).
I have the entire database ready for use in an excel file.
A lot of these sites don't really have detailed information on these vendors. I went to each of the vendor's site and make sure that I got every single feature they have and more detailed info. I made a very through profile and comparison.
I would like to use this excel file for creating the backend (database) of the site that I am going to build.
How do I turn this into a database that can be used for a wordpress site?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
No. It is not a duplicate. The explanation of the project is the same since it is the same project. But please check the end of the question. One deals with the importing of data from a CSV and creating a database. The other deals with bulk creation of pages based on data (csv or database).
ASKER
What do you mean? What do I have to know?
The database is a mysql database.
When you say correct in excel, is there anything specifc that I have to do for this like best practices, precautions, naming conventions, etc?