Skip to main content
๐Ÿงฎ Range Plan Custom Calculated Fields

Explore the Range Rlan costing calculator to save time and track changes over time!

Updated over 5 months ago

Overview

Style Arcade's new Range Plan costing calculator enables the complete product costing setup and tracking within the Range Plan. The feature enables custom creation of calculated fields with the ability to reference foreign exchange rates, custom formulas and lookup tables, allowing product costs to be tracked and updated over time.

How to Access

To access the range plan costing calculator, please go into Settings > Beta Features Toggle > Use Range Plan costing calculator โœ…

The following custom fields will be ready for you to set up under Settings > Hierarchy & attributes:

  • Exchange Rates

  • Calculations

  • Lookup rules


Exchange Rates

What is it?

The exchange rate page allows you to store exchange rates over time in a custom-built currency table. These stored rates can be applied to calculated fields within your Range Plan. Once set up, exchange rates can be stored, edited, or deleted.

Use cases

  • Convert pricing supplied in a foreign currency to your primary currency

  • Set up a global pricing list by automating currency conversions

How do you set up?

Your primary currency is base currency your conversion rates will be applied to. This is usually set up during onboarding.

  1. Go to Settings > Hierarchy & Attributes > Exchange Rates

  2. Add new currency

  3. Select the currency to be added, add exchange rate & effective date

  4. Click Add New to save this new currency to your exchange rate table.

  5. Add new rate

  6. Select the effective date your new exchange rate applies from & enter your new rates. Click the โœ… tick to apply the new rates.

The currency rate will be applied to all products in your Range Plan with a delivery date on and after the effective date.


Calculations

What is it?

A number of calculations can be required when building the cost of a product. The calculations page allows you to build custom formulas to generate calculated fields for products within your Range Plan.

Use cases

  • Calculate the landed cost price, target price, shipping, duty or freight costs for a product.

  • Convert a price from one currency to another

How do you set up?

1. Click 'New calculated field', name the field as you wish for it to appear within the Range Plan and define the field type.

  • Number: For all numerical fields

  • Price: For all currency-related fields which will also add a "spend @" metric.

  • Percentage %: For percentage fields

2. Start typing your custom formulas, some examples below:

Use cases

Formula

Percentage

Intake margin %

=(RRP / 1.1 (tax) - Landing Cost) / (RRP / 1.1 (tax))

Price

Convert AU RRP to US RRP

=RRP * exchange_currency(AUD, USD)

Round the price UP to the nearest whole number

=CEILING(RRP, $1)
โ€‹
โ€‹Note: Make sure you add currency symbols before numbers in price field formulas (e.g., RRP + ยฃ1 or Cost price + $1).

Round the price UP to the nearest 0.99

=CEILING(RRP, $1) - $0.01
โ€‹
โ€‹Note: Make sure you add currency symbols before numbers in price field formulas (e.g., RRP + ยฃ1 or Cost price + $1).

Round the price DOWN to the nearest whole number

=FLOOR(RRP, $1)
โ€‹
โ€‹Note: Make sure you add currency symbols before numbers in price field formulas (e.g., RRP + ยฃ1 or Cost price + $1).

Round the price DOWN to the nearest 0.99

=FLOOR(RRP, $1) + 0.99
โ€‹
โ€‹Note: Make sure you add currency symbols before numbers in price field formulas (e.g., RRP + ยฃ1 or Cost price + $1).

3. Once your formula is complete click 'Validate' and 'Save'.

You can also enable Manual edit in range plan to allow type over the output of this calculation.


The manual over-written figures will be highlighted in blue on the product card & can be reverted to calculated output using the revert arrow:

4. Once saved the calculated field will appear on your Range Plan product card.


โ€‹


Lookup rules

What is it?

Lookup rules allow you to set custom fields based on a set of mapped fields & criteria.

E.g. if Category = Lipstick, Brand = YSL, then set RRP to $100

Use cases

  • To build freight, duty or shipping rates based on a mapped hierarchy

  • Set RRP or sell price based on lookup criteria

How do you set up?

1. Click 'New lookup rule', name the field as you wish for it to appear within the Range Plan and define the field type:

2. Click 'Add lookup rule' and select the first field this lookup should reference. Click the + button to add additional fields to add to your lookup rule.

3. Enter the output of the criteria and apply an effective date.

To duplicate the lookup row click the button below or click ' Add new row' to enter a new option for lookup.


Update the output value and effective date. Click + to update the output value and apply a new effective date.


Click + to update the output value and apply a new effective date.

4. Once your formula is complete click 'Validate' and 'Save'.

You can also enable Manual edit in range plan to allow others to type over the output of this calculation.


The manual over-written figures will be highlighted in blue on the product card & can be reverted to calculated output using the revert arrow:

Once saved the calculated field will appear on your Range Plan product card.


Costing Template

Once you have created all of your RP costing fields, create a template in rollups to help track, maintain and manage product costs.


FAQ ๐Ÿ”

Can I add free text fields as an output value?

The costing calculator allows only numerical values to be created at this stage.

Can I re-order the product fields in my Range Plan product card?

Currently, the calculated fields appear in the Range Plan in order of creation.

Why are my fields not showing on the Range Plan product card?

Please check the following:

  • All inputs to the calculated formula have been entered for the specific product

  • Effective date applied if a lookup or exchange rate field is equal to or earlier than the product delivery date

Can I overwrite/edit my fields in Rollups?

Currently, all costs must be edited within the Plan view however this is being investigated and may be included in a later phase of the project.

Did this answer your question?