Käynnissä

Soner * Reserved * Custom SQL Query - CRE Loaded 6.2 - Customer's Last Order

Additional Work Required From Original Provider...

We need a custom MYSQL query for CRE Loaded 6.2 patch 3, that shows the following…

For each customer that has made a purchase in the store we want to see per column:

A : Customer ID

B : First Name

C : Last Name

D : Email Address

E : Phone Number

F : Main Account Address Book – Company

G : Main Account Address Book – Address

H : Main Account Address Book – Suburb

I : Main Account Address Book – City

J : Main Account Address Book – State

K : Main Account Address Book – Zip Code

L : Main Account Address Book – Country

M : Main Account Address Book – Company

N : Most Recent Order – Order Number

O : Most Recent Order – Order Date

P : Most Recent Order – Order Total

Q : Most Recent Order – Rep (added custom field in Orders table)

Q : Most Recent Order – Payment Type (CC or Money Order)

Please bid the exact cost of creating this query. A sample database will be provided for use and testing purposes after a winning bid is chosen.

Taidot: PHP, Ostoskärryt

Näytä lisää: table customer, q email, n query, book company, customer table, creating php table, p sql, country m, testing q, testing p, sql query, sql mysql, sql l, sql code, sql c, query table, purchase order, mysql query, last, j query, d custom, customer s, custom type, custom field, custom email

About the Employer:
( 15 reviews ) San Diego, United States

Projektin tunnus: #395486

Myönnetty käyttäjälle:

soner

As agreed.

30 $ USD 0 päivässä
(124 arvostelua)
8.2

3 freelanceria on tarjonnut keskimäärin 33 $ tähän työhön

profsite

Check PMB that shows our specialization in creloaded oscommerce

40 $ USD 1 päivässä
(1 arvostelu)
2.3
senthilgr

i will do it for you..send me the details...

30 $ USD 0 päivässä
(0 arvostelua)
0.0