Windows Server

Brian Seto · Guest

Hi all

I was wondering if there was a way to exclude a product from being shown to
a customer based on the user object.

For example, I want customer A whose first name begins with the letter "A"
to see products A, B, C, and D, but I want customer B whose first name begins
with the letter "B" to see products B, D, E, F.

I know that the targeting system can target discounts to customers based on
their profile, but I want to know how to exclude specific products without
having to create a virtual catalog or base catalog for each possibility.

Any ideas or suggestions would be appreciated.

Thanks in advance
Brian

Vinayak Tadas[MSFT] · Guest

When you request the products from the catalog or category you can set the
SqlWhereClause when you call the catalog APIS

See this article and the related links
http://blogs.msdn.com/vinayakt/archive/2004/05/04/125476.aspx

For eg
string filterClause;
if ( user's first name begins with A)
filterClause = "ProductId like N'A%'";
catalogSearch.SqlWhereClause = filterClause;
int totalRecords = 0;
DataSet catalogSearchResults = catalogSearch.Search(out totalRecords);

Thanks
Vinayak Tadas
Microsoft
http://blogs.msdn.com/vinayakt

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure! For more info visit http://www.microsoft.com/security. Please
reply to the newsgroups only

--------------------
Thread-Topic: Excluding products
thread-index: AcW/quloleQ1fTy2SGyQF/Chm+ZJdw==
X-WBNR-Posting-Host: 65.207.189.233
From: "=?Utf-8?B?QnJpYW4gU2V0bw==?=" <BrianSeto@discussions.microsoft.com>
Subject: Excluding products
Date: Thu, 22 Sep 2005 12:22:03 -0700
Lines: 17
Message-ID: <3530B136-1D57-4607-BF72-486592D48E50@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.commerceserver.general
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:3545
X-Tomcat-NG: microsoft.public.commerceserver.general

Hi all

I was wondering if there was a way to exclude a product from being shown to
a customer based on the user object.

For example, I want customer A whose first name begins with the letter "A"
to see products A, B, C, and D, but I want customer B whose first name
begins
with the letter "B" to see products B, D, E, F.

I know that the targeting system can target discounts to customers based on
their profile, but I want to know how to exclude specific products without
having to create a virtual catalog or base catalog for each possibility.

Any ideas or suggestions would be appreciated.

Thanks in advance
Brian

	Windows Server Forum Index -> Commerce Server	All times are GMT
Page 1 of 1