MySQL Query to Get All Coupon

One of my answer in StackOverflow on Question How WooCommerce Coupons are stored in Database? has got many hits, So I thought to put a whole query in this tutorial which might help other developers.

Let me know in the comment if this helps you or not if it helps then do hit the FB like button and share with other WooCommerce developers.

About Raunak Gupta

I'm an expert Laravel, WooCommerce, WordPress theme and plugin developer, over the time I have developed several sites and applications. I like to help the upcoming developer, So I share my experience through this blog. View all posts by Raunak Gupta →

Creating Simple Product using WooCommerce CRUD

25 03 2018
6

new way of creating, updating or deleting a product or an order using CRUD method. In this tutorial, we'll be learning how to use it to create or update a product.

Keyboard Shortcuts for NetBeans, Sublime Text and PhpStorm

10 12 2017
5

keyboard hack ;) Spend time finding the correct menu for a specific action and forgot afterwards. Then why not use keyboard shortcuts which might come handy.

How to Get Order Details by Order ID

mmerce full order details by Order ID? Don't worry in this tutorial I have written one function that will help to get the details in a fraction of a second.

Multiple DB Connections in Laravel 5

06 04 2017
1

t database in Laravel or want to switch different DB connection dynamically? Then this article will solve your query.

7 thoughts on “MySQL Query to Get All Coupon”

Paweł Banachowicz March 15, 2018 at 7:59 am

Hello. Could You please take a look:

https://stackoverflow.com/questions/49290446/creating-product-while-creating-listing

I saw You solved similar matter. thanks
Reply
Silvana June 22, 2018 at 3:30 pm

Good, this is what I was searching for in google
Reply
Robert Bueno September 26, 2018 at 7:41 pm

Hello, i want to select and delete all 30 percent coupons from my database, how can i do that ?
Reply
- Raunak Gupta April 6, 2019 at 5:41 pm
  
  Hi Robert,
  
  Here is the WP_Query which will fetch all the coupon having 30% discount, now you just needs to loop it and delete it using wp_delete_post( int $postid, bool $force_delete = false )
```
$args = [
	'numberposts' => -1,
	'post_type' => 'shop_coupon',
	'meta_query' => [
		'relation' => 'AND',
		[
			'key' => 'discount_type',
			'value' => 'percent',
			'compare' => '=',
		],
		[
			'key' => 'coupon_amount',
			'value' => '30',
			'compare' => '=',
		]
	]
];

$query = new WP_Query($args);
```
  Hope it helps!
  Reply
Schalk October 8, 2018 at 3:33 pm

Hi, this is great, thank you!
Is it possible to somehow also add detail of the customer that used the coupon? Like their name or email address?
all my coupons has a usage limit of 1.

Thank you
Schalk
Reply
Andry April 15, 2019 at 9:23 am

Hi, thank for tutorial, but how to import coupon in database table?
Reply
- Raunak Gupta April 20, 2019 at 5:50 pm
  
  Hi Andry,
  
  If you run this query in phpMyAdmin then you will get an option to export the resultset in the form of CSV.
  Reply

MySQL Query to Get All Coupon