Creating Catalog Expressions
Web Server forum
Back To The Forum Home!Search!Private Messaging System

Web Server Talk Web Server Talk > Web Servers reviews > Microsoft Commerce Server > Content Selection Framework > Creating Catalog Expressions




  Last Thread   Next Thread Next
  Show Printable Version Email this Page Subscribe to this Thread      Post New Thread    Post A Reply      

    Creating Catalog Expressions  
Andy


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
04-22-05 12:51 PM

Hi,

I have had a question from a client that I am unable to answer (well I think
I know the answer but need to check). They want to create an expression that
says "BUY 'A' AND 'B', GET 10% OFF".

I know how to do "BUY 'A', GET 10% OFF" and "BUY 'A' OR 'B', GET 10% OFF",
but can't figure out a way to do this. From my understanding, the expression
will be matched against each line in the basket so will never be true as eac
h
line cannot be 'A' AND 'B' - it can only be one or the other.

I could also set the expression to be "BUY 2 FROM Category 'X'" but this
will allow the customer to select 2 x 'A' rather than 1 x 'A' AND 1 x 'B'.

Is this possible, and if so can you give me a pointer as to how to do it?

Many thanks,
Andy





[ Post a follow-up to this message ]



    RE: Creating Catalog Expressions  
WenJun Zhang[msft]


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
04-25-05 07:51 AM

Hi Andy,

If I understand correctly, what you are talking about is discount
other than expression, right?

If so, with Commerce feature pack 1, you should be able to achieve
this by using Paired Discount. Create 2 discounts as:

BUY 'A', GET 10% OFF of 'B'
BUY 'B', GET 10% OFF of 'A'

In the above case, only if the customer buys both 'A' and 'B', he
will get the 10% discount of total.

Thanks.

Best regards,

WenJun Zhang
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader
so that others may learn and benefit from your issue.

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





[ Post a follow-up to this message ]



    RE: Creating Catalog Expressions  
Andy


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
04-25-05 12:54 PM

Many thanks for that. Now I have a further question.

What if I want to create a discount based on three products, eg: "BUY 'A'
AND 'B' AND 'C', GET 10% OFF"?

Many thanks,
Andy

""WenJun Zhang[msft]"" wrote:

> Hi Andy,
>
> If I understand correctly, what you are talking about is discount
> other than expression, right?
>
> If so, with Commerce feature pack 1, you should be able to achieve
> this by using Paired Discount. Create 2 discounts as:
>
> BUY 'A', GET 10% OFF of 'B'
> BUY 'B', GET 10% OFF of 'A'
>
> In the above case, only if the customer buys both 'A' and 'B', he
> will get the 10% discount of total.
>
> Thanks.
>
> Best regards,
>
> WenJun Zhang
> Microsoft Online Partner Support
>
> When responding to posts, please "Reply to Group" via your newsreader
> so that others may learn and benefit from your issue.
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights





[ Post a follow-up to this message ]



    RE: Creating Catalog Expressions  
WenJun Zhang[msft]


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
04-26-05 12:47 PM

Hi Andy,

From my point of view, this may not be possible when there are more
than 2 items within the condition. The pair discounts solution is
acutally a 'work around'. Actually in Commerce document, we state
that AND is not supported with discount condition.

"Both AND and OR cumulative conditions are allowed in the Catalog
Expression builder, but only the OR condition is supported for
discounts. The AND condition is not supported and should not be used.
"

Anyway I'd like to discuss this issue in our internal. If there is
another direction or work around can achieve the 'more than 2 items'
scenario, I'll update here to let you know.

Thanks.

Best regards,

WenJun Zhang
Microsoft Online Partner Support

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





[ Post a follow-up to this message ]



    RE: Creating Catalog Expressions  
WenJun Zhang[msft]


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
04-27-05 12:55 PM

Hi Andy,

One of our Commerce experts pointed out an approach by using bundle.
Maybe this is not convenient enough but it has been confirmed as the
most straightforward way currently. For your reference:

1. create an order level discount for each bundle with Boolean bundle
target Expression (TargetingContext expression such as Bundle1,
Bundle2, ¡_)
2. define bundle in a custom table, define bundle with productid
3. Create global Dictionaries and add bundle productid / 1 pairs to
them when initializing the site.
4. search each bundle dictionary with productid when item being added
to basket, flip 1 to 0 if match found
5. Evaluate the sum of each bundle dictionary before running basket
pipeline, set corresponding bundle TargetingContext expression to
true if sum is 0.
6. Run basket pipeline to apply targeting discounts.

Thanks.

Best regards,

WenJun Zhang
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader
so that others may learn and benefit from your issue.

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





[ Post a follow-up to this message ]



    Sponsored Links  




 





   All times are GMT. The time now is 11:15 AM.      Post New Thread    Post A Reply      
  Last Thread   Next Thread Next


Most Popular forums 

Forum Jump:
Rate This Thread:

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is OFF
 
Medical and Health forum | Computer Games Reviews | Graphics design forum

Back To The Top
Home | Usercp | Faq | Register