Project Detail

Description

Hi,

THIS WORK IS FOR AN ADULT TOY SITE. PLEASE DO NOT BID UNLESS YOU ARE WILLING TO WORK ON IT!!

We do have a test server for work done that you can us.

What we need to do is to be able to customize this contribution which is already installed:
http://www.oscommerce.com/community/contributions,524/

So that we can search daily, weekly and monthly sales. This contribution has these functions but I want to be able to select these by a drop down menu.

Now to the more difficult part. I also need to be able to separate sales by date and country and also province. This is for tax reasons. We only use one currency so there is no need to separate currencies or anything like that. We are in Canada, British Columbia and if a sale is made on an item in this province it needs two taxes and if its outside of BC and in another province it only needs one tax. If a sale is made outside of the country there are no taxes. So we need these figures seperated so the accountant can figure out the taxes correctly.

If it would be easier you could make a drop down menu so that I can select totals for all countries combined or an individual country. If a country is selected it would show totals by province/state and a total for all sales combined for that country.

The total shown for these results would be without the taxes charged so no need to include them but this would need to include any shipping charges the customer has been charged.

The contribution currently allows me to remove pending orders, delivered orders and so on from the totals. I would still like this function to be available so please do not remove it. But would like to change how I use it. I want to see sales by order status by using check boxes instead of the current oscommerce red (Deselect) and green (Active) buttons that would be great. Every time I don't want to see lets say pending orders in the totals for instance it currently re-loads the page. This is not needed. Check boxes would work much better.

So to wrap up the things needed:

1.) Search by date using drop down menus.
2.) Display sales by All Countries, Country which lists sales by State/Province and a total for all but without taxes and will include shipping costs.
3.) Change current order selector (pending, processing, delivered...) so that is uses a check boxes.

I hope I explained myself enough. Feel free to contact me if you need some clarification.

Thanks,
Jamie