MySQL Query to Get All Coupon

MySQL query to list all the published WooCommerce 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.

Default image
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.
Articles: 18


  1. Paweł Banachowicz
    Paweł Banachowicz

    Hello. Could You please take a look:

    I saw You solved similar matter. thanks

  2. Good, this is what I was searching for in google

  3. Hello, i want to select and delete all 30 percent coupons from my database, how can i do that ?

  4. 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

  5. Thank you for this, how do I update the minimum amount field?

    I got ‘Unknown column ‘minimum_amount’ in ‘field list’ All changes were reverted (DDL statements can’t be reverted)’ when I edited using TablePlus directly from the output record.

    Thank you !

Leave a Reply to NeillCancel Reply