Price Rule Engine

[james-2]

CONTENTS DELETED

The author has deleted this message.

[Arthur Marquez]

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
>

[james-2]

CONTENTS DELETED

The author has deleted this message.

[Rishi Solanki]

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

[james-2]

CONTENTS DELETED

The author has deleted this message.

[Rishi Solanki]

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

[Arthur Marquez]

James,

I'm sure others can help you address this.

However, having done a lot of pricing scenarios, I've discovered some misunderstanding that often occurs when addressing MARGIN, vs MARK-UP.

30% margin is accomplished by taking COST (whether average, or actual), and using 1,429 as the multiplier.

Hence, 130% of cost, would achieve only 23% margin, which would not reach your objective if a 30% margin.

I've included a chart to help illustrate this example.

I hope you find this helpful.

Arthur

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

[james-2]

CONTENTS DELETED

The author has deleted this message.

[Rishi Solanki]

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