AbanteCart Community
Shopping Cart Operations => Built-in Features => Topic started by: davezub on November 18, 2015, 08:25:21 AM
-
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
-
It is common to neglect reporting as this is a great area for third party developer to integrate. They have greater expertise in reporting.
We focus on UI, security, stability and ecommerce core features. Reporting is a different aspect.
In the future, we can consider improving reporting.
For now, I can suggest contacting Opencart developers that did reporting extensions and suggest them to create extension for AbanteCart. It should not be hard to integrate Opencart code.