Add simple table to prestashop module
- Status Completed
- Budget €30 - €250 EUR
- Total Bids 16
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).
Thanks.Get free quotes for a project like this
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online