Find Jobs
Hire Freelancers

Create two admin reports for Oscommerce

$250-750 USD

En curso
Publicado hace alrededor de 15 años

$250-750 USD

Pagado a la entrega
This project is to create two reports for oscommerce admin side. Please only experienced ppl bid. REPORT 1 -------------- 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 [login to view URL],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 REPORT 2 ---------- This is to create a report that is similar to this contrib (which we already have installed) [login to view URL],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
ID del proyecto: 371766

Información sobre el proyecto

13 propuestas
Proyecto remoto
Activo hace 15 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos

Sobre este cliente

Bandera de UNITED KINGDOM
Glasgow2, United Kingdom
5,0
46
Miembro desde ago 10, 2007

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.