I am planning to use wordpress as the base for my next web application. Earlier I have used RoR, Laravel etc. for web application and wordpress mainly for blogging.
The web application will define a seperate PRODUCT table (other than the default wordpress tables), and based on the url structure the data for a a particular product will be fetched.
dummy, pummy is the seo friendly name of the specific product. Under a particular url the data for the product is to shown. The legacy data (about 15000 products) will be imported into the product table.
Most of the frameworks like RoR, Laravel etc support routing, where in you can read the url and fetch the data from the database and display. So using a function in your controller you can fetch the data and display it using views.
I want to understand the best practices and how this can be implemented in wordpress. In case product is a custom post, do we create one post per product (15000 posts in this case) etc.