Title: Metakey SQL
Last modified: April 18, 2023

---

# Metakey SQL

 *  Resolved [singusplatus](https://wordpress.org/support/users/singusplatus/)
 * (@singusplatus)
 * [3 years, 1 month ago](https://wordpress.org/support/topic/metakey-sql/)
 * I’m trying to get the amount of discount used by the pimwick card but can’t find
   the metadata or so in SQL.
   At the end I would like to get every products where
   giftcard were used in a SQL request.Where to find the metakey ?Thanks in advance

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Author [pimwick](https://wordpress.org/support/users/pimwick/)
 * (@pimwick)
 * [3 years, 1 month ago](https://wordpress.org/support/topic/metakey-sql/#post-16674254)
 * Redeemed gift cards are stored as an Order Item. You can find this data in the
   wp_woocommerce_order_itemmeta table. Look for the type “pw_gift_card” in the 
   wp_woocommerce_order_items table.
 *  Plugin Author [pimwick](https://wordpress.org/support/users/pimwick/)
 * (@pimwick)
 * [3 years ago](https://wordpress.org/support/topic/metakey-sql/#post-16705669)
 * I am marking this thread as closed but let us know if you have any other questions.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Metakey SQL’ is closed to new replies.

 * ![](https://ps.w.org/pw-woocommerce-gift-cards/assets/icon-256x256.png?rev=1809373)
 * [PW WooCommerce Gift Cards](https://wordpress.org/plugins/pw-woocommerce-gift-cards/)
 * [Support Threads](https://wordpress.org/support/plugin/pw-woocommerce-gift-cards/)
 * [Active Topics](https://wordpress.org/support/plugin/pw-woocommerce-gift-cards/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/pw-woocommerce-gift-cards/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/pw-woocommerce-gift-cards/reviews/)

## Tags

 * [export](https://wordpress.org/support/topic-tag/export/)
 * [metakey](https://wordpress.org/support/topic-tag/metakey/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * 2 replies
 * 2 participants
 * Last reply from: [pimwick](https://wordpress.org/support/users/pimwick/)
 * Last activity: [3 years ago](https://wordpress.org/support/topic/metakey-sql/#post-16705669)
 * Status: resolved