Help with sorting and storing data on WordPress

Why do you want to go for a custom MYSQL database altogether?
You can simply use custom post types for products. Please check http://codex.wordpress.org/Post_Types You can add images, custom fields such as review, ratings etc.

There are many plugins that can help you create custom post types easily.
https://wordpress.org/plugins/custom-post-type-ui/
https://premium.wpmudev.org/project/custompress/

There is another plugin you can use to create a products catalog.
Check this: https://wordpress.org/plugins/wp-catalogue/

Thanks,
Faizan

Related Posts:

  1. Creating 20,000 Posts or Pages using a .csv file?
  2. How to properly insert data into custom table via plugin
  3. How does WordPress handle MySQL row lock errors?
  4. Searching users with WP_List_Table plugin
  5. Search and replace text across all posts
  6. Bad Request (Invalid Hostname) on working server, database problem
  7. Help!! I Screwed up my WP
  8. $wpdb->get_results() does not fetch results with unicode ‘WHERE’ clause
  9. Changing BIGINT to INT
  10. Replace existing pages with new pages, keep menu links
  11. Can I run multiple queries with $wpdb->prepare?
  12. wordpress in nginx docker container connected to php:8-fpm container and mariadb container isn’t creating any tables on plugin activation
  13. greatest() function returns undefined property
  14. How to determine what is generating large amount of database queries?
  15. Get post by ASC from custome field DATE picker
  16. mysqli_error() expects parameter 1 to be mysqli, null given in own db class
  17. Display data on Word Press site posts and pages from mysql table
  18. Help With MySQL to WPDB Query Conversion
  19. Creating mySQL procedure with $wpdb
  20. WpDataTables – View Image Directory
  21. get current date + 90 days and checking every day
  22. join 2 table orders wordpress plugin
  23. How do I run SQL queries on a WordPress web page? [closed]
  24. How can I perform high-level database merging for WordPress within continues delivery?
  25. 306 MB of wp_options occupied by WordPress SEO Plugin, is that normal? [closed]
  26. WordPress plugin creation how to execute .sql in order to insert multiple rows at activation of plugin
  27. Enabling WP_USE_EXT_MYSQL to support old plugin
  28. how to access all user dashboard on fronted page [closed]
  29. Insert data from .sql file in wordpress plugin
  30. WordPress + JavaScipt + AJAX + MySQL: insert query for form
  31. Automatic switch to backup database on fail
  32. SQL to order by CPT results by user->display_name w/only user->ID known
  33. Migrating to WordPress Recipe Plugin and Some SQL Issues
  34. Enabling plugin failed because MySQL user do not have CREATE permissions
  35. WordPress page and plugin list using sql query
  36. Multiple instance of data in plugin custom database table on plugin activation
  37. WP-DownloadManager – Query most download per week/month etc
  38. Better ads plugin has 500.000 entries in wp_postmeta
  39. Errors when trying to use a plugin to write to the database
  40. _prime_post_caches in wordpress
  41. pagination on data fetched using SQL query
  42. after wordpress update to 3.5+ i get many errors in plugin wpdb::prepare()
  43. Speeding SQL queries for a large database?
  44. Cannot get wpdb data (Error in a simple fuction) [closed]
  45. Mass SQL WordPress Meta Key deletion
  46. Notice: Uninitialized string offset: 0 in social sharing mu-plugin
  47. dbDelta not adding additional columns in plugin database update
  48. Using ‘mysqli_connect’ ‘crashes’ WordPress client-side
  49. Always get creating a new table with foreign key
  50. How can I fetch data from another website to my wordpress website with mysql database
  51. Getting error “Warning: mysql_query(): Can’t connect to local MySQL server through socket ‘FILEPATH/cccatalog-plugin.php on line 1656”
  52. DB Query not working in Plugin
  53. External wpdb connections in different plugins on single page
  54. Comment Approve – Add custom function when comment is approved
  55. WordPress plugin: efficient way to store large data
  56. Plugin generating unexpected output – on WP mysql dump import
  57. WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version [closed]
  58. Can’t create tables with my plugin
  59. Integrating Custom Database with WordPress
  60. How to display results from a data table with an encrypted user id?
  61. Check against server time to display SQL entries – Radio Station DJ Rotator Plugin
  62. add_action for publish_post doesn’t work
  63. WordPress Cache delete on plugin uninstall
  64. need to find duplicated meta value in custom filed and view the posts that have the same value
  65. how can we migrate wordpress 5.9 website from aws ec2 to new installed wp 5.9 oci compute
  66. JOIN and SUM different statement results (Mailster Database)
  67. My CPU usage in A2 Hosting Shared Plan (Turbo Boost) is high due to mysql query!
  68. Some error in mysql script ? Can’t working to create table
  69. How to get the custom field value using SQL query
  70. Need to know if my approach to designing a geneaology plug-in for wordpress makes sense
  71. What database state changes happen after a post is manually “updated” with no changes?
  72. WP Function does not trigger on Webhook API Call
  73. I created a plugin with ‘view page’ that uses MYSQL + PHP. When I use wp_insert_post(), it turns everything to HTML
  74. How to get database connection details without longing to cpanel in WordPress?
  75. Performing CRUD operations on front end in wordpress
  76. Display a number value from mysql query in WP
  77. WordPress UPDATE queries on MySQL database stuck
  78. Store GravityForm data in phpmyadmin (mysql)
  79. WordPress database problem wp_posts, primary key
  80. How much PHP and MySQL or MariaDB knowledge should I know to start writing WordPress themes and plug-ins and whatever else a beginner can edit?
  81. Login issue in WordPress
  82. get/show Last ID
  83. HyperDB failover Delay
  84. Resetting AUTO_INCREMENT primary key
  85. Re-writing MySQl query for execute faster
  86. Create Database Tables on Plugin Activation hook
  87. Write mysql credentials in plugin
  88. Slow WordPress admin panel with a total query time of 1664ms
  89. Linking Plugin Files to WP
  90. MySql Query for WordPress
  91. Using wp config to connect to a DB from a plugin
  92. How to display blog posts only authored by the administrator
  93. how to show the data from a myqsl database in a post [closed]
  94. Post sorting and ordering function in WordPress Admin is broken and always shows post from oldest to newest
  95. How can I delete the options from DB when the plugin is deleted?
  96. PHP Creating a formula from mysql db values and db stored math operator
  97. Share or sync user table data with another user table
  98. Split Million WordPress Post’s Into Multiple Database Server
  99. Getting 504 Gateway Timeout Error on AWS Server! [closed]
  100. WordPress issue – data is not showing in wp-admin, but when searching through database, all the data is there