Price Columns are the columns that are shown to the user when viewing price details for a configured product.
Configurators often have complex pricing rules. One strategy to go about pricing a configured product is by capturing all of the piece parts that make up the product and tallying them up (see pricing rules).
When showing the pieces of the configured product that make up the price, you can choose what columns are shown to the user. We call these 'Price Columns'. Several columns are built in, but you can also define your own.
Built-In Price Columns
Your portal comes with several built-in price columns. Some of them are shown by default to the user, and some aren't. You can edit built-in price columns to change their label as well their visibility settings. See price column properties later in this article for details.
| Price Column Name | Datatype | Shown by Default | Description |
|---|---|---|---|
| Media | text | A media file that represents the item. Shown as a "thumbnail" when viewing price details. | |
| Sku | text | ✓ | The unique sku of the item. |
| Description | text | ✓ | The description of the item. |
| Weight | number |
The weight item. | |
| Lead Time | number | The lead time of the item measured in days. | |
| Material Cost | number | The material cost of the item. | |
| Material Price | number | The material price of the item. | |
| Labor Cost | number | The labor cost of the item. | |
| Labor Price | number | The labor price of the item. | |
| Discount | number | The discount applied to this item. | |
| Unit Of Measure | text | ✓ | The unit of measure. |
| Net Price | number | ✓ | The list price minus discount. |
| Qty | number | ✓ | The quantity of the item. |
| Ext Net Price | number | ✓ | The net price multiplied by qty. |
Custom Price Columns
If the built-in price columns don't serve your needs, you can create your own custom price columns. Some examples could be "Carbon Footprint" (a number), "Country of Origin" (a string), "Is Kosher" (a boolean), etc. When creating your custom price column under Settings > Products > Price Columns, be aware of the properties you can set for each one, listed below.
Custom Price Column Properties
| Name | Description |
|---|---|
| Name | The name of the price column. Once a price column is created, its name cannot be changed. |
| Label | If provided, will be the label of the column when shown in the UI of the configurator. If not provided, the name will be used. |
| Description | The description of the price column. |
| Type | The datatype of the price column. |
| Is Rollup | For number columns, you can choose to make the column a rollup of its children when the price item itself is set to use rollups. See the 'Use Rollup' property of the price item for more details. |
| Visible | Whether the price column will be visible in the UI of the running configurator. |
| Roles | Select the user roles that should be able to view this column. |
| Media Height | For media columns, controls the height of the media in pixels. |
| Media Width | For media columns, controls the width of the media in pixels. |
| Properties for Number Columns | |
|---|---|
| Precision | Specifies how many decimal places the value can have. |
| Min Precision | Will add trailing zeroes to the value until the minimum precision is met. For example, if the minimum precision is 2, and the user types in 32.1, then the field will show 32.10 when it is not being edited. |
| Format | How to express the value. Can be number, currency, or percentage. |
| Prefix | Text to prepend to the number value. |
| Suffix | Text to append to the number value. |
Localizing Price Columns
To localize your price columns into different languages, follow these steps:
- Setup the languages in the company settings.
To add translations of a specific language, you must first have added this language to your company settings. Learn how. - Open the translate dialog.
In the price column admin screen, click on the Translate button in the bottom toolbar.
- Add translations for your price column properties.
The translation dialog will show a list of all the properties that can be translated. There will be a column showing your terms for these items in your default language, and a column for each additional language you have chosen to support in your company settings.
Missing translations that need your attention are shown in red. To add missing translations, select the cell in the table and start typing. You can also auto-translate all the missing translations by clicking on the 'Auto-Translate' button, which will use the Google Translate API to fill in your missing translations.
- Save your translations.
To save your translations, click on OK, and then save the price column. Note that if later you add more language to your company, you should also come back to the translations dialog and add the missing translations.