Roundhouse custom software development London


Sage 200 Stock Item Import Update


Stock Item Import Update

Stock Import Overview


When preparing a Sage 200 installation, it is possible to migrate/import details such a stock items from existing systems.  The import allows the user to update the stock record with various static fields. This new stock import update allows the existing stock items to be updated with the standard cost field.



On launching the Stock Item Update Import routine from the S200 menu, the following form will be displayed.

sage plugins stock import

Import/Update Stock Item Values

Select a file to import by clicking the open file button to the right of the white text box.  This will open a standard MS Windows file selection dialog from which a file may be selected.


Clicking the Import button will offer a confirmation dialog, and on selecting the OK button, search category values will be imported.


If a record contains an error, such as an invalid stock item code, then a message will be displayed with a description of the error. The error will also be logged in a log file in the same folder as the import file (with the same name appended with a suffix of “.log”.

sage plugins stock update
sage plugins category import

Once the import has finished. The total number of errors will be displayed. The user may amend the file and re-import. If no errors are found in the file then the total number of stock items which have been updated will be shown.

sage plugins import file
sage add-ons import stock

File Format


A text file must be created containing stock item values that are to be imported and updated (shown in Red).  This CSV file contains fields which are not used to update the S200 stock item. The file must be in CSV (Comma Separated Values) format as follows:

stock item import update

The first row of the file must contain a header record containing column descriptions.  The column descriptions are not validated and the header row is skipped during the import. If the program does not find the correct number of columns on the first row – then the file will not be processed. If the field values on the stock item rows are blank then those stock item field values will not be updated.

Log File


The log file may be viewed after the import (e.g. in note pad). The log file is created for any errors found when importing the CSV file. The product code is shown (followed by the field and value) and the message from the sage 200 object.

For further information on this and other Roundhouse Add-ons for Sage 200, please contact Roundhouse.

Roundhouse bespoke software development London