I do not understand this part: "profit margin based on related categories of this product...."
----- Original Message ----- From: "Hansen Wang" <[email protected]> To: [email protected] Sent: Thursday, February 19, 2009 1:47:15 PM (GMT-0600) America/Chicago Subject: Re: average cost calculation in price rule Or is that right, that the "average cost" from price rule action means the "average cost" price of the product which is set explicitly from the prices tab of a product? Secondly, does it sound reasonable solution that we use a nightly job to update the "average cost" price of the product using the inventory costs of all the inventory items for this product? What we really want is a price structure based on the average cost of based on inventory items for a product and a profit margin based on related categories of this product. On Thu, Feb 19, 2009 at 10:27 AM, Hansen Wang <[email protected]> wrote: > I have a product whose list price and default price are both set to 5. > These are the only explicit prices set for this product. There is also no > cost component set for this product. This product has only one inventory > item whose cost is 3. I set up a price rule for this product to add 30% of > average cost to the list price. When I try to add one of this product in the > cart, the price is shown 6.5, instead of 5.9. The reason is that the price > rule use the list price as the average cost. Is there any way (out of box) > the price rule will use inventory cost? >
