Metakey SQL

  • Resolved singusplatus

    (@singusplatus)


    3 years, 1 month ago

    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

    (@pimwick)

    3 years, 1 month ago

    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

    (@pimwick)

    3 years ago

    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.

  • 2 replies
  • 2 participants
  • Last reply from: pimwick
  • Last activity: 3 years ago
  • Status: resolved