Need db software to track customer special orders in retail store

C

CH

Does anyone know of a template or software that is designed to track the
creation of a customer special order in a retail store envionment?

Thanks
 
P

pietlinden

Post a description of the process of creating a customer special order and
describe specifically what you want to track and I will help you get
started.

Steve

and then send a bill afterwards? I thought you said your name was
Mark... Sounds suspiciously like PC Data$heet.
 
C

CH

Not sure how much detail you're looking for, but it goes something like this:
We are a retail sporting goods store that often needs to order special
specific product for our customers and would like to keep track of it from
beginning of the process to the end. We would place the order for the
customer from one of a number of vendors, once the product is receievd into
the store, we would contact the customer via telephone or e-mail and advise
them that the product had arrived.

Rough fields
1) customers complete contact data including e-mail address
2) record current date
3)Record specific data of the product they are ordering...style, colour,
size, SKU, vendor, price, expected delivery date, actual delievry date,
purchase order number, comments
4) Record action we took on this file: Customer contact 1st try, 2nd try,
3rd try and how they were contacted,


Is that the info you were looking for?
 
J

John... Visio MVP

He is also looking for how much money you are willing (or unwilling to part
with).

These newsgroups are loaded with well qualified people who are willing to
you with your design for free. Steve aka Mark, aka PCD, aka Roberta is not
one of them.

John...
 
M

Michael Gramelspacher

These newsgroups are loaded with well qualified people who are willing to
you with your design for free. Steve aka Mark, aka PCD, aka Roberta is not
one of them.

Is that so. Looks like this fellow Mark is the only person thus far to offer
any suggestions.
 
B

BruceM

Steve does indeed have a history of providing some useful information before
going back to his old ways. Be advised, and proceed with caution.
Regarding his suggested table design, one observation is that Vendor would
be relevant to the line item (OrderDetail) rather than the entire order if a
customer's order may comprise items from several vendors.
TblHowCustomerContacted may be an extra step you don't really need. A value
list may be enough, although there's no harm to using a lookup table. The
trouble with any system is that if a contact method is not on the list you
will need a way to add it. It's not that hard to do, but it is another
step.
 
L

Larry Linson

John forgot that Michael Gramelspacher is just another of Steve's
sockpuppets.
Is that so. Looks like this fellow Mark is the
only person thus far to offer any suggestions.

If we couldn't chase you down, again, now, Steve, we could remember you've
used Michael Gramelspacher in the past as one of your aliases. This fellow
Michael, thus, is not to be believed, because he is just another of Steve's
personae.
 
A

Arno R

Larry Linson said:
John forgot that Michael Gramelspacher is just another of Steve's
sockpuppets.



If we couldn't chase you down, again, now, Steve, we could remember you've
used Michael Gramelspacher in the past as one of your aliases. This fellow
Michael, thus, is not to be believed, because he is just another of Steve's
personae.

Well, that's new to me...
I have never seen that 'connection'.

Arno R
 
A

Arno R

Michael Gramelspacher said:
Arno, You may not agree with my opinions, but believe me, I am who I say I am.

Michael Gramelspacher
http://www.psci.net/gramelsp/gramelsp/Index.htm

Ok, ok ;-) You have convinced me !
But I was not the one doubting that...
I did not even say that I disagreed with your opinions ...

BTW:
Please don't blame Larry too much for his apparent 'mixing-you-up-with-someone-else'.
Steve has and has had lots and lots of 'persona's' here in the groups.
At times it can be really confusing.

Arno R
 
M

Michael Gramelspacher

BTW:
Please don't blame Larry too much for his apparent 'mixing-you-up-with-someone-else'.
Steve has and has had lots and lots of 'persona's' here in the groups.
At times it can be really confusing.

Arno R

Hey, we're cool.
 
L

Larry Linson

BTW:

Please don't blame Larry too much for his apparent
'mixing-you-up-with-someone-else'.
Steve has and has had lots and lots of 'persona's' here in the groups.
At times it can be really confusing.

My recollection is that (probably in a USENET newsgroup), that Gramelspacher
has leapt to Steve's defense. If Michael is not a Steve sockpupper, or
vice-versa, it seems that he is a person so gullible as to defend the
indefensible, perhaps Steve's best buddy. If I am wrong, then I apologize
for insulting Michael by saying that he is Steve. However, a family history
site doesn't prove "independence".
 
M

Michael Gramelspacher

BTW:

Please don't blame Larry too much for his apparent
'mixing-you-up-with-someone-else'.
Steve has and has had lots and lots of 'persona's' here in the groups.
At times it can be really confusing.

My recollection is that (probably in a USENET newsgroup), that Gramelspacher
has leapt to Steve's defense. If Michael is not a Steve sockpupper, or
vice-versa, it seems that he is a person so gullible as to defend the
indefensible, perhaps Steve's best buddy. If I am wrong, then I apologize
for insulting Michael by saying that he is Steve. However, a family history
site doesn't prove "independence".
Larry, I do not have the slightest idea who Steve is. I only jump to Steve's
defense in certain limited situations. If a message of Steve's does not mention
advertising, then it is just another message in my book. I realize that not
everyone feels that way. I see that as an honest difference of opinion. Really,
that is all there is to it.
 
A

Arno R

Michael Gramelspacher said:
Larry, I do not have the slightest idea who Steve is.

Read all about him, you will get an idea...
and maybe you might consider to stop defending him.
http://home.tiscali.nl/arracom/whoissteve.html
I only jump to Steve's
defense in certain limited situations. If a message of Steve's does not mention
advertising, then it is just another message in my book.

Don't play the same game as Steve...
BTW: In the thread "Export to Text File with newline delimiter" (cdma) you definitely were defending Steve.
In that same thread he was definitely advertising.
I realize that not
everyone feels that way. I see that as an honest difference of opinion. Really,
that is all there is to it.

All we want is to stop the advertising here...
With or without you, we will continue to do so, that's all there is to it.

Arno R
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top