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, g. e. money, e book company be, customer table, creating php table, country state and city database mysql, code 6 d, b j's, p sql, country m, testing q, testing p, SQL Query, sql mysql, sql l, Sql code, sql c, S&M, query table, purchase order, P&G, mysql query, last

Tietoa työnantajasta:
( 15 arvostelua ) 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