Report that shows past products purchased by all customers?

Our website is www.aglowcandleco.com.

After several chats to Shopify support, I’m at loss. It seems like such a basic need for businesses to see which products their customers are actually purchasing.

According to Shopify: "What you will be able to see is the customers’ name and email address as well as the date of their first order, number of orders they’ve placed, value of the orders, but it does not show the name of the products they purchased."

We want a report that shows individual products purchased, at the individual customer level, to help with targeted marketing efforts to encourage customers to try other candle scents. Ideally this report would show other fields like customer name, physical address, and e-mail address.

They recommend Easy Reports as a 3rd party app to get this info. We were prepared to upgrade from Shopify Basic to Shopify for this need, but it doesn’t seem like that would do the trick. Does anyone have any recommendation for us?

If you upgrade to Shopify you should have access to the Sales reports. They are somewhat limited, but see below from my dev store - I think you can get what you want.

If that doesn’t work for you, our free app Report Toaster can do that plus a LOT more. Please feel free to check it out and let us know if you have any questions. Thanks!

Hey @aziggs

Would a report like the below screenshot work for you - the columns are the total number of individual items sold to customers over their lifetime orders.

Anto

@Anto_S Yes, particularly if another column could be added that has customer address (for direct mail purposes). Is that possible?

@CloudlabSam Thank you! Do you know if a column can be customized to include customer address?

Unfortunately no. We wrote an entire blog post about it https://www.cloudlab.com/post/data-you-can-t-get-from-shopify-volume-3.

@aziggs We’ve added customer name + address + email, screenshot below. Happy to discuss on DM or at anto@opstack.co if this works for you.