Change a cookie based shop into an sql shop

In Progress Posted Sep 26, 2011 Paid on delivery
In Progress 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.

eCommerce HTML Shopping Carts SQL Website Design

Project ID: #1223505

About the project

10 proposals Remote project Active Nov 12, 2011

Awarded to:

netsolve

Glad to work. Thanks

€500 EUR in 11 days
(137 Reviews)
6.7

10 freelancers are bidding on average €590 for this job

krishdts

Hello ,we have gone through your project named Change a cookie based shop into an sql shop and we like to convey that we have already done similar kind of projects before also. We can address any concerns that you More

€750 EUR in 20 days
(76 Reviews)
8.5
NovaStudios

See PM for details.

€550 EUR in 17 days
(204 Reviews)
8.4
neoconcepts

we would like to do the specified things in your current web shop. Thanks Sujit Kumar

€450 EUR in 14 days
(56 Reviews)
6.8
sajjj

hi thecube128, please check PM for details. regards, sajjj

€750 EUR in 30 days
(51 Reviews)
6.8
dotsaravanan

We are very much interested to work with you in this project. Kindly go through the PMB for more details.

€550 EUR in 15 days
(23 Reviews)
6.4
adibr70

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

€449 EUR in 15 days
(21 Reviews)
5.3
frozenwebtech

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

€800 EUR in 14 days
(12 Reviews)
5.2
atulfelix

I've created multiple database applications including imagerotation dot com with over 5 years experience. I can create the login script with sessions and database, infact I have even created a free login script based o More

€250 EUR in 7 days
(3 Reviews)
4.1
spicywebtech

Hi....We do have done such projects in past...please check the PMB for further details.

€650 EUR in 20 days
(0 Reviews)
0.0
amch86

Hi, I have read the requirements and can help you in that. Its nothing but like an eCommerce site functionality. Thanks!

€750 EUR in 10 days
(0 Reviews)
0.0