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. Convert simple SQL Query to WordPress query
  8. Query with no terms uses index.php template instead of archive.php
  9. How to use custom taxonomies to reference complex relationships?
  10. Create a clone from one WordPress site to another in a few minutes
  11. Create template for taxonomy results limited by Custom Post Type
  12. Template for custom post with custom taxonomy
  13. WordPress Custom Post Type Children Template
  14. Getting template_include to work when allow_url_include is off?
  15. Custom post type content using custom fields without template
  16. 2 Templates 1 custom post type according url
  17. Database to page routing API?
  18. Custom taxonomy and custom post type – wrong permalinks and template
  19. Store CPT ‘Reviews’ average ratings to a WordPress DB table or to a DB custom table?
  20. Can I override a CPT template on a per post basis with Gutenberg block editor?
  21. How to change wp prefix for custom post type only?
  22. Content vs Template on custom post
  23. Is it possible to store Custom Post Type data in separate set of tables and still have wp_post class functionality?
  24. How to use custom template files in deeper directory?
  25. Assign External Database Queries to Global Variables and Make Them Accessible
  26. Add update or delete database records using custom post type
  27. WordPress Doesn’t Generate Taxonomy Archive
  28. A case for Hierarchical Custom Posts
  29. Custom taxonomy returns 404
  30. Function causing the loop display posting more (empty)
  31. Filter widget outputs
  32. Adding Page Templates to post but it ignored it
  33. Template for all categories of a custom post type?
  34. WP_Query orderby and tax_query
  35. Migrating a taxonomy’s tags to the native category
  36. Flush Rewrite Rules when new site is created on network
  37. wp_insert_post sometimes fails after API call
  38. Importing Data from a Non-WordPress database, into WP
  39. How to organise this data within WordPress
  40. WordPress custom taxonomy template not working
  41. Organize WordPress site, so it can maintain with huge database
  42. How can I get this request to use the Custom Post Type page template instead?
  43. Save custom post type to external database
  44. How to specify a template for a path like http://example.com/something?
  45. Custom templates for a specific category
  46. Archive for a Taxonomy of a Custom Post type
  47. Proper way to display latest 5 posts grouped by post type?
  48. Show data from one Custom Post Type in another Custom Post Type
  49. Custom post type pages return 404 page?
  50. WordPress 3.9 not using custom template
  51. Template files for Custom Post Type and Taxonomy
  52. Set templates for custom post types
  53. How to Create Template File for Parent Page of Custom Post Type
  54. Custom post_type search pages
  55. how to remove pages loading with the archive templates
  56. Specifying meta field’s column type in Database using add_post_meta
  57. Main query not querying any posts in custom taxonomy template
  58. Custom Empty Results page for my Custom Post Type
  59. Replace dynamically content in a custom database table when a custom post is created
  60. Custom posts template page
  61. Loop through custom posts by taxonomy and display the titles in a list, it is repeating 8 times
  62. How can I use archive-{post_type}.php theme template?
  63. Running a song lyrics site on WordPress
  64. Save and user submitted data from a form and display them in the wp backend
  65. Front end access to a SQL data repository – recommended way?
  66. Navigate posts with different post type that are in the same categories
  67. Dump custom post type database
  68. Should I use custom taxonomies or not?
  69. make permalink go to a custom single.php file
  70. Add Previous/Next Buttons to CPT Single Pages Only
  71. Designing a custom post type with a minimum number of meta fields
  72. Creating Sections for Post Types
  73. Custom post types with categories in template
  74. Creating separate feeds for custom post types
  75. Allow front end users to add data to a custom post type
  76. Which file/template is in charge of taxonomies for custom post types?
  77. How can I trace inconsistency in loading a template?
  78. Update post if exist from PHP
  79. How to get_term_meta on single custom post?
  80. WordPress hook which triggers on post import
  81. Assigning alternate single-{cpt} template based on blog_id in multisite
  82. How do I find a way to create a global single.php for a custom post type?
  83. How do I assign a block template (.html) to a custom post type?
  84. Templates for hierarchical custom post type
  85. Update all published posts at once
  86. How to use single.php for creating, reading and editing Custom Posts with ACF
  87. Custom Post Type setup
  88. Apply template by path/slug related to custom post type?
  89. assign different templates to custom post type with homepage loop
  90. How to get the current category with custom posts
  91. Custom post type is using the index.php template
  92. Assign a template to a custom post type when displayed by the main loop on the home page
  93. Entity to store contact form entries?
  94. I’m trying to create a custom version of the wp_list_authors function that includes custom post types
  95. Get template part with CPT and Custom Taxonomy conditionals
  96. Template code to split a post and print a custom field?
  97. Displaying a list of Contacts
  98. How to create a template to show child terms of a MAIN taxonomy
  99. How to change single custom post template by custom taxonomy?
  100. New post from database

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)