Post by amertad » Tue May 18, 2010 3:48 am

hi.

Can the state reported fully established?

( in -> index.php?route=report/sale )

For example:

Could all products with the number of them in the desired orders seen?
Last edited by i2Paq on Sat Jul 24, 2010 1:58 pm, edited 2 times in total.
Reason: Topic moved

توسعه اپن کارت
طراحی نرم افزارهای مبتنی بر اپن کارت - امنیت/توسعه اختصاصی/خدمات سئو/ سیستم تیکت و فروش بلیط/مدیر سمینار و همایش
اتصال اپن کارت به نرم افزارهای انبار داری و انواع CRM و ERP و دستگاه پوز و پرینتر
https://www.imahmoudi.ir
https://www.opencart.com/index.php?rout ... @gmail.com


User avatar
New member

Posts

Joined
Fri Apr 30, 2010 1:04 am
Location - tehran - iran

Post by Xsecrets » Fri May 21, 2010 11:45 pm

anything is possible if you know php or are willing to pay someone who does, but I don't currently know of any report mods other than the stock 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 i2Paq » Sat May 22, 2010 1:42 am

As soon as I'm starting to use OpenCart (this will be from 1.4.8 ) I will have someone build a full report and when it is done I will donate it to the project.
I hope it will make it into the core.

It could be that it will be 2 separate reports:

1. amount of product sold per period per product and total amount (per currency).

2. total amount sold per period incl. VAT and excl VAT (per currency), total of shipping cost and average cart value + how many customers have bought in that period.

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 breeze » Mon May 24, 2010 6:01 pm

i2Paq,

I will be happy to contribute some spare $$ for your guy to make these, and more if he wants. Pls let me know when you're about to make them.

breeze solutions | proud opencart user


Newbie

Posts

Joined
Mon May 24, 2010 5:56 pm

Post by American » Thu Jun 10, 2010 6:29 am

One of the few things I really liked about OSC based stores, CRELoaded in particular, was their reporting.

See an admin demo: http://demos.creloaded.com/creloaded_pr ... word=demos

Sales Tax report is very important.

Brad G
Granbury, Texas
OC 1.5.6.4


User avatar
New member

Posts

Joined
Fri May 21, 2010 7:39 am
Location - Fort Worth, Texas

Post by fido-x » Thu Jun 10, 2010 5:34 pm

I've already started work on something like this. Still a lot of work to do, but here's some screenshots of what I've got working so far.
stats_summary.png

stats_summary.png (29.66 KiB) Viewed 5549 times

stats_products.png

stats_products.png (39.98 KiB) Viewed 5549 times

stats_customers.png

stats_customers.png (37.33 KiB) Viewed 5549 times


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 » Thu Jun 10, 2010 5:55 pm

fido-x wrote:I've already started work on something like this. Still a lot of work to do, but here's some screenshots of what I've got working so far.
Looking promising! :)

If it is something I could use then I will donate/purchase it as it is something needed for most OC users.

Thanks for the hard work!

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 fido-x » Thu Jun 10, 2010 6:16 pm

i2Paq wrote:Looking promising! :)
Thanks for the comment. After building a statistics page for my own site (can be viewed here), I thought it might be nice to have something similar in the administration, since there is nothing like it in OpenCart.

This "tool" is intended to give an overview of your store operations, including charts and graphs and, when it's finished, it is intended that it will be printable to a PDF file.

I'd be interested in hearing what others think should be included.

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 » Thu Jun 10, 2010 6:32 pm

fido-x wrote:
i2Paq wrote:Looking promising! :)
Thanks for the comment.
YWC!
After building a statistics page for my own site (can be viewed here), I thought it might be nice to have something similar in the administration, since there is nothing like it in OpenCart.

This "tool" is intended to give an overview of your store operations, including charts and graphs and, when it's finished, it is intended that it will be printable to a PDF file.

I'd be interested in hearing what others think should be included.
That is a nice tool you got there!

Did you have a look at my wishes?

1. amount of product sold per period per product and total amount (per currency).

2. total amount sold per period incl. VAT and excl VAT (per currency), total of shipping cost and average cart value + how many customers have bought in that period.

I will PM you a link with the report, mentioned at 2, that I currently use in my osCommerce shop.

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 fido-x » Thu Jun 10, 2010 7:18 pm

i2Paq wrote:That is a nice tool you got there!
Thank you.
Did you have a look at my wishes?

1. amount of product sold per period per product and total amount (per currency).

2. total amount sold per period incl. VAT and excl VAT (per currency), total of shipping cost and average cart value + how many customers have bought in that period.

I will PM you a link with the report, mentioned at 2, that I currently use in my osCommerce shop.
Yes, I saw those. Hadn't thought about "per currency", as the figures I've been working with for this idea came from a single store, single currency and (at the moment) a single category of products (all from the same manufacturer!). But, in the case of this particular store, their website is secondary to their "over-the-counter" sales.

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 » Thu Jun 10, 2010 7:21 pm

fido-x wrote:Yes, I saw those. Hadn't thought about "per currency", as the figures I've been working with for this idea came from a single store, single currency and (at the moment) a single category of products (all from the same manufacturer!). But, in the case of this particular store, their website is secondary to their "over-the-counter" sales.
I have 2 customers that have multiple currency's etc. and thus want these separate reports so they have a easy overview on there sales etc. per currency, product, manufacturer etc.

The more you talk about it, the more you come up with ;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 fido-x » Thu Jun 10, 2010 7:28 pm

i2Paq wrote:I have 2 customers that have multiple currency's etc. and thus want these separate reports so they have a easy overview on there sales etc. per currency, product, manufacturer etc.
So a "Filter by Currency" option then.
The more you talk about it, the more you come up with ;D
You're not wrong there!

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 fido-x » Sun Jun 13, 2010 9:27 pm

OK, I've got something you can have a look at besides screenshots. You can preview current progress at http://dev.fido-x.net, and log in to the admin with username/password pair "stats/stats".

This is still very much "work in development", so don't expect everything to be working yet.

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 » Mon Jun 14, 2010 5:20 am

fido-x wrote:OK, I've got something you can have a look at besides screenshots. You can preview current progress at http://dev.fido-x.net, and log in to the admin with username/password pair "stats/stats".

This is still very much "work in development", so don't expect everything to be working yet.
Wauw!

Rely a great report for what is is now already.

Comments:

On the summary I'm missing the: Total Tax (per tax), Shipment-costs and average cart.

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 fido-x » Mon Jun 14, 2010 1:37 pm

i2Paq wrote:Wauw!

Rely a great report for what is is now already.
Thanks. It's coming along.
Comments:

On the summary I'm missing the: Total Tax (per tax), Shipment-costs and average cart.
Good idea. I'll add them in.

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 fido-x » Thu Jun 17, 2010 8:18 pm

Could have sworn I made a progress report last night!

Anyway, last night I reported that I had total taxes and total shipping displaying. I've now got taxes by tax rate working. I've also made some minor changes in labelling of the tabs.

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 » Fri Jun 18, 2010 12:42 am

fido-x wrote:Could have sworn I made a progress report last night!
They moved the forums last night to a new server.
During that they've "lost" some posts...

pruts0rs ;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 12oclocker » Wed Jul 21, 2010 6:59 am

Hey Fido-x,
I like your customer demographic pie graph thing, that is pretty cool.
check out my post here: http://forum.opencart.com/viewtopic.php?f=110&t=17513
If you were able to take the features of what I described in that post, and add some cool graph stuff to it, that would be a very powerful tool, and everything you would need to track product & sales stats!
In a retail business the product and sales stats, and being able to view them by day, month, week, year, etc. Is the most important part of tracking your business progress.
(also for your averaging, I think a monthly & quarterly average would be very beneficial to show, most businesses work from monthly or quarterly sales statistics, rather than weekly, but I would still keep the weekly in there too)
Let me know what you think.

Active Member

Posts

Joined
Fri Feb 19, 2010 10:50 am

Post by fido-x » Thu Jul 22, 2010 11:09 pm

12oclocker wrote:Hey Fido-x,
I like your customer demographic pie graph thing, that is pretty cool.
check out my post here: http://forum.opencart.com/viewtopic.php?f=110&t=17513
If you were able to take the features of what I described in that post, and add some cool graph stuff to it, that would be a very powerful tool, and everything you would need to track product & sales stats!
In a retail business the product and sales stats, and being able to view them by day, month, week, year, etc. Is the most important part of tracking your business progress.
(also for your averaging, I think a monthly & quarterly average would be very beneficial to show, most businesses work from monthly or quarterly sales statistics, rather than weekly, but I would still keep the weekly in there too)
Let me know what you think.
You've got some good ideas there. I like what you've done as well. I agree, a monthly and quarterly average would be good additions. I've still got some work to do on this (obviously), but at the moment, due to a couple of other projects and a couple of family matters and just having started a course in small business management, I'm a bit squeezed.

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 12oclocker » Sat Jul 24, 2010 2:40 am

fido-x wrote: You've got some good ideas there. I like what you've done as well. I agree, a monthly and quarterly average would be good additions. I've still got some work to do on this (obviously), but at the moment, due to a couple of other projects and a couple of family matters and just having started a course in small business management, I'm a bit squeezed.
I hear you on that, I have zero free time as well, lol, I desperately needed those stat calc's, so I had to write that mod the other night, as soon as I get some time I want to add some graphs for monthly, quarterly, yearly averages & stats, etc.

Active Member

Posts

Joined
Fri Feb 19, 2010 10:50 am
Who is online

Users browsing this forum: No registered users and 2 guests