One place that OpenCart is lacking is in detailed sales reports.
I need a report that allows me to see each order, based on a date range and order type, including columns (with totals) for order number, customer, sub total, sales tax, shipping, and total.
A report like this is important for filing sales tax.
Thanks
Dan
I want this to + another report as well.
I'm willing to donate if someone will greate these 2 reports
I think that wat I want could be included in the report the TS wants.
I'm willing to donate if someone will greate these 2 reports
I think that wat I want could be included in the report the TS wants.
Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
what would you want differently i2paq?
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
If someone can create a report module with multiple report options, I would be willing to donate too.
Well you know if a person were going to write a report they would kind of need to know at least some hint as to what multiple options are. Unfortunately I think this kind of report might be a rather large pain to write in a standardized way that will work with all stores because of how the information is stored in the database.
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
I would want to be able to generate the following between a begin and an end date (end date should be execluded from totals):
How many customers have bought
Total sales excl. Tax
Total sales incl. Tax
Total shipping costs excl. Tax
Total shipping costs incl. Tax
Total Tax (split per differend tax rates)
Average Cart excl. Tax
Average Cart incl. Tax
How many customers have bought
Total sales excl. Tax
Total sales incl. Tax
Total shipping costs excl. Tax
Total shipping costs incl. Tax
Total Tax (split per differend tax rates)
Average Cart excl. Tax
Average Cart incl. Tax
Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
When I was writing the Google analytics module I learnt that you can actually send a lot of data to GA and then pull reports back as you need.
Maybe you can send the extra reporting data you need to GA and then make up custom reports?
A substantial benefit of using GA as your ecommerce reporting is that the data is "offsite" and not subject to breakage when the next version comes out.
Maybe you can send the extra reporting data you need to GA and then make up custom reports?
A substantial benefit of using GA as your ecommerce reporting is that the data is "offsite" and not subject to breakage when the next version comes out.
www.opencartstore.com
Get OpenCart Templates and OpenCart Modules.
Nice if you use GA, as most people will not I rather see the report build in to OC.imaginetech wrote:When I was writing the Google analytics module I learnt that you can actually send a lot of data to GA and then pull reports back as you need.
Maybe you can send the extra reporting data you need to GA and then make up custom reports?
A substantial benefit of using GA as your ecommerce reporting is that the data is "offsite" and not subject to breakage when the next version comes out.
Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
yeah this is going to be a royal pain to build something like this if it's even possible with the current data structure. Building the report for a single shop with set business rules wouldn't be too bad, but trying to make one that will work for any opencart install would be more headache than it's worth.
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
Why, if it is a default OC then the tables are default so using these tables should be not so hard.Xsecrets wrote:yeah this is going to be a royal pain to build something like this if it's even possible with the current data structure. Building the report for a single shop with set business rules wouldn't be too bad, but trying to make one that will work for any opencart install would be more headache than it's worth.
It has been done for osCommerce as my current shop has this module/page.
Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
because the only place that this information is available past the time of purchase is in the order_totals table. And the only way to tell which field is what in that table is by a text field. which for default english finding total and sub total wouldn't be too hard, but then throw in all the different languages and it starts getting more difficult. Then the coupons are in there by coupon name only (this could be literally anything so no way to filter them out other than by process of eliminating everything else) then you've got tax I don't have taxed orders on my demo installs, so I haven't verified, but I would imagine this is going to have the text of your tax rate, which won't be standard. Most people will have tax in there, but you know that someone is going to want to call it slave to big brother or something stupid not to mention once again vat and other languages. The reason it's a bit easier in oscommerce is because their order_total table has a class field that makes it easier to pick out the different order total types.
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
Thanks for your explanation, I still think it could be done, I'm not saying it will be easy.Xsecrets wrote: *knip*
The reason I "need" this report is because of our government and its Tax law.
Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
Well I never said it would be impossible, but unfortunately it's not really worth the effort it would take. The real solution would be to change some core files so you do have a class field or something similar, but then as soon as a new update comes out it will break everything. Unfortunately there's just no good outlook for this one right now. But who knows maybe one of the other developers around here will see this and have a brilliantly simple solution that I missed. It happens sometimes.
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
You could always try this http://www.opencart.com/index.php?route ... on_id=1350
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool
If you're not living on the edge ... you're taking up too much space!
I have actually updated the ORDERS page to show:
Order ID, InvoiceID, Invoice Date, Customer name, Status, Order Date, Order Total, Open Amount, Tax
For this there are some major mods I had to do:
- Invoice Date, this is actually very important! OC doesn't create an Invoice Date, it just creates the InvoiceID and prints todays date whenever you open the invoice, so if you print the invoices once a week or once a month, your dates will be off. I added an Invoice Date column to the order table and fixed it like that.
- Open Amount, I added a full payments system that tracks incoming payments, so the user can see for every invoice how much still needs to be paid.
Also I changed the filter on the dates from a single date filter to a range, so you can show all orders in MAY or all invoices in MAY (this can be different)
I will be adding a totals table soon at the bottom of the page so you can see the full amount of all the orders in the range and full tax, etc.
perhaps this is what you guys need too?
BTW, the language problem for selecting totals, etc is not a problem, I selected them through the sort-order as this is something that's specified regardless of the language used.
Order ID, InvoiceID, Invoice Date, Customer name, Status, Order Date, Order Total, Open Amount, Tax
For this there are some major mods I had to do:
- Invoice Date, this is actually very important! OC doesn't create an Invoice Date, it just creates the InvoiceID and prints todays date whenever you open the invoice, so if you print the invoices once a week or once a month, your dates will be off. I added an Invoice Date column to the order table and fixed it like that.
- Open Amount, I added a full payments system that tracks incoming payments, so the user can see for every invoice how much still needs to be paid.
Also I changed the filter on the dates from a single date filter to a range, so you can show all orders in MAY or all invoices in MAY (this can be different)
I will be adding a totals table soon at the bottom of the page so you can see the full amount of all the orders in the range and full tax, etc.
perhaps this is what you guys need too?
BTW, the language problem for selecting totals, etc is not a problem, I selected them through the sort-order as this is something that's specified regardless of the language used.
Opencart specialist | Our website | Our modules
Hi Burrito,
This is exactly what we need, the full range of date so that we can filter month by month
and per Country as well
This would greatly help the marketing team to put more emphasis on Countries where sales are low
Cheers!
This is exactly what we need, the full range of date so that we can filter month by month
and per Country as well This would greatly help the marketing team to put more emphasis on Countries where sales are low
Cheers!
I have not yet added a selection by country, but this should be no problem to add either.
I sent you a PM
I sent you a PM
Opencart specialist | Our website | Our modules
Who is online
Users browsing this forum: No registered users and 13 guests
