Post by fido-x » Tue Jan 25, 2011 2:36 pm

This is a module for the administration that provides a full and detailed overview of your website operations.

Provides the following reports:
- Summary (overview as at the current date)
- General Information (geo zones, shipping methods, tax rates, currencies)
- Sales Report (including breakdowns of sales by currency, shipping costs by method, taxes collected by tax rate)
- Profit and Loss Report (how much did you make or lose?)
- Stock Report (displays stock levels)
- Sales by Store (product sales by store)
- Sales by Category (product sales by category)
- Sales by Manufacturer (product sales by manufacturer)
- Customer Demographics (where on earth do they come from?)
- Charts

Print out a professional report at the click of a button. Give your report a title, write an introduction (optional), select the pages you want in the report (sales, profit & loss, etc.), then click either the "Print to PDF" or "Print to HTML", to be provided with a printable report that you can present to your boss/auditor/taxman.

Installation instructions included. No files overwritten. Includes vQmod file to automatically add an entry under "Reports" in the admin menu.

Compatible with OpenCart versions 1.4.8, 1.4.8b, 1.4.9, 1.4.9.1, 1.4.9.2, 1.4.9.3.

Demo can be found at http://demo.fido-x.net/. You can log in to the admin with username/password pair of "demo/demo", then go to "Reports->Financial Report".

Available from OpenCart Extensions or from Fido-X.

Image
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!


User avatar
Expert Member

Posts

Joined
Sat Jun 28, 2008 1:09 am
Location - Tasmania, Australia

Post by i2Paq » Wed Jan 26, 2011 2:37 am

Yeeehaaaa! Finaly you did it!

*counting his money, damn, "mam!, I need my week allowance" :D

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.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by Qphoria » Wed Jan 26, 2011 4:17 am

Holy Crap! This is absolutely amazing! Great Job!

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by i2Paq » Wed Jan 26, 2011 5:54 am

Does it use the Cost price table?

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.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by Xsecrets » Wed Jan 26, 2011 6:09 am

i2Paq wrote:Does it use the Cost price table?
I would think it would have to I don't know how else you would get a profit report.

OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter


Guru Member

Posts

Joined
Sun Oct 25, 2009 3:51 am
Location - FL US

Post by fido-x » Wed Jan 26, 2011 12:15 pm

Thanks for the comments.
Xsecrets wrote:
i2Paq wrote:Does it use the Cost price table?
I would think it would have to I don't know how else you would get a profit report.
Yes, it does.

A couple of "bugs" have been reported. I have updated the package with a fix, so those who have made purchases should be able to get a fresh copy. Alternatively, you can fix it yourself with the following:

Change lines 625 and 1769 in "admin/controller/module/statements.php" from:

Code: Select all

$stock_status = $this->model_fido_statements-getStockStatus($product['stock_status_id']); 
to:

Code: Select all

$stock_status = $this->model_fido_statements->getStockStatus($product['stock_status_id']); 
Thanks to Brook for finding this.

Image
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!


User avatar
Expert Member

Posts

Joined
Sat Jun 28, 2008 1:09 am
Location - Tasmania, Australia

Post by JAY6390 » Wed Jan 26, 2011 9:12 pm

hehe it's easily done when you get into your coding zone to mishit a key and not notice

Fantastic work Fido! Very thorough reporting indeed

Image


User avatar
Guru Member

Posts

Joined
Wed May 26, 2010 11:47 pm
Location - United Kingdom

Post by scanreg » Wed Jan 26, 2011 9:38 pm

Super nice!

1. Might be an issue with the Sales By Category calculating percentage

Laptops & Notebooks shows $500.00 sales, 33.33%

but MP3 Players shows sales of just $100.00 but also a percentage of 33.33%

2. Sales breakdown by payment type would be good too (cc, paypal, etc)

HTH

Active Member

Posts

Joined
Thu May 06, 2010 12:15 am

Post by fido-x » Thu Jan 27, 2011 9:10 am

scanreg wrote:Super nice!

1. Might be an issue with the Sales By Category calculating percentage

Laptops & Notebooks shows $500.00 sales, 33.33%

but MP3 Players shows sales of just $100.00 but also a percentage of 33.33%
The figures are correct. The "Sales by Category" page displays a list of your categories/sub-categories, how many products are in each category/sub-category and percentage of product sales (not sales value).

You'll note, that on the demo site, only 3 products have been "sold", one from "Desktops > Mac", one from "Laptops & Notebooks" and one from "MP3 Players". These 3 products,together, represent 100% of your sales. Each product, individually, represents one third or 33.33% of your sales.
2. Sales breakdown by payment type would be good too (cc, paypal, etc)

HTH
Good idea. Hadn't thought about that. I'll look into it.

Image
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!


User avatar
Expert Member

Posts

Joined
Sat Jun 28, 2008 1:09 am
Location - Tasmania, Australia

Post by Moggin » Fri Jan 28, 2011 1:27 am

oh... this takes Opencart and reports to a new level.
Very, very impressive!

Active Member

Posts

Joined
Wed May 05, 2010 4:56 am

Post by scanreg » Fri Jan 28, 2011 2:29 am

Would love to use something like this to do bulk inventory updates

Active Member

Posts

Joined
Thu May 06, 2010 12:15 am

Post by cashman9 » Wed Feb 02, 2011 11:49 am

Thank you for a great extension.

Is it possible to get sales by products as well based on monthly, weekly and days, with price and qty sold and total gained based on products specifically?

Also, if I enter the cost of the product on each individual products, will it recalculate the whole profit/loss? or only for going forward sales that I will have?

* Found some bugs in calculations... Shipping cost doesnt add up properly.

Active Member

Posts

Joined
Wed Nov 17, 2010 4:28 am

Post by fido-x » Wed Feb 02, 2011 2:45 pm

cashman9 wrote:Is it possible to get sales by products as well based on monthly, weekly and days, with price and qty sold and total gained based on products specifically?
I'll look into this for a future update.
Also, if I enter the cost of the product on each individual products, will it recalculate the whole profit/loss? or only for going forward sales that I will have?
Yes, since the "cost" is only stored in the database table anyway. The profit/loss report uses the order, order_product and product tables. Value of sales is taken from the orders table, while the query to determine the cost uses the order_product and product tables.
* Found some bugs in calculations... Shipping cost doesnt add up properly.
That's a possibility. Could you provide some more information on this please. For example, have you changed the sort order under "Extensions->Order Totals"?

Image
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!


User avatar
Expert Member

Posts

Joined
Sat Jun 28, 2008 1:09 am
Location - Tasmania, Australia

Post by cashman9 » Thu Feb 03, 2011 2:54 am

Sort order is:

Sub total 1
Coupon 2
Insurance 3
Shipping 4
Rush Order 5
Taxes: 6
Store Credit 7
Total 8

----------------------------------------------

The shipping only calculates the first one, which is the first class mail, but skips priority mail, media mail and etc.

And now since I changed the order since both insurance and shipping was on 3, and I switched to shipping 4, it only shows insurance. as expenditure for shipping.

How can I resolve it?

Thanks.

Active Member

Posts

Joined
Wed Nov 17, 2010 4:28 am

Post by fido-x » Thu Feb 03, 2011 10:59 am

Shipping costs and taxes collected are taken from the "order_totals" table. Changing the sort order of your order totals will render historical data inaccurate. By that, I mean, that any orders placed before the change would have the order totals in the previous sort order, while orders placed after the change will have the order totals in the new sort order.

Other reasons for reporting wrong figures could be the result of price changes during the reporting period. For example: if the cost price of a product changes during the reporting period, the changed price will be used in calculating profit and loss.

There are quite a few "variables" like this that will have an effect on the accuracy of the report. It is up to you, as the store owner, to make note of the date when things change (prices, taxes, costs) and adjust your reporting period(s) accordingly. You would, as par for the course, have to keep records of these sorts of changes anyway.

While the "order_product" table contains the price the product sold for and the tax rate that was applied to the sale (and this table does get used in calculations), it does not tell you what type of tax it was (VAT, Sales Tax, GST). This information is in the "order_totals" table. So, as stated at the begining, changing the sort order of the "order_totals" table will throw up inaccuracies in reporting.

Image
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!


User avatar
Expert Member

Posts

Joined
Sat Jun 28, 2008 1:09 am
Location - Tasmania, Australia

Post by cashman9 » Thu Feb 03, 2011 1:01 pm

I understand that clearly, since I have now changed the "sort order" all has changed and will be calculated differently going forward. However, this didn't address the issue with shipping. Prior to the change of "sort order," the shipping calculation TOTAL was incorrect.

Meaning that I use shipping module USPS that calculates each price like First Class mail, priority mail and etc. In the Profit/Loss in the Financial Reporting module, it did show the tables for each cost, however, upon calculating the total and subtracting it, it only showed First Class mail neglecting Priority mail and Medial mail, in the total cost, hence the calculations were wrong.

Active Member

Posts

Joined
Wed Nov 17, 2010 4:28 am

Post by fido-x » Thu Feb 03, 2011 1:49 pm

Your right, there is a "bug" in the calculations for the shipping. Hadn't noticed it before. Should have seen in the "popup" window on the "Sales" page, that there was no total for the shipping method. Oh well, back to the drawing board ::) :bang:

Image
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!


User avatar
Expert Member

Posts

Joined
Sat Jun 28, 2008 1:09 am
Location - Tasmania, Australia

Post by cashman9 » Thu Feb 03, 2011 2:02 pm

fido-x wrote:Your right, there is a "bug" in the calculations for the shipping. Hadn't noticed it before. Should have seen in the "popup" window on the "Sales" page, that there was no total for the shipping method. Oh well, back to the drawing board ::) :bang:

Good that I pointed you to the right direction. :)

Since I change the sorting order, the tax is also gone and instead it shows insurance cost. I hope that will get fixed as its going forward right?

Active Member

Posts

Joined
Wed Nov 17, 2010 4:28 am

Post by fido-x » Fri Feb 04, 2011 10:51 pm

cashman9 wrote:Since I change the sorting order, the tax is also gone and instead it shows insurance cost. I hope that will get fixed as its going forward right?
Yes. Well, it should. Let me know if it doesn't (I'm sure you will ;D ).

Image
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!


User avatar
Expert Member

Posts

Joined
Sat Jun 28, 2008 1:09 am
Location - Tasmania, Australia

Post by cashman9 » Sun Feb 06, 2011 8:57 am

fido-x wrote:
cashman9 wrote:Since I change the sorting order, the tax is also gone and instead it shows insurance cost. I hope that will get fixed as its going forward right?
Yes. Well, it should. Let me know if it doesn't (I'm sure you will ;D ).

Ok great, you working on the shipping calculation bug right?

Active Member

Posts

Joined
Wed Nov 17, 2010 4:28 am
Who is online

Users browsing this forum: No registered users and 7 guests