Sales prices and price calculation

Prices are an important topic for any business. Thanks to PlentyONE, you can be very flexible with your prices.

  • First, you can define the conditions under which your products are sold at a specific price. For example, you can sell products for a lower price in the plentyShop than on Amazon. Or you can sell products cheaper to B2B customers than to B2C customers. In PlentyONE, such conditions are called “sales prices”.

  • Second, you can save prices for each individual variation. For example, if you sell a t-shirt in S, M, L and XL, then you can decide whether the XL variation should be a bit more expensive than the rest.

  • Third, you can have PlentyONE automatically calculate your monetary prices. For example, you could start out with the item’s purchase price and then add transportation costs, storage costs and taxes. Finally, you could add a 7% profit margin on top.

1. Sales prices

Sales prices define the conditions under which a variation is sold at a specific price. For example, you can sell products for a lower price in the plentyShop than on Amazon. Or you can sell products cheaper to B2B customers than to B2C customers.

New PlentyONE systems come equipped with two default sales prices. Take a look at these default sales prices and use them to get acquainted with the topic. Feel free to modify the default sales prices and/or create entirely new sales prices.

1.1. Creating new sales prices

Create any number of sales prices to map the entire range of your prices in PlentyONE. During the process, you’ll give the sales prices names and you’ll decide which currencies, customer classes, marketplaces or other conditions should apply.

Errors due to multiple sales prices

Do not create multiple sales prices with the exact same conditions. This causes errors.

  • Example: You have two sales prices that both apply to B2B customers, your online shop and the country of delivery Germany.

  • Consequences: PlentyONE doesn’t know which sales price should be used. PlentyONE will use one of the sales prices at random, since both apply equally.

  1. Go to Setup » Item » Sales prices.

  2. Click on New.
    → The New tab opens.

  3. Carry out the settings. Refer to the table.

  4. Save () the settings.

  5. Then link the finished sales prices with variants.

Setting Explanation

ID

As soon as you save the sales price, it automatically receives a consecutive and unique ID. This ID cannot be changed.

Subscription int.

This option is relevant if you offer plugins on plentyMarketplace on a subscription basis.

Note: This option is neither relevant for the plentyShop nor for the scheduler or subscription module.

Position

Enter the position number. If you link multiple sales prices to a variation, then you’ll see these sales prices sorted by their position number in the item data record.

Internal name EN

Enter an internal name for the sales price. This name appears in a variety of different places within your PlentyONE back end. For example, you’ll choose the sales price by name when you link it to individual items.

External name EN

Enter an external name for the sales price.

Note: Currently, this name is not displayed in the plentyShop. That means: There is not currently an option within the ShopBuilder widget, which allows you to display the external name in the plentyShop. If you want to display the external name in the plentyShop, then you will need to customise the webshop’s code.

Minimum quantity

Should the sales price only apply if a customer buys multiple copies of the item? For example, let’s assume you sell socks for 6 EUR per pair. Do you want the price to be reduced to 5 EUR per pair if a customer buys 3 or more pairs of socks? If so, then enter the quantity that applies to this sales price.

Tip: Add even more quantity-based sales prices to create a sliding scale of prices.

Additional settings: Quantity-based discounts also need to be permitted for the customer class. Go to Setup » CRM » Classes » [Open class]. Make sure that the setting Volume discount is set to include.

Currency

Which currencies should the sales price apply to? Select them from the list ().

Background info: While configuring your online store, you’ll decide which languages and currencies your store should be available in. For example, let’s assume that customers can choose the currencies EUR, PLN, CHF and GBP from the header. Then it would make sense to also save prices for these currencies.

Automatic conversion: Activate the option Live conversion () to have plentymarkets automatically convert your prices from the standard currency, e.g. EUR, into the other currencies, e.g. PLN, CHF and GBP.
If you don’t activate this option, then your prices will all have the same number, but different currencies, e.g. 19 EUR and 19 PLN. Therefore, it usually makes sense to have plentymarkets automatically convert the prices.

Make sure you’re happy with the conversion factors saved in the menu Setup » Orders » Payment » Currencies.

Price type

Which type of sales price do you want to configure? In most cases, you’ll create a standard sales price. But in some cases, you might want to create an “RRP”, “set price” or “special offer” instead. If so, then select the corresponding price type ().

  • RRP = A recommended retail price, which only serves to show the price difference between the RRP and a standard sales price in the plentyShop. Products cannot be sold for the recommended retail price. In order for the RRP to be displayed in the plentyShop, the variation must be linked to the RRP and the standard price. Furthermore, the RRP must be higher than the standard price. If these conditions are met, then the RRP will be displayed in the plentyShop in strikethrough text next to the sales price.

  • Special offer = An offer price that applies, for example, on Google Shopping. The Google shopping feed includes the field “price” and “sales_price”. The field “price” is a regular sales price, so no price type. The field “sales_price” is a special offer. Special offers are only displayed in the feed, if they are smaller than the sales price.

  • Set price = Sets are a way to combine products and sell them as a unit. If you decide to combine products and sell them as a set, then you’ll also need to give the individual set components a set price.

Display

Should this sales price automatically be linked to new item data records? If so, then activate the option Always display for new items ().

If this setting is deactivated, then you will still be able to manually add the sales price to items.

Client

Should the sales price only apply to specific clients (stores)? If so, then select all of the stores () that this sales price should apply to.

Background info: With PlentyONE, you can manage several online stores, i.e. several clients, with only one software. Consequently, it is possible to manage several different areas of business with one PlentyONE system. That’s a great advantage. But it also means that you’ll always need to tell PlentyONE which online store the sales price applies to.

Class

Should the sales price only apply to specific customer classes? For example, do you want to sell products cheaper to B2B customers than to B2C customers? If so, then select all of the customer classes () that this sales price should apply to.

Note: Create the necessary customer classes in advance, if they don’t already exist in your system.

Frequent source of errors: Do not create multiple sales prices with the exact same conditions. This causes errors.

  • Example: You have two sales prices that both apply to B2B customers, your online shop and the country of delivery Germany.

  • Consequences: PlentyONE doesn’t know which sales price should be used. PlentyONE will use one of the sales prices at random, since both apply equally.

Country

Should the sales price only apply to specific countries of delivery? Example: you pay different tax rates in different countries. As such, you might want to sell an item for a slightly higher price in some countries, rather than pay the difference yourself. Select all of the countries () that this sales price should apply to.

Referrer

Should the sales price only apply to specific distribution channels? For example, do you want to sell the item for a lower price in your plentyShop than on Amazon? Select all of the platforms () that this sales price should apply to.

Price with ID 1 is set as default sales price for this field. If you change this selection, you cannot go back to ID 1.

Note: If you select eBay or Amazon, then the corresponding account settings will appear further below. Here you’ll tell PlentyONE which eBay or Amazon account the sales price should apply to. Therefore, link your eBay or Amazon account to PlentyONE in advance.

Frequent source of errors: Do not create multiple sales prices with the exact same conditions. This causes errors.

  • Example: You have two sales prices that both apply to B2B customers, your online shop and the country of delivery Germany.

  • Consequences: PlentyONE doesn’t know which sales price should be used. PlentyONE will use one of the sales prices at random, since both apply equally.

Amazon accounts

Tell PlentyONE which Amazon account the sales price should apply to. Therefore, link your Amazon account to PlentyONE in advance.

Price with ID 1 is set as default sales price for this field. If you change this selection, you cannot go back to ID 1.

This setting is greyed out until you select an Amazon platform from the list above.

eBay accounts

Tell PlentyONE which eBay account the sales price should apply to. Therefore, link your eBay account to PlentyONE in advance.

Price with ID 1 is set as default sales price for this field. If you change this selection, you cannot go back to ID 1.

This setting is greyed out until you select an eBay platform from the list above.

1.2. Working with existing sales prices

As soon as you create a sales price, it is automatically added to the overview in the menu Setup » Item » Sales prices.

1.2.1. Searching for sales prices

Use the filters on the left to limit which sales prices are displayed in the overview on the right.

Filtering sales prices:

  1. Go to Setup » Item » Sales prices.

  2. Select the filters on the left. Refer to the table.

  3. Click Search ().
    → The filtered sales prices will be displayed in the overview on the right.

Setting Explanation

ID

Enter the ID to search for the sales price with this ID.

Name

Enter the name to search for the sales price with this name.

Minimum quantity

Enter a quantity value to search for the sales price with this quantity.

Client

Select a client (store) to search for sales prices for this client.

Class

Select a customer class to search for sales prices for this class.

Referrer

Select an order referrer to search for sales prices for this referrer.

Amazon accounts

Select an Amazon account to search for sales prices for this Amazon account.

eBay accounts

Select an eBay account to search for sales prices for this eBay account.

Currency

Select a currency or to search for sales prices for this currency.

Language

When you select a language, the internal and external names of the sales price are displayed in the table on the right.

Country

Select a country of delivery to search for sales prices for this country.

1.2.2. Saving the names in multiple languages

After creating a sales price, you can translate the name of the sales price into the required languages.

Translating a sales price:

  1. Go to Setup » Item » Sales prices » [Open sales price] » Tab: Language.

  2. Enter the internal name in the required languages.

  3. Enter the external name in the required languages.

  4. Save () the settings.

1.3. Applying the sales price to products

Sales prices are linked to individual variations, rather than to the item as a whole. For example, if you sell a t-shirt in S, M, L and XL, then you can decide whether the XL variation should be a bit more expensive than the rest.

There are a few different ways to link sales prices to variations and enter the actual monetary prices:

  • If you only want to save prices for a few items, then it makes sense to manually link sales prices and enter monetary amounts.

  • If you want to save prices for lots of items, then we would recommend importing the sales prices and monetary amounts.

  • Rather than manually entering the monetary amounts, you might want PlentyONE to automatically calculate them for you.

1.4. Export sales prices

Proceed as follows, to export your sales prices as a CSV file:

  1. Go to Setup » Item » Sales prices.

  2. Click Download data as CSV (download).

  3. Select which pages of the table you want to export.

  4. Click mat:symbol:download EXPORT DATA.

Your selected sales prices will be downloaded as a CSV file.

Export either specific sales prices or whole pages See Table 1 for more information.

Table 1. Export options
Option Explanation

All pages

All sales prices on all pages are exported.

Current page

Only sales prices on the current page are exported. Set the amount of sales prices per page via Results per page.

Selected rows

Only sales prices you selected are exported. Can only be selected, if rows are selected.

Set the range of table pages

Enter the range of pages that you want to export.

1.5. FAQ

I want PlentyONE to automatically calculate my prices for me. Is that possible?

Yes. This is done with the help of so-called price calculations. Further information.

An item was sold for the wrong price. How can I tell who changed the price and when?

This can be done with the change history, assuming that it was already activated in your system for a fee.

  1. Go to Data » Change history.

  2. Set the search filters as follows:

    • Data record = Sales price of the variation

    • Unique IDs = variation. Then enter the variation ID as well.

  3. Click Search ().

I’m required to display the lowest price of the last 30 days. How do I do that?

Background info

On 28th May 2022 a new regulation on specifying prices went into effect. In these regulations, § 11 (1) specifies how prices must be displayed when products are discounted.

“Anyone required to state a total price must, whenever announcing a price reduction for a product, inform consumers of the lowest total price they have charged consumers within the 30 days prior to the price reduction taking effect.”

How do I save the price in the back end?

The lowest price can manually be entered into PlentyONE, imported or automatically detected.

This value is displayed in the webshop starting from plentyShop LTS version 5.0.51. Instructions for displaying the value in your plentyShop are found further below.

Manual entry:

  1. Go to Item » Items » [Open variation] » Tab: Prices » Section: Sales prices.

  2. In a line, click on and then on sell Lowest price » Set manually.
    → The column becomes editable and the gross price is automatically entered into it.

  3. Enter a different value into the column if needed.

  4. Save () the settings.

Automatic detection:

  1. Go to Item » Items » [Open variation] » Tab: Prices » Section: Sales prices.

  2. In a line, click on and then on sell Lowest price » Enable automatic detection.
    → The lowest price of the last 30 days is automatically entered into the column. This value is detected with the help of the change history. If you have not yet activated the change history, then you will see a pop-up window, which informs you of the costs that will be incurred. You will have to confirm your decision to activate the change history.

  3. Save () the settings.

The lowest price will automatically be detected approximately 90 seconds after you have activated and saved the setting for the first time. Afterwards, it will automatically be detected every night.

Import:

  1. Go to Data » Import.

  2. Create a new import of the type Item.

  3. Use the mapping fields Sales prices / Lowest price of the last 30 days and Sales prices / Calculate lowest price automatically to control the settings via import.

How do I display the price in my plentyShop?

  1. Go to Plugins » Plugin set overview » [Open plugin set].

    • Make sure that the plugin plentyShop LTS uses version 5.0.51 or higher. Update the plugin if necessary.

  2. Go to Shop » ShopBuilder » [Open content] » [Open widget "Item / Item price"].

    • Make sure that the option Display strikethrough price is activated.

  3. Go to Item » Items » [Open variation] » Tab: Prices » Section: Sales prices.

    • Make sure that a value is entered into the column Lowest price during the last 30 days.

If these conditions are met, then the lowest price of the last 30 days will automatically be displayed in the plentyShop. It will appear underneath the price.

How do I display the RRP as a strikethrough price in the webshop?

  1. Go to Setup » Item » Sales prices.

    • Make sure that you have a sales price without any price type selected and another sales price with the price type RRP.

  2. Go to Item » Items » [Open variation] » Tab: Prices » Section: Sales prices.

    • Make sure that the variation is linked to the standard sales price and to the RRP price.

    • Make sure that the RRP price is higher than the standard sales price.

If these conditions are met, then the RRP will be displayed in the plentyShop in strikethrough text next to the sales price.

*Is it possible to import sales prices instead of creating them manually?

No. Sales prices can only be created manually. This can be done via the setup menu or with an assistant.

2. Price calculation

Let PlentyONE calculate your prices for you. For example, start with the purchase price and then add transportation costs, storage costs and taxes. Finally, add a 7% profit margin on top. With PlentyONE, you decide how your prices should be calculated.

Procedure

This function is configured in several different steps:

2.1. Creating a new price calculation

  1. Go to Setup » Item » Calculation.

  2. Click on Price calculation.

  3. Customise the settings to meet your needs:

    1. Enter a distinct name for the calculation.

    2. Create your own formulas.

    3. Select decimal places and rounding behaviour for each target price.

  4. Save () the settings.

2.1.1. Settings

Setting Explanation

Name

Enter a distinct name for the calculation. The name is only used internally and is not visible to customers. You’ll select the price calculation by its name, e.g. when you apply it to specific variations.

Active

The price calculation will only be applied to products if it is active. In other words, you can try out new formulas and rounding behaviours, without causing the item prices to be recalculated. Activate the price calculation when it should go into effect.

  • = Saving does not trigger a recalculation.

  • = Saving opens a pop-up window. You will be asked to confirm your decision because saving triggers a recalculation. You will see how many variations are affected.

Note: Prices are not recalculated immediately. Rather, the recalculation starts after a short delay (about 3 minutes).

2.1.2. Formula

How should the price be calculated? For example, you could start with the purchase price and then add transportation costs, storage costs and taxes. Finally, you could add a 7% profit margin on top. In this case, the formula might look something like this:
(Purchase + Transport + Storage + VAT) * 1.07

formula

Writing the formula:

  1. Enter a name for the formula if needed, e.g. base formula.

  2. Click on the entry field.
    → A calculator opens.

  3. Enter the formula:

    1. Enter numbers and mathematical symbols with the calculator or the keyboard.

    2. Search for available variables and add them to your calculation ().

  4. Click Apply.

Available variables
Variation
Setting Explanation

Purchase price

Corresponds to the net purchase price under:
Item » Items » [Open variation\] » Tab: Pricing » Section: Costs » Option: Net purchase price

The purchase price is either calculated automatically or managed manually depending on how the settings were saved in the menu Setup » Stock » Stock » Incoming items.

Mov. avg. Purchase price*

Corresponds to the moving average purchase price under:
Item » Items » [Open variation\] » Tab: Pricing » Section: Costs » Option: Net moving average purchase price

It is recalculated every time stock is booked in. It is calculated from the purchase prices of all stocks that are available for the variation in the warehouse.

Note: Go to Setup » Stock » Stock » Incoming items and see which warehouses were activated with the setting Warehouse for moving average price. The moving average purchase price only takes items into account that were booked into one of these warehouses. If no warehouse is active, then no moving average purchase price is calculated.

Transportation costs

Corresponds to the net transportation costs under:
Item » Items » [Open variation\] » Tab: Pricing » Section: Costs » Option: Transportation costs

VAT
(standard client)*

Corresponds to the percentage of VAT under:
Item » Items » [Open variation\] » Tab: Pricing » Section: Costs » Option: VAT

Note: In the variation, the VAT is saved as a percentage. In the formula, you’ll need to convert the percentage into a decimal number. Example: You can turn 7% into 1.07 by entering (1 + VAT / 100).

Customs

Corresponds to the percentage of customs under:
Item » Items » [Open variation\] » Tab: Pricing » Section: Costs » Option: Customs in %

Note: In the variation, the customs surcharge is saved as a percentage. In the formula, you’ll need to convert the percentage into a decimal number. Example: You can turn 11,2% into 1.112 by entering (1 + Customs / 100).

Operating costs

Corresponds to the percentage of operating costs under:
Item » Items » [Open variation\] » Tab: Pricing » Section: Costs » Option: Operating costs in %

Note: In the variation, the operating costs are saved as a percentage. In the formula, you’ll need to convert the percentage into a decimal number. Example: You can turn 7% into 1.07 by entering (1 + Operating costs / 100)

Storage costs

Corresponds to the net storage costs under:
Item » Items » [Open variation\] » Tab: Pricing » Section: Costs » Option: Storage costs

Extra shipping charge 1;
Extra shipping charge 2

Corresponds to the extra shipping charge under:
Item » Items » [Open variation\] » Tab: Shipping » Section: Shipping » Option: Extra shipping charge 1 and 2

This is a fee that should be charged in addition to the normal shipping costs. Such extra shipping charges are useful for large or bulky items that are particularly expensive to ship.

  • Extra shipping charge 1 applies to the first item.

  • Extra shipping charge 2 applies to each additional item.

Additional settings: In each of your shipping profiles, specify whether these extra charges should be added to the basic shipping costs.

The manual also includes several example calculations for extra shipping charges.
Sales prices

Add sales prices to your formula. This list only includes the sales prices that you’ve already created in your system.

Example of use
Imagine you sell items in the plentyShop and on Amazon. You want the Amazon price to always be 10% more than in the plentyShop. In this case, you could calculate the Amazon price like this:
Amazon = plentyShop * 1.10

Why can’t I select some of the sales prices?
To avoid errors, some sales prices are not available for selection. It is not possible to use a sales price as a variable if it has already been chosen as a target price.

Properties

Add properties of the type "Int" or "Float" to your formula. This list only includes the sales prices that you’ve already created in your system.

Have you also saved a value for the property?
Make sure that you’ve linked the property to the corresponding variations and that you’ve saved a whole number or a decimal number as the value.

Formulas

It is possible to build new formulas on top of existing ones. For example, you could start by creating a base formula. Then you could add other calculations to further modify the formula. Previously created formulas will turn into variables, which you can select here.

Why don’t I see this area?
This area is only displayed if your price calculation includes more than one calculation building block.

2.1.3. Target price

Which sales prices should the formula calculate? For example, you might want to calculate the prices for your plentyShop with this formula and the prices on Amazon with a different formula. How many decimal places should the sales price have? Should it be rounded up or down? Choose your preferences from the drop-down lists.

target price

Choosing sales prices:

  1. Click on Target price.
    → A new line is added.

  2. Choose the appropriate sales price, rounding behaviour and number of decimal places. Note Table 2.

  3. Repeat the procedure to add further target prices as needed.

Table 2. Target prices, rounding behaviour and decimal places
Setting Explanation

Target price

Select the appropriate sales price from the drop-down list.

Why can’t I select some of the sales prices?

  • To avoid duplicate target prices. For example, if you selected the plentyShop as the target price in the first line, then you cannot select the online shop as the target price again in the second line.

  • To avoid errors. It is not possible to set a sales price as the target price if it is currently being used as a variable.
Rounding behaviour
Behaviour Explanation Examples

Do not round, but rather limit decimal places

Prices will not be rounded. Instead, enter a number of decimal places. Any further decimal places will be cut off at this point.

4.3275
4.327
4.32

To full euro

Prices will always be rounded to the next full euro, pound, franc, etc.

10.00
11.00
12.00

To full cent

Prices will always be rounded to the next cent, penny, centime, etc. This means prices will be rounded to a maximum of two decimal places.

4.32
4.33
4.34

To x.99

Prices will always be rounded to one cent before the full euro (one penny before the full pound, etc.).

10.99
11.99
12.99

To x.95

Prices will always be rounded to five cents before the full euro (five pence before the full pound, etc.).

10.95
11.95
12.95

To x.45 or x.95

Prices will always be rounded to five cents before the full or half euro (five pence before the full or half pound, etc.).

10.45
10.95
11.45

In 50 cent increments

Prices will always be rounded in increments of 50 cents, pence, centimes, etc.

10.50
11.00
11.50

In 25 cent increments

Prices will always be rounded in increments of 25 cents, pence, centimes, etc.

10.25
10.50
10.75

In 10 cent increments

Prices will always be rounded in increments of 10 cents, pence, centimes, etc.

10.10
10.20
10.30

To x.x9

Prices always have a 9 as the second decimal place.

10.19
10.29
10.39

In 5 cent increments

Prices will always be rounded in increments of 5 cents, pence, centimes, etc.

10.05
10.10
10.15

Rounding direction

Which direction should the prices be rounded in?

  • Mathematical = The calculated prices will either be rounded up or down. The direction depends on whether the price is above or below a certain threshold. For example, the rounding behaviour To x.99 has a threshold of 49 cents. If a calculated price ends with x.48, then the price is rounded down. If a calculated price ends with x.49, then the price is rounded up.

  • Round up = The calculated price will always be rounded up.

  • Round down = The calculated price will always be rounded down.

Decimal places

Enter the appropriate number of decimal places. The calculated price is cut off at this point.

Examples:

  • Calculated price: 199.123456

  • 4 decimal places: 199.1234

  • 2 decimal places: 199.12

Why can’t I enter decimal places?
Most rounding behaviours are inherently limited to 2 decimal places. If you select one of these rounding behaviours, then you will not be able to enter decimal places.

2.1.4. Adding further calculations

Each price calculation is made up of one or more calculation building blocks. Within each building block, you’ll:

further calculation

The first building block automatically appears when you create the price calculation. Click on Calculation to add further building blocks and thus build your formulas on each other. For example, you could use the first calculation to create a base formula. And you could use additional calculations to modify this formula even further.

Previous formulas turn into variables

The neat thing about this building block format is that you can re-use previously created formulas. They turn into variables, which you can select in the calculator.

2.2. Working with existing calculations

Once you’ve created a new price calculation, it’s automatically added to the overview in the menu Setup » Item » Price calculation. Click on a price calculation to open it and edit it further.

2.2.1. Toolbar in the overview

Symbol Explanation

Reloads the menu.

Opens the screen for creating a new price calculation.

It’s possible to open several price calculations at the same time. Select the desired calculations () and click on . The price calculations will be displayed one below the other on the left side of the screen.

It’s possible to copy existing price calculations. Select the desired calculations () and click on . The new calculations will be added to the overview. They will automatically be made inactive and given the name Copy of "original name".

Note: Links to variations will not be copied.

delete

It’s possible to delete several price calculations at the same time. Select the desired calculations () and click on .

Note: A price calculation can only be deleted if it is not linked to a variation.

2.2.2. Columns in the table

Header Explanation

It’s possible to open or delete several price calculations at the same time. Select the desired calculations () and click on one of the symbols in the toolbar.

Active

Active price calculations are marked with a blue dot (). This helps you recognise the active and inactive calculations at a glance.

UUID

The price calculation’s UUID. The UUID is automatically generated when the price calculation is created. The UUID cannot be changed.

Tip: Do you want to copy the UUID? To do so, open the price calculation and click on the UUID in the lower left corner. The UUID is copied to the clipboard.

Name

The name that was entered while creating the price calculation. In the overview, the price calculations are sorted alphabetically by their names.

Calculated sales prices

The target prices that were chosen while creating the price calculation.

Linked variations

The number of variations that are linked with the price calculation. This number tells you how many variations will be affected when prices are recalculated.

Number of variations with errors

The number of variations that are linked to the price calculation, but whose prices cannot be calculated correctly. Open the error log to see what’s causing the problem.

2.2.3. Meta data

Once you’ve opened a price calculation, you’ll see meta information displayed in the lower left corner. The following data is displayed here:

  • Name

  • UUID

  • Creation date

  • Date when changes were last made

The UUID can be copied.

Move your cursor over the UUID. The cursor changes shape (). Click on the UUID to copy it to the clipboard.

2.2.4. Error logs

Every price calculation includes an error log. The log tells you which variations cannot have their prices calculated and why.

Viewing and fixing errors:

  1. Go to Setup » Item » Calculation.

  2. Open the price calculation and click on Error log on the left.

  3. Expand a line () to see further information about the errors.

  4. Click on a variation ID to open the variation and fix the errors.

Table 3. Error logs
Header Explanation

Variation ID

The number of variations that are linked to the price calculation, but whose prices cannot be calculated correctly. Click on a variation ID to open the variation and fix the errors.

Errors

The number of errors that occurred for the variation.

2.3. Applying the calculation to products

There are different possibilities to apply price calculation on products:

  • If you want to use price calculation on a few products, we recommend to do it manually.

  • If you want to use price calculation on many products, we recommend to use import or group functions.

Manually

  1. Go to Item » Edit item » [Open variation] » Tab: Settings » Area: Sales prices.

  2. Choose a previously created price calculation from the right drop-down list.

  3. Save () the settings.

  4. Reload the item data record if needed. To do so, right-click on the item tab and then click on Reload.
    → The sales price and the automatically calculated monetary price will be displayed in the list.

Import

The price calculation can be linked via import. Use the import type Item and the field Variation / price calculation UUID.

Unresolved include directive in modules/item/pages/prices.adoc - include::data:page$elasticSync-item[]

Group function

Price calculation can be linked via variation group function.

  1. Go to Item » Items.

  2. Set search filters as needed and start the search.

  3. Select () the variations to be edited.

  4. In the toolbar, click on layers » layers Variation group function.
    → The Variation group function window opens.

  5. Select () the procedure price calculation from the drop-down list.
    → The action is added to the lower part of the window.

  6. Seelect your price calculation from the drop-down list in the bottom part from the window.

  7. Execute the group function.

One price calculation per variation

Only one price calculation can be linked to a variation. Imagine you’ve already linked a price calculation to a variation. Then you link a second price calculation to the same variation. In this case, the second price calculation would overwrite the first one. Both price calculations can not simultaneously be linked to the variation.

Nonetheless, it’s still possible to calculate prices differently, e.g. in the plentyShop and on Amazon. This is done by adding multiple calculation building blocks to your price calculation.
PlentyONE works with gross prices

Behind the scenes, PlentyONE works with gross prices:

  • In the item data record, you can decide whether you want gross prices or net prices to be displayed. But this only affects how the prices are displayed.

  • Only gross prices are saved internally in the database. So if you save a net price, then it will be converted internally into a gross price and saved as such in the database.

2.4. FAQ

Which actions cause prices to be recalculated?

  • Modifying a price calculation: Saving changes to an active calculation () will cause prices to be recalculated. More specifically, prices will be recalculated if you change a value within a calculation building block (formula, target price, rounding behaviour). Simply saving without changes or modifying the name will not cause prices to be recalculated. Saving opens a pop-up window. You will be asked to confirm your decision. You will see how many variations are affected.

  • Modifying the value for a variable: Imagine your prices are calculated with the following formula: (PURCHASE + Transport + Storage + VAT) * 1.07. If you change a product’s purchase price, transportation costs, storage costs or VAT, then new data will flow into the formula and the price will be recalculated. The variables that can be added to a formula are constantly being monitored for changes.

Note: Prices are not recalculated immediately. Rather, the recalculation starts after a short delay (about 3 minutes).

When will my prices be recalculated?

Prices are not recalculated immediately. Rather, the recalculation starts after a short delay (about 3 minutes after it is triggered). For example, if you change a product’s purchase price, then the recalculation will begin approximately 3 minutes later.

Why not immediately? Often, more than just one change is made to a product. For example, you might need to change a product’s purchase price and its transportation costs. If the prices were recalculated immediately, then the first recalculation might not even be finished before the second one starts.

What happens if a value is missing from the formula?

The price will not be calculated. Imagine your prices are calculated with the following formula: (Purchase + Transport + Storage + VAT) * 1.07. In this example, if you forgot to save a purchase price for an item, then its price will not be calculated. Open the error log to see if any values are missing for your products. The error log tells you which variations cannot be calculated and why.

What happens if the calculated price is 0?

PlentyONE prevents prices from accidentally being saved with the value 0.00. Both before and after rounding, the system checks whether the calculated price is 0. If this is the case, then the price will not be saved and the error log will include information about the problem.

What happens if I choose a target price that isn’t yet linked to the variation?

No problem. When the price calculation is triggered, the sales price will be linked to the variation and the monetary price will be calculated.

Can I apply multiple price calculations to the same variation?

No. Only one price calculation can be linked to a variation. Imagine you’ve already linked a price calculation to a variation. Then you link a second price calculation to the same variation. In this case, the second price calculation would overwrite the first one. Both price calculations can not simultaneously be linked to the variation.

Nonetheless, it’s still possible to calculate prices differently, e.g. in the plentyShop and on Amazon. This is done by adding multiple calculation building blocks to your price calculation.

3. Old price calculation (will be discontinued in the future)

  1. Go to Setup » Item » Calculation.

  2. Click on New price calculation.
    → The New price calculation window opens.

  3. Enter a name.

  4. Click on Add.
    → The new price calculation opens.

  5. Carry out the settings. Note Table 4.

  6. Save () the settings.

Table 4. Creating a price calculation
Setting Explanation

Settings

Name

Enter a name for the price calculation. The name will be displayed in the Sales prices area in the Settings tab of an item variation.

Price source

Select a price which serves as the basis of the price calculation.

Transportation costs

Activate to add transportation costs to the price source. Enter the transportation costs in the Costs area in the Settings tab of an item variation.

Storage costs

Activate to add storage costs to the price source. Enter the storage costs in the Costs area in the Settings tab of an item variation.

Customs

Activate to add customs to the price source. Enter the customs rate in the Costs area in the Settings tab of an item variation. Customs is entered in percent.

Operating costs

Activate to add operating costs to the price source. Enter the operating costs in the Costs area in the Settings tab of an item variation. Operating costs are entered in percent.

VAT

Activate to add the VAT rate to the price source. Select the VAT rate in the Costs area in the Settings tab of an item variation. The VAT is entered in percent.

Links

Add

Click on Add to create a new link.

Target

Select a price which serves as the target price of the price calculation.

Operator

Select the operator. Plus, Minus, Plus percentage, Minus percentage, Multiplied by and Divided by are available.

Operand

Enter a numerical value.

Client (store)

This option only relates to manufacturer commissions. Select a client (store) to be linked with the price calculation.

Referrer

This option only relates to manufacturer commissions. Select a referrer to be linked with the price calculation.