We have an online store selling automotive parts and our product catalog is provided by a third party company, and unfortunately it has basically zero SEO potential. And we do not have an option to modify it.
So we need to resort to developing SEO friendly pages to represent all the various product categories and various vehicle makes and models. I have lists already prepared in Excel format that represent every Vehicle Make and Model, as well as every Product Category and type.
So we basically need to have pages that represent all possible combinations of each vehicle name and product category.
Honda Civic Alternator
Honda Civic Starter
Honda Civic Timing Belt
Honda Civic Brake Pads
Toyota Camry Alternator
Toyota Camry Starter
Nissan Maxima Alternator
Nissan Maxima Starter
.....You get the idea
So our goal would be that eventually these pages would be ranked reasonably well in the search engines, driving targeted traffic to our product catalog. We would also use them for our targeted Google Adwords campaigns.
The pages wouldn't actually show products that can be purchased, since you are required to enter into our product catalog for that (by selecting your vehicle year, make, model). But the pages would just contain general information regarding the particular product category/type and vehicle make/model.
All the content about each product category and type, we would create ourselves for these pages. Much of the product descriptions could be used dynamically across the board for the various vehicle makes and models.
How I need your Help / My Question to you guys:
Disclaimer: I am not a web developer, so forgive me if this is a simple question. That is why I need your help
What is the most efficient ways to create all these pages and manage them long-term? Since we're looking at hundreds of pages, they need to make use of dynamically generated content. Should we have a database that the stores all the information? Should we use a CMS? A friend who is a web developer thought that Wordpress might be a good solution, for example. Should we do something custom? Or just manually create a bunch of PHP pages and use PHP includes? That seems like too much work though.... seems like there should be a better way than that.
I would greatly appreciate some suggestions on how to accomplish this. If you need any further clarification from me on anything too, just let me know. I tried to keep it fairly short.