thread Re: How do I pull a list of customers who bought a specific product? in Archived Discussions (Read Only)

Reporting - How do I see which customers purchased an item?

dwm — Wed, 30 Mar 2022 17:06:58 GMT

Is there a way to see which customers purchased an item? I run a wine store and we would like to send clients updates when the next vintage of the same wine arrives or more of the same wine if it was temporarily sold out.

This is an important revenue generator for us, in addition to be a nice service to our clients who appreciate the heads on wines they have traditionally supported

Re: Item History

Tom — Thu, 05 Jan 2017 02:47:01 GMT

Hi @dwm, welcome to the seller community and thanks for bringing this up! 😀

Yes — you can see which customers purchased an item by heading over to your Item Sales tab > select appropriate date range > Export > Detail CSV. A spreadsheet will download to your computer. From there, you can sort the "Item" column and cross reference which customers bought that wine by viewing the "Customer Name" column.

Hope this helps. Let us know if you have any questions or feedback!

Cheers. 🥂

Re: Item History

dwm — Thu, 05 Jan 2017 12:36:14 GMT

This is hugely helpful. Thank you!!

Option to find customer names associated with each sale?

123rupert — Tue, 31 Jan 2017 23:45:43 GMT

Hello team!

I don't know if there is something to my question, but I would love the option to find the names of the transactions for the day. For example I can go and click on the "Activity " tab but find only the amounts, receipt number and last 4 digits of the card used on the sale, but if you don't remember the name of a particular customer to add an important note or so then you have to search thru that whole list looking for it according to the time they were in, kind of inconviente and sometimes impossible.

Re: Item History

EConway — Thu, 16 Feb 2017 21:08:31 GMT

We're also interested in doing something similar, however when I export the file the "Customer Name" column is entirely blank. Is there a setting we need to enable in order to see this data?

How do I pull a list of customers who bought a specific product?

skooner77 — Fri, 17 Feb 2017 20:55:51 GMT

I would like to be able to pull a list of customers who purchased a specific product. I can't seem to find a report or other method for accomplishing this.

Could someone point me in the right direction on this?

Thanks much.

Re: Item History

Spenser — Sun, 19 Feb 2017 19:42:45 GMT

Hmm, strange, @EConway. Have you been adding your customers to each sale, prior to charging?

Re: How do I pull a list of customers who bought a specific product?

Spenser — Mon, 20 Feb 2017 18:23:40 GMT

Hi, @skooner77, welcome to the Community. I moved your post to existing thread on this topic. While we don't have a Dashboard report specifically for this, you can acquire this info if you're using the Customer Directory feature. Hope this helps!

Re: How do I pull a list of customers who bought a specific product?

skooner77 — Mon, 20 Feb 2017 19:18:30 GMT

Thanks for connecting me with this thread and this answer, Spenser. I was able to download the list.

While this does get me to the ultimate answer I need, I'm wondering if there is a mechanism through which I could request that this functionality become more easily accessible and more useable within Square Marketing. The report that I was able to download through your instructions does give me the ability to find customer names, but it doesn't include contact information, it's buried within a bunch of other data I have to sort through, and I can't easily communicate with this targeted group of people.

As the backbone of our retail system, being able to make it easier for customers to purchase additional products from us is obviously critically important. I honestly am shocked that there haven't been tons more requests for this feature.

Re: How do I pull a list of customers who bought a specific product?

Spenser — Tue, 21 Feb 2017 02:03:33 GMT

Thanks for following up @skooner77, I'm glad to hear it was partly helpful at least. I appreciate the feedback and can see how a closer link between reporting and marketing would save you some work - quickly reaching out to a group of people who bought a particular product from you, for example.

In any case, I'll pass on the suggestion and will update here if there are any updates that would benefit this thread. Thanks again!

Re: Item History

mpakiela — Sat, 29 Apr 2017 21:33:03 GMT

So far I've been able to find what I need as far as a report goes by doing this Detail CSV - except for I do not see a place to chose a 'date range' just a specific date. Is there a way to chose an entire month at a time vs. doing every day separately when I export the Detail CSV?? I want to see what customers purchased in the month of entire month of April without having 30 separate reports.

Thanks

Re: Item History

EJ_ — Tue, 02 May 2017 17:18:26 GMT

@mpakiela You should be able to choose a date range by clicking on the date selector box.

Here's a screen shot for reference:

Re: Item History

FPVdronesXYZ — Wed, 03 May 2017 05:18:47 GMT

Hi - I am using WIX and I just integrated Square. Square is not capturing the item purchased or customer name at least. I have downloaded the details Excel sheet and the Customer Name is blank and Item field just says "Custom Amount" under it. Below is excerpt of one of the Excel Rows. I removed the transaction ids. Do I need to enable something?

5/2/2017

8:07:59

Arizona

None

Custom Amount

$50.95

$0.00

$50.95

$0.00

Payment

FPVdrones.XYZ

Re: Item History

EJ_ — Thu, 04 May 2017 15:16:13 GMT

@FPVdronesXYZ Hi there,

Although Square integrates with Wix to process payments, all API functions are operated and managed by Wix.

For help with Wix-specific questions, you’ll need to contact the Wix Support Team directly.

Re: Item History

Extremevbc — Tue, 26 Sep 2017 17:33:56 GMT

I have the same issue where my cutomer ID column is blank but when I click on the transaction it shows the customer name.

Re: Item History

Helen — Tue, 26 Sep 2017 17:39:29 GMT

Sorry to hear that @Extremevbc! If you've added customers to each sale before charging this information should appear. If you're still seeing a blank column, please get in touch with our Support team directly so we can investigate this further.

Is there a way to create an Items by Customer report?

safsac — Sun, 01 Oct 2017 02:19:50 GMT

I would like to click on a customer and see all the items they have purchased (a summary) without having to look at each of their orders individually. Is there a way to do that?

Re: Is there a way to create an Items by Customer report?

Helen — Tue, 22 Jan 2019 19:31:32 GMT

This reply was created from merging an existing thread: “Is there a way to create an Items by Customer report?”

Welcome to the Seller Community @safsac! I moved your post here so you can see Tom's Best Answer about how to see this report (see page 1 of this thread). 👍

Re: Is there a way to create an Items by Customer report?

safsac — Wed, 04 Oct 2017 15:55:46 GMT

The process explained in "Tom's Best Answer" was helpful (but cumbersome) to a certain degree. But the date range is the problem. I'd like to veiw and evaluate a customer's ENTIRE history....not just one year at a time. Is there a way to do that without having to run multiple reports - one year at a time?

Re: Is there a way to create an Items by Customer report?

Helen — Sat, 07 Oct 2017 20:07:57 GMT

@safsac Unfortunately you can only pull a report for one year or less! I definitely see how that would be useful and I'll share your request for the ability to see a customer's entire history with the Product Team.