I need an Admin Module for Zen Cart [url removed, login to view] that produces advanced sales reports.
I want to be able to generate reports using the the following:
1. Date range (select start and end date from a calender
2. Order Status (ability to select multiple order statuses from the full list)
3. Shipping Country (ability to select multiple countries from the full list)
4. Product (ability to select multiple products from the full list)
option to display summary or detailed report
The detailed report to display as follows:
First display query info from above as a title, ie. This report shows sales from jan 1 2011 - jan 31 2011
Display a table with the following info:
date of sale
number of products in order
- a sub table with the products in order, attributes of items, sale price, cost & gross profit
Sub total for each order# showing sale price, cost and gross profit
Sub total for each country showing sale price, cost and gross profit
Grand total at bottom of report showing sale price, cost and gross profit
Ability to sort by
1. order number then by country then date
2. by country and then order number then date
I will want to be able to print this out in a nice, clear to understand report.
Ability to download csv file.
The summary report should show the following:
Report Title ie. This report shows sales from jan 1 2011 - jan 31 2011
total number of products shipped to each country with total sale price, cost of goods sold and gross profit.
Total Sales $10,000.00
Cost of goods sold $8,000.00
Gross Profit $2000.00
Also show grand totals to all countries selected for the date range.
Again, I will want to be able to print this out in a nice, clear and understandable report.
Ability to download csv
The cost of each product is not in the database. I will need to be able to provide the product cost somehow. I would rather not add a table to database for this. Maybe I could create a file with this information?
Please provide me the files to upload to the server. I will not be able to give you access to the server.