Back/Front end Reseller/affiliate,Salesperson Admin & Corporate Pages

Cancelled Posted Dec 2, 2012 Paid on delivery
Cancelled Paid on delivery

We are working in a LAMP envionment using InnoDB databse engine. Affiliates or re-sellers sell on our behalf. They may have salespeople who work for them and also may sell our products with or without commission

Our relationship is with the re-seller. We do not provide a re-seller commission on the sale of a GPS unit. What we do is sell the unit to them at a discounted price. There are Discount tables that apply the discount amount or discount percentage of the regular price in order entry

Like a telephone we change the end user a monthly fee for use. It is to cover both voice, email, SMS text and GPS data that the GPS is capable of transmitting. We negotiate a commission on the monthly service fees that we will pay to the re-seller for each of their customers. We direct bill their customers as well as our own

The front end admin pages allow the re-seller to maintain their company information, company credit card – which is not there now and needs to be added – look at their orders and monthly invoices. Also to view invoice commissions which have been paid and which are owing with column totals. An ability to query orders and invoices for their company or by salesperson if they have any

The salesperson admin pages is a lot more limited and is subset of the re-seller data. The salesperson can maintain his address and contact information and view his orders and invoices only

Commissions obviously will be the most important part of this and we need to provide accurate information on commissions paid and the commissions payable to the re-seller. There is no requirement for the application to generate commission cheques just to provide screen/page queries, printed an email reports

At the time this was coded we did not have our invoicing module in place so commission date was not readily available. Commissions are calculated by a daily cron job which are in the process of completing. This is now being developed

The front end admin pages have 90% of all the data maintainable. We want to use the FE admin pages and expand it to include all the other fields and tables that SafeTracks will use to setup the Re-seller. This would then become the Back End Admin Page for both where SafeTracks can add new re-sellers or modify existing re-seller discount & commission rates etc. which are disabled to the re-seller

The other thing we want to add is SafeTracks global orders and invoices reporting page. These would include orders and invoices for all re-sellers. SafeTracks is also setup as a re-seller. Customers may also buy directly online without going through any re-seller. So this would be a global sales reporting page with an ability to sort on most columns as well as an ability to input query section parameters

This is also where I think we would run re-seller monthly commissions reports grouped by re-seller to provide the amount of commissions owing by re-seller. We would also need to be able to include a function to update one re-seller, a range of re-sellers or all re-sellers as commissions PAID. We should be able to export this date to a CSV file or Excel file so the date can be used as input into an accounting system

There will be other reporting requirements needed at a global or SafeTracks level. We have costs tables in the database so we may require Gross Sales, Costs and Gross Profit reporting for a range of time. This too would need to be exportable in CSV or Excel files

We have created a Re-seller Credit Card Table which we will need to incorporate

No 100% up front milestone. Must speak excellent English. Must sign NDA. Must provide daily status updates & adhere to project management principles

Accounting CSS Excel MySQL PHP

Project ID: #4003441

About the project

3 proposals Remote project Active Dec 8, 2012