Price Lists

Price lists allow you to offer different prices to different customers. With price lists you can adjust all prices by a percentage amount, or set specific prices on each individual product. Each price list has a currency, so they can also be used to sell your products in multiple currencies.

Getting Started

Price Lists can be set up in the admin from Settings > Price Lists. You can add as many price lists as you need and assign them to specific customers.

The default pricing is the prices you have set up on your products outside of price lists. When you set up a price list, the Conversion Rate is used to set up an initial price for each product relative to your default pricing. For example, if you set the Conversion Rate to 120% the prices will be 20% higher. If you set the Conversion Rate to 100% the prices will be the same as your default pricing.

If you need more control, you can set specific prices for each product. This can be done by editing a product in the admin from Products > Product List and then visiting the Pricing tab. For each price list that you have added, you will see an extra field for the unit price and RRP. If these are left blank then the conversion rate price will be used. If they are filled in then the specific prices will be used instead.

Assigning a Price List to a Customer

To assign a price list to a customer, visit the customer in the admin from the Customers section. Go to Edit Customer in the top right, then select the required price list from the Price List field.

Bulk Updating Prices

If you have lots of prices to edit, the easiest way to do this is to edit them in a spreadsheet using the product export and import. The product export file can be edited directly and then used as a basis for a new import which will update any products already on the system. To do this, export your products from the Products section in the admin, then load the file into a spreadsheet. Export your changes as a CSV file and upload it to Products > Import. For each price list you will see two extra columns on the export file, for example “Unit Price:Price List Name” and “RRP:Price List Name”.