Create a system that verifies, calculates and store data posted in a Wordpress member area. The goal is to check and control the payment of stores’ sales commissions to the guides.
The following data should be added in the system:
Sales Amount - The total amount that was sold by the user who is adding the data (employee and store owner);
Date - The date that the sales occurred;
Reference number - The reference number will be related to the person who will receive commission for the sale. Then the system should know that sales with reference number 2 must be summed together for the commission calculation, and it is very important to mention that this value is not related to the sales that have reference number 3, for example.
The system must contain 4 different types of users:
Store employee: Will be able to post data in the system and will be able to view the history of the data that has been added, should also be able to change the data of the same day.
Store Owner: Will be able to add data, modify it in the system and check the data history of all the sales made by all the employees that were added. The system should already show the commissions (guide and developer) that the store owner should pay to the administrator.
Administrator: Can view the data that all stores have added, without distinction per employee, per store only. The administrator will also be able to view the commission paid by each store and the total amount that should be paid for each guide.
Site Manager: Can configure commission values, create new users, and control the entire system. You should also receive a commission on account of your services, which must be calculated and displayed. The commission of the site managers is also calculated using the total amount of sales, an example will be given later.
How does the commission work?
Assuming that a store made a $1000 sale, and the commission on the system is set to 20% for the guide and 2.5% for the site manager. Remembering that the site manager is the one who has the power to define these commissions percentages.
Therefore, the commission to be paid will be $200 for the guide (20% for 1000) and $25 for the developer (2,5% for 1000). The total commission paid will be $225.
How does the data adding and the viewing of this data work?
Taking into account the same previous commission amounts.
The employee 1 of store 5 add a sale, on the date 25/02, an amount of $1000 in the system, with reference number 3. This value will be stored and can be viewed by the employee when he wants.
The owner of store 5, upon accessing the system, will see that the employee 1 made a sale of $1000 to the reference number 3 (guide number 3) on February 25, and that a $225 commission should be paid to the administrator.
The administrator, upon accessing the system, will see that he should receive $225 from the owner of store 5, on account of a sale made on 02/25, to pay $200 to the guide reference number 3 and $25 to the site manager. He may mark this amount as “Paid” or “Not Paid”. This visualization can be done after the sale, since the objective is that the commission should be paid on the same day that the sale was made.
Both the administrator and the store owner can view past value history.
The site manager will be able to view all history, all stores, all employees and all paid commissions, to ensure the system security. The system should be able to work with multiple stores and multiple employees.
The plugin might work in the Front End or in the Wordpress Dashboard. The important thing is that it must be as simple as possible, without major graphic productions and that it must be able to be installed on any Wordpress website.
The important thing is not to have limitations on the number of users, to have a good structure to store and organize the data history and to perform all the functions described previously.