Finding the repeat buyers of an e-commerce order list

[BrianEcom]

Hey guys. I have a customer order list for my e-commerce website and I am trying to find out my repeat buyers as well as my biggest buyers.

Here is an example of how it looks like:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Email[/TD]
[TD]Product Bought[/TD]
[TD]Total That Customer Spent[/TD]
[/TR]
[TR]
[TD]customer1@email.com[/TD]
[TD]shoes[/TD]
[TD]$5[/TD]
[/TR]
[TR]
[TD]customer2@email.com[/TD]
[TD]hats[/TD]
[TD]$3[/TD]
[/TR]
</tbody>[/TABLE]

The only way to find out how many times this customer bought is to count the number of times their emails show up in the email field.

Is there an easy way to find out who my repeat buyers are as well as sort by the highest amount of total spend?

 

[Eric W]

Welcome to the Board!

You can do that with formulas like this:

	A	B	C	D	E	F	G	H	I
Most Frequent
customer4@email.com	customer1@email.com
customer1@email.com	customer5@email.com
customer3@email.com	shirts	customer2@email.com	customer2@email.com
customer2@email.com	shoes	customer5@email.com	customer3@email.com
customer2@email.com	belts	customer3@email.com	customer4@email.com
customer5@email.com	belts
customer5@email.com	belts
customer1@email.com	shirts
customer1@email.com	ties
customer3@email.com	belts
customer4@email.com	shirts
customer5@email.com	belts
customer5@email.com	shirts
customer2@email.com	belts
customer4@email.com	shoes
customer1@email.com	shirts
customer3@email.com	belts
customer1@email.com	hats
customer1@email.com	pants

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]Email[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]Product Bought[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]Total That Customer Spent[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]Biggest Spenders[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]customer1@email.com[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]shoes[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$5 [/TD]
[TD="align: right"][/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$106 [/TD]
[TD="align: right"][/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]6[/TD]

[TD="align: center"]3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]customer2@email.com[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "]hats[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$3 [/TD]
[TD="align: right"][/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$70 [/TD]
[TD="align: right"][/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]4[/TD]

[TD="align: center"]4[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$9 [/TD]
[TD="align: right"][/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$40 [/TD]
[TD="align: right"][/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]4[/TD]

[TD="align: center"]5[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$8 [/TD]
[TD="align: right"][/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$36 [/TD]
[TD="align: right"][/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]3[/TD]

[TD="align: center"]6[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$10 [/TD]
[TD="align: right"][/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$32 [/TD]
[TD="align: right"][/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]2[/TD]

[TD="align: center"]7[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$10 [/TD]
[TD="align: right"][/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="align: right"][/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] "][/TD]

[TD="align: center"]8[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$3 [/TD]
[TD="align: right"][/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]9[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$17 [/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$8 [/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$6 [/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]12[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$95 [/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]13[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$4 [/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]14[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$19 [/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$19 [/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]16[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$11 [/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]17[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$4 [/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]18[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$17 [/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]19[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$17 [/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]20[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FAFAFA]#FAFAFA[/URL] , align: right"]$19 [/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I2[/TH]
[TD="align: left"]=IF(H2="","",COUNTIF($A$2:$A$20,H2))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]F2[/TH]
[TD="align: left"]=IF(E2="","",SUMIF($A$2:$A$20,E2,$C$2:$C$20))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Array Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H2[/TH]
[TD="align: left"]{=IFERROR(INDEX($A$2:$A$20,MOD(LARGE(IF(MATCH($A$2:$A$20,$A$2:$A$20,0)=ROW($A$2:$A$20)-ROW($A$2)+1,COUNTIF($A$2:$A$20,$A$2:$A$20)+(ROW($A$2:$A$20)-ROW($A$2)+1)/10000),ROWS($H$2:$H2)),1)*10000),"")}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]E2[/TH]
[TD="align: left"]{=IFERROR(INDEX($A$2:$A$20,MOD(LARGE(IF(MATCH($A$2:$A$20,$A$2:$A$20,0)=ROW($A$2:$A$20)-ROW($A$2)+1,INT(SUMIF($A$2:$A$20,$A$2:$A$20,$C$2:$C$20))+(ROW($A$2:$A$20)-ROW($A$2)+1)/10000),ROWS($E$2:$E2)),1)*10000),"")}[/TD]
[/TR]
</tbody>[/TABLE]
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself[/TD]
[/TR]
</tbody>[/TABLE]



The problem is that if your order list is really large, this type of formula tends to crash Excel. If that happens, I'd recommend an on demand VBA macro that scans your list and creates the output lists. Let me know if that's of interest.

 

[DRSteele]

I would like to suggest that a Pivot Table is ideal. I was able to construct a PT the same as the output in your columns E to I in about 30 seconds.

 

[BrianEcom]

Thats awesome! What are the steps involved in this pivot table? I dont have much experience creating them.

 

[DRSteele]

Well, if you lack experience with PTs, you could watch these videos and others from the ExcelIsFun channel on youtube. Then, it will be easier to understand the steps for this particular task.

https://www.youtube.com/watch?v=e-yuYNgsHAk
https://www.youtube.com/watch?v=Y2cIAIJAEWA

 

[markmzz]

​Look at the table below (3 Pivot Tables - DRSteele's suggestion):

[TABLE="class: grid, width: 1105"]
<tbody>[TR]
[TD]
[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Email[/TD]
[TD]Product Bought[/TD]
[TD]Total That Customer Spent[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]customer1@email.com[/TD]
[TD]shoes[/TD]
[TD="align: right"]5[/TD]
[TD]
[/TD]
[TD]Total That Customer Spent[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]Count of Email[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]Values[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]customer2@email.com[/TD]
[TD]hats[/TD]
[TD="align: right"]3[/TD]
[TD]
[/TD]
[TD]Email[/TD]
[TD]Total[/TD]
[TD]
[/TD]
[TD]Email[/TD]
[TD]Total[/TD]
[TD]
[/TD]
[TD]Product Bought[/TD]
[TD]Count of Email[/TD]
[TD]Total Spent[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]customer3@email.com[/TD]
[TD]shirts[/TD]
[TD="align: right"]9[/TD]
[TD]
[/TD]
[TD]customer4@email.com[/TD]
[TD="align: right"]106[/TD]
[TD]
[/TD]
[TD]customer1@email.com[/TD]
[TD="align: right"]6[/TD]
[TD]
[/TD]
[TD]belts[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]69[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]customer2@email.com[/TD]
[TD]shoes[/TD]
[TD="align: right"]8[/TD]
[TD]
[/TD]
[TD]customer1@email.com[/TD]
[TD="align: right"]70[/TD]
[TD]
[/TD]
[TD]customer5@email.com[/TD]
[TD="align: right"]4[/TD]
[TD]
[/TD]
[TD]shirts[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]144[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]customer2@email.com[/TD]
[TD]belts[/TD]
[TD="align: right"]10[/TD]
[TD]
[/TD]
[TD]customer2@email.com[/TD]
[TD="align: right"]40[/TD]
[TD]
[/TD]
[TD]customer2@email.com[/TD]
[TD="align: right"]4[/TD]
[TD]
[/TD]
[TD]shoes[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]24[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]customer5@email.com[/TD]
[TD]belts[/TD]
[TD="align: right"]10[/TD]
[TD]
[/TD]
[TD]customer5@email.com[/TD]
[TD="align: right"]36[/TD]
[TD]
[/TD]
[TD]customer3@email.com[/TD]
[TD="align: right"]3[/TD]
[TD]
[/TD]
[TD]hats[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]customer5@email.com[/TD]
[TD]belts[/TD]
[TD="align: right"]3[/TD]
[TD]
[/TD]
[TD]customer3@email.com[/TD]
[TD="align: right"]32[/TD]
[TD]
[/TD]
[TD]customer4@email.com[/TD]
[TD="align: right"]2[/TD]
[TD]
[/TD]
[TD]ties[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]customer1@email.com[/TD]
[TD]shirts[/TD]
[TD="align: right"]17[/TD]
[TD]
[/TD]
[TD]Total Geral[/TD]
[TD="align: right"]284[/TD]
[TD]
[/TD]
[TD]Total Geral[/TD]
[TD="align: right"]19[/TD]
[TD]
[/TD]
[TD]pants[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]19[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]customer1@email.com[/TD]
[TD]ties[/TD]
[TD="align: right"]8[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]Total Geral[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]284[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]customer3@email.com[/TD]
[TD]belts[/TD]
[TD="align: right"]6[/TD]
[TD]**[/TD]
[TD]*************************[/TD]
[TD]*****[/TD]
[TD]**[/TD]
[TD]**********************[/TD]
[TD]*****[/TD]
[TD]**[/TD]
[TD]****************[/TD]
[TD]*************[/TD]
[TD]***********[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]customer4@email.com[/TD]
[TD]shirts[/TD]
[TD="align: right"]95[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]customer5@email.com[/TD]
[TD]belts[/TD]
[TD="align: right"]4[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]customer5@email.com[/TD]
[TD]shirts[/TD]
[TD="align: right"]19[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]customer2@email.com[/TD]
[TD]belts[/TD]
[TD="align: right"]19[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]customer4@email.com[/TD]
[TD]shoes[/TD]
[TD="align: right"]11[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]customer1@email.com[/TD]
[TD]shirts[/TD]
[TD="align: right"]4[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]customer3@email.com[/TD]
[TD]belts[/TD]
[TD="align: right"]17[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]customer1@email.com[/TD]
[TD]hats[/TD]
[TD="align: right"]17[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]customer1@email.com[/TD]
[TD]pants[/TD]
[TD="align: right"]19[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]***[/TD]
[TD]*********************[/TD]
[TD]********[/TD]
[TD]*********[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Markmzz