OFBiz › OFBiz - User

Re: Price tier

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

5 messages Options

Pierre Smits-3

Re: Price tier

Hi James,

Price maintenance can be the most laborious task of PIM. Ofbiz offers both
extensive capabilities through price rules (see [1]) as well as the
echnical flexibility to help you with this. Have a look at the demo data
provided codebase. If you have suggestions how to improve the demo data
regarding this, please let us know.

Without having the complete picture you have, defining price rules per
product category could help you here.

[1]
https://demo-stable.ofbiz.apache.org/catalog/control/EditProductPriceRules?productPriceRuleId=9000

Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since
2008 (without privileges)

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer

On Fri, Jun 5, 2020 at 12:32 AM <[hidden email]> wrote:

> What is the best way to handle the below tiered pricing by product with
> quantity breaks in Ofbiz? If we have to set this up by product by tier
> this will be a nightmare
>
>
>
> Item Sales 1 (0-6) (6-35) 36-71 72+
> ISB79963 3.65 3.1 2.55 2.3
> ISB79965 1.85 1.6 1.3 1.17
> ISB79970 13.99 11.95 9.85 8.87
> ISB79971 11.99 10.25 8.45 7.61
> ISB79972 5.75 4.95 3.99 3.59
> ISB79973 3.85 3.3 2.7 2.43
> ISB79975 1.55 1.35 1.1 0.99
> ISB79980 12.99 10.99 9.25 8.33
> ISB79981 10.99 9.5 7.85 7.07
> ISB79982 5.75 4.85 3.99 3.59
> ISB79983 3.85 3.25 2.7 2.43
> ISB79985 2.05 1.75 1.5 1.35
> ISB79988 2.55 2.2 1.8 1.62
>

Pierre Smits-3

Re: Price tier

To assist you in evaluation how this works (and to help you define your own
price rules) I have defined some new demo data regarding this. Currently
this is not in the code base, but you can evaluate/test this merging PR
#!17 into your development implementation. See
https://github.com/apache/ofbiz-framework/pull/117

Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since
2008 (without privileges)

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer

On Fri, Jun 5, 2020 at 8:18 AM Pierre Smits <[hidden email]> wrote:

> Hi James,
>
> Price maintenance can be the most laborious task of PIM. Ofbiz offers both
> extensive capabilities through price rules (see [1]) as well as the
> echnical flexibility to help you with this. Have a look at the demo data
> provided codebase. If you have suggestions how to improve the demo data
> regarding this, please let us know.
>
> Without having the complete picture you have, defining price rules per
> product category could help you here.
>
> [1]
> https://demo-stable.ofbiz.apache.org/catalog/control/EditProductPriceRules?productPriceRuleId=9000
>
> Met vriendelijke groet,
>
> Pierre Smits
> *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since
> 2008 (without privileges)
>
> *Apache Trafodion <https://trafodion.apache.org>, Vice President*
> *Apache Directory <https://directory.apache.org>, PMC Member*
> Apache Incubator <https://incubator.apache.org>, committer
> Apache Steve <https://steve.apache.org>, committer
>
>
> On Fri, Jun 5, 2020 at 12:32 AM <[hidden email]> wrote:
>
>> What is the best way to handle the below tiered pricing by product with
>> quantity breaks in Ofbiz? If we have to set this up by product by tier
>> this will be a nightmare
>>
>>
>>
>> Item Sales 1 (0-6) (6-35) 36-71 72+
>> ISB79963 3.65 3.1 2.55 2.3
>> ISB79965 1.85 1.6 1.3 1.17
>> ISB79970 13.99 11.95 9.85 8.87
>> ISB79971 11.99 10.25 8.45 7.61
>> ISB79972 5.75 4.95 3.99 3.59
>> ISB79973 3.85 3.3 2.7 2.43
>> ISB79975 1.55 1.35 1.1 0.99
>> ISB79980 12.99 10.99 9.25 8.33
>> ISB79981 10.99 9.5 7.85 7.07
>> ISB79982 5.75 4.85 3.99 3.59
>> ISB79983 3.85 3.25 2.7 2.43
>> ISB79985 2.05 1.75 1.5 1.35
>> ISB79988 2.55 2.2 1.8 1.62
>>
>

Pierre Smits-3

Re: Price tier

In reply to this post by Pierre Smits-3

Hi James,

That is a way to do it, but I suspect it will add a lot to manage prices
for each product. A simpler way would be to define the discounts as
percentages of one of standard price definitions of the product (based on
the ProductPriceType, see [1]). That way you only have to maintain 1 price
per product, instead of 1 per tier per product.

Another way is to have a fixed discount amount per tier, again being the
selected standard price.

As always, OFBiz offers a lot of flexibility to have it dealing with such
price variations as you like...

[1]
https://demo-stable.ofbiz.apache.org/webtools/control/FindGeneric?entityName=ProductPriceType

Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since
2008 (without privileges)

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer

On Fri, Jun 5, 2020 at 12:52 PM <[hidden email]> wrote:

> Since each product as a unique price in each tier would i need to create
> a rule for each product for each tier?
>
> -------- Original Message --------
> Subject: Re: Price tier
> From: Pierre Smits <[hidden email]>
> Date: Thu, June 04, 2020 11:18 pm
> To: [hidden email]
>
> Hi James,
>
> Price maintenance can be the most laborious task of PIM. Ofbiz offers
> both
> extensive capabilities through price rules (see [1]) as well as the
> echnical flexibility to help you with this. Have a look at the demo data
> provided codebase. If you have suggestions how to improve the demo data
> regarding this, please let us know.
>
> Without having the complete picture you have, defining price rules per
> product category could help you here.
>
> [1]
>
> https://demo-stable.ofbiz.apache.org/catalog/control/EditProductPriceRules?productPriceRuleId=9000
>
> Met vriendelijke groet,
>
> Pierre Smits
> *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/>
> since
> 2008 (without privileges)
>
> *Apache Trafodion <https://trafodion.apache.org>, Vice President*
> *Apache Directory <https://directory.apache.org>, PMC Member*
> Apache Incubator <https://incubator.apache.org>, committer
> Apache Steve <https://steve.apache.org>, committer
>
>
> On Fri, Jun 5, 2020 at 12:32 AM <[hidden email]> wrote:
>
> > What is the best way to handle the below tiered pricing by product with
> > quantity breaks in Ofbiz? If we have to set this up by product by tier
> > this will be a nightmare
> >
> >
> >
> > Item Sales 1 (0-6) (6-35) 36-71 72+
> > ISB79963 3.65 3.1 2.55 2.3
> > ISB79965 1.85 1.6 1.3 1.17
> > ISB79970 13.99 11.95 9.85 8.87
> > ISB79971 11.99 10.25 8.45 7.61
> > ISB79972 5.75 4.95 3.99 3.59
> > ISB79973 3.85 3.3 2.7 2.43
> > ISB79975 1.55 1.35 1.1 0.99
> > ISB79980 12.99 10.99 9.25 8.33
> > ISB79981 10.99 9.5 7.85 7.07
> > ISB79982 5.75 4.85 3.99 3.59
> > ISB79983 3.85 3.25 2.7 2.43
> > ISB79985 2.05 1.75 1.5 1.35
> > ISB79988 2.55 2.2 1.8 1.62
> >
>

Pierre Smits-3

Re: Price tier

In reply to this post by Pierre Smits-3

That is what I suggested earlier. See latest addition to pr #117 as an
example.

https://github.com/apache/ofbiz-framework/commit/299ebe3a99ca1cfa8b484360d916a445f7a78bf2

Op vr 5 jun. 2020 15:26 schreef <[hidden email]>:

> Ok Great so we can add a new Product Price Type. Let's Say we add 3 new
> Product Price Types. Tier 1, Tier 2, Tier 3. Can price rules be set up
> to utilize a percentage of these new Product Price Types?
>
> -------- Original Message --------
> Subject: Re: Price tier
> From: Pierre Smits <[hidden email]>
> Date: Fri, June 05, 2020 4:18 am
> To: [hidden email]
>
> Hi James,
>
> That is a way to do it, but I suspect it will add a lot to manage prices
> for each product. A simpler way would be to define the discounts as
> percentages of one of standard price definitions of the product (based
> on
> the ProductPriceType, see [1]). That way you only have to maintain 1
> price
> per product, instead of 1 per tier per product.
>
> Another way is to have a fixed discount amount per tier, again being the
> selected standard price.
>
> As always, OFBiz offers a lot of flexibility to have it dealing with
> such
> price variations as you like...
>
> [1]
>
> https://demo-stable.ofbiz.apache.org/webtools/control/FindGeneric?entityName=ProductPriceType
>
> Met vriendelijke groet,
>
> Pierre Smits
> *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/>
> since
> 2008 (without privileges)
>
> *Apache Trafodion <https://trafodion.apache.org>, Vice President*
> *Apache Directory <https://directory.apache.org>, PMC Member*
> Apache Incubator <https://incubator.apache.org>, committer
> Apache Steve <https://steve.apache.org>, committer
>
>
> On Fri, Jun 5, 2020 at 12:52 PM <[hidden email]> wrote:
>
> > Since each product as a unique price in each tier would i need to create
> > a rule for each product for each tier?
> >
> > -------- Original Message --------
> > Subject: Re: Price tier
> > From: Pierre Smits <[hidden email]>
> > Date: Thu, June 04, 2020 11:18 pm
> > To: [hidden email]
> >
> > Hi James,
> >
> > Price maintenance can be the most laborious task of PIM. Ofbiz offers
> > both
> > extensive capabilities through price rules (see [1]) as well as the
> > echnical flexibility to help you with this. Have a look at the demo data
> > provided codebase. If you have suggestions how to improve the demo data
> > regarding this, please let us know.
> >
> > Without having the complete picture you have, defining price rules per
> > product category could help you here.
> >
> > [1]
> >
> >
> https://demo-stable.ofbiz.apache.org/catalog/control/EditProductPriceRules?productPriceRuleId=9000
> >
> > Met vriendelijke groet,
> >
> > Pierre Smits
> > *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/>
> > since
> > 2008 (without privileges)
> >
> > *Apache Trafodion <https://trafodion.apache.org>, Vice President*
> > *Apache Directory <https://directory.apache.org>, PMC Member*
> > Apache Incubator <https://incubator.apache.org>, committer
> > Apache Steve <https://steve.apache.org>, committer
> >
> >
> > On Fri, Jun 5, 2020 at 12:32 AM <[hidden email]> wrote:
> >
> > > What is the best way to handle the below tiered pricing by product with
> > > quantity breaks in Ofbiz? If we have to set this up by product by tier
> > > this will be a nightmare
> > >
> > >
> > >
> > > Item Sales 1 (0-6) (6-35) 36-71 72+
> > > ISB79963 3.65 3.1 2.55 2.3
> > > ISB79965 1.85 1.6 1.3 1.17
> > > ISB79970 13.99 11.95 9.85 8.87
> > > ISB79971 11.99 10.25 8.45 7.61
> > > ISB79972 5.75 4.95 3.99 3.59
> > > ISB79973 3.85 3.3 2.7 2.43
> > > ISB79975 1.55 1.35 1.1 0.99
> > > ISB79980 12.99 10.99 9.25 8.33
> > > ISB79981 10.99 9.5 7.85 7.07
> > > ISB79982 5.75 4.85 3.99 3.59
> > > ISB79983 3.85 3.25 2.7 2.43
> > > ISB79985 2.05 1.75 1.5 1.35
> > > ISB79988 2.55 2.2 1.8 1.62
> > >
> >
>

Pierre Smits-3

Re: Price tier

James,

Correction: that is not what I suggested earlier. IMO, new price types are
not needed. As it means that you still have to define the associating
prices individually for each product. Better is it to work with (new)
product categories, associated products with those and set price rules for
those categories. As per earlier provided url.

Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since
2008 (without privileges)

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer

On Fri, Jun 5, 2020 at 3:34 PM Pierre Smits <[hidden email]> wrote:

> That is what I suggested earlier. See latest addition to pr #117 as an
> example.
>
>
> https://github.com/apache/ofbiz-framework/commit/299ebe3a99ca1cfa8b484360d916a445f7a78bf2
>
> Op vr 5 jun. 2020 15:26 schreef <[hidden email]>:
>
>> Ok Great so we can add a new Product Price Type. Let's Say we add 3 new
>> Product Price Types. Tier 1, Tier 2, Tier 3. Can price rules be set up
>> to utilize a percentage of these new Product Price Types?
>>
>> -------- Original Message --------
>> Subject: Re: Price tier
>> From: Pierre Smits <[hidden email]>
>> Date: Fri, June 05, 2020 4:18 am
>> To: [hidden email]
>>
>> Hi James,
>>
>> That is a way to do it, but I suspect it will add a lot to manage prices
>> for each product. A simpler way would be to define the discounts as
>> percentages of one of standard price definitions of the product (based
>> on
>> the ProductPriceType, see [1]). That way you only have to maintain 1
>> price
>> per product, instead of 1 per tier per product.
>>
>> Another way is to have a fixed discount amount per tier, again being the
>> selected standard price.
>>
>> As always, OFBiz offers a lot of flexibility to have it dealing with
>> such
>> price variations as you like...
>>
>> [1]
>>
>> https://demo-stable.ofbiz.apache.org/webtools/control/FindGeneric?entityName=ProductPriceType
>>
>> Met vriendelijke groet,
>>
>> Pierre Smits
>> *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/>
>> since
>> 2008 (without privileges)
>>
>> *Apache Trafodion <https://trafodion.apache.org>, Vice President*
>> *Apache Directory <https://directory.apache.org>, PMC Member*
>> Apache Incubator <https://incubator.apache.org>, committer
>> Apache Steve <https://steve.apache.org>, committer
>>
>>
>> On Fri, Jun 5, 2020 at 12:52 PM <[hidden email]> wrote:
>>
>> > Since each product as a unique price in each tier would i need to create
>> > a rule for each product for each tier?
>> >
>> > -------- Original Message --------
>> > Subject: Re: Price tier
>> > From: Pierre Smits <[hidden email]>
>> > Date: Thu, June 04, 2020 11:18 pm
>> > To: [hidden email]
>> >
>> > Hi James,
>> >
>> > Price maintenance can be the most laborious task of PIM. Ofbiz offers
>> > both
>> > extensive capabilities through price rules (see [1]) as well as the
>> > echnical flexibility to help you with this. Have a look at the demo data
>> > provided codebase. If you have suggestions how to improve the demo data
>> > regarding this, please let us know.
>> >
>> > Without having the complete picture you have, defining price rules per
>> > product category could help you here.
>> >
>> > [1]
>> >
>> >
>> https://demo-stable.ofbiz.apache.org/catalog/control/EditProductPriceRules?productPriceRuleId=9000
>> >
>> > Met vriendelijke groet,
>> >
>> > Pierre Smits
>> > *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/>
>> > since
>> > 2008 (without privileges)
>> >
>> > *Apache Trafodion <https://trafodion.apache.org>, Vice President*
>> > *Apache Directory <https://directory.apache.org>, PMC Member*
>> > Apache Incubator <https://incubator.apache.org>, committer
>> > Apache Steve <https://steve.apache.org>, committer
>> >
>> >
>> > On Fri, Jun 5, 2020 at 12:32 AM <[hidden email]> wrote:
>> >
>> > > What is the best way to handle the below tiered pricing by product
>> with
>> > > quantity breaks in Ofbiz? If we have to set this up by product by tier
>> > > this will be a nightmare
>> > >
>> > >
>> > >
>> > > Item Sales 1 (0-6) (6-35) 36-71 72+
>> > > ISB79963 3.65 3.1 2.55 2.3
>> > > ISB79965 1.85 1.6 1.3 1.17
>> > > ISB79970 13.99 11.95 9.85 8.87
>> > > ISB79971 11.99 10.25 8.45 7.61
>> > > ISB79972 5.75 4.95 3.99 3.59
>> > > ISB79973 3.85 3.3 2.7 2.43
>> > > ISB79975 1.55 1.35 1.1 0.99
>> > > ISB79980 12.99 10.99 9.25 8.33
>> > > ISB79981 10.99 9.5 7.85 7.07
>> > > ISB79982 5.75 4.85 3.99 3.59
>> > > ISB79983 3.85 3.25 2.7 2.43
>> > > ISB79985 2.05 1.75 1.5 1.35
>> > > ISB79988 2.55 2.2 1.8 1.62
>> > >
>> >
>>
>