Custom SQL Query - CRE Loaded 6.2 - Customer's Last Order
$30-250 USD
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.
ID do Projeto: #355770
Sobre o projeto
Concedido a:
17 freelancers estão ofertando em média $62 nesse trabalho
Hi this is Kiran Patel, 4 yrs exp on SQL. and very good exp on creating complex queries. See PM.
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.
Hi, Expert Computer engineer,Can Start work on Immediatey effect Thanx eeskiypie/amasan with yash4chauhan
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
Will do it for less to build a good review and to get started! I have over 6 years experience in SQL..