In this article you will learn the in’s and out’s of the Price List screen, such as:
Add and manage new price lists and product prices, costs, and box dimensions from the Price Lists tab.
Massively update their information and upload your company's price list into Komet Sales to set specific Prices and Costs for every product.
Automatically update product information and set Seasons for each price list.
Roles enabled to use this screen: Admin.
When you enable Price Lists, the system will use these prices and costs to suggest them through the system when adding products.
Table of Contents
Enable Price Lists
To use the Price and Cost Lists screen, you must enable it from the settings. Do the following instructions to enable this screen:
Go to Setup and select Settings.
Select Price Lists from the Customers group.
Activate Enable Price Lists.
Enable Include Costs to include costs and assign them to specific Vendors.
Enable Price List Automatic Addition to automatically add new product packs to Price Lists.
Click Save to store the changes.
Manage Price Lists
You can add new Price Lists, edit them, create Seasons, associate customers, manage prices, and export them to PDF and Excel files from this tab.
Types of Price Lists
There are three types of Price Lists:
Prebook Price List. This list applies to Prebook Orders.
Open Market Price List. This list applies to Open Market Sales.
Standing Order Price List. This list applies to Orders generated through Standing Orders.
When you create a Price List, you can set it as a Default or a Master Price List. Here is an explanation of both types:
Master Price List. A Master Price List applies to the whole company. When choosing a Price List as Master, the system uses it to create an order for a customer with no set Price List. There can only be one Master Price List.
Default Price List. A Default Price List lists products with a defined base price for each item. This price list applies to every customer and season. A Default Price List is a base for each price list you create and the season assigned to them.
For Customers purchasing through the E-Commerce, the system will use Price Lists with type All or Prebook.
To set an existing Price List as a Master Price List, it must not be associated with a Customer, Location, or a specific Type.
Add a Price List
To add or create a new price list, follow these instructions:
Go to Price Lists in the Setup tab.
Click on New Price List.
Fill out the information and select the Price List type in the pop-up message.
Click on Save.
Once you create a Price List, it is not possible to change the Price List Type.
Add products to a Price List
After creating a new Price List, you must add products and their information. Products are added through Seasons. To do this, follow these instructions:
Click on the dropdown button in the Actions column and select Edit.
Click on New Season.
Enter the name of the new Season and select the date range when the Season is effective; you can also leave the End Date field empty to keep the Season going.
Add products. You can copy them from a previous Price List, upload them from a Master Template, or add the products manually.
Click Save to store the new Season in the Price List.
You can add a Product to multiple Price Lists. To do so, select as many Price Lists as you want on the Add Item to Price List pop-up.
Master Template
A Master Template is an Excel file to add all your prices and costs to every product in Komet Sales. Once all the information is added, you can upload the file to Komet Sales, and the system automatically adds them to a price list in Komet Sales.
To download a Master Template, click on the Actions button at the top left of the list and select Download Master Template.
Manage Products from a Price List
To modify the product information, click on the Actions column from the Price List you want to change and select Manage Products. This takes you to the Global Pricing screen to modify products from your Price List.
Associate Customers to a Price List
Associating a Customer to a Price List sets the prices a particular customer will see when buying products from you. This way, you can create multiple price lists to use with each customer depending on the negotiations on product prices your company has with them. To associate a Customer to a Price List, follow these instructions:
Click on the Actions column from the Price List you want to modify.
Select Associate Customers.
Select the customers you wish to associate to the Price List and use the > button to move them to the Selected Customers Column. You can also move every available customer by clicking on the >> button.
Click Save to store the changes.
A customer can only be associated with one Price List within the same date range.
Price List Actions
In the Actions column, you can do the following actions for each Price List:
Edit. Edit the information from the Price List, and add or remove seasons.
Associate Customers. Associate or remove customers from a particular Price List.
Manage Products. Re-directs to Global Pricing to modify individual product information within the Price List.
Export Price List. Export the Price List in PDF or Excel format.
Delete. Delete the selected Price List.
Global Pricing
You can add items to your Price List and change product Prices, Box Type, Cost, and Vendor from this section. Changes can be done individually by product or massively for several products at a time. You can also calculate the estimated landed cost on this page by selecting the date at the top.
You can select the columns of the screen by clicking on the gear icon.
Add Items to a Price List
To manually add products to a Price List from the Global Pricing screen, click on Add New Item to Price List, fill out the product information, and click Save.
Individual Product Update
To modify or select the Vendor, Box Type, Cost, and Price for a particular product on the product list, use the editable fields under each column on the product line. You can also duplicate and remove lines by going to the Actions column.
Prices - Mass Update
To modify prices from entire Price Lists, there is a process called Prices Mass Update; follow these instructions to do so:
In the Global Pricing screen, click the Actions button at the top left of the list.
Select Price List - Prices Mass Update.
Choose the way you wish to modify the prices:
Change Prices in Dollars.
Increase or Decrease Prices in Dollars or Percentages.
Input the amount and click Continue.
Click on Yes to confirm the update.
Costs - Mass Update
To modify the Costs from entire Price Lists, there is a process called Costs - Mass Update. To do so, follow these instructions:
Click the Actions button at the top left of the list in the Global Pricing screen.
Select Price List - Costs Mass Update.
Choose the way you wish to modify the costs:
Change Costs in Dollars.
Increase or Decrease Costs in Dollar or Percentage.
Input the amount and click Continue.
Click on Yes to confirm the update.
Standing Order - Mass Update
You can modify the prices from Prebooks and Purchase Orders created through Standing Orders with the prices from a previous Price List through a Standing Order Mass Update.
There are two types of mass updates you can make:
SO - Master - Mass Update
The changes made through this action only affect the Master Standing Order.
In the Global Pricing screen, search for the Price List you wish to modify and apply all the filters to which you want to apply changes.
Click the Actions button located at the top left of the list.
Select SO - Master - Mass Update.
Click Proceed.
Type Confirm in the pop-up message to apply changes.
This changes do not apply to existing Standing Order Prebooks or Purchase Orders.
SO - PB&PO - Mass Update
These changes apply to existing Prebooks and Purchase Orders.
In the Global Pricing screen, search for the Price List you wish to modify and apply all the filters to which you want to apply changes.
Click the Actions button located at the top left of the list.
Select SO - PB&PO - Mass Update.
Click Proceed.
Type Confirm in the pop-up message to apply changes.
Only Prebooks and Purchase Orders that are not fulfilled or have a future truck date are modified by this action.
Export Price Lists
You can export your company’s price lists in Excel from the Global Pricing screen. To do this, follow these instructions:
Go to Setup and select Price Lists.
Click on Product Prices.
Search the Price List you want to export.
Click on Actions.
Select Export to Excel from the dropdown menu.
Related Articles
-
-
Apply a Price List to a Prebook (Knowledge Base)
-
Custom Price Lists and Seasons (Knowledge Base)
-
-
Export Price Lists (Knowledge Base)
-
-
-
Get a Price List (API)
-
Price List Per Location and Customer (Knowledge Base)
-
Price Lists for Future Sales (Knowledge Base)