No way to export GC orders

The process is simply a copy/paste from the browser into Excel. Which step is failing?

No, that does not help me. We need to export the following fields at a minimum:
First Name
Last Name
Amount (balance)
GC #
Email address
https://help.rise.ai/en/articles/4027788-migrating-existing-gift-cards-to-rise

I see there are two db tables that show some of that info, but not all of it, and none in one table.

There are 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.

• This reply was modified 4 years, 3 months ago by pimwick.

Yes, I’ve copied and pasted the admin “table” of the gift codes, and I’ve also exported the two tables.

It has been a laborious, time-consuming, and cost-intensive process to merge all of the data for my needs.

Please add this to your list of requested improvements:
Export all gift cert purchases with: date of purchase, gift code number, purchase name, balance, expiration date, purchaser email.

Thank you for the feedback! This is something we have on our roadmap for a future update.

Let us know if we can help with anything else. Best of luck with your store!