Purchase price list

When you add products to a new or an existing purchase order, the system determines the buy price is using the following priority (in order from 1 to 3):

1. Supplier price lists (Purchases > Supplier price lists)
   • The buy price is first taken from the supplier price lists page, where you can set up prices for each supplier. This allows you to maintain different buy prices for the same product across multiple suppliers.
2. Product unit cost (Product edit > Sku variation > "Unit cost price for new purchases")
   • If no supplier price list is found, the unit cost price for new purchases (set on the product edit page) will be used.
3. If neither #1 nor #2 is set up, the system will fall back to the FIFO cost. If none of the above exist, the default buy price will be zero. 

The buy price can always be manually overridden at the time of entering or editing in any of the aforementioned calculations.

Price list

You can add supplier price lists using the supplier price lists page (Purchases > Supplier price lists).

"Unit factor of" is a conversion number the purchase order system uses to translate quantities between different units of measure.

In the example above:

• The supplier provides the item in kilograms (KG)
• The item selling unit (set on the product edit page) is in grams, so
• The system sets the unit factor of 1,000.

This way, when you reorder the product in KGs (from that specific supplier) and receive the purchase order, the system will automatically convert the received quantities into the selling unit (in this case, grams) using the unit factor.

Data import template for supplier purchase price lists

To import supplier price lists, go Products > Import data. From the dropdown list of data types, select Supplier price lists. Then, click Download template to export an Excel spreadsheet template with columns for you to fill in, explained in the table below.