Now if I delete a purchase, and the buyer has already paid and has a receipt I  1) delete the buyer from the Items table and 2) change buyer_paid in the Buyers table to 'no.'  I also print a reminder to the auction clerk to get straight with the buyer.  This should mean that the buyer is given a refund and a new receipt is printed if some not-paid-for items remain in the buyer's shopping cart.