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:
- In Sage, go to Customers>Price Lists (rather that the File>Import menu.)
- Select the Price List to import to or click New to create a new one
- Click the Import button to open the Import Customer Price List window
- Click Browse... and locate the import CSV file
- Click Continue... and you will see a summary of your import as shown below, where the data can be edited, if necessary
- Click Apply to import the data
Important considerations!
- The CSV file must be closed before importing
- The calculation method for the imported price list is automatically set to Fixed and cannot be changed.
- 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 ...Adding New Price List Customers using supported 3rd Party Plugins
Introduction Woosage supports the application of Customer and Special Price Lists to customer roles in WooCommerce by mapping a price list, which is made up of the prices specific to a customer or group of customers, to a website role, that can be ...Woosage50 Price & Product Processing (Professional Edition)
The features explained in this article are only available in the Professional edition of Woosage50 When the various product and prices settings of Woosage50 are enabled, the Sage product records are used to update and create website product data, ...Bulk Import of Sage Users
Assuming you have first installed the Woosage50 plugin on your website, you can import users from Sage including their Sage accounts code, price lists etc. using the details below. You can also use this method to add these details to to existing ...