I am building a new store and will have 2 separate collections for it. I need to be able to export orders by the collection ordered from. I've looked into Deepmine and a few other export apps and while they are almost there, they don't let me export the products that were purchased along with all the other order information (like shopifys basic export does). Does anyone know of a way to export orders by collection that also exports the products ordered?
I get that you want to know the path through which the customer went on your page - through which Collection page when he added the product to the cart. If you don't have specific tracking made for this then post-factum I think this data is not available in Shopify anywhere.
But you could achieve this "Orders by Collection" result very closely with the https://excelify.io app if you are using Custom Collections:
Note that if you will have the same product in many collections then this might be a bit question of logic - which one do you consider as the real one for that order.