Back/Front end Reseller/affiliate,Salesperson Admin & Corporate Pages
$300-600 USD
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
Project ID: #4003441