Sedang Disiapkan

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

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.

Kemahiran: Pemprosesan Data, Troli Membeli-belah

Lihat lebih lanjut: sql query find last order date, sql order custom, find name last order sql, sql last order date customer, table customer, q email, per h, n query, g. e. money, e book company be, customer table, country state and city database mysql, code 6 d, b j's, finding orders placed last days sql, query last customer, sql days last order, customer orders sql, sql query select latest accounts, sql view history queries last several days, creating sql table cre loaded, find recent order customer query, order account customer sql, sql select customers last orders, sql query selecting customers orders latest date

Tentang Majikan:
( 15 ulasan ) San Diego, United States

ID Projek: #355770

Dianugerahkan kepada:

soner

I can do this query easily. Please contact.

$50 USD dalam 0 hari
(6 Ulasan)
4.8

20 freelancers are bidding on average $60 for this job

value4u

Hi, please check my PM. Thank you.

$100 USD dalam 2 hari
(143 Ulasan)
7.6
saiSoftIndia

Ready to start now.

$35 USD dalam 0 hari
(118 Ulasan)
6.4
solutionD

Ready and excited.

$45 USD dalam 0 hari
(43 Ulasan)
6.2
Donstudio

hi, get it done professionally and fast. Please review PM. regards from Ralph

$80 USD dalam sehari
(22 Ulasan)
6.2
CoVaLiDiTy

can help you. tnx.

$150 USD dalam sehari
(107 Ulasan)
6.1
mistersoft

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

$50 USD dalam 0 hari
(56 Ulasan)
6.0
softwaredep

Lets start. Thank you.

$75 USD dalam 2 hari
(6 Ulasan)
4.5
esoftbusiness

Hello Sir See PMB.

$90 USD dalam sehari
(4 Ulasan)
4.1
tipstersoft

please check your pm

$30 USD dalam 0 hari
(13 Ulasan)
3.6
wincent

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

$50 USD dalam 0 hari
(7 Ulasan)
3.5
getndone

Hi Plz check PM.

$30 USD dalam 0 hari
(5 Ulasan)
3.3
TheOneInfo

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

$30 USD dalam sehari
(1 Ulasan)
3.1
antony123

I can offer the solution

$100 USD dalam 3 hari
(5 Ulasan)
3.4
shivtechnologies

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

$50 USD dalam sehari
(1 Ulasan)
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 dalam 0 hari
(3 Ulasan)
1.2
YashpalSingh123

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

$75 USD dalam sehari
(1 Ulasan)
1.0
mapanws

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

$90 USD dalam sehari
(0 Ulasan)
0.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 dalam 2 hari
(0 Ulasan)
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 dalam 0 hari
(0 Ulasan)
0.0
manickamK

i can help u

$100 USD dalam sehari
(0 Ulasan)
2.0