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
0

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

20 09 2017
9

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.

2 thoughts on “MySQL Query to Get All Coupon”

Silvana June 22, 2018 at 3:30 pm

Good, this is what I was searching for in google
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

MySQL Query to Get All Coupon