PHP / MySQL work
I have a simple ordersysrem at mongoclikke . de (please have a look and click on the RED link "BESTELLEN".
The text of the website is all in German but no worries, the code and description is in English.
If there are any problems with the language, let me know!
Some useful words / sentences so that you can understand the order process:
D / Bitte wähl das Produkt aus das du bestellen möchtest.
E / Choose product
D / weiter
E / next
D / Bitte die gewünschte Versandmethode auswählen.
E / Choose shipping method
D / unversichter / versichert
E / insured / not insured
D / Bitte eine Zahlungsmethode auswahlen.
E / Choose payment method
D / Überweisung
E / Bank transfer / Wire transfer
D / Nachname
E / Cash On Delivery (COD)
What needs to be done:
Currently, you can only order one (1) item at a time.
Customer will need to be able to order up to 4 different items.
So when they see the first screen where they can choose an item, they need to be able to have severals (4 in total) drop down menues where they can choose multiple items.
When a customer orders more than one item, they will get a discount.
It will be an absolut discount (xx amoutn of Euros).
So, for example, if a customer orders 2 items, they will get x amout of Euros. If they order 3 items, they will get xxx amount of Euros as a discount.)
When a customer orders multiple items, the shipping cot will differ from the normal shipping cost.
It will be a flatrate for all the ordered items.
So, for example, if a customer orders 3 items, he will not be charged 3 time the shipping cost for one item but a certain flat rate for all 3 items which will be lower than 3 times the shipping cost for one item.
On my backend administration panel, I can only see the raw data rignt now: Name, Sttreet, Amount etc.
But what I want is an exttra page with simple statistics on there.
A page which can tell me how man customers ordered insured shipping versus uninsured shipping for example.
It should be pretty staight forward: You probably need to do a "row count" and output the data on a page.
I don't need graphical statistics. Numbers in a table are okay for me (If you can do graphics / charts, that would be very nice though!)
There are several different statistics I'll need.
Number of products people order (last 14 days / last 50 days / last 300 days)
Number of prople who chose insured / uninsured shipping
Number of people who chose payment option bank ttransfer versus cash on delivery
Number of people who piad (already) versus number of people who didn't pay.
Average amount of turnover per customer
etc. (I might need 2 or 3 statistics more but there shouldn't be a problem once you did the first one.
GOOGLE ANALYTICS / GOOGLE GOAL TRACKING
Please also insert the php code of my Google Analytics account and Google GOAL TRACKING (Adwords) into the code of the site so that I can easily track my stats and results.
It's just a siingle line of php code which needs to be inserted in each php page. That's it.
Okay, this might seem like a lot of work but if you are an experienced PHP / MySQL coder, this shouldn't be a problem for you.
If you need any clarification or if you don't agree with any of this description, please let me know.
This project is NOT very urgent.
So, it's okay if you have other stuff to do right now and only want to do this project later on.
Up to 2 weeks (14 days) is allright for me.