Can a custom report show specific product sales by full price and discount code?

[cglaspell]

I want to have a report, that will show me a specific product (or all of my products) and their sales revenue from full retail buyers and the discount code buyers. I know I can look at SALES BY DISCOUNT, that just gives me a dollar amount, I also know I can add in PRODUCT title and see products and the total number of discounts sold, but thats not getting exactly what I want....im thinking something like:

PRODUCT TITLE/FULL PRICE SALES/DISCOUNT CODE SALES

[Lilynora]

Hello 🥰, I'm a Shopify🏢 expert💆 am offering free business explaination🥳 why you aren't making sales 💲💵💷💶💰💸💱💱 on your Shopify 🏢 store 💰

That means you need to implement klaviyo and the flows into your store, by implementing this you will be able to track your store analysis. 

[CloudlabSam]

Hi there,

Seems like you've run up against a limitation of Shopify, as they don't have this type of report.

Our Report Toaster app can help. We can create a custom report to provide the data the way you've described. Please feel free to take a look and get in touch with support to help you get setup.

Thanks,

Sam

[Mipler-I]

Hi @cglaspell !

It is possible to do this with Mipler: Advanced Reports.

Just check this example:

If you give Mipler a try, our support team will happily provide you with all the reports you need.
We can even assist you in creating custom columns that perfectly suit your requirements.

And here's the best part - we offer a 7-day free trial! It's a great opportunity for you to test it out and see how it fits your needs.
But don't worry, if it's not quite what you're looking for, you can easily remove the app.

If you have any questions or need any further assistance, just let us know. We're here to help!