That sounds awesome! So how does two actions work with each other. How would you configure the following using multiple actions!
Avg Cost + Percent of Margin Thanks Scott!! -------- Original Message -------- Subject: Re: Price Rule Engine From: Rishi Solanki <rishisolan...@gmail.com> Date: Tue, April 17, 2018 1:44 am To: ofbizuser <user@ofbiz.apache.org> +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: +91-9893287847 http://www.hotwaxsystems.com www.hotwax.co On Tue, Apr 17, 2018 at 11:45 AM, Scott Gray <scott.g...@hotwaxsystems.com> 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, <ja...@productive1.com> 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 <rishisolan...@gmail.com> > > Date: Fri, April 06, 2018 1:43 am > > To: ofbizuser <user@ofbiz.apache.org> > > > > Please go thru the calculateProductPrice service it will have all > > information. > > > > Rishi Solanki > > Sr Manager, Enterprise Software Development > > HotWax Systems Pvt. Ltd. > > Direct: +91-9893287847 > > http://www.hotwaxsystems.com > > www.hotwax.co > > > > On Thu, Apr 5, 2018 at 10:33 PM, <ja...@productive1.com> 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 <rishisolan...@gmail.com> > > > Date: Thu, April 05, 2018 6:06 am > > > To: ofbizuser <user@ofbiz.apache.org> > > > > > > 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: +91-9893287847 > > > http://www.hotwaxsystems.com > > > www.hotwax.co > > > > > > On Thu, Apr 5, 2018 at 6:26 PM, <ja...@productive1.com> 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 <rishisolan...@gmail.com> > > > > Date: Thu, April 05, 2018 5:10 am > > > > To: ofbizuser <user@ofbiz.apache.org> > > > > > > > > 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: +91-9893287847 > > > > http://www.hotwaxsystems.com > > > > www.hotwax.co > > > > > > > > On Thu, Apr 5, 2018 at 5:12 PM, <ja...@productive1.com> 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 <arthurm.farmersun...@gmail.com> > > > > > Date: Wed, April 04, 2018 1:23 pm > > > > > To: user@ofbiz.apache.org > > > > > > > > > > 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, <ja...@productive1.com> 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 > > > > > > > > > > > > > > > > > > > > >
