Sage 50 Price Lists CSV Import Addon - (£99+VAT)

Now you can import Customer Special Prices, Customer Price List Prices and Supplier Price List Prices into the Sage Line 50 / Sage 50 Accounts Price File from a CSV file.

• Can be used to import data into any field in the Sage 50 Price file that is exposed by the Sage SDO.
• A simple five column CSV file handles most situations.
• The column headings in first line of the CSV file are used to define the fields that the data should be imported into.
• The CSV file contents are displayed, along with any error messages, before the import takes place.
• Create new template CSV files by selecting fields from a list of available field names.
• Export option will load your template with the data from your current Price file.
• The program can be run from a button in the Sage 50 Product Module (Accounts Pro and Financial Controller only).
• Licensed for use on as many of your company's computers as you like.
• Compatible with Sage Line 50 Accountant, Accountant Plus or Financial Controller versions 8 to 15 (2009).
  Only £99.00 + VAT for a company wide licence.
• Free 30 day trial

Works with:

• Sage Line 50 Accountant | Sage 50 Accounts
• Sage Line 50 Accountant Plus | Sage 50 Accounts Plus
• Sage Line 50 Financial Controller | Sage 50 Accounts Professional
• Sage Client Manager

To Run the Program

• If you have Financial Controller run the program by clicking the button on the Sage 50 Product module tool bar.
• Alternatively, run the program by selecting 'Adept Tools' and then 'Price CSV Import' from the Windows Start Button / Programs Menu.
• Before running the program - back up your Sage Data

Program Options

The program only three options and if in doubt you should leave all the boxes unticked.

Unix Compatibility

CSV files created on a UNIX computer usually use a single Line Feed to terminate each record whereas Windows computers will terminate each record with a Carriage Return Line Feed combination. If you tick the "UNIX Compatibility" box the program will be able to read CSV files in either format. However the multi-line option for Memos and Web Long Descriptions will be disabled because this feature relies on being able to use a single Line Feed (Excel Alt-Enter) to indicate the end of a line within a field.

Restrict Automatice Preview to Header row only

When you select a CSV file the program will normally load it straight away. This can become tedious if you regularly import large CSV files. If you tick the "Restrict Automatic Preview to Header row only" box only the first row of the CSV file will be loaded until you explicitly press the Load button.

Only Display which have Errors

If you tick the "Only display records which have errors" box the program will only display records that have an error message in the Status column..

Price CSV Import - Main Screen

• The window can be resized by dragging the corners or edges.
• The status bar at the bottom of the window will display a progress bar when the program is busy.
• When the program is idle, the contents of the current CSV file will be displayed.

Company Box

The Company Name from your Sage 50 data files will be displayed here.

CSV File Box

• Enter the path and file name of the CSV file that contains the data that you want to import.
• Alternatively, you can press the Browse button to use the standard Windows file browser to help locate your CSV file.

Delete Existing Price Type Boxes S, P and U

Tick these boxes if you want the program to delete existing prices before it imports the new prices.

First Row Contains Headings

• Tick this box if the first row of your CSV file contains the field names of the data to be imported.
• If this box is not ticked the program will use the simple 5 column CSV layout described below

Menu Button Click this button to display the program's menu. Fields Export Options (Discussed Above) Sage Path (see Installation) User Name (see Installation) Licence (see Installation About Help

Browse Button

Press this button to browse for the CSV file to be loaded.

Load Button

• Press this button to import the CSV file into Sage 50.
• The program will check the CSV file and if any errors are found appropriate error messages will be displayed in the Status column.
• If all is well, the following dialog will be displayed to allow you to confirm that you want to import the Products.

Fields Menu Option

Select this option to display information about the Price Field Names that are available to you in your version of Sage 50.

• To create a new template CSV file tick the boxes alongside the fields that you want to create columns for.
• When you close the Product Fields dialog you will be prompted to save your Template CSV file in a folder and with a name of your choice.

Export Menu Option

• Select this option to export the data in your current Sage 50 Price file into a template.
• Any data that is already in the template will be overwritten.
• You can select the record type that you want to export by ticking the S, P and U boxes.
• Press the Browse button to change the CSV file name.

(Video Tutorials - coming soon!)

Simple and Straightforward

Installation of the Sage 50 Price Lists CSV Import is simple and straightforward and should take no more than a few minutes. Comprehensive step-by-step instructions are provided.

Prior to installation you will need to:

• Ensure that you have installed all the appropriate patches and updates from the Sage update site for your version of Sage (comprehensive notes are provided with the download)
• Obtain from Sage a Serial and Activation key to enable '3rd Party Integration'.
  Notes and telephone numbers are provided with the download but Sage will want to know the main serial number for your copy of Sage and the version number - found by going to Sage 50,'s HELP / ABOUT menu option.
  N.B. The same 3rd Party Integration keys can be used for all addons that require them

• A fully functional 30 day free trial of Sage 50 Price Lists CSV Import is available.
• The trial can be unlocked by purchasing a full licence - you will not loose any settings
• Still got questions? Checkout the FAQ section.

£99.00 (£113.85 inc VAT)	Sage 50 Price Lists CSV Import
Ref: S50-018

Home > Sage Add ons > Sage 50 / Sage Line 50 Price Lists CSV Import Software

Sage 50 Addons Summary
Sage 50 Addons FAQ's
Sage 50 Addons Resellers

Addons that View Data ..

Sage 50 Company Viewer Lite
Sage 50 Product Viewer Mid
Sage 50 Order Viewer Pro

Addons that Manipulate Data ..

Sage 50 Back to Back Ordering
Sage 50 Credit Note Creator
Sage 50 Document Explosion
Sage 50 Multi Location Stock Tools
Sage 50 Payment Allocations
Sage 50 Product & Account Code Changer
Sage 50 Product Duplicator
Sage 50 Product Memos Backup Program
Sage 50 Sales Price Updater
Sage 50 Stock Adjustments In
Sage 50 Stock Split Program
Sage 50 Stock Transaction Editor
Sage 50 Subscriptions

Addons that Import Data ...

Sage 50 Address CSV Import
Sage 50 Customer CSV Import
Sage 50 Fixed Assets CSV Import
Sage 50 Invoice CSV Import
Sage 50 Price Lists CSV Import
Sage 50 Product CSV Import
Sage 50 Project Charge CSV Import
Sage 50 Purchase Order CSV Import
Sage 50 Sales Order CSV Import
Sage 50 Transaction CSV Import

Addons that also work with ..
Sage Instant* &/or Sage Instant Plus*

Sage 50 Company Viewer Lite
Sage 50 Customer CSV Importer
Sage 50 Product & Account Code Changer
Sage 50 Product CSV Import
Sage 50 Product Viewer Mid
Sage 50 Order Viewer Pro