I am trying to pull a detail report on a specific product. I want to have order detail for all pinot noir sold. how do I do that?
go to orders>advanced search/sort>select line item search>select the Pinot Noir product from the product drop down and click finish. To see details of these orders, you can export this data next by clicking export>results of current search>export. Once that file exports save it and open it up. You will notice three tabs at the bottom of the file for detailed information.