Metakey SQL

  • Resolved singusplatus

    (@singusplatus)


    1 year, 10 months 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)

    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)

    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.