Hi - is this possible to do? I would like to get a CSV export of customers who purchased a specific product collection, or specific product. I cannot seem to figure out any way to do this from your admin panel. Seems like basic marketing info that we should be able to drill down and receive. Is this possible?
So I just tried what you suggested. I installed Deep Mine and it generated a list of customers who bought an item. BUT I want to email these people using your new email system. However, I cannot create a customer group from the downloaded CSV (as far as I can tell). The CSV also does not contain their addresses, etc and when I try to upload it asks if I want to replace the existing customers or not. I don’t want to do that and erase all the missing info — so I hesitate to use this. I would expect that if I did upload without the overwrite, there would be no resulting list. Besides that, I am not even sure if this would work anyway.
That all said. You can see how ridiculous this hunt is. Because you are intentionally hiding pretty basic information from long-time customers who simply refuse to go from $75 to $300 a month. I am sure if I could just do this on Shopify, I could search that product — the people who bought it and make an email list. Or maybe tag them and make a list.
Or maybe I need to download three more apps for $10 a month per from third-party vendors?
That's extremely irritating. So you're telling me this DeepMine app doesn't put the email addresses and home addresses of these specific customers on the CSV sheet?
I figured it out using Google sheets.
There is a much easier way to do that. Just go to Orders and in search type in the name of the product. It should filter all orders that contain that product. You can then tag all these customers or orders or just export the list!
Hi @swalach when I filter the orders by searching for the product name I only see an option to tag all of these orders. There doesn't seem to be a way to tag the customers in bulk and going 1 by 1 is not practical...am I missing something?
Hey @Expresomoda ,
Yes, that's true. You can only add tags to Orders (using Shopify admin). You would have to export the list, get the email column and import it back to Customers with a tag.
It lets you segment the customers according to purchased products along with other parameters.
Then you can easily message them and include automations.
The service starts at $20 per month and scales pretty generously.
Easy way - any plan:
Go to Sales Over Time Report
Input the date range you want.
Add customer name, customer email, and product type as columns (or whatever you're looking for).
Export and then sort in Excel or other spreadsheet program.
Rishika here from the Better Reports support team.
I believe our app Better Reports can help! We can create a custom report showing a list of customers who bought a specific product or a collection. It is possible to add filters “Product name” or “Product is in collection” in the report to show customers for a specific product or collection. You can also export the report to CSV, Excel or PDF.
In addition to building custom reports to meet your specific needs, you'll have access to 60+ built-in reports that cover many common use cases for merchants and our reports can be scheduled to send to your email or Google Drive at set frequencies (for instance, hourly, daily, monthly).
I encourage you to install Better Reports and start your free 14-day trial, and I'll be happy to set this up for you.
Let me know how you go and feel free to reach out if you have any further questions.