Hi Brains Trust,
I have a potential wholesale customer who would like a list of products, including size and price.
I can see how to Export Product list to CSV file, but cannot make it include individual sizes and prices - any help appreciated.
Also, I’m wondering about setting them up as a Wholesale Customer with a set discount price - is this the best way to handle this situation please ?
Thanks in advance. 
Hi Doogal,
This is certainly possible, please feel free to reach out!
To export a product list with individual sizes and prices, you can utilize a custom report or an app specifically designed for this purpose. Here’s a general approach to achieve this:
Custom report: Shopify provides a built-in report generator called “Custom Reports” that allows you to create custom reports based on specific criteria. You can navigate to “Analytics” > “Reports” > “Custom Reports” in your Shopify admin, and create a report that includes the product title, variant sizes, and prices. This will generate a report that can be exported as a CSV file.
Apps: There are several apps available on the Shopify App Store that offer advanced reporting and export capabilities. These apps often provide more flexibility and customization options compared to the built-in report generator. Some popular apps for this purpose include “EZ Exporter” and “Better Reports.”
Regarding setting up the wholesale customer with a set discount price, using the Wholesale channel or a dedicated wholesale app would be the recommended approach. These solutions allow you to create a separate customer group or tag for your wholesale customers and assign them a specific discount price. This way, you can offer a customized pricing structure and streamline the wholesale ordering process.
Some popular wholesale apps on the Shopify App Store include “Wholesale Club” and “Bold Custom Pricing.”
By combining the product list export with individual sizes and prices and setting up a wholesale customer with a discounted price, you’ll be able to cater to your potential wholesale customer’s needs effectively.
Hi @Doogal
If you are open to use a third party app, I might have a great solution for your problem! Our App DataChamp allows you to easily export the data you need for your list. You can also of course create the reports with a discount price and many more options. Once your reports are set up, you can run them automatically, so you do not have to export them by yourself!
You can download your reports as a CSV File, Excel, Spreadsheet and many more. If you would require any help with the set up of the app, just contact us!
Hopefully we could help you with your concern
Hello @Doogal ,
In Report Pundit we provide premade reports and a custom report builder through which you can quickly extract data at your convenience in various formats including CSV, Excel, PDF, and drive
You can generate a report with product title, variant option, size, prices, and more as per your requirement.
You can also contact us with your reporting requirements our live support team can build it for you.
Cheers!