How to Order by random on a SQL query

You can use ORDER BY rand(), but it’s a very heavy query as a temporary table is created for it.

A WC_Product_Query or a WP_Query could be a good alternative to WPDB custom query. Both support 'orderby' => 'rand',…

Related Posts:

  1. Get WooCommerce product attribute taxonomies in a SQL query on WordPress database
  2. How to get all products from an order including variations via SQL query?
  3. get woocommerce product image url and price from database [closed]
  4. Update WooCommerce stock status with SQL query if stock value is greater than 0
  5. How to get products without tag?
  6. Woocommerce change the price of products in the database
  7. Query product’s image path by category WooCommerce database?
  8. How to speed up “My Account > Orders Page” on Site with More than 200,000 orders?
  9. Alter the cost of products using phpmyadmin sql query
  10. Woocommerce order_complete email dont send after changing order status via sql
  11. Use a woocommerce hook to create a table and populate it with a query
  12. Is it possible to extract all product columns except for one?
  13. How to get current product category ID in product archive page
  14. WooCommerce prices location in DB
  15. WP/WooCommerce REST API cart/checkout/order [closed]
  16. Fatal Error when installing woocommerce despite upgrading
  17. Adding an action within a function that is being called by add_filter
  18. Hide Add to Cart Button
  19. How to modify “[Product] has been added to your cart” in WooCommerce?
  20. woocommerce fail to replace template string in email title [closed]
  21. Why do Woocommerce templates use hooks rather than get_template_part
  22. Woocommerce checkout via external page [closed]
  23. Change font size in products listing pages in woocommerce
  24. How to stop a Gutenberg Block from firing multiple GET Requests?
  25. WooCommerce customer account multiple emails
  26. WooCommerce Product Page css
  27. Get the name of all the Items of cart in current session
  28. Change WordPress Site Title and Tagline and WooCommerce settings using ACF [closed]
  29. remove categories from product
  30. Woocommerce: custom loop in product tabs breaks reviews tab
  31. Category Tree In WooCommerce Product API
  32. Programatically Remove Item from Cart Not Working – Needs Page Refresh
  33. How to delete 1000s of duplicated images in WordPress?
  34. Set default value field meta_Value [closed]
  35. Woocommerce Product Import Automation
  36. Get posts from subcategory by parent category slug
  37. how to get jetpack’s infinite scroll to work with woocommerce?
  38. remove default pagination on woocommerce shop page
  39. WordPress Comment Box on woocommerce product page [closed]
  40. Remove Bulk Action For non admin user
  41. Add max-value to hooked quantity selector in woocommerce [closed]
  42. Can’t remove woocommerce sidebar
  43. woo product , wp_insert_post() never displays on the front end. What gives? [closed]
  44. Single product page doesn’t display price
  45. Should I use docker in wordpress production?
  46. Unable to paste google analytics con header.php [closed]
  47. can’t get the product id in single woocommerce page
  48. Php echo woocommerce price
  49. Different files for order details
  50. Multiple Schema.org markups on a single product page
  51. WooCommerce get_author_posts_url() – Author URL redirecting to shop base
  52. Error message if user is buying less than 200 euros of a given product [closed]
  53. WooCommerce show a variation both in check boxes and in a list
  54. Woocommerce – How to mix products and posts on a landing page?
  55. Disable woocommerce product search plugin’s autocomplete [closed]
  56. Add sub variations in product page
  57. Woo commerce product quantity wise SKU
  58. Override une fonction dans une class Woocommerce
  59. What to do if images are not displayed in mob. versions of the online store on wordpress?
  60. WooCommerce (Bookings) + AddOns not always calculating correctly the total
  61. Woocommerce order proceed hooks
  62. List of JS events in the WooCommerce frontend
  63. WooCommerce custom product type not saving with namespaces
  64. Add shortcode to show woocommerce shipping class name on product template
  65. Redirecting orders by company field
  66. Upload file to Woocommerce Order
  67. wp_login overriding user meta data
  68. woocommerce REST api on the website’s front-end
  69. Woocommerce List categories with Image thumbnail
  70. How to add (and change the font of) the short product description to order page and customer’s new order e-mail [closed]
  71. Display WOO Commerce products on HTML page?
  72. How to add custom text field inputs for attributes in backend?
  73. Get unsolved array keys of product data tabs in woo product editor page
  74. Show products as posts on archive page
  75. Woocommerce new shop page
  76. Add class to latest item Woocommerce
  77. WooCommerce: how to set stock per attribute on variable product
  78. How to display products in sidebar in 2 columns?
  79. Replace “Add to cart” by a link to contact page on specific product
  80. Adding price to woocommerce cart item with get_price gets multiplied with 3?
  81. Increase load-out-page speed
  82. WooCommerce Stucked (?) – Edit dimensions
  83. Use Product Attribute in conditional tag
  84. Admin – Custom Post Type in WooCommerce menu – how to control menu order
  85. Facing issue in Woocommerce 3.3 version in wordpress
  86. getting attributes in a product loop
  87. Update products, terms and relations via SQL
  88. How to Display Amount of products being displayed out of the amount in category – WordPress/Woocommerce
  89. How to programatically create a WooCommerce downloadable product?
  90. Echo SKU in WooCommerce Conformation page [closed]
  91. Custom sender email address for specific WooCommerce product
  92. Adding Extra Customer Email In Woocommerce Checkout
  93. How to override email text New Customer Order?
  94. How do I create a array custom field for use with facetwp.com?
  95. How to add my theme’s style to woocommerce blocks?
  96. Get a customer’s phone number by woocommerce
  97. Insert a custom field as a second email address to a completed order in WooCommerce
  98. Want to add Number of Products added by each shop manager in users list
  99. Titles with thumbnails in media library
  100. WooCommerce Webhook Action When a New Product Review was Submitted/Created