• Resolved yuuffy

    (@yuuffy)


    How do you export the meta data to xls csv? We are using the Export Orders Plugin, but the plugin doesn’t add any meta keys we could add to the export order XLS/CSV?

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

    (@pimwick)

    We aren’t familiar with the Export Orders Plugin however the line item type for purchased gift cards is “pw_gift_card”.

    If you are using the WooCommerce REST API there is a field in the Orders API endpoint for redeemed gift cards (pw_gift_cards_redeemed) that is an array that contains two fields:

        "pw_gift_cards_redeemed": [
            {
                "number": "25JB-HZ6R-D8U3-PBUL",
                "amount": "10.000000"
            }
        ],

    If no gift cards were used on the order it will be an empty array:

    "pw_gift_cards_redeemed": [],

    When a gift card is purchased there is a new Order Line Item type (pw_gift_card) that contains the gift card number, amount, etc inside the Order Line Item Meta.

    Plugin Author pimwick

    (@pimwick)

    Hope this information helped, I’m marking the thread as resolved. Best of luck with your project!

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

The topic ‘Export Data to XLS/CSV?’ is closed to new replies.