Closed

Prestashop MS-SQL Interface

This project was awarded to basbas112 for $1500 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
N/A
Total Bids
9
Project Description

Customize a Prestashop engine (ver 1.5.3.1) to also post transaction info to existing Microsoft SQL database (Express 2008 SP2).

MySQL (for Prestashop) database, MS SQL database, web server will be hosted same local server (MS Windows Server 2003).

Cart Modifications include:
- Add field to cart for customer to provide “Expected Order Pickup Time”. Field will be two pull down fields, pull down field for the hour (8:00AM to 11:00PM) and one for the minutes, in 5 minute increments. Info will be stored in cart table of MySQL database and transferred to MS-SQL.
- Voucher field in Prestashop cart will be used as Gift Card Field.
* When value is entered into voucher field, query MS SQL database and obtain validity and available balance on card. Will then create voucher for cart for the voucher value or cart value, which ever is less.

Order Modifications Include:
- Obtain order number (orderID) from MS-SQL and use as Prestashop invoice number instead of default invoice number.
- Push order detail information into SQL database, including order header, items, and payment. Payment options include gift card and credit card.

Notes:
- Database connection information will be obtained from MySQL configuration table.
- Credit card transactions will be authorized by FirstData e4 module

- SQL queries have already been written and tested in VBScript. (see attached)

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online