Price grid management

Here you will learn how to work with price grids associated to charge in Opencell. Price grid allows you to efficiently manage tariffs, and also to export and import datasheet from Microsoft Excel.

Concept

Charges are the elements on which you will be able to define the tarrifs of your products/services. As you must already know, 3 types of charges exist:

• Recurring → Recurring prices (think Netflix subscription)

• Usage → For consumption (think electricity)

• One shot:

  • Other → Any product you would sell once. Not linked to a subscription

  • Subscription → Think an activation fee, linked to a specific subscription

  • Termination → Thing cancellation fees for a given subscription

Opencell supports flat prices and matrix based prices also called “Price grids”.

Price grids can be found on Price versions, that are managed on Charges themselves directly.

Now price grids can also be managed directly in a sub-menu of the Catalog app → Catalog manager → Price version:

From there, you can directly import, export and consult the whole history.

Please refer to Export / Import price versions for more informations

From the price version:

Price grids are available only if you use attributes (business or custom ones) to define the price for your product/service based on their value. For example Color would be an attribute, and it’s possible values might include Red White and Blue. Depending if it’s either of these colors, than the price of the chair (yes, in my example here we are talking about a chair) will change accordingly to the price I would have put in my price grid. This is an easy example, however you can have price grids with dozens of attributes, making their management complicated.

To create a price grid, you have to activate the feature when creating your Price version. Once done hit the ‘SAVE’ button and then you can add your attributes, that will be the dimensions (or just columns) of your grid.

Custom attributes in price grids are the ones you create on your own, either from the product version section of a product, either on the attributes tab of a commercial offer, or directly in the Attributes sub-menu in the Catalog.
Business attributes in the other hand exist by default in any Opencell environment and are used to have links to external solutions, retrieve the information and use that specific information to define values for each dimension (or column), thus giving out a price.

As for other objects in Opencell, a price version has statuses. It’s modification can only be done when in “DRAFT” status. However a new update in V13 allows a some users to modify “PUBLISHED” price versions (flat prices or price grids), and this will be described bellow.

To ease your grid management, and even more when you have grids with a great number of lines, you might want apply some filters on your grid. This new option (v14.2), is available once you have created a grid, and you have saved the grid at least once.

You will then see the new Filter/Simulation section that you can use.
The simulation feature is detailed below in section Price simulator feature.

From import/export sub menu:

Price grid prioritization:

Opencell has a specific way to prioritize combinations (or price grid lines) from one another.

Let’s contemplate the price grid below:

As you can see on the far left side, we have 3 distinct sections here.

• Section 1 → All columns have a listed value in them

• Section 2 → All columns minus one have a listed value

• Section 3 → All columns minus two have listed value

Note how the sections are arranged here. Section 1 is at the very top, as all its columns have at least one listed value. Section 2 has all it lines that have all columns but one with a listed value, and this goes so on. Contrary to the dimensions below, the system will actually rearrange all your price grid lines based on this logic. So you don’t have to worry about the way you create or import them (the rearrangement is done at each save).

We also have 5 dimensions (attributes as columns)n which are A, B, C, D, and E. Columns order is very important as their place on the grid definer their priority, and this goes left to right, most important priority to less important one. So it will be important for you to take this under consideration when creating your grids.

We now know that prioritization on price grids is both done on lines (automatically from the system) and manually by user via the dimensions. This allows any user to be able to visually see the prioritization made in Opencell:

• Lines → From top to bottom

• Columns → From left to right

Opencell will always prioritize the “perfect match”, which means when system can find as many exact values between what the goal and what is present in the grid.

Say the target is: Blue, Leather, Yes, Partial, USA

Then the appropriate line will be:

Other case if the target could be: Blue, Leather, Yes, Partial, IT

Then the appropriate line will be:

Same line would actually be selected for the following target: Blue, Leather, Yes, Partial, Fr

The selection is due to the prioritization that we have implemented in Opencell. Below is a small exercise. Select for each case the #line that will be selected to give a price.

Answers: Case 1=L5, Case 2=L1, Case 3=None, Case 4=L2

Price simulator feature

A cool new feature to allow users to quickly check their price grids is now available via the price simulator. This essentially allows you to check:

• If a combination is present

And

• If a price is entered for a specific combination

Which means that in a few clics, you can easily stress test yout grids in Opencell.

In our example below, we have chair which price gris has 5 different attributes:

As you can see, I have opened my price simulator, which is empty, for now…

Now after entering some values for each attribute, my system was able to detect that I had a perfect match for my combination, and thus a price is available:

But when I enter a combination that does not exist in my grid, my system then displays a “No match” in the price cell

The price grid also works with partial lines, where empty cell can take any value 😉

Prices in other currencies

If some of your customers are billed in another currency than your functional currency, you can give a price version a specific price in that currency. Rating then uses this price for a customer whose billing account uses that currency, instead of converting the functional price with the exchange rate. You can do this on a fixed price and on a price grid. The currencies you can choose from are the trading currencies set up on your platform (see Setting multi-currency).

You can add, change or remove these prices only while the price version is in DRAFT status. To add a currency to a published price version, duplicate the version and add the currency to the new one.

On a fixed price

1. Open the price version and click Add new currency, under the price. A new line appears.

2. Pick the currency. The list shows your trading currencies, except your functional currency and the currencies already added. The Rate is filled in with the current exchange rate of that currency, and you can change it.

3. Enter the price in that currency, in one of two ways:

   • To convert your functional price, keep a rate and click Calculate. The price becomes your functional price multiplied by the rate: with a rate of 1.2, a price of 100 € gives 120 $, and with a rate of 1, both prices are the same.

   • To set a price of your own, type it in Price and empty the Rate field. If you keep a rate, the price must be exactly your functional price multiplied by the rate, otherwise it is not saved and a message says that the price is inconsistent with the rate: empty the Rate field and save again.

4. Click the save icon of the line. To remove a currency, click its delete icon.

On a price grid

1. Open the price version and click Add new currency, above the grid. A New currency column is added and its settings window opens.

2. Pick the currency. As for a fixed price, the list leaves out your functional currency and the currencies already in the grid, and the Rate is filled in with the current exchange rate. An example of the conversion is shown next to the rate, such as 100€ = 110.00$.

3. Click the button at the bottom of the window:

   • Add currency and fill column, when a rate is filled in: the column is added, and every line of the grid, on all pages, gets your functional price multiplied by the rate.

   • Add currency, when the rate is empty: the column is added empty, and you type the prices yourself.

4. Change any price of the column if you need to, then save the grid. Make sure every line of the column has a price: a customer billed in that currency cannot be charged for a line whose price in that currency is empty.

The column is labelled Unit price followed by the currency symbol, for example Unit price $, and sits to the right of the unit price in your functional currency. To convert the column again with another rate, click the edit icon in its header, change the rate and click Update. Every line of the column is then recalculated, which replaces the prices you changed by hand. The currency of an existing column cannot be changed.

Use this price for Billing Accounts associated to this currency

Each currency has this setting, on by default. On a fixed price, you change it on the line of the currency. On a price grid, you change it in the window that opens from the edit icon of the column, while the price version is in DRAFT status. The change is saved as soon as you switch it: then close the window with Cancel, because Update would also recalculate every price of the column from the rate.

Prices in other currencies are exported and imported with the price version: see Export / Import price versions.

Price indexation columns

When a price version holds the custom prices of a framework agreement line (a contract line of type Custom contract price), its price grid can show two extra columns used by price indexation. See Framework agreements.

Indexation formula

• The Indexation formula column appears only when the price version is linked to a contract line.

• On each line of the grid, you can pick an indexation formula. The list offers only PUBLISHED and IN_USE formulas, and you can search them by code or description.

• If you leave the cell empty, the line is indexed with the formula of the contract line, if it has one.

• The info icon on the column title reminds you: Indexation formula used during indexation of linked contract items. If empty, then the formula from contract item will be used.

Indexation factor

• The Indexation factor column is read-only and sits right of Indexation formula.

• It appears only on a price version created by a successful price indexation.

• It shows the indexation factor used to compute the price of each line.

• The info icon on the column title reads: Indexation adjustment factor used to compute this price.