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