Change a cookie based shop into an sql shop
€250-750 EUR
Paid on delivery
The last freelancer did not deliver and simply disappeared without notice.
We'll give this project another try:
I have a webshop that works with cookies ([url removed, login to view]) but I do not have the time to change the cookie based cart system to a sql database system.
Please have a look at the shop BEFORE you place a bid.
[url removed, login to view]
What I need is an SQL Database (I will supply the Table Structure) and the code that links the DB with the existing shop.
More information on the DB-Structure in the attached file.
What needs to be done:
* Create DB
* Create Password Login (with email notification for forgotten password and the possibility to alter passwords themselves)
* Orders are placed from the existing websites. Every order should be saved with the session-ID until the order is completed
* The Session-ID code that needs to be implemented on every website.
* When entering the existing shopping cart the session-ID String should be devided into separated into the separate products. Here the existing code must be used for the price calculation and displaying.
* After the shopping cart is completed the order can be reviewed on the next page - again the website exists. The code must only be altered.
* Next step is the address for the [url removed, login to view] customer must be able to choose from his saved addresses in the database the address for the shipment and the address for the invoice. Address alterations must be possible.
* When sending the order, the order has to be saved to the databse and an email with the order information is sent to the customer and to our company with the details.
* A new page where the customer details (address for shipping, address for invoice,customer password) can be altered
* A new page where the previous orders can be looked at - with the possibility to re-order one or more of these products.
Thats all.
You see the database is not very big. The following tables are needed:
Table LOGIN: Username, Password, Email
Table ORDER: CustomerID, Order, Order-Date
Table CUSTOMER: Complete Address Information
Tables with product info for later implementation
The string that is created when ordering a product includes: Product-ID; Product Description, Additional Description, Quantity, Package Size, Amount, Price
* The session must be capable to cary at least 20 ordered products before the customer must proceed to the cart.
Not a tough project:)
Interested?
PREVIOUS INFO
At the moment products are chosen and saved in a cookie. When customers go to the shopping cart the price and product details are gathered from a separate file, price reductions are calculated (pretty tough calculationL )and displayed.
What I would need is a pretty simple database.
Password login - with email for forgotten passwords, passwords can be changed by users.
Customers select products on the current website. The product number and quantity are saved in a session. This should work just like on the current website so that I can use the calculations in the current cart. Infos are separated through "|" Different artikels through "~"
When customers go to the shopping cart - The items information and price will be gathered from database files through the product ID.
Calculations from here should remain the same. See the current cart for details
Products in the shopping cart should be able to be saved in a separate table for future shopping - just like it is possible at the moment.
The next step should gather customer invoice address from the database as well as customer delivery address from the database. Separate addresses must be selectable, editable and deletable.
Next – check out with review of order. No payment system at this point.
After order has been sent the customer receives an email with the details of the order and the order is written to the database and the customer shopping history.
Everything works so far. Only the database has to be implemented.
Project ID: #1223505
About the project
Awarded to:
10 freelancers are bidding on average €590 for this job
We are very much interested to work with you in this project. Kindly go through the PMB for more details.
I have experience working with PHP, JavaScript, MySQL and integrating it all into a site. Check out your Private Message for some example sites that I made using PHP. Adrian
Hi There- If you are looking for a serious Web designer team then look no further. Professional developers. a team of Professional & Expert Web Designers and Web Developers with similar expertise here. Our team of More
Hi....We do have done such projects in past...please check the PMB for further details.
Hi, I have read the requirements and can help you in that. Its nothing but like an eCommerce site functionality. Thanks!