Emaze Auction: Emails">
#emailReserveMet#
">
#emailReserveNotMet#
">
SELECT Bid.bidAuto, Bid.bidPriceMaximum, Member.email
FROM Bid INNER JOIN Member ON Bid.userID = Member.userID
WHERE Bid.lotID = ##Form.lotID##
AND Bid.userID <> ##bidderUserID##
AND Member.userEmailEvents LIKE '%outbid%'
#emailReserveMetLoser#
">
SELECT Bid.bidPrice, Member.email
FROM Bid INNER JOIN Member ON Bid.userID = Member.userID
WHERE Bid.lotID = ##getCheckList.lotID## AND Bid.bidWin = 1
AND Member.userEmailEvents LIKE '%winner%'
#emailReserveExtWinner#
">
SELECT Bid.bidPrice, Member.email
FROM Bid INNER JOIN Member ON Bid.userID = Member.userID
WHERE Bid.lotID = ##getCheckList.lotID## AND Bid.bidWin = 0
AND Member.userEmailEvents LIKE '%loser%'
#emailReserveExtLoser#
">
SELECT Bid.bidPrice, Bid.bidQuantity, Member.email
FROM Bid INNER JOIN Member ON Bid.userID = Member.userID
WHERE Bid.lotID = ##lotID## AND Bid.bidWin = 1
AND Member.userEmailEvents LIKE '%loser%'
#emailReserveCloseWinner#
">
SELECT Member.email, Bid.bidQuantity, Bid.bidPrice
FROM Member INNER JOIN Bid ON Member.userID = Bid.userID
WHERE Bid.lotID = ##lotID## AND Bid.bidWin = 0
AND Member.userEmailEvents LIKE '%loser%'
#emailReserveCloseLoser#
">
#emailReserveNotMetExt#
">
#emailReserveNotMetExtMax#
">
Reserve emails updated.
Emails - Reserve Price
To update the email options, make the changes and then click on the submit button at the bottom of the page. Each email will automatically include the lot name and the appropriate bidding information.
Reserve Price Met (notify admin or seller that reserve price has been met)
Subject:
Message:
Reserve Price Not Met (notify admin or seller after lot closes that reserve price was not met)
Subject:
Message:
Reserve Price Met - Loser (notify losing bidders that reserve price has been met)
Subject:
Message:
Lot Closed - Winner (winning bid, but still less than reserve price)
Subject:
Message:
Lot Closed - Loser (losing bid, but winning bid less than reserve price)
Subject:
Message:
The following emails are only used if the option to extend the lot closing time has been turned on in the Closing Options page for the Reserve Not Met option. This includes extended the closing time and emailing the lot contact person. If these options are not checked and the lot closes with the reserve price not being met, then the above Reserve Price Not Met email will be sent instead.
Closing Time Extended - Winner (winning bid, but still less than reserve price)
Subject:
Message:
Closing Time Extended - Loser (losing bid, but winning bid less than reserve price)
Subject:
Message:
Reserve not met - closing time extended (to admin/seller)
Subject:
Message:
Reseve not met - closing time not extended as maximum extensions has been reached (to admin/seller)