I am running an online shop based on PrestaShop software. I need as simple module that will calculate points accumulated by the customer with each order.
Each product apart form monetary value has points value as well. For example one product cost £9 and also has a value of 9.8 points.
Thus there needs to be a database amendment that will be in a shape of tables associated with the product that describe amount of points for each product.
Next in PRODUCT EDITION area we need to have POINTS TAB - See Points Tab 1.jpg.
When we click on Points Tab we need to be able to edit points for each product.
Once we have done that, we need to display amount of points on the product page on the main page not the back office - see Front [url removed, login to view] - Customizable colours and font - simple amendment in css and php.
Next when customer makes a purchase - all of the points need to be calculated and summed up.
Total points need to be visible in the cart - sum of points per order and sum of points per product x amount.,
See Cart [url removed, login to view]
Once order has been submitted and completed all of the points accumulated need to be inserted into the database and associated to the customer. Following order points MUST be added to the previous points not overwritten.
When we are accessing CUSTOMER TAB in back office - we need to see amount of points accumulated by the customer to this point and that needs to be a FORM input that we can edit - what will result in updating the database.
See Customer [url removed, login to view]
After each purchase I need to have points displayed on the invoice for the customer.
In table - points for product total
Underneath - total points for the order and Total points until current date.
Please see invoice [url removed, login to view]
There also need to be an option to change points into credits/voucher amount.
Export button that will export data for specific month.
Reset button that will clear point for all customers.
Export to contain this field Private Note.
Please see Private Note [url removed, login to view]
Private Note is separated by commas and contains 4 values.
Button needs to export data to excel in this format - including total points for the client during chosen month:
Please see Excel Export [url removed, login to view]
This is going to be a multishop platform - for Type 1 Customers that will generate vouchers for accumulated points. Points to be deleted upon conversion. Type 2 Customers that will simply export points at the end of the month and reset data.
Module can be the same for both shops but must export Client ID, Name , Surname, Private Note split in 4 and in the middle of the Prvate note - amount of points generated by the customer this month.
We have had a module already but unfortunately it has been interfering with the whole shop, delaying loading time - customers with lots of orders could not be loaded due to time out error when module was enabled.
Map and Graphic layout of CUSTOMER TAB was completely messed up when module was enabled.
Shop was freezing and transactions were missing.
These are things that we need to avoid.
There might still be some amendments to the project but this will be discussed as we go along.