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