Create Pages from Database

There seems little point in creating a new post entry for each of your products if your table of products already has all of the information you wish to display.

Your best bet is to create a single page for example “Product” and then setup your own rewrite rule, using add_rewrite_rule, so that you can setup links such as /product/some-product-alias. You would then need to perform a query on the product alias to lookup the product information from your product table and then display this on the template (either use page-product.php or create a template and assign this in the admin)

There’s a little more information on setting up the redirects in this answer of mine.

Related Posts:

  1. How do I write this SQL statement for Posts written in last 24 hours?
  2. wpdb custom post_type problem
  3. Adding custom tables to WordPress
  4. How to import a custom MySQL DB table into a WordPress custom post type
  5. Custom post type and custom taxonomy key lenght & query performance
  6. Populate custom post type/custom fields from an external database
  7. Get custom post_type’s archive URL
  8. Delete all posts of a custom post type—efficiently
  9. Custom Post Types 404 Issue
  10. How to add custom content template part for a custom post type on main query using a plugin
  11. Custom Post Types, or completely custom?
  12. Template for specific post of custom post type
  13. Loading custom page template via plugin
  14. Templates for Custom Post Types and Custom Taxonomies
  15. How to use custom database tables for custom post types?
  16. Apply template to custom post type
  17. Page is defaulting to archive page and not designated template
  18. How to quickly switch custom post type singular template?
  19. Ordering Post 2 Post admin meta box by meta from CPT
  20. Using Custom Templates for Custom Post Types for the Genesis Theme Framework?
  21. Custom page type – template under page attributes?
  22. Display different gutenberg template from selected post attributes
  23. Custom post type Vs. data in own table
  24. Single page template for custom post_type
  25. Trying to manage templates on a blog with lots of custom taxonomies
  26. Remove header and footer but KEEP all css and js etc for a custom post template?
  27. How to get current post id of a custom post type in a loop using template singel-{custom type}.php?
  28. Pagination Issue: Custom Post Type In Index
  29. Create second custom 404 page for selected post type
  30. is_page_template not working as expected
  31. Query to change custom post type with specific category
  32. Mass convert MySQL data entries into custom post type?
  33. WordPress post count not showing for custom post type author
  34. Create Template for Custom Post Type same like for Page
  35. Insert post metadata for all posts in CPT at once if metadata no existent
  36. Template for custom post with custom taxonomy
  37. Custom taxonomy and custom post type – wrong permalinks and template
  38. Can I override a CPT template on a per post basis with Gutenberg block editor?
  39. Content vs Template on custom post
  40. Add update or delete database records using custom post type
  41. A case for Hierarchical Custom Posts
  42. Custom taxonomy returns 404
  43. Template for all categories of a custom post type?
  44. Flush Rewrite Rules when new site is created on network
  45. Importing Data from a Non-WordPress database, into WP
  46. Show data from one Custom Post Type in another Custom Post Type
  47. Custom post type pages return 404 page?
  48. Template files for Custom Post Type and Taxonomy
  49. make permalink go to a custom single.php file
  50. Creating Sections for Post Types
  51. Which file/template is in charge of taxonomies for custom post types?
  52. Custom post type is using the index.php template
  53. Get template part with CPT and Custom Taxonomy conditionals
  54. Template code to split a post and print a custom field?
  55. Displaying a list of Contacts
  56. How to create a template to show child terms of a MAIN taxonomy
  57. How to change single custom post template by custom taxonomy?
  58. WordPress as a frontend website for iOS app [closed]
  59. Setting a homepage – doesn’t seem to work
  60. Using custom post types WordPress network
  61. How to import database table as custom post type and custom fields?
  62. List of a specific Custom Post Type in Custom Template
  63. Require custom post type if is_admin() – template doesn’t show up?
  64. Say I have a tech blog, how best would I store technical specs for a phone, if i use custom post types
  65. Function to allow single post template based on custom taxonomy?
  66. Shortcode in pages or tempate files for custom post type
  67. How can I allow users to edit text that will be displayed on a custom post type archive page?
  68. Custom Post Type, Custom Taxonomy Template: How to get current taxonomy name?
  69. custom post types, custom fields and normalization
  70. Custom post type defaults to index.php for archive page
  71. Custom post type single page uses the right template in preview mode but shows a different template after being posted
  72. How do I force a CPT to select a shared custom template in Post Attributes?
  73. How to replicate data storage and querying using WordPress. Custom posts/fields or Custom db tables?
  74. Question on templates
  75. Assign for all post of a post type a specific single-post template
  76. Taxonomy template file not working with a taxonomy that contains a slash
  77. taxonomy – templates are not loading
  78. How can I load Template file from wordpress plugin
  79. Templates for CPT not working
  80. Changing an item in drop down after 5 latest posts per taxonomy
  81. In WordPress do I create tables for my plugin or do I create custom post types for a Student and Classes Registration system?
  82. Loading a template for a URL pattern
  83. Show Templates in Custom Post Type Editor
  84. How to enable the user to add value through the admin panel?
  85. Custom Homepage As Single Page or Custom Post Type?
  86. WordPress Custom taxonomy template
  87. Use one template for different custom post types with the same markup
  88. Custom page template not being called
  89. Pulling Content from Existing Database
  90. How to display custom post types AND regular posts separately on a shared taxonomy archive?
  91. Querying multiple taxonomies in URL leads to wrong taxonomy archive
  92. Displaying database table in backend of wordpress
  93. Custom post type pagination, single page issue
  94. Multisite – Echo admins profile meta
  95. Custom template support for custom post type?
  96. Custom Post Type Template Based on Page Slug?
  97. custom post types containing a collection of items
  98. PHP Button Custom link [closed]
  99. How can I produce multiple webpages with a different output based on one entry/Page/custom Page?
  100. Remote database access on another wordpress site’s custom post type

Leave a Comment