You have chosen to sponsor your bid up to a maximum amount of .
We are looking for a prestashop developer to add a new table to an existing prestashop stats module. The module is an existing admin module, which shows us some stats. We are using prestashop v1.3.7.
We would like it modified to include a new table with the following columns:
Month | Sales | Shipping costs | Profit per month
Description of columns:
Month: One row for every month.
Sales: the total sold in the given month
Shipping costs: if the order weights 2€, if it bigger than 50gr --> 4€ , if it is bigger than 100gr --> 6€. If the payment method is Cash on Delivery, then add 4€.
Profit: Sales - ShippingCosts - Wholesale price
Prestashop has several tables containing the required information... orders, products, etc...
The other table in the module is showing the following and can be used as an example (but should be removed):
Order ID | Total | Profit | Shipping | Discounts | Profit | Shipping | Discounts
The SQL behind this work should not so complicated as you can see in the example.
I am attaching the php file of the existing module, which creates the sample table. You should have a local prestashop installation so you can test the module while developing.
If we are satisfied with your work, we will hire you for future modifications (for instance in a second stage we want to pull data from Google Analytics).