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

Concluído Postado Dec 10, 2008 Pago na entrega
Concluído Pago na entrega

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.

Processamento de dados Carrinhos de compras

ID do Projeto: #355770

Sobre o projeto

17 propostas Projeto remoto Ativo em Dec 15, 2008

Concedido a:

soner

I can do this query easily. Please contact.

$50 USD em 0 dias
(6 Comentários)
4.8

17 freelancers estão ofertando em média $62 nesse trabalho

value4u

Hi, please check my PM. Thank you.

$100 USD in 2 dias
(152 Comentários)
7.6
saiSoftIndia

Ready to start now.

$35 USD in 0 dias
(180 Comentários)
6.8
mistersoft

Will be done today. I will create mysql query for this. Thanks!

$50 USD in 0 dias
(109 Comentários)
6.8
wincent

quick work. im very familiar with creloaded and mysql/php.

$50 USD in 0 dias
(8 Comentários)
4.1
esoftbusiness

Hello Sir See PMB.

$90 USD em 1 dia
(7 Comentários)
4.1
softwaredep

Lets start. Thank you.

$75 USD in 2 dias
(6 Comentários)
4.5
tipstersoft

please check your pm

$30 USD in 0 dias
(13 Comentários)
3.6
TheOneInfo

Hi this is Kiran Patel, 4 yrs exp on SQL. and very good exp on creating complex queries. See PM.

$30 USD em 1 dia
(1 Comentário)
3.1
antony123

I can offer the solution

$100 USD in 3 dias
(5 Comentários)
3.4
shivtechnologies

Hi, I can create the query to generate the details required.

$50 USD em 1 dia
(1 Comentário)
1.8
phpsmith

Hi, I am a oscommerce expert. I have been working on oscommerce for the last 5 years so have a lot of experience and can do pretty much anything with it.

$49 USD in 0 dias
(3 Comentários)
1.2
YashpalSingh123

Hi, Expert Computer engineer,Can Start work on Immediatey effect Thanx eeskiypie/amasan with yash4chauhan

$75 USD em 1 dia
(1 Comentário)
1.0
mapanws

Dear Sir, We are a web design firm from Indonesia. We can do this.

$90 USD em 1 dia
(0 Comentários)
0.0
manickamK

i can help u

$100 USD em 1 dia
(0 Comentários)
2.0
prabhas123

Hi, I can write a query for u. I have been writing procedures in mysql for many projects. Pl. provide me the database structure so that I can start thanks

$50 USD in 2 dias
(0 Comentários)
0.0
Kiran7

Will do it for less to build a good review and to get started! I have over 6 years experience in SQL..

$30 USD in 0 dias
(0 Comentários)
0.0