Sold Product Taken From Inventory

• Project ID:

  623957

• Project Type:

  Fixed

• Budget:

  $30-$250 USD
  

Project Description:

Sold Product Taken From Inventory

SCENARIO:
When a user purchases a product or products from our dynamic website, the completed order works fine but doesn't take the product out of inventory. Each product from the "Products" table is treated as a "one time purchase" item. The table's primary key is productnumber. The column called "forsale" is used to determine whether the product item is for sale or already sold. When the product is created, the column "forsale" has the default value of "2". When the purchase of any product is made, a hidden field with a value of "1" is submitted through a webform to change the "forsale" value from "2" to "1". This submission form is located at https://seelowprices.com/checkout/securedserver2/.

TASK AT HAND
I need a SQL statement and/or whatever script necessary to submit the value of "1" into the "forsale" column of each product that is being sold during every purchase order. If the shopping cart has 3 different items, then 3 products would receive "1" in the "forsale" column.


WEBSITE CHECKOUT PROCESS OVERVIEW
http://seelowprices.com/search/detailpage/ add to cart
https://seelowprices.com/shoppingcart/ verify / edit shoppingcart contents
https://seelowprices.com/checkout/ update address information
https://seelowprices.com/checkout/paymentoption/ choice of payment
https://seelowprices.com/checkout/verify/ submits to the "orders" table
https://seelowprices.com/checkout/securedserver1/ submits to the "orderdetails" table
https://seelowprices.com/checkout/securedserver2/ submits a "1" value to the "products" table column "forsale"
https://seelowprices.com/checkout/securedserver3/ submits hidden fields to the merchant services processor

TABLE STRUCTURE:
http://seelowprices.com/images/forsale_column.jpg
http://seelowprices.com/images/tables_structure.jpg

SOFTWARE USED:
Microsoft SQL Server Database 2008, Scripting Language is ASP VB Script (Classic ASP) Dreamweaver CS4

WEBSITE STATUS:
Website is functional but in it's testing phase.

-----------------------------------------------------------------------------------------------------------------------

INFORMATION PROVIDED:
Above, I have provided what I believe is all the information regarding this project with exception to login information to the FTP & database. Please base your bid on this but I will be happy to answer questions and exchange correspondence through this website's personal message board during the development of this work. Try to keep in mind of time zones differences if responses aren't immediate.

SELECTION PROCESS:
Not required but it is very helpful when the service provider explains in very short detail the results of your work in completing this project here.

Skills required:

ASP, MySQL, Script Install, Shopping Carts, SQL

Additional Files:

forsale_column.jpg tables_structure.jpg