Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

List all coupons issued to a user ?

2 views
Skip to first unread message

Ravi Shankar

unread,
Aug 7, 2004, 4:15:01 AM8/7/04
to
IS there a mechanism to retrieve a list of all coupons
issued to a user ?

David Messner [MSFT]

unread,
Aug 12, 2004, 7:43:59 PM8/12/04
to
In FP1 you can export all the coupons associated with a coupon definition.
If that includes user information, that will be included in the exported
file. Other than that you'd have to query the promotion code tables
themselves.

-djm
--
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2004 Microsoft Corporation. All rights
reserved.

--------------------
Content-Class: urn:content-classes:message
From: "Ravi Shankar" <shankar...@hp.com>
Sender: "Ravi Shankar" <shankar...@hp.com>
Subject: List all coupons issued to a user ?
Date: Sat, 7 Aug 2004 01:15:01 -0700
Lines: 3
Message-ID: <1bed01c47c56$a3199150$a501...@phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Thread-Index: AcR8VqMZJkt+fJm9TjKkIRZg1w4gdg==
Newsgroups: microsoft.public.commerceserver.campaigns_csf
Path: cpmsftngxa06.phx.gbl
Xref: cpmsftngxa06.phx.gbl
microsoft.public.commerceserver.campaigns_csf:2816
NNTP-Posting-Host: tk2msftngxa13.phx.gbl 10.40.1.165
X-Tomcat-NG: microsoft.public.commerceserver.campaigns_csf

Ravi Shankar

unread,
Aug 16, 2004, 2:12:38 AM8/16/04
to
I was planning on using a combination of Distribution
Lists (Direct Mailer) and the coupon code export to

1. Intimate the user on their being issued the coupon
2. Create some kind of a storage associated with the
user where this information can be stored on the system
for subsequent use by the system ? (build a subsystem
like basket for storing coupons)

Do you think this would fly ?

Regards.

Andy Xu[MSFT]

unread,
Aug 18, 2004, 4:58:00 PM8/18/04
to
Ravi,

To do the first thing, Direct mail job can take a list which can be
imported from a file (that file can be generated by exporting coupon). So
it is very feasible. However, you probably want to include the coupon
number in the email. You have to either utilize list's rcp_url field or
store the coupon information into a certain user profile property.

The second thing sounds to me is more belonging to your own work. From the
runtime, you can try to retrieve the user's coupon related information by
looking up the promocode table's target_user field. Which usually is the
email address for the user.

HTH,
Andy Xu [MSFT]
Commerce Server Team


--
This posting is provided "AS IS" with no warranties, and confers no rights.

Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this
message are best directed to the newsgroup/thread from which they
originated.

--------------------
Content-Class: urn:content-classes:message
From: "Ravi Shankar" <shankar...@hp.com>
Sender: "Ravi Shankar" <shankar...@hp.com>

References: <1bed01c47c56$a3199150$a501...@phx.gbl>
<1yB41XMg...@cpmsftngxa06.phx.gbl>
Subject: RE: List all coupons issued to a user ?
Date: Sun, 15 Aug 2004 23:12:38 -0700
Lines: 57
Message-ID: <68af01c48358$0803e450$a501...@phx.gbl>


MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable


X-Newsreader: Microsoft CDO for Windows 2000
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300

Thread-Index: AcSDWAgDAs47hGQuQwi7v/OTQzSnWg==


Newsgroups: microsoft.public.commerceserver.campaigns_csf
Path: cpmsftngxa06.phx.gbl
Xref: cpmsftngxa06.phx.gbl

microsoft.public.commerceserver.campaigns_csf:2825

dsum...@gmail.com

unread,
Sep 3, 2012, 6:23:31 AM9/3/12
to
On Saturday, August 7, 2004 3:15:01 AM UTC-5, Ravi Shankar wrote:
> IS there a mechanism to retrieve a list of all coupons
> issued to a user ?

Shop Now and save 15% on your entire order + get free gift(s) + free shipping on orders over $35!!!! http://www.edenfantasys.com/#pcode-VR4
0 new messages