Emaze Auction: Closing Emails">
#emailAdmin#
">
SELECT Bid.bidPrice, Bid.bidQuantityWin, Member.firstName, Member.lastName, Member.email
FROM Bid INNER JOIN Member ON Bid.userID = Member.userID
WHERE Bid.lotID = ##lotID## AND Bid.bidWin = 1
ORDER BY Bid.bidPrice, Bid.bidQuantityWin
#emailAdmin#
#emailAdminWinners#
">
#emailNoBidsClose#
">
SELECT Bid.bidPrice, Bid.bidQuantityWin, Member.email
FROM Bid INNER JOIN Member ON Bid.userID = Member.userID
WHERE Bid.lotID = ##lotID## AND Bid.bidWin = 1
AND Member.userEmailEvents LIKE '%winner%'
#emailWinner#
">
SELECT Bid.bidPrice, Bid.bidQuantity, Member.email
FROM Bid INNER JOIN Member ON Bid.userID = Member.userID
WHERE Bid.lotID = ##lotID## AND Bid.bidWin = 0
AND Member.userEmailEvents LIKE '%loser%'AND Bid.bidWin = 0
#emailLoser#
">
">
#emailNoBidsExtended#
">
#emailNoBidsExtendedMax#
">
Closing emails updated.
Closing Emails
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.
Email
From Name
Reply-to Email
Closing Lot
(leave blank for no name)
Lot Closed (email to admin/seller)
Subject:
Message without list of winning bidders (option set in Close Options screen)
Additional text for message with list of winning bidders (includes above message)
Lot closed with no bids (email to admin/seller)
Subject:
Message:
Winner (you won the bidding)
Subject:
Message:
Loser (you lost the bidding)
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 No Bids options. This includes extended the closing time and emailing the lot contact person. If these options are not checked and the lot closes with no bids, then the above Lot closed with no bids email will be sent instead.
No bids - closing time extended (to admin/seller)
Subject:
Message:
No bids - closing time not extended as maximum extensions has been reached (to admin/seller)