OFBiz › OFBiz - User

Promotion rule for quantity discount

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

15 messages Options

rajsaini

Promotion rule for quantity discount

Hi,

I am having difficulty in setting up promotion. Promotion I want to set
up is:

If the X product in shopping has Qty >= Y, apply 10% discount to the item.

I tried:

Action X Product for Y% discount - Can get the discounted price but
this promotion applies to every item i.e. it does not consider the
minimum quantity limit.

Condition X quantity of Product - If I add this condition to the above
action, it does apply the minimum quantity condition but applies
discount to the item above X.

I searched through the Google and found this
http://lists.ofbiz.org/pipermail/dev/2004-October/006894.html. It make
me sure that it is possible and I am missing something.

Thanks,

Raj

rajsaini

Re: Promotion rule for quantity discount

Sorry to repeat it again. Does someone have any clue to this? I am sure
this is possible, I am missing something trivial.

Thanks,

Raj

Raj Saini wrote:

> Hi,
>
> I am having difficulty in setting up promotion. Promotion I want to
> set up is:
>
> If the X product in shopping has Qty >= Y, apply 10% discount to the
> item.
>
> I tried:
>
> Action X Product for Y% discount - Can get the discounted price but
> this promotion applies to every item i.e. it does not consider the
> minimum quantity limit.
>
> Condition X quantity of Product - If I add this condition to the above
> action, it does apply the minimum quantity condition but applies
> discount to the item above X.
>
> I searched through the Google and found this
> http://lists.ofbiz.org/pipermail/dev/2004-October/006894.html. It make
> me sure that it is possible and I am missing something.
>
> Thanks,
>
> Raj
>
>

Scott Gray

Re: Promotion rule for quantity discount

Hi Raj

It looks like a bug to me, X Product for Y Price works but X Product for Y%
Discount doesn't respect the quantity as you said.

I'll have a look at the code.

Regards
Scott

On 16/12/2007, Raj Saini <[hidden email]> wrote:

>
> Sorry to repeat it again. Does someone have any clue to this? I am sure
> this is possible, I am missing something trivial.
>
> Thanks,
>
> Raj
>
> Raj Saini wrote:
> > Hi,
> >
> > I am having difficulty in setting up promotion. Promotion I want to
> > set up is:
> >
> > If the X product in shopping has Qty >= Y, apply 10% discount to the
> > item.
> >
> > I tried:
> >
> > Action X Product for Y% discount - Can get the discounted price but
> > this promotion applies to every item i.e. it does not consider the
> > minimum quantity limit.
> >
> > Condition X quantity of Product - If I add this condition to the above
> > action, it does apply the minimum quantity condition but applies
> > discount to the item above X.
> >
> > I searched through the Google and found this
> > http://lists.ofbiz.org/pipermail/dev/2004-October/006894.html. It make
> > me sure that it is possible and I am missing something.
> >
> > Thanks,
> >
> > Raj
> >
> >
>
>

Scott Gray

Re: Promotion rule for quantity discount

Fixed in rev. 604551

Regards
Scott

On 16/12/2007, Scott Gray <[hidden email]> wrote:

>
> Hi Raj
>
> It looks like a bug to me, X Product for Y Price works but X Product for
> Y% Discount doesn't respect the quantity as you said.
>
> I'll have a look at the code.
>
> Regards
> Scott
>
> On 16/12/2007, Raj Saini <[hidden email]> wrote:
> >
> > Sorry to repeat it again. Does someone have any clue to this? I am sure
> > this is possible, I am missing something trivial.
> >
> > Thanks,
> >
> > Raj
> >
> > Raj Saini wrote:
> > > Hi,
> > >
> > > I am having difficulty in setting up promotion. Promotion I want to
> > > set up is:
> > >
> > > If the X product in shopping has Qty >= Y, apply 10% discount to the
> > > item.
> > >
> > > I tried:
> > >
> > > Action X Product for Y% discount - Can get the discounted price but
> > > this promotion applies to every item i.e. it does not consider the
> > > minimum quantity limit.
> > >
> > > Condition X quantity of Product - If I add this condition to the above
> > > action, it does apply the minimum quantity condition but applies
> > > discount to the item above X.
> > >
> > > I searched through the Google and found this
> > > http://lists.ofbiz.org/pipermail/dev/2004-October/006894.html . It
> > make
> > > me sure that it is possible and I am missing something.
> > >
> > > Thanks,
> > >
> > > Raj
> > >
> > >
> >
> >
>

Vince Clark

Re: Promotion rule for quantity discount

Not sure if this is a related issue, but we have had really strange behavior using qty discounts and X Product for Y Price. We are using multiple qty discounts so we have about 14 rules in a promo, for qty's 2-15.

When we enter the rules we must enter them starting with the highest qty first (15). If we start with the lowest (2) the promo doesn't work.

This suggests that the order the records are stored in the database matters. We have done this many many times to be absolutely certain what was happening. We can reproduce the problem consistently. We are using a version of trunk from a couple of weeks ago.

I'm going to look thru the code to see how it orders and applies promo rules before filing this as a bug. Any thoughts or suggestions are appreciated.

----- Original Message -----
From: "Scott Gray" <[hidden email]>
To: [hidden email]
Sent: Saturday, December 15, 2007 9:18:15 PM (GMT-0700) America/Chihuahua
Subject: Re: Promotion rule for quantity discount

Fixed in rev. 604551

Regards
Scott

On 16/12/2007, Scott Gray <[hidden email]> wrote:

Scott Gray

Re: Promotion rule for quantity discount

Hi Vince

If you can find a way to replicate the problem with the demo data it'll make
it easier to get it fixed.

Regards
Scott

On 17/12/2007, Vince M. Clark <[hidden email]> wrote:

>
> Not sure if this is a related issue, but we have had really strange
> behavior using qty discounts and X Product for Y Price. We are using
> multiple qty discounts so we have about 14 rules in a promo, for qty's 2-15.
>
> When we enter the rules we must enter them starting with the highest qty
> first (15). If we start with the lowest (2) the promo doesn't work.
>
> This suggests that the order the records are stored in the database
> matters. We have done this many many times to be absolutely certain what was
> happening. We can reproduce the problem consistently. We are using a version
> of trunk from a couple of weeks ago.
>
> I'm going to look thru the code to see how it orders and applies promo
> rules before filing this as a bug. Any thoughts or suggestions are
> appreciated.
>
> ----- Original Message -----
> From: "Scott Gray" <[hidden email]>
> To: [hidden email]
> Sent: Saturday, December 15, 2007 9:18:15 PM (GMT-0700) America/Chihuahua
> Subject: Re: Promotion rule for quantity discount
>
> Fixed in rev. 604551
>
> Regards
> Scott
>
> On 16/12/2007, Scott Gray <[hidden email]> wrote:
> >
> > Hi Raj
> >
> > It looks like a bug to me, X Product for Y Price works but X Product for
> > Y% Discount doesn't respect the quantity as you said.
> >
> > I'll have a look at the code.
> >
> > Regards
> > Scott
> >
> > On 16/12/2007, Raj Saini <[hidden email]> wrote:
> > >
> > > Sorry to repeat it again. Does someone have any clue to this? I am
> sure
> > > this is possible, I am missing something trivial.
> > >
> > > Thanks,
> > >
> > > Raj
> > >
> > > Raj Saini wrote:
> > > > Hi,
> > > >
> > > > I am having difficulty in setting up promotion. Promotion I want to
> > > > set up is:
> > > >
> > > > If the X product in shopping has Qty >= Y, apply 10% discount to the
> > > > item.
> > > >
> > > > I tried:
> > > >
> > > > Action X Product for Y% discount - Can get the discounted price but
> > > > this promotion applies to every item i.e. it does not consider the
> > > > minimum quantity limit.
> > > >
> > > > Condition X quantity of Product - If I add this condition to the
> above
> > > > action, it does apply the minimum quantity condition but applies
> > > > discount to the item above X.
> > > >
> > > > I searched through the Google and found this
> > > > http://lists.ofbiz.org/pipermail/dev/2004-October/006894.html . It
> > > make
> > > > me sure that it is possible and I am missing something.
> > > >
> > > > Thanks,
> > > >
> > > > Raj
> > > >
> > > >
> > >
> > >
> >
>

rajsaini

Re: Promotion rule for quantity discount

In reply to this post by Scott Gray

Hi Scott,

Thanks for fixing it quickly. However, I am half way of what I am trying
to achieve.

Action - X Product for Y% discount works for if the quantity is 10 or
multiple of 10. For example if I add 12, the promotion is applied to
only 10 and rest 2 are not included. Is it desired behavior? If yes, I
am surely missing something more.

I have created a test promo at demo.hotwaxmedia.com. Would be great if
you can have a look on that.

Thanks again for your kind help.

Raj

Action X Product for Y% discount

Scott Gray wrote:

> Fixed in rev. 604551
>
> Regards
> Scott
>
> On 16/12/2007, Scott Gray <[hidden email]> wrote:
>
>> Hi Raj
>>
>> It looks like a bug to me, X Product for Y Price works but X Product for
>> Y% Discount doesn't respect the quantity as you said.
>>
>> I'll have a look at the code.
>>
>> Regards
>> Scott
>>
>> On 16/12/2007, Raj Saini <[hidden email]> wrote:
>>
>>> Sorry to repeat it again. Does someone have any clue to this? I am sure
>>> this is possible, I am missing something trivial.
>>>
>>> Thanks,
>>>
>>> Raj
>>>
>>> Raj Saini wrote:
>>>
>>>> Hi,
>>>>
>>>> I am having difficulty in setting up promotion. Promotion I want to
>>>> set up is:
>>>>
>>>> If the X product in shopping has Qty >= Y, apply 10% discount to the
>>>> item.
>>>>
>>>> I tried:
>>>>
>>>> Action X Product for Y% discount - Can get the discounted price but
>>>> this promotion applies to every item i.e. it does not consider the
>>>> minimum quantity limit.
>>>>
>>>> Condition X quantity of Product - If I add this condition to the above
>>>> action, it does apply the minimum quantity condition but applies
>>>> discount to the item above X.
>>>>
>>>> I searched through the Google and found this
>>>> http://lists.ofbiz.org/pipermail/dev/2004-October/006894.html . It
>>>>
>>> make
>>>
>>>> me sure that it is possible and I am missing something.
>>>>
>>>> Thanks,
>>>>
>>>> Raj
>>>>
>>>>
>>>>
>>>
>
>

Vince Clark

Re: Promotion rule for quantity discount

Raj

You may be running into the same issue we are with quantities. Try this.

Delete all your rules and actions and add them back into the promotion starting with the highest quantity first. I know it sounds crazy, but we are pretty sure we have uncovered a bug related to qty discounts and the only thing that seems to get around it is by putting the actions and rules in from highest to lowest qty. It seems as though the order the records are stored in the database matters.

----- Original Message -----
From: "Raj Saini" <[hidden email]>
To: [hidden email]
Sent: Monday, December 17, 2007 9:36:12 AM (GMT-0700) America/Denver
Subject: Re: Promotion rule for quantity discount

Hi Scott,

Thanks for fixing it quickly. However, I am half way of what I am trying
to achieve.

Action - X Product for Y% discount works for if the quantity is 10 or
multiple of 10. For example if I add 12, the promotion is applied to
only 10 and rest 2 are not included. Is it desired behavior? If yes, I
am surely missing something more.

I have created a test promo at demo.hotwaxmedia.com. Would be great if
you can have a look on that.

Thanks again for your kind help.

Raj

Action X Product for Y% discount

Scott Gray wrote:

rajsaini

Re: Promotion rule for quantity discount

Vince,

In my case it is just one rule. What I want to achieve is apply a X%
discount if the quantities are more than or equal to Y. That means if
the quantities exceeds Y, all the quantities should be discounted by
10%. It works correctly if the value of quantities is exact as Y or any
multiple of Y. For example if Y is 10, it would work correctly for 10,
20, 30....
Any quantities above the multiple of Y are not applied discount.

Do you have above scenario working even for a single rule? I shall be
thankful if you can provide some insight.

Thanks,

Raj

Vince M. Clark wrote:

> Raj
>
> You may be running into the same issue we are with quantities. Try this.
>
> Delete all your rules and actions and add them back into the promotion starting with the highest quantity first. I know it sounds crazy, but we are pretty sure we have uncovered a bug related to qty discounts and the only thing that seems to get around it is by putting the actions and rules in from highest to lowest qty. It seems as though the order the records are stored in the database matters.
>
> ----- Original Message -----
> From: "Raj Saini" <[hidden email]>
> To: [hidden email]
> Sent: Monday, December 17, 2007 9:36:12 AM (GMT-0700) America/Denver
> Subject: Re: Promotion rule for quantity discount
>
> Hi Scott,
>
> Thanks for fixing it quickly. However, I am half way of what I am trying
> to achieve.
>
> Action - X Product for Y% discount works for if the quantity is 10 or
> multiple of 10. For example if I add 12, the promotion is applied to
> only 10 and rest 2 are not included. Is it desired behavior? If yes, I
> am surely missing something more.
>
> I have created a test promo at demo.hotwaxmedia.com. Would be great if
> you can have a look on that.
>
> Thanks again for your kind help.
>
> Raj
>
> Action X Product for Y% discount
>
>
> Scott Gray wrote:
>
>> Fixed in rev. 604551
>>
>> Regards
>> Scott
>>
>> On 16/12/2007, Scott Gray <[hidden email]> wrote:
>>
>>
>>> Hi Raj
>>>
>>> It looks like a bug to me, X Product for Y Price works but X Product for
>>> Y% Discount doesn't respect the quantity as you said.
>>>
>>> I'll have a look at the code.
>>>
>>> Regards
>>> Scott
>>>
>>> On 16/12/2007, Raj Saini <[hidden email]> wrote:
>>>
>>>
>>>> Sorry to repeat it again. Does someone have any clue to this? I am sure
>>>> this is possible, I am missing something trivial.
>>>>
>>>> Thanks,
>>>>
>>>> Raj
>>>>
>>>> Raj Saini wrote:
>>>>
>>>>
>>>>> Hi,
>>>>>
>>>>> I am having difficulty in setting up promotion. Promotion I want to
>>>>> set up is:
>>>>>
>>>>> If the X product in shopping has Qty >= Y, apply 10% discount to the
>>>>> item.
>>>>>
>>>>> I tried:
>>>>>
>>>>> Action X Product for Y% discount - Can get the discounted price but
>>>>> this promotion applies to every item i.e. it does not consider the
>>>>> minimum quantity limit.
>>>>>
>>>>> Condition X quantity of Product - If I add this condition to the above
>>>>> action, it does apply the minimum quantity condition but applies
>>>>> discount to the item above X.
>>>>>
>>>>> I searched through the Google and found this
>>>>> http://lists.ofbiz.org/pipermail/dev/2004-October/006894.html . It
>>>>>
>>>>>
>>>> make
>>>>
>>>>
>>>>> me sure that it is possible and I am missing something.
>>>>>
>>>>> Thanks,
>>>>>
>>>>> Raj
>>>>>
>>>>>
>>>>>
>>>>>
>>
>
>
>

Jacques Le Roux

Re: Promotion rule for quantity discount

Administrator

In reply to this post by Vince Clark

Vince,

If you can reproduce this using Demo data, opening a Jira issue would be a good thing

Thanks

Jacques

De : "Vince M. Clark" <[hidden email]>
> Raj
>
> You may be running into the same issue we are with quantities. Try this.
>
> Delete all your rules and actions and add them back into the promotion starting with the highest quantity first. I know it sounds
crazy, but we are pretty sure we have uncovered a bug related to qty discounts and the only thing that seems to get around it is by
putting the actions and rules in from highest to lowest qty. It seems as though the order the records are stored in the database
matters.

>
> ----- Original Message -----
> From: "Raj Saini" <[hidden email]>
> To: [hidden email]
> Sent: Monday, December 17, 2007 9:36:12 AM (GMT-0700) America/Denver
> Subject: Re: Promotion rule for quantity discount
>
> Hi Scott,
>
> Thanks for fixing it quickly. However, I am half way of what I am trying
> to achieve.
>
> Action - X Product for Y% discount works for if the quantity is 10 or
> multiple of 10. For example if I add 12, the promotion is applied to
> only 10 and rest 2 are not included. Is it desired behavior? If yes, I
> am surely missing something more.
>
> I have created a test promo at demo.hotwaxmedia.com. Would be great if
> you can have a look on that.
>
> Thanks again for your kind help.
>
> Raj
>
> Action X Product for Y% discount
>
>
> Scott Gray wrote:
> > Fixed in rev. 604551
> >
> > Regards
> > Scott
> >
> > On 16/12/2007, Scott Gray <[hidden email]> wrote:
> >
> >> Hi Raj
> >>
> >> It looks like a bug to me, X Product for Y Price works but X Product for
> >> Y% Discount doesn't respect the quantity as you said.
> >>
> >> I'll have a look at the code.
> >>
> >> Regards
> >> Scott
> >>
> >> On 16/12/2007, Raj Saini <[hidden email]> wrote:
> >>
> >>> Sorry to repeat it again. Does someone have any clue to this? I am sure
> >>> this is possible, I am missing something trivial.
> >>>
> >>> Thanks,
> >>>
> >>> Raj
> >>>
> >>> Raj Saini wrote:
> >>>
> >>>> Hi,
> >>>>
> >>>> I am having difficulty in setting up promotion. Promotion I want to
> >>>> set up is:
> >>>>
> >>>> If the X product in shopping has Qty >= Y, apply 10% discount to the
> >>>> item.
> >>>>
> >>>> I tried:
> >>>>
> >>>> Action X Product for Y% discount - Can get the discounted price but
> >>>> this promotion applies to every item i.e. it does not consider the
> >>>> minimum quantity limit.
> >>>>
> >>>> Condition X quantity of Product - If I add this condition to the above
> >>>> action, it does apply the minimum quantity condition but applies
> >>>> discount to the item above X.
> >>>>
> >>>> I searched through the Google and found this
> >>>> http://lists.ofbiz.org/pipermail/dev/2004-October/006894.html . It
> >>>>
> >>> make
> >>>
> >>>> me sure that it is possible and I am missing something.
> >>>>
> >>>> Thanks,
> >>>>
> >>>> Raj
> >>>>
> >>>>
> >>>>
> >>>
> >
> >
>
>

David E Jones

Re: Promotion rule for quantity discount

In reply to this post by Vince Clark

On Dec 17, 2007, at 9:12 AM, Vince M. Clark wrote:

> Raj
>
> You may be running into the same issue we are with quantities. Try
> this.
>
> Delete all your rules and actions and add them back into the
> promotion starting with the highest quantity first. I know it sounds
> crazy, but we are pretty sure we have uncovered a bug related to qty
> discounts and the only thing that seems to get around it is by
> putting the actions and rules in from highest to lowest qty. It
> seems as though the order the records are stored in the database
> matters.

That's a funny symptom... This would certainly happen if your quantity
bases rules did not all have a low and high number, with no overlaps
between them (done using something like <= on one side and > on the
other side).

-David

smime.p7s (3K) Download Attachment

Jacques Le Roux

Re: Promotion rule for quantity discount

Administrator

In reply to this post by rajsaini

I'm not sure as I have been in vacation thes last times, but it seems to me that a change has addressed this problem recently, can
anybody confirms please ?

Thanks

Jacques

From: "Raj Saini" <[hidden email]>

> Vince,
>
> In my case it is just one rule. What I want to achieve is apply a X% discount if the quantities are more than or equal to Y. That
> means if the quantities exceeds Y, all the quantities should be discounted by 10%. It works correctly if the value of quantities
> is exact as Y or any multiple of Y. For example if Y is 10, it would work correctly for 10, 20, 30....
> Any quantities above the multiple of Y are not applied discount.
>
> Do you have above scenario working even for a single rule? I shall be thankful if you can provide some insight.
>
> Thanks,
>
> Raj
>
> Vince M. Clark wrote:
>> Raj
>> You may be running into the same issue we are with quantities. Try this.
>> Delete all your rules and actions and add them back into the promotion starting with the highest quantity first. I know it sounds
>> crazy, but we are pretty sure we have uncovered a bug related to qty discounts and the only thing that seems to get around it is
>> by putting the actions and rules in from highest to lowest qty. It seems as though the order the records are stored in the
>> database matters.
>> ----- Original Message -----
>> From: "Raj Saini" <[hidden email]> To: [hidden email] Sent: Monday, December 17, 2007 9:36:12 AM (GMT-0700)
>> America/Denver Subject: Re: Promotion rule for quantity discount
>> Hi Scott,
>> Thanks for fixing it quickly. However, I am half way of what I am trying to achieve.
>> Action - X Product for Y% discount works for if the quantity is 10 or multiple of 10. For example if I add 12, the promotion is
>> applied to only 10 and rest 2 are not included. Is it desired behavior? If yes, I am surely missing something more.
>> I have created a test promo at demo.hotwaxmedia.com. Would be great if you can have a look on that.
>> Thanks again for your kind help.
>> Raj
>> Action X Product for Y% discount
>>
>> Scott Gray wrote:
>>> Fixed in rev. 604551
>>> Regards Scott
>>> On 16/12/2007, Scott Gray <[hidden email]> wrote:
>>>
>>>> Hi Raj
>>>> It looks like a bug to me, X Product for Y Price works but X Product for Y% Discount doesn't respect the quantity as you said.
>>>> I'll have a look at the code.
>>>> Regards Scott
>>>> On 16/12/2007, Raj Saini <[hidden email]> wrote:
>>>>
>>>>> Sorry to repeat it again. Does someone have any clue to this? I am sure this is possible, I am missing something trivial.
>>>>> Thanks,
>>>>> Raj
>>>>> Raj Saini wrote:
>>>>>
>>>>>> Hi,
>>>>>> I am having difficulty in setting up promotion. Promotion I want to set up is:
>>>>>> If the X product in shopping has Qty >= Y, apply 10% discount to the item.
>>>>>> I tried:
>>>>>> Action X Product for Y% discount - Can get the discounted price but this promotion applies to every item i.e. it does not
>>>>>> consider the minimum quantity limit.
>>>>>> Condition X quantity of Product - If I add this condition to the above action, it does apply the minimum quantity condition
>>>>>> but applies discount to the item above X.
>>>>>> I searched through the Google and found this http://lists.ofbiz.org/pipermail/dev/2004-October/006894.html . It
>>>>>>
>>>>> make
>>>>>
>>>>>> me sure that it is possible and I am missing something.
>>>>>> Thanks,
>>>>>> Raj
>>>>>>
>>>>>>
>>>>>>
>>>
>>
>>
>>
>

rajsaini

Re: Promotion rule for quantity discount

Jacques,

I tested on revision 605076 and it did not work as expected. Scot Gray
fixed something but it is still not working.

Thanks,

Raj

Jacques Le Roux wrote:

> I'm not sure as I have been in vacation thes last times, but it seems
> to me that a change has addressed this problem recently, can anybody
> confirms please ?
>
> Thanks
>
> Jacques
>
> From: "Raj Saini" <[hidden email]>
>> Vince,
>>
>> In my case it is just one rule. What I want to achieve is apply a X%
>> discount if the quantities are more than or equal to Y. That means if
>> the quantities exceeds Y, all the quantities should be discounted by
>> 10%. It works correctly if the value of quantities is exact as Y or
>> any multiple of Y. For example if Y is 10, it would work correctly
>> for 10, 20, 30....
>> Any quantities above the multiple of Y are not applied discount.
>>
>> Do you have above scenario working even for a single rule? I shall be
>> thankful if you can provide some insight.
>>
>> Thanks,
>>
>> Raj
>>
>> Vince M. Clark wrote:
>>> Raj
>>> You may be running into the same issue we are with quantities. Try
>>> this.
>>> Delete all your rules and actions and add them back into the
>>> promotion starting with the highest quantity first. I know it sounds
>>> crazy, but we are pretty sure we have uncovered a bug related to qty
>>> discounts and the only thing that seems to get around it is by
>>> putting the actions and rules in from highest to lowest qty. It
>>> seems as though the order the records are stored in the database
>>> matters.
>>> ----- Original Message ----- From: "Raj Saini" <[hidden email]>
>>> To: [hidden email] Sent: Monday, December 17, 2007 9:36:12 AM
>>> (GMT-0700) America/Denver Subject: Re: Promotion rule for quantity
>>> discount
>>> Hi Scott,
>>> Thanks for fixing it quickly. However, I am half way of what I am
>>> trying to achieve.
>>> Action - X Product for Y% discount works for if the quantity is 10
>>> or multiple of 10. For example if I add 12, the promotion is applied
>>> to only 10 and rest 2 are not included. Is it desired behavior? If
>>> yes, I am surely missing something more.
>>> I have created a test promo at demo.hotwaxmedia.com. Would be great
>>> if you can have a look on that.
>>> Thanks again for your kind help.
>>> Raj
>>> Action X Product for Y% discount
>>>
>>> Scott Gray wrote:
>>>> Fixed in rev. 604551
>>>> Regards Scott
>>>> On 16/12/2007, Scott Gray <[hidden email]> wrote:
>>>>
>>>>> Hi Raj
>>>>> It looks like a bug to me, X Product for Y Price works but X
>>>>> Product for Y% Discount doesn't respect the quantity as you said.
>>>>> I'll have a look at the code.
>>>>> Regards Scott
>>>>> On 16/12/2007, Raj Saini <[hidden email]> wrote:
>>>>>
>>>>>> Sorry to repeat it again. Does someone have any clue to this? I
>>>>>> am sure this is possible, I am missing something trivial.
>>>>>> Thanks,
>>>>>> Raj
>>>>>> Raj Saini wrote:
>>>>>>
>>>>>>> Hi,
>>>>>>> I am having difficulty in setting up promotion. Promotion I want
>>>>>>> to set up is:
>>>>>>> If the X product in shopping has Qty >= Y, apply 10% discount to
>>>>>>> the item.
>>>>>>> I tried:
>>>>>>> Action X Product for Y% discount - Can get the discounted price
>>>>>>> but this promotion applies to every item i.e. it does not
>>>>>>> consider the minimum quantity limit.
>>>>>>> Condition X quantity of Product - If I add this condition to the
>>>>>>> above action, it does apply the minimum quantity condition but
>>>>>>> applies discount to the item above X.
>>>>>>> I searched through the Google and found this
>>>>>>> http://lists.ofbiz.org/pipermail/dev/2004-October/006894.html . It
>>>>>>>
>>>>>> make
>>>>>>
>>>>>>> me sure that it is possible and I am missing something.
>>>>>>> Thanks,
>>>>>>> Raj
>>>>>>>
>>>>>>>
>>>>>>>
>>>>
>>>
>>>
>>>
>>
>
>

Jacques Le Roux

Re: Promotion rule for quantity discount

Administrator

Thanks Raj,

Could you please open a Jira issue for that ? You only have to create an account https://issues.apache.org/jira/browse/OFBIZ

Jacques

From: "Raj Saini" <[hidden email]>

> Jacques,
>
> I tested on revision 605076 and it did not work as expected. Scot Gray
> fixed something but it is still not working.
>
> Thanks,
>
> Raj
>
> Jacques Le Roux wrote:
>> I'm not sure as I have been in vacation thes last times, but it seems
>> to me that a change has addressed this problem recently, can anybody
>> confirms please ?
>>
>> Thanks
>>
>> Jacques
>>
>> From: "Raj Saini" <[hidden email]>
>>> Vince,
>>>
>>> In my case it is just one rule. What I want to achieve is apply a X%
>>> discount if the quantities are more than or equal to Y. That means if
>>> the quantities exceeds Y, all the quantities should be discounted by
>>> 10%. It works correctly if the value of quantities is exact as Y or
>>> any multiple of Y. For example if Y is 10, it would work correctly
>>> for 10, 20, 30....
>>> Any quantities above the multiple of Y are not applied discount.
>>>
>>> Do you have above scenario working even for a single rule? I shall be
>>> thankful if you can provide some insight.
>>>
>>> Thanks,
>>>
>>> Raj
>>>
>>> Vince M. Clark wrote:
>>>> Raj
>>>> You may be running into the same issue we are with quantities. Try
>>>> this.
>>>> Delete all your rules and actions and add them back into the
>>>> promotion starting with the highest quantity first. I know it sounds
>>>> crazy, but we are pretty sure we have uncovered a bug related to qty
>>>> discounts and the only thing that seems to get around it is by
>>>> putting the actions and rules in from highest to lowest qty. It
>>>> seems as though the order the records are stored in the database
>>>> matters.
>>>> ----- Original Message ----- From: "Raj Saini" <[hidden email]>
>>>> To: [hidden email] Sent: Monday, December 17, 2007 9:36:12 AM
>>>> (GMT-0700) America/Denver Subject: Re: Promotion rule for quantity
>>>> discount
>>>> Hi Scott,
>>>> Thanks for fixing it quickly. However, I am half way of what I am
>>>> trying to achieve.
>>>> Action - X Product for Y% discount works for if the quantity is 10
>>>> or multiple of 10. For example if I add 12, the promotion is applied
>>>> to only 10 and rest 2 are not included. Is it desired behavior? If
>>>> yes, I am surely missing something more.
>>>> I have created a test promo at demo.hotwaxmedia.com. Would be great
>>>> if you can have a look on that.
>>>> Thanks again for your kind help.
>>>> Raj
>>>> Action X Product for Y% discount
>>>>
>>>> Scott Gray wrote:
>>>>> Fixed in rev. 604551
>>>>> Regards Scott
>>>>> On 16/12/2007, Scott Gray <[hidden email]> wrote:
>>>>>
>>>>>> Hi Raj
>>>>>> It looks like a bug to me, X Product for Y Price works but X
>>>>>> Product for Y% Discount doesn't respect the quantity as you said.
>>>>>> I'll have a look at the code.
>>>>>> Regards Scott
>>>>>> On 16/12/2007, Raj Saini <[hidden email]> wrote:
>>>>>>
>>>>>>> Sorry to repeat it again. Does someone have any clue to this? I
>>>>>>> am sure this is possible, I am missing something trivial.
>>>>>>> Thanks,
>>>>>>> Raj
>>>>>>> Raj Saini wrote:
>>>>>>>
>>>>>>>> Hi,
>>>>>>>> I am having difficulty in setting up promotion. Promotion I want
>>>>>>>> to set up is:
>>>>>>>> If the X product in shopping has Qty >= Y, apply 10% discount to
>>>>>>>> the item.
>>>>>>>> I tried:
>>>>>>>> Action X Product for Y% discount - Can get the discounted price
>>>>>>>> but this promotion applies to every item i.e. it does not
>>>>>>>> consider the minimum quantity limit.
>>>>>>>> Condition X quantity of Product - If I add this condition to the
>>>>>>>> above action, it does apply the minimum quantity condition but
>>>>>>>> applies discount to the item above X.
>>>>>>>> I searched through the Google and found this
>>>>>>>> http://lists.ofbiz.org/pipermail/dev/2004-October/006894.html . It
>>>>>>>>
>>>>>>> make
>>>>>>>
>>>>>>>> me sure that it is possible and I am missing something.
>>>>>>>> Thanks,
>>>>>>>> Raj
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>
>>
>>
>
>

rajsaini

Re: Promotion rule for quantity discount

Thanks Jacques. I already have an account and Jira issue is created.

https://issues.apache.org/jira/browse/OFBIZ-1560

Thanks,

Raj

Jacques Le Roux wrote:

> Thanks Raj,
>
> Could you please open a Jira issue for that ? You only have to create
> an account https://issues.apache.org/jira/browse/OFBIZ
>
> Jacques
>
> From: "Raj Saini" <[hidden email]>
>> Jacques,
>>
>> I tested on revision 605076 and it did not work as expected. Scot
>> Gray fixed something but it is still not working.
>>
>> Thanks,
>>
>> Raj
>>
>> Jacques Le Roux wrote:
>>> I'm not sure as I have been in vacation thes last times, but it
>>> seems to me that a change has addressed this problem recently, can
>>> anybody confirms please ?
>>>
>>> Thanks
>>>
>>> Jacques
>>>
>>> From: "Raj Saini" <[hidden email]>
>>>> Vince,
>>>>
>>>> In my case it is just one rule. What I want to achieve is apply a
>>>> X% discount if the quantities are more than or equal to Y. That
>>>> means if the quantities exceeds Y, all the quantities should be
>>>> discounted by 10%. It works correctly if the value of quantities is
>>>> exact as Y or any multiple of Y. For example if Y is 10, it would
>>>> work correctly for 10, 20, 30....
>>>> Any quantities above the multiple of Y are not applied discount.
>>>>
>>>> Do you have above scenario working even for a single rule? I shall
>>>> be thankful if you can provide some insight.
>>>>
>>>> Thanks,
>>>>
>>>> Raj
>>>>
>>>> Vince M. Clark wrote:
>>>>> Raj
>>>>> You may be running into the same issue we are with quantities. Try
>>>>> this.
>>>>> Delete all your rules and actions and add them back into the
>>>>> promotion starting with the highest quantity first. I know it
>>>>> sounds crazy, but we are pretty sure we have uncovered a bug
>>>>> related to qty discounts and the only thing that seems to get
>>>>> around it is by putting the actions and rules in from highest to
>>>>> lowest qty. It seems as though the order the records are stored in
>>>>> the database matters.
>>>>> ----- Original Message ----- From: "Raj Saini"
>>>>> <[hidden email]> To: [hidden email] Sent: Monday,
>>>>> December 17, 2007 9:36:12 AM (GMT-0700) America/Denver Subject:
>>>>> Re: Promotion rule for quantity discount
>>>>> Hi Scott,
>>>>> Thanks for fixing it quickly. However, I am half way of what I am
>>>>> trying to achieve.
>>>>> Action - X Product for Y% discount works for if the quantity is 10
>>>>> or multiple of 10. For example if I add 12, the promotion is
>>>>> applied to only 10 and rest 2 are not included. Is it desired
>>>>> behavior? If yes, I am surely missing something more.
>>>>> I have created a test promo at demo.hotwaxmedia.com. Would be
>>>>> great if you can have a look on that.
>>>>> Thanks again for your kind help.
>>>>> Raj
>>>>> Action X Product for Y% discount
>>>>>
>>>>> Scott Gray wrote:
>>>>>> Fixed in rev. 604551
>>>>>> Regards Scott
>>>>>> On 16/12/2007, Scott Gray <[hidden email]> wrote:
>>>>>>
>>>>>>> Hi Raj
>>>>>>> It looks like a bug to me, X Product for Y Price works but X
>>>>>>> Product for Y% Discount doesn't respect the quantity as you said.
>>>>>>> I'll have a look at the code.
>>>>>>> Regards Scott
>>>>>>> On 16/12/2007, Raj Saini <[hidden email]> wrote:
>>>>>>>
>>>>>>>> Sorry to repeat it again. Does someone have any clue to this? I
>>>>>>>> am sure this is possible, I am missing something trivial.
>>>>>>>> Thanks,
>>>>>>>> Raj
>>>>>>>> Raj Saini wrote:
>>>>>>>>
>>>>>>>>> Hi,
>>>>>>>>> I am having difficulty in setting up promotion. Promotion I
>>>>>>>>> want to set up is:
>>>>>>>>> If the X product in shopping has Qty >= Y, apply 10% discount
>>>>>>>>> to the item.
>>>>>>>>> I tried:
>>>>>>>>> Action X Product for Y% discount - Can get the discounted
>>>>>>>>> price but this promotion applies to every item i.e. it does
>>>>>>>>> not consider the minimum quantity limit.
>>>>>>>>> Condition X quantity of Product - If I add this condition to
>>>>>>>>> the above action, it does apply the minimum quantity condition
>>>>>>>>> but applies discount to the item above X.
>>>>>>>>> I searched through the Google and found this
>>>>>>>>> http://lists.ofbiz.org/pipermail/dev/2004-October/006894.html
>>>>>>>>> . It
>>>>>>>>>
>>>>>>>> make
>>>>>>>>
>>>>>>>>> me sure that it is possible and I am missing something.
>>>>>>>>> Thanks,
>>>>>>>>> Raj
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>
>>>
>>
>>
>