BV Commerce Forum
»
BV Commerce Support
»
Development
»
Free Add-on Report: Find Customers Who Purchased
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
This is an unsupported free add-on. This free report generates a list of customers who purchased a specific product and optionally ignores customers who purchased other products. For example: Find customers who purchased MY-TRIAL-VERSION but ignore any who bought MY-STANDARD-VERSION,MY-PRO-VERSION INSTALLATIONUnzip the attached archive into the /BVModules/Reports/ folder of your store and it will show up automatically in the reports tab of the admin. Edited by user Friday, June 3, 2016 12:53:13 PM(UTC)
| Reason: Not specified File Attachment(s):  Customers Who Purchased.zip (4kb) downloaded 330 time(s).You cannot view/download attachments. Try to login or register.
|
|
|
|
|
|
Rank: Member
Joined: 2/18/2006(UTC)
Posts: 172
|
Doesn't work for me... always get: <SPAN id=ctl00_MainContent_lblResult>Found 0 Customers
|
|
|
|
|
|
Rank: Member
Joined: 6/6/2005(UTC)
Posts: 483
|
Works for me. But you have to include the final SKU number with the added modifier. The one that shows up on the customers order. In our case we have a SKU# = "Kal07" but we have 2 choices for this product, "A" and "B". We have to use "Kal07A" and "Kal07B" in our search criteria to get it to work.
Bob Noble
|
|
|
|
|
|
Rank: Member
Joined: 4/28/2003(UTC)
Posts: 141
|
It's not working for me, but I think it is due to all of our Sku's having a *-* in them. example JS-00124. Richard www.somethingmorestore.com
|
|
|
|
|
|
Rank: Member
Joined: 8/20/2007(UTC)
Posts: 2
|
Hi Marcus,
This report is very handy, are there any other available that you are aware of.
Such as...
Sales of a product in a given date range
|
|
|
|
|
|
Rank: Member
Joined: 2/21/2007(UTC)
Posts: 1,113
|
It would also be nice to run a daily report by SHIPPING METHOD to quickly see if you have any express packages -- this would actually be a nice column on the Orders page |
|
|
|
|
|
|
Rank: Member
Joined: 5/24/2004(UTC)
Posts: 4,147
|
|
|
|
|
|
|
|
Rank: Member
Joined: 3/3/2006(UTC)
Posts: 1,737
|
Joe, In the meantime, you could highlight shipping methods in the emails that go to the drop shipper and admin., prompting a quick look at the orders page for express orders. |
Optimists invent airplanes,
Pessimists buy parachutes. |
|
|
|
|
|
Rank: Member
Joined: 4/10/2006(UTC)
Posts: 462
|
While I probably would not use a full blown report for express shipping, as about 50% of our orders are typically express. I do wish that the shipping method was included on the order details screen rather than only on the shipping screen. |
Netriplex Corporation<br /> |
|
|
|
|
|
Rank: Member
Joined: 4/10/2006(UTC)
Posts: 462
|
I have attached some updated code to this bv report. The changes include: 1. The ability to generate reports for products that have '-' in their product sku. 2. Limit results by Date Range 3. The results no include a column that provides a link to the order that is found 4. At the bottom of the report their is textbox that contains a list of all the e-mail addresses of the customers found during when the report is run. Useful for copy and paste if you are looking to mass e-mail everyone that ordered a particular product to inform them of a recall or some other issue. File Attachment(s): Customers Who Purchased.zip (4kb) downloaded 364 time(s).You cannot view/download attachments. Try to login or register. |
Netriplex Corporation<br /> |
|
|
|
|
|
Rank: Member
Joined: 9/27/2004(UTC)
Posts: 1,099
|
Wow, thanks for sharing! It looks like a nice update. |
|
|
|
|
|
|
Rank: Member
Joined: 6/26/2006(UTC)
Posts: 351
|
Thanks guys, this is great! |
|
|
|
|
|
|
Rank: Member
Joined: 2/18/2006(UTC)
Posts: 172
|
[3]I think it would be nice to add couple of extra futures to this report: 1. <?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com:office:smarttags" /><st1:City w:st="on"><st1:place w:st="on">Sale</st1:place></st1:City> by Manufacturer/Brand (Something Like: Find all Customers Who Purchased ‘Panasonic’) 2. Add extra column with the Order Total and have a Number of Orders and Totaling in the end of the report. If anyone willing to do it for us, please contact me: [email protected][/3]
|
|
|
|
|
|
Rank: Member
Joined: 10/29/2008(UTC)
Posts: 66
|
This is AWESOME. Thanks for the fix Netriplex!
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.