In tracezilla you can create price lists for purchasing and sales as well as associate the price list with a customer or supplier.
First, the price list is created, and then prices are entered per SKU. If the prices are specific to a customer or supplier, the price list is linked to the partner.
When a SKU is added to an order, tracezilla will automatically retrieve the price from a price list. tracezilla is looking for:
- whether a price list is associated to the partner
- whether a price has been entered for the SKU in the associated price list
- whether there is a fallback price list
- or if a specific price list is not associated, whether there is a global price list
When a price is retrieved automatically, the name of the price list will appear.
Create price lists for sales prices
- Click Sales in the top menu and select Price Lists in the drop-down menu.
- Click Create Price List in the upper right corner.
Give the price list a name that you can easily recognize it by.
- You can enter a Reference code, which is used to sort your price lists in the overview. This is optional.
- You can select a fallback price list. Where no price is specified in the price list, tracezilla will get the price from the fallback price list. If you have created a customer-specific price list, it is an advantage that a standard price list is specified as a fallback price list.
- If the price list is a standard price list that applies to most customers, you can select Yes to the price list being global. If the price list is customer-specific you must select No.
- Select the currency and check the exchange rate.
- If you wish for the exchange rate to be updated automatically, you can select yes in the field Automatically fetch latest exchange rate if it is available. If you wish the exchange rate to be fixed based on the rate set when creating the price list, select No.
- When a price list is Active, tracezilla can retrieve prices from the price list. When a price list is no longer in use, select No.
- Click Save.
Create price lists for purchase prices
- Click Purchase in the top menu and select Price Lists in the drop-down menu.
- The rest goes as for sales prices.
Enter prices for the SKUs in the price list
- Click the price list in the overview.
- You can use the filters to the left to search for the SKU (Stock Keeping Unit).
- Enter a price for a specific SKU by clicking the pencil icon in the right side.
- Click Save or press Enter on your keyboard.
- You can view and edit multiple price lists at the same time by finding the price list on the left side in the Turn on price lists field and selecting the price list that you want to edit.
- You can also import prices and make changes to several prices at once using the price list import template.
Associate the price list to a customer or supplier
You can indicate that a specific customer or supplier should use a specific price list.
- Click Partners in the top menu.
- Select the customer/supplier among your partners.
- Click the button Edit in the lower right corner of the Basic information.
- Click the tab Prices, conditions…. Enter part of the name of the price list in the field Price List, Purchase or Price List, Sales and select the price list.
- Click Save.
Replace a price list
You can create a new price list to replace another price list. When the new price list has been created, you can set a date from which the new price list should apply. If the pricelist is obly to be active for a limited period of time, you can also set an end date.
By entering the date 01.01.2022, orders delivered after this date will retrieve prices from the new price list.
Here’s how you do it:
- Click Sales or Purchase in the top menu and select Price Lists.
- Create a new price list. You can follow the steps in the section Create price lists for sales prices.
- Search for the previous price list to be replaced.
- Click the blue button to the right of the price list and select Edit.
- Select the newly created price list in the field Replacement: Price List.
- Enter the date on which the new price list should apply. Please notice, that the date is activated by the delivery date on orders.
- Enter an end date.
- Click Save.
You can archive the previous price list after the specified date by selecting No in the field Active.
Updating prices in the price list
Do you need to update all the prices in a price list according to a certain percentage? For example all retail prices increase by 2%?
Then you can make use of tracezilla’s import template:
- Click Sales in the top menu and select Price lists.
- Search for the price list that contains prices that need to be updated. Click the price list.
- In the field Hide, you can select None, Price missing or Has price to narrow down the relevant SKUs.
- Click Import at the top right. Select Get Import Template in the dialog window.
- Open the spreadsheet on your computer.
- Now you can make calculations of the prices. Please note that the prices of the import template cannot be uploaded with underlying calculations. Make sure to Copy and Paste as values (see below).
- Save the file on your computer.
- Click Upload in tracezilla and select the file from the desktop.
Example of calculation
1) In column F of the import template, row 2, enter a formula so that all prices increase by 2%.
If you would like to deduct a percentage, you can also do so in a price list via the import template.
To deduct 15%, use the following formula
2) By entering $, the formula will follow the rows in column E, i.e. E3, E4, E5 etc.
3) In the lower right corner of the cell, the formula can now be dragged down so that it is applied at all prices.
4) Select all the prices in column F and press Ctrl C to copy. Move the mouse to cell G2. Press Ctrl Shift V (Paste as values).
5) Select all the prices in column E and F. Right-click and select Delete> Delete Cell Left so that the update prices from column G are moved to column E.
Save the file on your computer and then it is ready to be uploaded into tracezilla again.
If the updated prices are to appear in another price list that replaces the previous, the name of the price list must be changed in column E, row 1 to the name of the new price list.