Posts Tagged seelowprices

Price Is Reduced After Specified Days

Price Is Reduced After Specified Days

OVERVIEW:
I want the prices of my online store products reduced to specified amount on the basis of when the product was created. When a new product is submitted, the discountprice field in the products table receives a default value based on the price (price * .94 = discountprice)

PRODUCTS database fields (involved in this project)
price
discountprice price * discountrate = discountprice
discountrate .94 (default)
discountdays 10 (default)
datecreated 2010-11-08 23:34:28 CURRENT_TIMESTAMP (default)

JOB A HAND:
Change the SQL Statement in the products pages to include an "IF" statement.
EXAMPLE: If datecreated AND discountdays = OR < NOW then show discountprice OTHERWISE price

PAGES THAT REQUIRE THE CHANGE: I will provide the following PHP pages for the freelancer to change. If its not hard, I may add the additional SQL to complete this project.
http://seelowprices.com/search/justlisted/
http://seelowprices.com/search/keyword/results/
http://seelowprices.com/search/detailpage/
https://seelowprices.com/shoppingcart/
https://seelowprices.com/checkout/verify/

GOAL:
SCENARIO: On a default situation, if I created a product called XYZ with a price of $100 on 2010-11-08 23:34:28, then on 2010-11-18 23:34:28, the price would display $94. Only if I changed the discountrate, would the price of this product vary. Only if I changed the discountdays, would the price change on a different day.

Scripting Language/Database: PHP MySQL

—————————————————————————–
Send me a private message regarding your approach to making this work and the results of the work in completing this project.

INFORMATION PROVIDED:
Above, I have provided what I believe is all the information regarding this project. Please base your bid on this but I will be happy to answer questions and exchange correspondence through this websites personal message board during the development of this work. Try to keep in mind of time zones differences if responses arent immediate.

Tags: , , , , , , , , , , , , , , , ,

Processing Server Update Orders Table

Processing Server Update Orders Table

***This project has been set aside for brycep ***

OVERVIEW:
The credit card processing with Linkpoint works fine. Once the user verifies the order, he or she submits to the securedserver page which merely redirects with 18 hidden fields of data to the card processor. After Linkpoint approves the transaction, the user is sent back to seelowprices.com order complete page. This last page declares the order was valid and displays the order number for confirmation. A new record is inserted in the orders table but there is no identification information coming from the online processor.

GOAL:
I want my Credit Card Processing System with linkpointcentral.com to update Fields: paid, transaction_id and chargetime to the orders table.

a) paid (insert "2")
b) transaction_id (Processors order #)
c) chargetime (date/time)

WEBPAGE ORDER SEQUENCE:
https://seelowprices.com/checkout/
https://seelowprices.com/checkout/paymentoptions/
https://seelowprices.com/checkout/verify/
https://seelowprices.com/checkout/securedserver/
https://www.linkpointcentral.com/lpc/servlet/lppay
https://seelowprices.com/checkout/orderplaced/

Tags: , , , , , , , , , , , , , , , ,

Amazon Flexible Payments Service FPS Setup

Amazon Flexible Payments Service FPS Setup

OVERVIEW
Our website is a secured ecommerce site with Credit Card processing, Paypal, Google Checkout and now looking to link our shopping cart with Amazon Payments. We use Webassist eCart 4.0 for our shopping cart.

WHAT WE ALREADY HAVE FOR AMAZON PAYMENTS
1) Merchant account already setup with Amazon.com
2) Have the Access Key ID
3) Have the Secret Access Key
4) A four webpage checkout process (see below)

GOAL
We need a service provider to implement Amazon Flexible Payments Service FPS. You may use the webpages below to integrate Amazon FPS with Webassist eCart 4.0.

WEBPAGE SEQUENCE – This chain of forms work fine together and a completed order occurs with inserted records into MySQL Orders & OrderDetails tables.

1) PAYMENT OPTION user chooses between credit cards, Paypal, Google Checkout, Amazon FPS
https://seelowprices.com/checkout/paymentoption/

2) VERIFY & SUBMIT FORM
https://seelowprices.com/checkout/amazon/

3) SUBMITTED FORM with 15 hidden fields
https://seelowprices.com/checkout/amazon/securedserver/

LISTING OF THE 15 HIDDEN FIELDS (may or may not be needed)
billingname
billingaddress
billingcity
billingstate
billingzip
billingcountry
billingproter
billingphone
emailaddress
ordertitle
ordernumber
total
subtotal
salestax
shipping

4) ORDER PLACED PAGE – this page thanks the user and provides an order number
https://seelowprices.com/checkout/amazon/orderplaced/

——————————————————————————————————

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 websites personal message board during the development of this work. Try to keep in mind of time zones differences if responses arent 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.

Tags: , , , , , , , , , , , , , , , ,