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. Fatal Error when installing woocommerce despite upgrading
  13. Adding an action within a function that is being called by add_filter
  14. Pass custom Checkout field value to Stripe gateway in WooCommerce
  15. woocommerce fail to replace template string in email title [closed]
  16. WooCommerce Shop Page Not Found 404
  17. How can I show an empty WooCommerce cart? [closed]
  18. Woocommerce : How to attach an custom attachment with customer-processing-order.php email template [closed]
  19. Woocommerce Pre Orders – Can i override templates?
  20. Woocommerce checkout via external page [closed]
  21. Change font size in products listing pages in woocommerce
  22. Image is not displayed in overridden woocommerce email
  23. remove categories from product
  24. WooCommerce Display Digital Download Files Type and Size
  25. woo commerce get all orders item given category
  26. Add Stripe Connect data to wc_stripe_payment_request
  27. WooCommerce get default shipping rate & conditions
  28. Using WooCommerce for payments only?
  29. Programatically Remove Item from Cart Not Working – Needs Page Refresh
  30. WooCommerce – Stock in Decimals, Using Quantity Intervals with Unique Prices [closed]
  31. Set default value field meta_Value [closed]
  32. WooCommerce Cart Link based on Cookie Values
  33. Woocommerce is_shop not on page slug? [closed]
  34. WooCommerce – Trigger Checkout Form Validation
  35. Debugging why featured images have stopped showing in WooCommerce on the homepage [closed]
  36. WooCommerce minimum order amount for specific country excluding local pickup [closed]
  37. woocommerce list product by id
  38. Woocommerce Login Redirect to old domain
  39. add sub subpage endpoint to woocommerce plugin my-account section
  40. Show Content On below single product with specific category
  41. How to change a WooCommerce Subscription Deposit and Monthly Payment? [closed]
  42. how to change the “return to shop” button text? [closed]
  43. how to scrolling image on single product page
  44. How to display WooCommerce product tag names on home and category pages
  45. Specifically Link To the “Leave a review” part of product page? [closed]
  46. Problem while adding the variable product woocommerce
  47. Woocommerce pre_get_posts query variation meta data not working
  48. Can’t hide product attributes with css on WooCommerce Product Page
  49. Updating product image
  50. Split in 2 columns add to cart button and variable forms
  51. Images not uploading on product page of woocommercr
  52. How to access WC()->cart in CF7 hook wpcf7_special_mail_tags
  53. How to integrate e-transfers with checkout in WooCommerce
  54. Woocomerce Edit source code of form in wordpress
  55. Single Product Page as a Popup
  56. Woocommerce to get restaurant table numbers in the checkout fields from the url
  57. Send all emails to Shop Manager along with admin
  58. Snippet to copy product affiliate link to a custom field
  59. UX Builder not loading for product description edits
  60. I need help with storefront theme shop page
  61. Woocommerce redirection product_name -> product_cat/product_name
  62. Woocommerce shop page not showing all products
  63. Wrong Billing Information in WC_Checkout->get_checkout_fields(‘billing’)?
  64. How to display two different custom taxonomy terms on a WooCommerce single product page
  65. Registration roles
  66. Change password notification email
  67. why my price is not showing while adding new product?
  68. How to send Woocommerce Customer Details (Name, Email and Phone Number) to Admin upon signup
  69. Sending billing details via POST request to an API
  70. how can my customers view their purchased products history like an invoice in a specific page on WordPress
  71. How do I make my products on the homepage responsive?
  72. Remove username and account password field from checkout page
  73. How to send an invoice with details to the customers
  74. Tax exclusive if coupon applied else tax inclusive in items
  75. WooCommerce Registration, Sync User, Billing and Shipping info
  76. Woocommerce on Subdirectory
  77. How to change “add to basket” button text in WooCommerce based on product category?
  78. Select all product woocommerce
  79. Woocommerce REST API: creating variations
  80. How to customize product at cart page
  81. WooCommerce Storefront site-header padding
  82. How to check which shortcode is using my template?
  83. woocommerce: when adding or removing items to cart , it takes cart a few seconds to read changes?
  84. How to get woocommerce integration instance?
  85. Create woocommerce order on new user registration
  86. How to put a date range in a virtual/downloadable product? [closed]
  87. When to use a child theme for WooCommerce Storefront?
  88. WooCommerce: Bulk Quantity in Cart
  89. Redirect whole website or pages to /wp-admin in wordpress
  90. Changing sale price programmatically, but it’s not shown on front-end
  91. Remove Span Class From Woocommerce Price
  92. Woocommerce shows empty columns [closed]
  93. Product atributes in title of order (not in description)
  94. How to create custome pdf file of my invioice in wordpress
  95. How to get sub items of parent menu item?
  96. WordPress and WooCommerce How to Assign Attribute Based Pricing
  97. unable to get product by category only getting product added lastly
  98. Storefront Child Theme show product attribute [closed]
  99. How to remove slug from Product category URL in Woocommerce
  100. Hide price, “add to cart” button and show message “Please log in to shop” [closed]