Skip to content

Pricing

Part Pricing

Pricing Support

Refer to the Pricing Support documentation for more information on pricing support in InvenTree.

Pricing information can be determined from multiple sources:

Pricing Source Description Linked to
Internal Price How much a part costs to make Part
Supplier Price The price to theoretically purchase a part from a given supplier (with price-breaks) Supplier
Purchase Cost Historical cost information for parts purchased Purchase Order
BOM Price Total price for an assembly (total price of all component items) Part

Override Pricing

In addition to caching pricing data as documented in the above table, manual pricing overrides can be specified for a particular part. Both the minimum price and maximum price can be specified manually, independent of the calculated values. If an manual price is specified for a part, it overrides any calculated value.

Sale Pricing

Additionally, the following information is stored for each part, in relation to sale pricing:

Pricing Source Description Linked to
Sale Price How much a salable item is sold for (with price-breaks) Part
Sale Cost How much an item was sold for Sales Order

Pricing Permissions

Access to part pricing data is controlled by the dedicated Pricing user role. This role is separate from the Parts role, allowing pricing information to be restricted (or granted) independently of general part data. For example, a group may be allowed to view and edit parts, without being able to see what those parts cost.

The Pricing role covers the following data:

Data Description
Cached Pricing The calculated pricing overview data for each part, including any pricing overrides
Sale Price Breaks The sale pricing defined for a salable part
Internal Price Breaks The internal pricing defined for a part

The permissions within the Pricing role apply as follows:

Permission Effect
View View the Pricing tab on the part detail page, and see pricing information (e.g. minimum / maximum price) displayed against parts and BOM items
Change Edit pricing overrides, manually refresh pricing data, and edit existing price breaks
Add Create new sale and internal price breaks
Delete Delete sale and internal price breaks

If a user does not have view permission for the Pricing role, the Pricing tab is hidden on the part detail page, and cached pricing fields are omitted from part and BOM data returned via the API.

Other Pricing Sources

Some of the data used to calculate part pricing is covered by other roles. Supplier price breaks are covered by the Purchase Orders role. Within the Pricing tab, the Purchase History and Supplier Pricing sections are only displayed if the user also has view permission for the Purchase Orders role, and the Sale Pricing and Sale History sections are only displayed if the user also has view permission for the Sales Orders role.

Pricing Tab

The pricing tab for a given Part provides all available pricing information for that part. It shows all price ranges and provides tools to calculate them.

The pricing tab is divided into different sections, based on the available pricing data.

Pricing Data

As not all parts have the same pricing data available, the pricing tab display may be different from one part to the next

Pricing Overview

At the top of the pricing tab, an Overview section shows a synopsis of the available pricing data:

Pricing_Overview Pricing_Overview

This overview tab provides information on the range of pricing data available within each category. If pricing data is not available for a given category, it is marked as No data.

Each price range is calculated in the Default Currency, independent of the currency in which the original pricing information is stored. This is necessary for operations such as data sorting, price comparison, etc. Note that while the overview information is calculated in a single currency, the original pricing information is still available in the original currency.

Price range data is cached in the database when underlying pricing information changes.

Refresh Pricing

While pricing data is automatically updated, the user can also manually refresh the pricing calculations manually, by pressing the "Refresh" button in the overview section.

Overall Pricing

The overall pricing range is calculated based on the minimum and maximum of available pricing data. Note that overall pricing is the primary source of pricing data used in other pricing calculations (such as cumulative BOM costing, for example).

Internal Pricing

A particular Part may have a set of Internal Price Breaks which denote quantity pricing set by the user. Internal pricing is set independent of any external pricing or BOM data - it is determined entirely by the user. If a part is purchased from external suppliers, then internal pricing may well be left blank.

If desired, price breaks can be specified based on particular quantities.

Internal_Pricing Internal_Pricing

Pricing Override

If the Internal Price Override setting is enabled, then internal pricing data overrides any other available pricing (if present).

Purchase History

If the Part is designated as purchaseable, then historical purchase cost information is displayed (and used to calculate overall pricing). Purchase history data is collected from completed purchase orders.

Purchase_History Purchase_History

Supplier Pricing

If supplier pricing information is available, this can be also used to determine price range data.

Supplier price breaks are specified per pack of the supplier part. When calculating supplier pricing for a part, the price of each supplier price break is divided by the pack quantity of the supplier part, so that the resulting price is expressed per unit of the base part. This allows pricing from supplier parts with different pack sizes to be compared directly.

Example

If a supplier sells a part in packs of 100, at a price of $11.55 per pack, the supplier pricing for the part is $0.1155 per unit.

Refer to the supplier part pricing documentation for more information.

Supplier_Pricing Supplier_Pricing

BOM Pricing

If a Part is designated as an assembly, then the Bill of Materials (BOM) can be used to determine the price of the assembly. The price of each component in the BOM is used to calculate the overall price of the assembly.

BOM_Pricing BOM_Pricing

BOM Pricing Chart

The BOM Pricing Chart displays two separate "pie charts", with minimum and maximum price data for each item in the BOM. Note that prices are only shown for BOM items which have available pricing information.

Complete Pricing Required

If pricing data is not available for all items in the BOM, the assembly pricing will be incomplete

Variant Pricing

For template parts, the price of any variants of the template is taken into account:

Variant_Pricing Variant_Pricing

Sale Pricing

If the Part is designated as Salable then sale price breaks are made available. These can be configured as desired by the user, to define the desired sale price at various quantities.

Sale_Pricing Sale_Pricing

Sale History

If the Part is designated as Salable then historical sale cost information is available. Sale history data is collected from completed sales orders.

Sale_History Sale_History

Price Data Caching

Pricing calculations (and conversions) can be expensive to perform. This can make pricing data for complex Bills of Material time consuming to retrieve from the server, if not handled correctly.

For this reason, all information displayed in the pricing overview section is pre-calculated and cached in the database. This ensures that when it needs to be retrieved (e.g. viewing pricing for an entire BOM) it can be accessed immediately.

Pricing data is cached in the default currency, which ensures that pricing can be compared across multiple parts in a consistent format.

Pricing Updates

If automated pricing updates are enabled, the pricing data updated automatically, and will generally be up-to-date without user interaction. Pricing data is re-calculated and cached by the background worker in the following ways:

Response to Data Changes

When underlying pricing data changes, the cached pricing data is automatically updated. This includes (but is not limited to):

  • Stock items being received against a Purchase Order with provided pricing
  • Stock items being sold against a Sales Order with provided pricing
  • Bills of Material being created or modified, which may change the pricing of an assembly

Periodic Updates

A periodic task runs in the background to ensure that any outdated or missing pricing data is kept up-to-date. This task runs at a scheduled regular interval, as controlled via the Pricing Rebuild Interval setting. The default value is 30 days, meaning that pricing data is updated at least once every 30 days. Setting this value to zero disables periodic updates.

Manual Updates

Additionally, the user can manually recalculate pricing for a given part. This can be done from the pricing overview display, by pressing the "Recalculate" button.

Disable Automatic Updates

Automatic pricing updates are enabled by default. If desired, this functionality can be disabled (via the Auto Update Pricing setting). If this is done, then pricing data will not be automatically updated, and the user must manually recalculate pricing data as required.

Disabling automatic pricing updates may be prudent in systems where pricing data changes frequently, but the user wants to control when the pricing data is updated. In this case, the user can manually recalculate pricing data as required.