Re: Price tier

2020-06-05 Thread Pierre Smits
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  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 :
>
>> 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 
>> Date: Fri, June 05, 2020 4:18 am
>> To: user@ofbiz.apache.org
>>
>> 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  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 
>> > Date: Thu, June 04, 2020 11:18 pm
>> > To: user@ofbiz.apache.org
>> >
>> > 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  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
>> > >
>> >
>>
>


Re: Price tier

2020-06-05 Thread Pierre Smits
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 :

> 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 
> Date: Fri, June 05, 2020 4:18 am
> To: user@ofbiz.apache.org
>
> 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  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 
> > Date: Thu, June 04, 2020 11:18 pm
> > To: user@ofbiz.apache.org
> >
> > 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  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
> > >
> >
>


RE: Price tier

2020-06-05 Thread james
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 
Date: Fri, June 05, 2020 4:18 am
To: user@ofbiz.apache.org

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  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 
> Date: Thu, June 04, 2020 11:18 pm
> To: user@ofbiz.apache.org
>
> 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  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
> >
>


Re: Price tier

2020-06-05 Thread Pierre Smits
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  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 
> Date: Thu, June 04, 2020 11:18 pm
> To: user@ofbiz.apache.org
>
> 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  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
> >
>


RE: Price tier

2020-06-05 Thread james
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 
Date: Thu, June 04, 2020 11:18 pm
To: user@ofbiz.apache.org

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  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
>


Re: Price tier

2020-06-05 Thread Pierre Smits
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  since
2008 (without privileges)

*Apache Trafodion , Vice President*
*Apache Directory , PMC Member*
Apache Incubator , committer
Apache Steve , committer


On Fri, Jun 5, 2020 at 8:18 AM Pierre Smits  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  since
> 2008 (without privileges)
>
> *Apache Trafodion , Vice President*
> *Apache Directory , PMC Member*
> Apache Incubator , committer
> Apache Steve , committer
>
>
> On Fri, Jun 5, 2020 at 12:32 AM  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
>>
>>
>>
>> ItemSales 1 (0-6)  (6-35)   36-71   72+
>> ISB799633.653.1 2.552.3
>> ISB799651.851.6 1.3 1.17
>> ISB7997013.99   11.95   9.858.87
>> ISB7997111.99   10.25   8.457.61
>> ISB799725.754.953.993.59
>> ISB799733.853.3 2.7 2.43
>> ISB799751.551.351.1 0.99
>> ISB7998012.99   10.99   9.258.33
>> ISB7998110.99   9.5 7.857.07
>> ISB799825.754.853.993.59
>> ISB799833.853.252.7 2.43
>> ISB799852.051.751.5 1.35
>> ISB799882.552.2 1.8 1.62
>>
>


Re: Price tier

2020-06-05 Thread Pierre Smits
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  since
2008 (without privileges)

*Apache Trafodion , Vice President*
*Apache Directory , PMC Member*
Apache Incubator , committer
Apache Steve , committer


On Fri, Jun 5, 2020 at 12:32 AM  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
>
>
>
> ItemSales 1 (0-6)  (6-35)   36-71   72+
> ISB799633.653.1 2.552.3
> ISB799651.851.6 1.3 1.17
> ISB7997013.99   11.95   9.858.87
> ISB7997111.99   10.25   8.457.61
> ISB799725.754.953.993.59
> ISB799733.853.3 2.7 2.43
> ISB799751.551.351.1 0.99
> ISB7998012.99   10.99   9.258.33
> ISB7998110.99   9.5 7.857.07
> ISB799825.754.853.993.59
> ISB799833.853.252.7 2.43
> ISB799852.051.751.5 1.35
> ISB799882.552.2 1.8 1.62
>