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. Convert WordPress posts to products in WooCommerce
  7. Can I explicitly specify ENGINE=InnoDB in WordPress?
  8. Bad Request (Invalid Hostname) on working server, database problem
  9. How can I list only sites that use a particular theme or plugin?
  10. Help!! I Screwed up my WP
  11. $wpdb->get_results() does not fetch results with unicode ‘WHERE’ clause
  12. Changing BIGINT to INT
  13. Replace existing pages with new pages, keep menu links
  14. Can I run multiple queries with $wpdb->prepare?
  15. How to remove duplicate Custom Fields?
  16. wordpress in nginx docker container connected to php:8-fpm container and mariadb container isn’t creating any tables on plugin activation
  17. greatest() function returns undefined property
  18. How to write one comment and publish on every post using database or plugin?
  19. How to get number of Affected rows from wordpress dbDelta() function
  20. How to determine what is generating large amount of database queries?
  21. Get post by ASC from custome field DATE picker
  22. MySql database help for a plugin
  23. How to remove Database Table in WordPress via Function file?
  24. mysqli_error() expects parameter 1 to be mysqli, null given in own db class
  25. Bulk edit existing shortcode within custom field
  26. Display data on Word Press site posts and pages from mysql table
  27. How to simultaneously access the same MySQL database in the main column and sidebar of WordPress?
  28. Help With MySQL to WPDB Query Conversion
  29. Creating mySQL procedure with $wpdb
  30. WpDataTables – View Image Directory
  31. get current date + 90 days and checking every day
  32. join 2 table orders wordpress plugin
  33. How do I run SQL queries on a WordPress web page? [closed]
  34. How can I perform high-level database merging for WordPress within continues delivery?
  35. 306 MB of wp_options occupied by WordPress SEO Plugin, is that normal? [closed]
  36. WordPress plugin creation how to execute .sql in order to insert multiple rows at activation of plugin
  37. Plugin: register_deactivation_hook works perfectly well, while register_activation_hook suddenly stopped working
  38. Enabling WP_USE_EXT_MYSQL to support old plugin
  39. how to access all user dashboard on fronted page [closed]
  40. Insert data from .sql file in wordpress plugin
  41. WordPress + JavaScipt + AJAX + MySQL: insert query for form
  42. WordPress Backend HA (Automatic failover)
  43. Automatic switch to backup database on fail
  44. SQL to order by CPT results by user->display_name w/only user->ID known
  45. Migrating to WordPress Recipe Plugin and Some SQL Issues
  46. Enabling plugin failed because MySQL user do not have CREATE permissions
  47. WordPress page and plugin list using sql query
  48. Multiple instance of data in plugin custom database table on plugin activation
  49. WP-DownloadManager – Query most download per week/month etc
  50. Better ads plugin has 500.000 entries in wp_postmeta
  51. Errors when trying to use a plugin to write to the database
  52. _prime_post_caches in wordpress
  53. pagination on data fetched using SQL query
  54. after wordpress update to 3.5+ i get many errors in plugin wpdb::prepare()
  55. Speeding SQL queries for a large database?
  56. Cannot get wpdb data (Error in a simple fuction) [closed]
  57. Mass SQL WordPress Meta Key deletion
  58. Notice: Uninitialized string offset: 0 in social sharing mu-plugin
  59. dbDelta not adding additional columns in plugin database update
  60. Using ‘mysqli_connect’ ‘crashes’ WordPress client-side
  61. Always get creating a new table with foreign key
  62. How to do database for download stats?
  63. How can I fetch data from another website to my wordpress website with mysql database
  64. Getting error “Warning: mysql_query(): Can’t connect to local MySQL server through socket ‘FILEPATH/cccatalog-plugin.php on line 1656”
  65. DB Query not working in Plugin
  66. External wpdb connections in different plugins on single page
  67. speed up pagination for huge database
  68. Way to send multiple values for column to MySQL?
  69. Comment Approve – Add custom function when comment is approved
  70. WordPress plugin: efficient way to store large data
  71. Plugin generating unexpected output – on WP mysql dump import
  72. WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version [closed]
  73. Can’t create tables with my plugin
  74. Integrating Custom Database with WordPress
  75. How to display results from a data table with an encrypted user id?
  76. Check against server time to display SQL entries – Radio Station DJ Rotator Plugin
  77. add_action for publish_post doesn’t work
  78. Linking Plugin Files to WP
  79. MySql Query for WordPress
  80. Using wp config to connect to a DB from a plugin
  81. how to search through plugin in wordpress cimy-user-extra-fields?
  82. Get all the related data from WordPress DB
  83. How to display blog posts only authored by the administrator
  84. Trying to insert a row from a Plugin
  85. 504/502 errors plauging our site
  86. how to show the data from a myqsl database in a post [closed]
  87. Post sorting and ordering function in WordPress Admin is broken and always shows post from oldest to newest
  88. How can I delete the options from DB when the plugin is deleted?
  89. PHP Creating a formula from mysql db values and db stored math operator
  90. Share or sync user table data with another user table
  91. Split Million WordPress Post’s Into Multiple Database Server
  92. Getting 504 Gateway Timeout Error on AWS Server! [closed]
  93. WordPress issue – data is not showing in wp-admin, but when searching through database, all the data is there
  94. Remove posts that start with similar words (like a delete duplicate posts plugin)
  95. WP_Query does not return the result even if the data is present in the database
  96. Updating wp_postmeta from meta_keys and meta_values from another table having price and sku only
  97. Import posts from a different database with the same old id
  98. WP Plugin: How to avoid db access for each comment?
  99. Saving Tutor LMS plugin courses as WordPress Blog Posts in Database [closed]
  100. Lets simple destroys website
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)