Emaze Auction: Fees for Seller-Created Lots

Emaze Auction: Fees for Seller-Created Lots DELETE FROM Fee WHERE lotID = #lotCount#

The fees for the following lot IDs were deleted:: #Form.deleteFeeLotID#

You did not check the checkbox to verify your delete request. Please back up, check the checkbox, and re-submit the form.

UPDATE Fee SET insertionFee = 0,#Form.insertionFee#, boldFee = 0,#Form.boldFee#, featuredCategoryFee = 0,#Form.featuredCategoryFee#, featuredHomepageFee = 0,#Form.featuredHomepageFee#, commissionFee = 0,#Form.commissionFee#, insertionFeePaidDateTime = NULL,#CreateODBCDateTime(CreateDateTime(Form.insertionFeePaidDateTimeYYYY, Form.insertionFeePaidDateTimeMM, Form.insertionFeePaidDateTimeDD, 12, 00, 00))#, commissionFeePaidDateTime = NULL,#CreateODBCDateTime(CreateDateTime(Form.commissionFeePaidDateTimeYYYY, Form.commissionFeePaidDateTimeMM, Form.commissionFeePaidDateTimeDD, 12, 00, 00))#, insertionFeeInvoicedDateTime = NULL,#CreateODBCDateTime(CreateDateTime(Form.insertionFeeInvoicedDateTimeYYYY, Form.insertionFeeInvoicedDateTimeMM, Form.insertionFeeInvoicedDateTimeDD, 12, 00, 00))#, commissionFeeInvoicedDateTime = NULL#CreateODBCDateTime(CreateDateTime(Form.commissionFeeInvoicedDateTimeYYYY, Form.commissionFeeInvoicedDateTimeMM, Form.commissionFeeInvoicedDateTimeDD, 12, 00, 00))# WHERE lotID = #Form.lotID# The fee for lot #Form.lotID# and seller #Form.username# has been updated.

SELECT Fee.lotID, Fee.commissionFee, Lot.lotCloseQueue, Bid.bidPrice, Bid.bidQuantityWin FROM (Bid INNER JOIN Lot ON Bid.lotID = Lot.lotID) INNER JOIN Fee ON Bid.lotID = Fee.lotID WHERE (Fee.commissionFeeFinal <> 1 OR Fee.commissionFeeFinal IS NULL) AND Bid.bidWin = 1 ORDER BY Fee.lotID SELECT Fee.lotID, Fee.commissionFee, Buy.buyPrice, Buy.buyQuantity, Lot.lotCloseQueue, Fee.insertionFee, Fee.boldFee, Fee.featuredCategoryFee, Fee.featuredHomepageFee FROM (Buy INNER JOIN Lot ON Buy.lotID = Lot.lotID) INNER JOIN Fee ON Buy.lotID = Fee.lotID WHERE Fee.commissionFeeFinal <> 1 OR Fee.commissionFeeFinal IS NULL Seller-Created Lot Fees

Order by:
name (+) name (-) name (+) name (-) name (+) name (-) name (+) name (-) open time (+) open time (-) close time (+) close time (-) time created (+) time created (-) Seller Insertion Commission Lot Name Lot Opens Lot Closes Lot Created (ID)

SELECT Fee.lotID, Fee.lotName, Fee.insertionFee, Fee.boldFee, Fee.featuredCategoryFee, Fee.featuredHomepageFee, Fee.commissionFee, Fee.commissionFeeFinal, Member.firstName, Member.lastName, Member.email, Member.username, Fee.insertionFeePaidDateTime, Fee.commissionFeePaidDateTime, Fee.lotType FROM Fee INNER JOIN Member ON Fee.userID = Member.userID WHERE Fee.commissionFeeFinal = 0 OR Fee.commissionFeeFinal IS NULL ORDER BY #order#

There are no open seller-created lots with fees at this time.

Fees on Open Lots

View Fees: ALL | #jump# #jump# |

All Fees/ Email	Lot	Lot Name	Lot Status	Type	Seller	Insertion	Ins. Paid?	Bold	Featured On Category	Featured On Homepage	Commission	Comm. Paid?	Total
Edit	#lotID#	#lotName#	ClosedOpen	AuctProcClas	#lastName#, #firstName# (#username#)	#LSCurrencyFormat(insertionFee,"local")#	-#DateFormat(insertionFeePaidDateTime,"mm-dd-yy")#	#LSCurrencyFormat(boldFee,"local")#	#LSCurrencyFormat(featuredCategoryFee,"local")#	#LSCurrencyFormat(featuredHomepageFee,"local")#	#LSCurrencyFormat(commissionFee,"local")#	#LSCurrencyFormat(commissionFee,"local")#	-#DateFormat(commissionFeePaidDateTime,"mm-dd-yy")#	#LSCurrencyFormat(Evaluate(insertionFee + commissionFee + boldFee + featuredCategoryFee + featuredHomepageFee),"local")#
Total Fees:					#LSCurrencyFormat(totalInsertionFee,"local")#		#LSCurrencyFormat(totalBoldFee,"local")#	#LSCurrencyFormat(totalFeaturedCategoryFee,"local")#	#LSCurrencyFormat(totalFeaturedHomepageFee,"local")#	#LSCurrencyFormat(totalCommissionFee,"local")#		#LSCurrencyFormat(Evaluate(totalInsertionFee + totalCommissionFee + totalBoldFee + totalFeaturedCategoryFee + totalFeaturedHomepageFee),"local")#
Commission Fees in green indicate closed lots where final fee may change.

Checkbox must be checked to delete designated fees.

SELECT Fee.lotID, Fee.lotName, Fee.insertionFee, Fee.boldFee, Fee.featuredCategoryFee, Fee.featuredHomepageFee, Fee.commissionFee, Fee.commissionFeeFinal, Member.firstName, Member.lastName, Member.email, Member.username, Fee.insertionFeePaidDateTime, Fee.commissionFeePaidDateTime, Fee.lotType FROM Fee INNER JOIN Member ON Fee.userID = Member.userID WHERE Fee.commissionFeeFinal = 1 ORDER BY #order#

There are no closed seller-created lots with fees at this time.

Fees on Closed Lots

View Fees: ALL | #jump# #jump# |

All Fees/ Email	Lot	Lot Name	Lot Status	Type	Seller	Insertion	Ins. Paid?	Bold	Featured On Category	Featured On Homepage	Commission	Comm. Paid?	Total
Edit	#lotID#	#lotName#	ClosedOpen	AuctProcClas	#lastName#, #firstName# (#username#)	#LSCurrencyFormat(insertionFee,"local")#	-#DateFormat(insertionFeePaidDateTime,"mm-dd-yy")#	#LSCurrencyFormat(boldFee,"local")#	#LSCurrencyFormat(featuredCategoryFee,"local")#	#LSCurrencyFormat(featuredHomepageFee,"local")#	#LSCurrencyFormat(commissionFee,"local")#	#LSCurrencyFormat(commissionFee,"local")#	-#DateFormat(commissionFeePaidDateTime,"mm-dd-yy")#	#LSCurrencyFormat(Evaluate(insertionFee + commissionFee + boldFee + featuredCategoryFee + featuredHomepageFee),"local")#
Total Fees:					#LSCurrencyFormat(totalInsertionFee,"local")#		#LSCurrencyFormat(totalBoldFee,"local")#	#LSCurrencyFormat(totalFeaturedCategoryFee,"local")#	#LSCurrencyFormat(totalFeaturedHomepageFee,"local")#	#LSCurrencyFormat(totalCommissionFee,"local")#		#LSCurrencyFormat(Evaluate(totalInsertionFee + totalCommissionFee + totalBoldFee + totalFeaturedCategoryFee + totalFeaturedHomepageFee),"local")#
Commission Fees in green indicate open lots where final fee may change.

Checkbox must be checked to delete designated fees.

SELECT Member.userID, Member.username, Member.firstName, Member.lastName, Member.email, Sum(Fee.insertionFee) AS SumOfInsertionFees, Sum(Fee.boldFee) AS SumOfBoldFees, Sum(Fee.featuredCategoryFee) AS SumOfFeaturedCategoryFees, Sum(Fee.featuredHomepageFee) AS SumOfFeaturedHomepageFees, Sum(Fee.commissionFee) AS SumOfCommissionFees FROM Member INNER JOIN Fee ON Member.userID = Fee.userID GROUP BY Member.userID, Member.firstName, Member.lastName, Member.email, Member.username ORDER BY Member.lastName, Member.firstName

Aggregate Fees by Seller

View Fees: ALL | #jump# #jump# |

All Fees/
Email Seller Username Insertion Bold Featured
On Category Featured
On Homepage Commission Total
Fee/Mail #lastName#, #firstName# #username# #LSCurrencyFormat(SumOfInsertionFees,"local")# #LSCurrencyFormat(SumOfBoldFees,"local")# #LSCurrencyFormat(SumOfFeaturedCategoryFees,"local")# #LSCurrencyFormat(SumOfFeaturedHomepageFees,"local")# #LSCurrencyFormat(SumOfCommissionFees,"local")# #LSCurrencyFormat(theTotal,"local")#

SELECT Member.firstName, Member.lastName, Member.email, Member.userID FROM Member WHERE username = '#username#'

All Fees/ Email	Seller	Username	Insertion	Bold	Featured On Category	Featured On Homepage	Commission	Total
Fee/Mail	#lastName#, #firstName#	#username#	#LSCurrencyFormat(SumOfInsertionFees,"local")#	#LSCurrencyFormat(SumOfBoldFees,"local")#	#LSCurrencyFormat(SumOfFeaturedCategoryFees,"local")#	#LSCurrencyFormat(SumOfFeaturedHomepageFees,"local")#	#LSCurrencyFormat(SumOfCommissionFees,"local")#	#LSCurrencyFormat(theTotal,"local")#

Fees for #getUser.firstName# #getUser.lastName#
#username# (#getUser.email#)
View Fees By This Seller

SELECT lotName, insertionFee, boldFee, featuredCategoryFee, featuredHomepageFee, commissionFee, commissionFeeFinal, insertionFeePaidDateTime, commissionFeePaidDateTime, insertionFeeInvoicedDateTime, commissionFeeInvoicedDateTime, lotType FROM Fee WHERE lotID = #lotID# #lotID#. Status = ClosedOpen
#getUserFees.lotName#

Fee Type Amount
Insertion

Bold

Featured On Category

Featured On Homepage

Commission

Insertion Fee Invoiced? CHECKED> Check if insertion fee not invoiced
Insertion Fee Paid? CHECKED> Check if insertion fee not paid
Commission Fee Invoiced? CHECKED> Check if commission fee not invoiced
Commission Fee Paid? CHECKED> Check if commission fee not paid

SELECT Member.firstName, Member.lastName, Member.email, Member.userID FROM Member WHERE username = '#username#'

Fee Type	Amount
Insertion
Bold
Featured On Category
Featured On Homepage
Commission
Insertion Fee Invoiced?	CHECKED> Check if insertion fee not invoiced Insertion Fee Paid?	CHECKED> Check if insertion fee not paid Commission Fee Invoiced?	CHECKED> Check if commission fee not invoiced Commission Fee Paid?	CHECKED> Check if commission fee not paid

Fees for #getUser.firstName# #getUser.lastName#
#username# (#getUser.email#)

SELECT lotID, lotName, insertionFee, boldFee, featuredCategoryFee, featuredHomepageFee, commissionFee, commissionFeeFinal, insertionFeePaidDateTime, commissionFeePaidDateTime, lotType FROM Fee WHERE userID = #getUser.userID# ORDER BY #order#

Delete/ Edit	Lot	Lot Name	Lot Status	Type	Insertion	Ins. Paid?	Bold	Featured On Category	Featured On Homepage	Commission	Comm. Paid?	Total
Edit	#lotID#	#lotName#	ClosedOpen	AuctProcClas	#LSCurrencyFormat(insertionFee,"local")#	-#DateFormat(insertionFeePaidDateTime,"mm-dd-yy")#	#LSCurrencyFormat(boldFee,"local")#	#LSCurrencyFormat(featuredCategoryFee,"local")#	#LSCurrencyFormat(featuredHomepageFee,"local")#	#LSCurrencyFormat(commissionFee,"local")#	#LSCurrencyFormat(commissionFee,"local")#	-#DateFormat(commissionFeePaidDateTime,"mm-dd-yy")#	#LSCurrencyFormat(Evaluate(insertionFee + commissionFee + boldFee + featuredCategoryFee + featuredHomepageFee),"local")#
54>Total Fees:	#LSCurrencyFormat(totalInsertionFee,"local")#		#LSCurrencyFormat(totalBoldFee,"local")#	#LSCurrencyFormat(totalFeaturedCategoryFee,"local")#	#LSCurrencyFormat(totalFeaturedHomepageFee,"local")#	#LSCurrencyFormat(totalCommissionFee,"local")#		#LSCurrencyFormat(Evaluate(totalInsertionFee + totalCommissionFee + totalBoldFee + totalFeaturedCategoryFee + totalFeaturedHomepageFee),"local")#
Commission Fees in green indicate open lots where final fee may change.

Checkbox must be checked to delete designated fees.

SELECT FeeBid.lotID, FeeBid.lotName, FeeBid.bidFee, FeeBid.bidWinFee, FeeBid.bidFeeFinal, FeeBid.bidViewFee, FeeBid.bidFeeInvoicedDateTime, FeeBid.bidWinFeeInvoicedDateTime, FeeBid.bidFeePaidDateTime, FeeBid.bidWinFeePaidDateTime, FeeBid.bidViewFeeInvoicedDateTime, FeeBid.bidViewFeePaidDateTime, Member.firstName, Member.lastName, Member.email, Member.username FROM FeeBid INNER JOIN Member ON FeeBid.userID = Member.userID ORDER BY #order#

Bidder	Lot ID	Lot Name	Final?	Bid Fee	Winning Bid Fee	Bid Description View Fee
#username# #firstName# #lastName#	#lotID#	#lotName#	NoYes	#LSCurrencyFormat(bidFee,"local")#	#LSCurrencyFormat(bidWinFee,"local")#	#LSCurrencyFormat(bidViewFee,"local")#