How does this code work?

The code adds a custom button to the WooCommerce Coupons page in the WordPress admin area that, when clicked, triggers an AJAX request to export all coupons to a CSV file.

The code provides a way for administrators to easily export all WooCommerce coupons to a CSV file directly from the WordPress admin area without the need for additional plugins.

How do I install this code?

To install this code, you should add it to your theme's functions.php file or to a custom plugin. It hooks into the WordPress admin area and adds a new button for exporting coupons.

Where does the exported CSV file get saved?

The exported CSV file is saved in the WordPress uploads directory with a unique filename based on the number of coupons and the current timestamp.

How do I know the export was successful?

Upon a successful export, an alert message will pop up in the admin area indicating that the coupons were exported successfully.

What information is included in the CSV export?

The CSV file will include the coupon ID, title, discount type, coupon amount, and expiry date for each coupon.

Export WooCommerce Coupons with Custom Button


<?php

// Function to handle AJAX request
add_action("admin_footer", "add_export_coupons_button");

function add_export_coupons_button()
{
    global $current_screen;

    if ($current_screen->post_type != "shop_coupon") {
        return;
    }?>
    <script type="text/javascript">
        jQuery(document).ready(function ($) {
            var exportButton = document.createElement('button');
            exportButton.innerHTML = 'Export Coupons';
            exportButton.id = 'export-coupons';
            exportButton.classList.add('page-title-action');
            exportButton.style.marginLeft = '10px';
            exportButton.addEventListener('click', function () {
                var buttonText = this.innerHTML;
                var spinner = document.createElement('span');
                spinner.classList.add('spinner', 'is-active');
                this.innerHTML = '';
                this.appendChild(spinner);
                this.appendChild(document.createTextNode(' Loading...'));
                this.disabled = true;

                $.ajax({
                    url: ajaxurl,
                    data: {
                        action: 'export_coupons_as_csv'
                    },
                    success: function (response) {
                        alert("Coupons exported successfully!");
                        exportButton.innerHTML = buttonText;
                        exportButton.disabled = false;
                    }
                });
            });

            var pageActions = document.querySelector('.page-title-action');
            pageActions.parentNode.insertBefore(exportButton, pageActions.nextSibling);
        });
    </script>
    <?php
}

// Include necessary WordPress files
require_once ABSPATH . "wp-load.php";
require_once ABSPATH . "wp-admin/includes/file.php";
require_once ABSPATH . "wp-admin/includes/media.php";

function export_coupons_as_csv()
{
    // Get all WooCommerce Coupons
    $args = [
        "posts_per_page" => -1,
        "post_type" => "shop_coupon",
        "post_status" => "publish",
    ];

    $coupons = get_posts($args);
    $csv_data = [];

    // Prepare data for CSV
    foreach ($coupons as $coupon) {
        $coupon_meta = get_post_meta($coupon->ID);
        $csv_data[] = [
            "ID" => $coupon->ID,
            "post_title" => $coupon->post_title,
            "discount_type" => $coupon_meta["discount_type"][0],
            "coupon_amount" => $coupon_meta["coupon_amount"][0],
            "expiry_date" => $coupon_meta["date_expires"][0],
        ];
    }

    // Convert array to CSV
    $upload_dir = wp_upload_dir();
    $csv_file_path =
        $upload_dir["path"] .
        "/coupons_" .
        count($csv_data) .
        "_" .
        time() .
        ".csv";
    $fp = fopen($csv_file_path, "w");

    foreach ($csv_data as $fields) {
        fputcsv($fp, $fields);
    }

    fclose($fp);

    $filetype = wp_check_filetype(basename($csv_file_path), null);
    $filetitle = preg_replace('/\.[^.]+$/', "", basename($csv_file_path));
    $attachment = [
        "post_mime_type" => $filetype["type"],
        "post_title" => $filetitle,
        "post_content" => "",
        "post_status" => "inherit",
    ];

    $attach_id = wp_insert_attachment($attachment, $csv_file_path);
    require_once ABSPATH . "wp-admin/includes/image.php";
    $attach_data = wp_generate_attachment_metadata($attach_id, $csv_file_path);
    wp_update_attachment_metadata($attach_id, $attach_data);
}

add_action("wp_ajax_export_coupons_as_csv", "export_coupons_as_csv");
?>

export_wc_coupons.php

Frequently Asked Questions