Scott Thanks a Bunch! I just solved my question below with your help. I added 3 actions.
-100% of List 100% Average Cost Percent of Margin ...and it worked perfectly. Final questions. 1. Is there away that the system can default all users to List Price instead of Default Price? 2. Is there a way to have a percent of Wholesale price list? -------- Original Message -------- Subject: RE: Price Rule Engine From: <[email protected]> Date: Tue, April 17, 2018 5:18 am To: [email protected] 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 <[email protected]> Date: Tue, April 17, 2018 1:44 am To: ofbizuser <[email protected]> +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 <[email protected]> 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, <[email protected]> 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 <[email protected]> > > Date: Fri, April 06, 2018 1:43 am > > To: ofbizuser <[email protected]> > > > > 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, <[email protected]> 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 <[email protected]> > > > Date: Thu, April 05, 2018 6:06 am > > > To: ofbizuser <[email protected]> > > > > > > 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, <[email protected]> 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 <[email protected]> > > > > Date: Thu, April 05, 2018 5:10 am > > > > To: ofbizuser <[email protected]> > > > > > > > > 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, <[email protected]> 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 <[email protected]> > > > > > Date: Wed, April 04, 2018 1:23 pm > > > > > To: [email protected] > > > > > > > > > > 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, <[email protected]> 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 > > > > > > > > > > > > > > > > > > > > >
