In Progress

Prestashop MS-SQL Interface

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)

Skills: Microsoft, MySQL, PHP, Software Architecture, SQL

See more: prestashop microsoft sql, prestashop sql server, mysql query invoice prestashop, sql prestashop, prestashop sql, credit card pull database, sql queries, sql and c, prestashop payment module, MS SQL, database microsoft sql, gift voucher payment module prestashop, push pull mysql, mysql number sql, web configuration database table, invoice balance, mysql connection query, vbscript post, mysql prestashop, database gift card, php sql add, mysql windows server 2008, mysql create table fields, gift payment module, queries sql

About the Employer:
( 1 review ) Avon Lake, United States

Project ID: #4469771

Awarded to:

basbas112

Bit of a tedious project, but can be done not an issue, please contact me thank you

$1500 USD in 21 days
(11 Reviews)
5.1

7 freelancers are bidding on average $1394 for this job

krishdts

Hello ,we have gone through your project named Prestashop MS-SQL Interface and we like to convey that we have already done similar kind of projects before also. We can address any concerns that you might have in regard More

$1442 USD in 25 days
(72 Reviews)
8.2
SunFlowerBiz

Hi, please check PM for our portfolio. Regards,

$1575 USD in 25 days
(71 Reviews)
7.1
getndone

let me handle the project for you

$1181 USD in 7 days
(42 Reviews)
5.5
miniric3

Hi, We at on2itonline would love to work with you on this, we do MAD "full service" websites on a clear and fixed budget. We have lots to offer that others don't ,like our lifetime FREE hosting on every website for a s More

$1545 USD in 20 days
(5 Reviews)
4.8
programer218

I am a prestashop developer! I can make this MS-SQL Interface. Please look my portfolio and review!

$1181 USD in 10 days
(16 Reviews)
4.5
Reza2012

Hi I have more than nine years experience in this field. send me details. Thanks.

$1540 USD in 60 days
(4 Reviews)
3.6
bparnerkar

Hello Sir, Thanks for providing us a chance to bid on job proposal. I have 4+ years of experience in Ecommerce development.I am well adept in Prestashop . Developing and customization shops on Prestashop. I have rea More

$1237 USD in 15 days
(1 Review)
3.0
magentomx

i have a develop to connect prestashop mysql to ANY sql (sql ms, sql oracle, sql postgress....). Check in my demos the info, in my protafolio , i have hight expertise into prestashop 1.5.x and last

$1237 USD in 10 days
(0 Reviews)
0.0