Akopia Akopia Services

[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date ][Interchange by thread ]

[ic] Complex Order Reports



Has anyone figured out how to generate a custom order report with
information like:

The week/month/year's top selling products.
The week/month/year's Gross Sales
The week to week change in Gross Sales
etc.

Im guessing that the above has to be done in a custom cgi-script or sub
routine. Is there any SQL expert out there that knows off the top of their
head how to run queries to extract the above data from the transactions
database?

Thanks in advance,
Lee






_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users


Search for: Match: Format: Sort by: