You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Jacques Le Roux <ja...@les7arts.com> on 2008/01/03 14:33:04 UTC

Re: Promotion rule for quantity discount

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" <ra...@gmail.com>
> 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" <ra...@gmail.com> To: user@ofbiz.apache.org 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 <le...@gmail.com> 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 <ra...@gmail.com> 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
>>>>>>
>>>>>>
>>>>>>
>>>
>>
>>
>>
> 


Re: Promotion rule for quantity discount

Posted by Raj Saini <ra...@gmail.com>.
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" <ra...@gmail.com>
>> 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" <ra...@gmail.com>
>>>> 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" 
>>>>> <ra...@gmail.com> To: user@ofbiz.apache.org 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 <le...@gmail.com> 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 <ra...@gmail.com> 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
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>
>>>
>>
>>
>


Re: Promotion rule for quantity discount

Posted by Jacques Le Roux <ja...@les7arts.com>.
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" <ra...@gmail.com>
> 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" <ra...@gmail.com>
>>> 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" <ra...@gmail.com> 
>>>> To: user@ofbiz.apache.org 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 <le...@gmail.com> 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 <ra...@gmail.com> 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
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>
>>
>>
> 
>

Re: Promotion rule for quantity discount

Posted by Raj Saini <ra...@gmail.com>.
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" <ra...@gmail.com>
>> 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" <ra...@gmail.com> 
>>> To: user@ofbiz.apache.org 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 <le...@gmail.com> 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 <ra...@gmail.com> 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
>>>>>>>
>>>>>>>
>>>>>>>
>>>>
>>>
>>>
>>>
>>
>
>