RE: Price Rule Engine

[james-2]

CONTENTS DELETED

The author has deleted this message.

[Scott Gray-3]

Have you tried setting the list price to zero?  Alternatively, if you want
to maintain a value in list price then use two price rule actions:
1. Percentage of list price: -100
2. Percentage of average cost: 130

That should set the first modifier to effectively zero the starting price,
and then can add your average cost modifier.

Regards
Scott

On 17 April 2018 at 03:03, <[hidden email]> wrote:

> I am sure there has to be a way to genrerate a price rule without always
> adding and subtracting to or from List Price.
>
> What if I wanted to at cost plus?  Or wholesale minus? Or a discount
> against the gross margin?
>
> Or what if I wanted to sell at the default price list or just sell at
> the Wholesale price list?
>
> -------- Original Message --------
> Subject: Re: Price Rule Engine
> From: Rishi Solanki <[hidden email]>
> Date: Fri, April 06, 2018 1:43 am
> To: ofbizuser <[hidden email]>
>
> Please go thru the calculateProductPrice service it will have all
> information.
>
> Rishi Solanki
> Sr Manager, Enterprise Software Development
> HotWax Systems Pvt. Ltd.
> Direct: [phone]
> http://www.hotwaxsystems.com
> www.hotwax.co
>
> On Thu, Apr 5, 2018 at 10:33 PM, <[hidden email]> wrote:
>
> > Thanks Rishi. I think we will need to customize it to give a few new
> > actions that are purely based off of costs. Do you know what entity we
> > would need to look to customize? I am thinking we would need to
> > duplicate every action that is there but have it add to the Average
> > Costs and Not List
> >
> > On a side note... Is it possible to create pricing based on the
> > warehouse that the product is shipping out of?
> >
> > -------- Original Message --------
> > Subject: Re: Price Rule Engine
> > From: Rishi Solanki <[hidden email]>
> > Date: Thu, April 05, 2018 6:06 am
> > To: ofbizuser <[hidden email]>
> >
> > Aha, sorry I forgot this while giving the solution. OOTB it is not
> > possible, but a trick of matching the average cost and list price would
> > work.
> > 100 is the avg cost and same list price (ECA rule to match them always).
> > Adding rule on avg cost will always sale the product on the price you
> > want.
> >
> > As mentioned OOTB not supported, you may like to customize it, as
> > required.
> >
> > Rishi Solanki
> > Sr Manager, Enterprise Software Development
> > HotWax Systems Pvt. Ltd.
> > Direct: [phone]
> > http://www.hotwaxsystems.com
> > www.hotwax.co
> >
> > On Thu, Apr 5, 2018 at 6:26 PM, <[hidden email]> wrote:
> >
> > > In case product's average cost change then you can create a price rule
> > > action such that Percent Of Average Cost (PRICE_POAC) to 130 percent.
> > > Then
> > > system will always sale the product on that rule.
> > >
> > > The issue with the price rule you mentioned is that the system would
> add
> > > 130 percent of costs to the list price. I want just the 130 Percent of
> > > Average Costs without adding that to the list price. Is that possible?
> > >
> > > -------- Original Message --------
> > > Subject: Re: Price Rule Engine
> > > From: Rishi Solanki <[hidden email]>
> > > Date: Thu, April 05, 2018 5:10 am
> > > To: ofbizuser <[hidden email]>
> > >
> > > James,
> > >
> > > If you wanted to set list price as 30% of average cost, then there is
> no
> > > direct mechanism. You may need to set the average price for product and
> > > service to do that.
> > > In case product's average cost change then you can create a price rule
> > > action such that Percent Of Average Cost (PRICE_POAC) to 130 percent.
> > > Then
> > > system will always sale the product on that rule.
> > > Please refer: Catalog >> Price Rules >> Edit Price Rules >> Action Type
> > > Section.
> > >
> > > Current Ecommerce Portal and price engine expect list price always. So
> > > setting list price and adding rule on Average Cost works for you, if
> I'm
> > > getting your problem correctly.
> > >
> > > HTH!
> > >
> > >
> > > Rishi Solanki
> > > Sr Manager, Enterprise Software Development
> > > HotWax Systems Pvt. Ltd.
> > > Direct: [phone]
> > > http://www.hotwaxsystems.com
> > > www.hotwax.co
> > >
> > > On Thu, Apr 5, 2018 at 5:12 PM, <[hidden email]> wrote:
> > >
> > > > The issue with the pricing engine is that the system is always trying
> > to
> > > > add to List Price so once it figures out the margin it will add it to
> > > > the list price. Most customers base a price off of something other
> than
> > > > list price. Is there a way to calculate Costs +$7 or 1.3 * Costs?
> > > > -------- Original Message --------
> > > > Subject: Re: Price Rule Engine
> > > > From: Arthur Marquez <[hidden email]>
> > > > Date: Wed, April 04, 2018 1:23 pm
> > > > To: [hidden email]
> > > >
> > > > Cost (or average cost) x (1.30) = 23% GM (Margin)
> > > >
> > > > 30% margin would be (*cost*) x (*1.429*)
> > > >
> > > >
> > > >
> > > >
> > > > *Arthur Marquez*
> > > >
> > > > *1-701-872-4471 : Office*
> > > > *1-818-919-5452 : Mobile*
> > > >
> > > > *Farmers Union Oil Company of Beach ND*
> > > > *Farmers Union Propane, C3H8*
> > > > *90 NE 1st St.*
> > > > *Beach ND 58621*
> > > >
> > > >
> > > > *http://www.cenexofbeach.com/ <http://www.cenexofbeach.com/>*
> > > >
> > > >
> > > >
> > > > On Wed, Apr 4, 2018 at 9:33 AM, <[hidden email]> wrote:
> > > >
> > > > >
> > > > > I noticed that the pricing engine will calculate off a percent off
> of
> > > > > list, default, Average costs, and margin but it is always using the
> > > List
> > > > > price as the base price so an example would be Price = Price *(20%
> of
> > > > > Average costs)
> > > > >
> > > > > What if you wanted all of your pricing to be based off of average
> > > costs.
> > > > > So I want 30% margin or 130% of my costs. So everything is based of
> > > > > average costs and list is not in the equation.
> > > > >
> > > > > Any insight on how to accomplish?
> > > > >
> > > > > Thanks,
> > > > >
> > > > > James
> > > > >
> > > >
> > >
> >
>

[Rishi Solanki]

+1 it will work for sure.

Thank you Scott for the trick, loving it. Thanks again!

Rishi Solanki
Sr Manager, Enterprise Software Development
HotWax Systems Pvt. Ltd.
Direct: [phone]
http://www.hotwaxsystems.com
www.hotwax.co

On Tue, Apr 17, 2018 at 11:45 AM, Scott Gray <[hidden email]>
wrote:

> Have you tried setting the list price to zero?  Alternatively, if you want
> to maintain a value in list price then use two price rule actions:
> 1. Percentage of list price: -100
> 2. Percentage of average cost: 130
>
> That should set the first modifier to effectively zero the starting price,
> and then can add your average cost modifier.
>
> Regards
> Scott
>
> On 17 April 2018 at 03:03, <[hidden email]> wrote:
>
> > I am sure there has to be a way to genrerate a price rule without always
> > adding and subtracting to or from List Price.
> >
> > What if I wanted to at cost plus?  Or wholesale minus? Or a discount
> > against the gross margin?
> >
> > Or what if I wanted to sell at the default price list or just sell at
> > the Wholesale price list?
> >
> > -------- Original Message --------
> > Subject: Re: Price Rule Engine
> > From: Rishi Solanki <[hidden email]>
> > Date: Fri, April 06, 2018 1:43 am
> > To: ofbizuser <[hidden email]>
> >
> > Please go thru the calculateProductPrice service it will have all
> > information.
> >
> > Rishi Solanki
> > Sr Manager, Enterprise Software Development
> > HotWax Systems Pvt. Ltd.
> > Direct: [phone]
> > http://www.hotwaxsystems.com
> > www.hotwax.co
> >
> > On Thu, Apr 5, 2018 at 10:33 PM, <[hidden email]> wrote:
> >
> > > Thanks Rishi. I think we will need to customize it to give a few new
> > > actions that are purely based off of costs. Do you know what entity we
> > > would need to look to customize? I am thinking we would need to
> > > duplicate every action that is there but have it add to the Average
> > > Costs and Not List
> > >
> > > On a side note... Is it possible to create pricing based on the
> > > warehouse that the product is shipping out of?
> > >
> > > -------- Original Message --------
> > > Subject: Re: Price Rule Engine
> > > From: Rishi Solanki <[hidden email]>
> > > Date: Thu, April 05, 2018 6:06 am
> > > To: ofbizuser <[hidden email]>
> > >
> > > Aha, sorry I forgot this while giving the solution. OOTB it is not
> > > possible, but a trick of matching the average cost and list price would
> > > work.
> > > 100 is the avg cost and same list price (ECA rule to match them
> always).
> > > Adding rule on avg cost will always sale the product on the price you
> > > want.
> > >
> > > As mentioned OOTB not supported, you may like to customize it, as
> > > required.
> > >
> > > Rishi Solanki
> > > Sr Manager, Enterprise Software Development
> > > HotWax Systems Pvt. Ltd.
> > > Direct: [phone]
> > > http://www.hotwaxsystems.com
> > > www.hotwax.co
> > >
> > > On Thu, Apr 5, 2018 at 6:26 PM, <[hidden email]> wrote:
> > >
> > > > In case product's average cost change then you can create a price
> rule
> > > > action such that Percent Of Average Cost (PRICE_POAC) to 130 percent.
> > > > Then
> > > > system will always sale the product on that rule.
> > > >
> > > > The issue with the price rule you mentioned is that the system would
> > add
> > > > 130 percent of costs to the list price. I want just the 130 Percent
> of
> > > > Average Costs without adding that to the list price. Is that
> possible?
> > > >
> > > > -------- Original Message --------
> > > > Subject: Re: Price Rule Engine
> > > > From: Rishi Solanki <[hidden email]>
> > > > Date: Thu, April 05, 2018 5:10 am
> > > > To: ofbizuser <[hidden email]>
> > > >
> > > > James,
> > > >
> > > > If you wanted to set list price as 30% of average cost, then there is
> > no
> > > > direct mechanism. You may need to set the average price for product
> and
> > > > service to do that.
> > > > In case product's average cost change then you can create a price
> rule
> > > > action such that Percent Of Average Cost (PRICE_POAC) to 130 percent.
> > > > Then
> > > > system will always sale the product on that rule.
> > > > Please refer: Catalog >> Price Rules >> Edit Price Rules >> Action
> Type
> > > > Section.
> > > >
> > > > Current Ecommerce Portal and price engine expect list price always.
> So
> > > > setting list price and adding rule on Average Cost works for you, if
> > I'm
> > > > getting your problem correctly.
> > > >
> > > > HTH!
> > > >
> > > >
> > > > Rishi Solanki
> > > > Sr Manager, Enterprise Software Development
> > > > HotWax Systems Pvt. Ltd.
> > > > Direct: [phone]
> > > > http://www.hotwaxsystems.com
> > > > www.hotwax.co
> > > >
> > > > On Thu, Apr 5, 2018 at 5:12 PM, <[hidden email]> wrote:
> > > >
> > > > > The issue with the pricing engine is that the system is always
> trying
> > > to
> > > > > add to List Price so once it figures out the margin it will add it
> to
> > > > > the list price. Most customers base a price off of something other
> > than
> > > > > list price. Is there a way to calculate Costs +$7 or 1.3 * Costs?
> > > > > -------- Original Message --------
> > > > > Subject: Re: Price Rule Engine
> > > > > From: Arthur Marquez <[hidden email]>
> > > > > Date: Wed, April 04, 2018 1:23 pm
> > > > > To: [hidden email]
> > > > >
> > > > > Cost (or average cost) x (1.30) = 23% GM (Margin)
> > > > >
> > > > > 30% margin would be (*cost*) x (*1.429*)
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > *Arthur Marquez*
> > > > >
> > > > > *1-701-872-4471 : Office*
> > > > > *1-818-919-5452 : Mobile*
> > > > >
> > > > > *Farmers Union Oil Company of Beach ND*
> > > > > *Farmers Union Propane, C3H8*
> > > > > *90 NE 1st St.*
> > > > > *Beach ND 58621*
> > > > >
> > > > >
> > > > > *http://www.cenexofbeach.com/ <http://www.cenexofbeach.com/>*
> > > > >
> > > > >
> > > > >
> > > > > On Wed, Apr 4, 2018 at 9:33 AM, <[hidden email]> wrote:
> > > > >
> > > > > >
> > > > > > I noticed that the pricing engine will calculate off a percent
> off
> > of
> > > > > > list, default, Average costs, and margin but it is always using
> the
> > > > List
> > > > > > price as the base price so an example would be Price = Price
> *(20%
> > of
> > > > > > Average costs)
> > > > > >
> > > > > > What if you wanted all of your pricing to be based off of average
> > > > costs.
> > > > > > So I want 30% margin or 130% of my costs. So everything is based
> of
> > > > > > average costs and list is not in the equation.
> > > > > >
> > > > > > Any insight on how to accomplish?
> > > > > >
> > > > > > Thanks,
> > > > > >
> > > > > > James
> > > > > >
> > > > >
> > > >
> > >
> >
>