Calculate Product Sales Price based on Cost!

This module provides for sales price on a product record to be calculated by a product cost multiplier. This is achieved by configuring a list of cost brackets each with a cost multiplier rate.

Features

• Configure a price to be locked, preventing the price to be included in calculations
• Hardcode a multiplier on the product that will override all other calculations
• Unlimited cost brackets with seperate rates can be defined
• Rates are defined at the Product Category level

Step 1: Configuration of Product Category

Rates are definsed on the product category record. Either create the rates at the lower level category or at the top level parent category. The calculator will start with the lowest category and move up the parents until a category that has rates defined.

Start by defining a each of the maximum costs and the appropriate rates for each.
Finish by defining the default rate, this will be the rate used if the cost price exceeds to the maximum defined rate in the table.


Click Save button

Update Prices Click "Update Prices" button to manually trigger all prices to be recalculated

Step 2: Configuration of Product

Scenario 1 - Lock Price

To lock the price of a product and ensure that the sales price is not updated by the Sales price calculator, check this box.

Scenario 2 - Set a Static Cost Multiplier rate

To statically set a rate for a specific record, enter a value in the "Cost Multiplier" field. If the value is greater than 0.0, this rate will be used in the calculation and all other settings will be ignored

Scenario 3 - Allow the Price to be automatically updated

Leave the two fields mentioned above as they are and the sales price for these products will be calculated based on the rules set in the product categories.



Note: Prices are automatically calculated every hour as per the Scheduled action "Product Price Update Cron"

To disable or change any details for this job, simply open this scheduled Action under Settings -> Automation -> Scheduled Actions -> Product Price Update Cron



Any questions, please visit www.damientaylorsydney.com/contactus