Export gift cards and status?

  • Resolved evmapa

    (@evmapa)


    5 years ago

    Hi! Is it possible to export a list of all bought gift cards and the remaining balance (if any)? If that isn’t possible natively, do you maybe have any hint on how to do that with e.g. a plugin like Advanced order export or similar export plugins? The list of all bought gift cards and the balance upon buying is no problem, but the current balance is giving me trouble. If this can be done natively I would be over the moon ??

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author pimwick

    (@pimwick)

    There isn’t an export available in the plugin, however there are only two tables that the gift cards use for storing information:

    wp_pimwick_gift_card
    Stores the card number, expiration date, and active flag.

    wp_pimwick_gift_card_activity
    This table contains the transaction log to record loading and redeeming the card. Columns include activity date, action, amount, and note.

    Note: it is assumed your site prefix is “wp_” (the default) however the table names may be slightly different depending on how your system is configured.

    Hope this helps, let me know if you have any other questions!

    Plugin Author pimwick

    (@pimwick)

    I’m marking this thread as resolved but let us know if you need anything else. Best of luck with your store!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Export gift cards and status?’ is closed to new replies.

Tags