Importing Customer Price List Prices

Price Lists allow you to create a prices for specific products, which can then be assigned to one or more customers in Sage.  There is a Price List import facility that can be useful for creating fixed price price lists (i.e. the calculation is not linked to the underlying product Selling Price). 

Note: if creating a price list for your website Regular Prices, for use with Woosage50, then it does not need to be assigned to customers in Sage

Create a list of Product Codes (SKUs) and their VAT-exclusive Prices as a CSV file in the following form. This can be done in a spreadsheet or note app (e.g. Excel or Notepad). The headings must be as shown and only the first 2 columns are used (any data in other columns is ignored, but we recommend that you remove additional columns from the import CSV).

Product Ref	Price
BEAN01	13.5
CAP01	4.5
HOOD01	14.85
HOODZ01	27
POLO01	18
POLO02	18
POLO03	18
POLO04	18
SUNG01	27

Import the file to a Price List, which can be a new or existing one, as follows:

1. In Sage, go to Customers>Price Lists (rather that the File>Import menu.)
2. Select the Price List to import to or click New to create a new one
   
3. Click the Import button to open the Import Customer Price List window
   
4. Click Browse... and locate the import CSV file
   
5. Click Continue... and you will see a summary of your import as shown below, where the data can be edited, if necessary
   
6. Click Apply to import the data
   

Important considerations!

1. The CSV file must be closed before importing
2. The calculation method for the imported price list is automatically set to Fixed and cannot be changed.
   
3. If the product already appears on the price list the price is overwritten.
   

• Related Articles

• Using a Price List for website Regular Prices

  Woosage50 allows you to use a Sage Price List to populate the Regular Prices on your website, which is useful if you use Sage Sales Prices for your trade/wholesale customers and want to create a Price List for retail customers, particularly if retail ...

• Creating a Sage Price List as a duplicate of Selling Prices

  Why might this be required? This may be a requirement in the following scenario. Your trade or wholesale prices are held in Sage in the Sage Selling Prices and you want to make these available to trade customers when they login to your website, via ...

• Sage Customer and Special Price Lists

  Introduction Woosage now supports the application of Customer and Special Price Lists to customer roles in WooCommerce (WordPress role). Each Customer Price List is mapped to a website role that will apply the relevant prices to customers with a role ...

• Adding New Price List Customers (when using Barn2 Plugin)

  Introduction Woosage supports the application of Customer and Special Price Lists to customer roles in WooCommerce. Each Customer Price List is mapped to a website role that will apply the relevant prices to customers with a role using a 3rd ...

• Adding New Price List Customers (when using Elex Plugin)

  Introduction Woosage supports the application of Customer and Special Price Lists to customer roles in WooCommerce. Each Customer Price List is mapped to a website role that will apply the relevant prices to customers using a 3rd party Role Based ...