Project Detail

Description

I need a small tweak to the included sales repport2 in my CRELoaded shop and one all new accounting report.

I have a shop based on a CRE Loaded 6.2 patch 13 that has been heavily modified and are using Norwegian language and tax so some adjustments compared to an original Creloaded shop may be needed. The development of this module will be done on a plain CRELoaded 6.2 version (install files can be provided by me), and I want the module to be developed as a module with install instructions. You will not get access to my live shop. I will implement the module based on your install instructions my self. I am available to test the modules during the development process to give feedback if needed.

We use a special version of customer groups for giving right prises for wholesale and retail customers. We also use Norwegian tax and currency. We also have a custom payment module that adds tax so this must be in the report.

TWEAK FOR SALES REPORT2
###################################################
1)
Like today's version I want Yearly, Monthly, Weekly and Daily as display groups, but when I am in daily view I want to click on the line for one of the days and be able to get a list of all the hours within that day and the same list of revenues. It is important the sales report opens and shows this month in daily view by default like today.

2)
I want to display the fields in the report (Date/time, Number of orders, Number of items, Revenue and Shipping) like before but in addition I want to show the COD fee and after this the Gift cards and coupons. After this I want a new revenue column that shows the revenue with subtracted gift cards, coupons and other discounts. After this I want a column with the total revenue(ot_total).

3)
The original revenue shows the ot_subtotal. We have one problem with this. Because on retail customers the sub total shows the price with tax, but on our wholesale customers the sub total shows the price without tax. We need the sub total to be with tax for both customers groups. So we need the report to add tax for the orders made from wholesale customers (members of customer group "1") this must also be done for the shipping and COD fee.

ALL NEW ACCOUNTING SALES REPORT
###################################################
This report will give me all the important numbers I need for making my accounting reports.

I need to be able to filter from date/time to date/time before running the report using a calendar pop up I click on to select the date. The time is default on 24 hours (all day), but I want to be able to set a special from and to hour (drop down box) if I want to.

I need the report to show the following using a kind of grid view shown in the attached image. The grid is to be made like this:

1)
Sub Total = "ot_subtotal" shown 3 times (like the grid example), each separate for the 3 different customer groups we have. 1 for orders made from RETAIL customers (customer group "0"), 2 for orders made from WHOLESALE customers (customer group "1"). 3 the last one is for orders made from customers from other countries (not Norway), this is to be checked against the country in the shipping address for the order.
2)
Shipping = "ot_shipping" shown 3 times in the same way as step 1.

3)COD = "ot_fixed_payment_chg " shown 3 times in the same way as step 1.

4)Discount Cupon = "ot_coupon " shown 3 times in the same way as step 1.

5)Gift card = "ot_gv " shown 3 times in the same way as step 1.

6)Custom OT = "ot_custom" shown 3 times in the same way as step 1.

7)Tax = "ot_tax " shown 3 times in the same way as in step 1, but with a additional total at the end.

8)Total = "ot_total " shown 3 times in the same way as in step 1, but with a additional total at the end.

Please be sure that you understand completely the project you are bidding on (if not ask us before bidding). We are looking for an Creloaded and php expert that have a deep understanding of the Crelodad shopping cart code base. Please don't bid if you are not 100% sure that you can complete the task in time. If you deliver only a half finished product you will not get paid.


Additional files submitted:
grid.png