Pavilion provides multiple pricing models for different use cases. Pricing model determines how item cost and prices are entered, and it also determines how item quantities are tracked.
Each category has a default pricing model. For most categories user can switch between Unique Item and Multi Quantity models. Special categories, like Loose Diamonds, Loose Gemstones, Bullion, and Bulk Diamonds, have a specific Pricing Model that can’t be changed unless the Category is changed.
Pricing Models
Pricing Model | Description | Example |
Unique Item | Most commonly used model. Represents a unique item that has its own cost, price, tag, and location. | Engagement Ring |
Gemstone | Unique Item that can also be priced by carat. | Loose gemstone |
Diamond | Unique Item that can also be priced by carat and based on the Rapaport price. | Loose diamond |
Metal Item | Unique Item that can also be priced by gram/carat and based on a metal spot price. | Coin, Bullion |
Multi Quantity | Used for serially-made identical items where you don’t need to keep track of each individual item location, price, and you don’t need to print a unique tag for each item. | Batteries, Watch Straps. |
Bulk Stones | Used for bulk stone packages (melees). Allows to keep track of purchases and sales based on both the number of pieces and the total carat weight. | Bulk diamonds (melees) package |
1. Unique Item
1.1 Unique Item Costs & Prices Sections
Key fields
Field | Definition |
SKU | SKU stands for Stock Keeping Unit and is a unique identifier assigned to the inventory item. It serves as a reference code for tracking and managing the item within the inventory. |
Vendor | Represents the supplier from which the inventory item was obtained. It identifies the company or entity responsible for providing the item. |
Vendor SKU | The vendor SKU field refers to the unit or product code assigned by the vendor to the inventory item. |
Document | The document field is used to attach number of related document purchase. |
Stock Status | The stock status field indicates the current status of the Inventory Item, such as In Stock, Out of Stock, Draft etc. |
Store | The store field specifies the physical store where the Inventory Item is located or assigned to. |
Location | The Location field specifies the physical location in the Store where the Inventory Item is located. |
2. Gemstone
2.1 Gemstones Costs & Prices Sections
Key fields
Field | Definition |
Weight | The Weight field denotes the measurement of the Inventory Item, typically in carats or the appropriate unit of measurement for the specific item, such as grams or ounces. |
Cost | The Cost field represents the amount spent or the associated cost of acquiring the inventory item. |
Total Cost | The Total Cost field calculates the overall cost by multiplying the Unit Cost by the Weight of the Inventory Item. |
Price Markup | The Price Markup represents the amount added to the cost price to determine the price of the Inventory Item. |
Price per Unit | The Price per unit field shows the selling price of an individual unit of the Inventory Item. |
Total Price | The Total Price is calculated by multiplying the Price Markup by the Total Cost, providing the overall selling price of the inventory item. |
2.2 Gemstones Inventory section
The Gemstone Inventory section works the same as the Unique Item pricing model. Refer to the Unique Item for details.
3. Diamond
3.1 Diamond Costs & Prices Sections
Key fields
Field | Definition |
Weight | The Weight field denotes the measurement of the Inventory Item, typically in carats or the appropriate unit of measurement for the specific item, such as grams or ounces. |
Cost | The Cost field represents the amount spent or the associated cost of acquiring the inventory item. |
Unit Cost | This field specifies the cost per unit of the Inventory Item, providing the Cost of the individual item. |
Rapaport Price | The Rapaport price reflects the value of the inventory item based on the Rapaport Diamond Report, which is published by Rapaport as a benchmark for diamond pricing and is updated weekly. |
Price Markup | The Price Markup represents the amount added to the cost price to determine the price of the Inventory Item. |
Price per Unit | The Price per unit field shows the selling price of an individual unit of the Inventory Item. |
Total Price | The Total Price is calculated by multiplying the Price Markup by the Total Cost, providing the overall selling price of the inventory item. |
Rap. Discount | The Rapaport discount indicates the percentage difference between your price and the Rapaport Price.
|
3.2 Diamond Inventory Section
The Gemstone Inventory section works the same as the Unique Item pricing model. Refer to the Unique Item for details.
4. Metal Item
4.1 Metal Item Costs & Prices Sections
Key fields
Field | Definition |
Weight | The Weight field denotes the measurement of the Inventory Item, typically in carats or the appropriate unit of measurement for the specific item, such as grams or ounces. |
Cost | The Cost field represents the amount spent or the associated cost of acquiring the inventory item. |
Unit Cost | This field specifies the cost per unit of the Inventory Item, providing the Cost of the individual item. |
Metal Spot Price | This field indicates the current market price of the metal used in the inventory item, such as gold or silver. |
Price Markup | The Price Markup represents the amount added to the cost price to determine the price of the Inventory Item. |
Price per Unit | The Price per unit field shows the selling price of an individual unit of the Inventory Item. |
Total Price | The Total Price is calculated by multiplying the Price Markup by the Total Cost, providing the overall selling price of the inventory item. |
4.2 Metal Item Inventory Section
The Gemstone Inventory section works the same as the Unique Item pricing model. Refer to the Unique Item for details.
5. Multi Quantity
5.1 Multi Quantity Item Costs & Prices Sections
Costs & Prices section is same as for Pricing Models - 1.1 Unique Item Costs & Prices Section
5.2 Multi Quantity Item Inventory Section
Key fields
Field | Definition |
SKU | SKU stands for Stock Keeping Unit and is a unique identifier assigned to the inventory item. It serves as a reference code for tracking and managing the item within the inventory. |
Vendor | Represents the supplier from which the inventory item was obtained. It identifies the company or entity responsible for providing the item. |
Vendor SKU | The vendor SKU field refers to the stock keeping unit or product code assigned by the vendor to the inventory item. |
Document | The document field is used to attach number of related document purchase. |
Stock Status | The stock status field indicates the current status of the Inventory Item, such as In Stock, Out of Stock, Draft, etc. |
Store | The store field specifies the physical store where the Inventory Item is located or assigned to. |
Available Quantity | The Available Quantity field represents the current quantity of the Inventory Item that is available for sale or use. It helps in monitoring stock levels and managing inventory replenishment. |
6. Bulk Stones
6.1 Bulk Stones Costs & Prices Sections
Key fields
Field | Definition |
Weight | The Weight field denotes the measurement of the Inventory Item, typically in carats or the appropriate unit of measurement for the specific item, such as grams or ounces. |
Cost | The Cost field represents the amount spent or the associated cost of acquiring the inventory item. |
Total Cost | The Total Cost field calculates the overall cost by multiplying the Unit Cost by the Weight of the Inventory Item. |
Price Markup | The Price Markup represents the amount added to the cost price to determine the price of the Inventory Item. |
Price per Unit | The Price per unit field shows the selling price of an individual unit of the Inventory Item. |
Total Price | The Total Price is calculated by multiplying the Price Markup by the Total Cost, providing the overall selling price of the inventory item. |
6.2 Bulk Stones Inventory Section
Key fields
Field | Definition |
SKU | SKU stands for Stock Keeping Unit and is a unique identifier assigned to the inventory item. It serves as a reference code for tracking and managing the item within the inventory. |
Vendor | Represents the supplier from which the inventory item was obtained. It identifies the company or entity responsible for providing the item. |
Vendor SKU | The vendor SKU field refers to the stock keeping unit or product code assigned by the vendor to the inventory item. |
Document | The document field is used to attach number of related document purchase. |
Stock Status | The stock status field indicates the current status of the Inventory Item, such as In Stock, Out of Stock, Draft, etc. |
Store | The store field specifies the physical store where the Inventory Item is located or assigned to. |
Original Quantity | The Original Quantity field displays the initial or original quantity of the inventory item when it was first added to the system. It helps in tracking any changes or adjustments made to the quantity over time. |