This project is to create two reports for oscommerce admin side. Please only experienced ppl bid.
I have a project that involves creating a new report for the admin side.
It is to report on Profit and would be based on this contrib already installed
[url removed, login to view],524
And would be able to compare month on month, day on day, year on year etc. See my attached screenshot
- instead of reporting pure sales, it would need to report gross proffit, so taking sales (excluding any TAX) , deducting the cost of each item from the sales (each item has a field Vendors Price(Base) which is the cost of the item (at present all these are blank as I have not updated the database)
- I would like also the report to take into account the method of payment for each order as the costs involved there differ.
Then for each of these methods there should be a text box that I can put in the relevant percentages that each method of payment takes out (as these can change). I have attached a screen shot of how I think it should look. e.g. paypal charges £0.20 + 2% per transaction so there should be two input boxes for paypal one for fixed transaction cost, and one for percentage transaction costs. For our credit card system there only needs to be one box for percentage.
The trasaction percentages need to worked out on the whole amount the customer has spent on that order inc postage and tax etc
-Also it needs to take into account the type of postage selected by the user, and have an input box to put the average cost value for that method of postage.
- Also we have a loyalty discount contrib that allows returning customers a percentage discount on their next order, this would need to be taken into account for each order
-We also offer some discount coupons, again if any have been used on any order, these have to be taken in to account too
-So for the profit results it would be total sales(excluding tax) minus Vendor base price for each item sold minus transaction costs minus postage costs per item minus cost of any Loyalty discount used minus cost of any coupons used
Ideally the input boxes values should actually be set by a configuration menu within the "Configuration" admin box that way I would not have to keep typing in all the variables for each report if the values havent changed.
-----END REPORT 1
This is to create a report that is similar to this contrib (which we already have installed)
[url removed, login to view],539/category,12/search,sales+tax
But we need to have the columns to break down the sales to show the total of taxable, and non taxable sales to all the different Tax Zones we have set up.
So we need this columns added to the report
-Product sales Gross (same as origional contrib)
-Product sales Total NET (same as origional contrib)
-NON tax sales in UK (this is a total of all the NON taxable sales within the tax zone UK that we have set up in oscommerce->admin->Localizations/taxes->Tax Zones)
-Taxable sales in the UK NET (so all the sales to the tax zone UK that were taxable (but excluding the total of the tax))
-Total tax paid by UK customers (this is the total tax from the above column)
-NON tax sales in EU (this is a total of all the NON taxable sales within the tax zone EU that we have set up in oscommerce->admin->Localizations/taxes->Tax Zones)
-Taxable sales in the EU NET (so all the sales to the tax zone EU that were taxable (but excluding the total of the tax))
-Total tax paid by EU customers (this is the total tax from the above column)
-NON tax sales rest of world (this is a total of ALL SALES to the tax zone International that we have set up in oscommerce->admin->Localizations/taxes->Tax Zones . It is all sales because we do not charge Tax for international orders outside of UK or EU)
-Shipping and Handling UK (total of all shipping and hadling paid by UK customers )
-Shipping and handling EU (total for EU)
-Shipping and Handling International ( total for international tax zone)
-Gift vouchers -(same as origional contrib)
-Customer loyalty - (total amount of customer loyalty fee claimed back. We have a contribution installed that gives customers discounts for repeat orders)
--------End Report 2