Tracking Gift Certificates

[fright-rags]

We tend to send out gift certificates to our good customers (for birthdays, etc) and I was wondering if there is a way to track them in the admin. I know there is a way to see if they were redeemed or not, but I would like to know if these people are ordering more than their certificate amount. The "Gift Certificates Sent" report doesn't give that info, and the sales report only gives general info. The only way I can do it is to search the order confirmation emails for "gift certificates" but that is way too time consuming. Is there any report that can do this?

[Ajeh]

You could customize the code in the file:
/your_secret_admin/stats_customers.php

with the code in RED:

  while (!$customers->EOF) {
    $rows++;

    $customers_query_gift_raw = "SELECT o.orders_id, ot.value FROM " . TABLE_ORDERS . " o, " . TABLE_ORDERS_TOTAL . " ot WHERE o.customers_id = '" . $customers->fields['customers_id'] . "' and o.orders_id = ot.orders_id and ot.class='ot_gv'";
    $customers_query_gift = $db->Execute($customers_query_gift_raw);

    if (strlen($rows) < 2) {
      $rows = '0' . $rows;
    }
?>
              <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href='<?php echo zen_href_link(FILENAME_CUSTOMERS, 'cID=' . $customers->fields['customers_id'], 'NONSSL'); ?>'">
                <td class="dataTableContent" align="right"><?php echo $customers->fields['customers_id']; ?>&nbsp;&nbsp;</td>
                <td class="dataTableContent"><?php echo '<a href="' . zen_href_link(FILENAME_CUSTOMERS, 'cID=' . $customers->fields['customers_id'], 'NONSSL') . '">' . $customers->fields['customers_firstname'] . ' ' . $customers->fields['customers_lastname'] . '</a>'; ?></td>
                <td class="dataTableContent" align="right"><?php echo $currencies->format($customers->fields['ordersum']) . '<br>GV: ' . $currencies->format($customers_query_gift->fields['value']); ?>&nbsp;</td>
              </tr>
<?php
    $customers->MoveNext();
  }
?>

[fright-rags]

Thanks so much! I'll give that a try!