I'm a recent convert from Opencart, and have everything up and running and things are working very well. One area that I can't seem to get my head around is the lack of detailed reports. OC had the same issue but there were several custom report generators. My problems is my host "Stable Host" does not allow remote sql access, so a lot of the mysql report writers I looked at won't work. I do have access to phpmyadmin, but hand coding sql joins etc..., simply don't have the time. I see the export orders feature, and I'm trying to create a pivot table, but the multiple products on one line is proving challenging. We have a small shop and I don't keep any stock, we have order periods, then order and ship. What I believe I need:
1. Is a custom report writer like they have for OC, but that is very hopeful.
2. A report that lists all the products, options, size, quantity, etc... that I need to order. Products Purchased Report is a start but does not list the options or is there any customization.
3. Customer report that just lists what was ordered and the options in csv that is somewhat manageable. The csv orders export is a start.
My other question is what is everyone else doing. I do see a lot of question suggestions on reports. What might be great if there are other users of the product that have built sql queries, worksheets, reports, etc... if there was a place to share these so other customers can use them.
Thanks