Require 3 reports based on Commerce Starter Kit 3.01 ( C# , ASP.NET)
Should use Microsoft report Engine .
Report1 )? Sales report? ( includes graph) . ? List sales for all products over time ( the time range should be set)? for? each sku and also on same graph the number of items added to the cart. ( If the data does not exist it must be added) . Skus should ignore? attribute suffixes.? ?
User Options : TimeScale
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? Specific products / Products in a category/All products
( prob messy)?
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? Sales ( ORder Items) , Added to cart , views
Report 2 ) Stock report
Shows stock levels over time? , predicts how long stock will last? in days.
Same options as report 1
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? + show quantity sold by day , week , month? ( this should be shown in a grid..
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? + SKUs are treated as different items ( Stock for size 4 is seperate to size 6) ?
eg
SKU? ? ? ? Attributes? ? Name? ? ? Week10/06 Week17/06 Week24/06? ? ? ? ? ? Days Left? Total sold? % of total for SKU
Report 3) Refund report
Grid , Orders that have been refununded due to returns? ( again show by date ) , and compare to total sold.? Ignore attributes. Order stat is between 500 and 599 . A total? and break down is required for each return category ( collumns) .?
User Options : TimeScale
The current web site uses enhancements on 3.01 ( and is running as .NET 3.5) ? so any code /enhancements must be presented as specific files which were changed and or scripts to run.