Import Stock Items

You can import Stock Items to import new items, or replace existing items.

Overview

Import Stock

Available fields to Import

Field Lengths

Overview

You can import new or replacement stock items from a file to easily update the Stock items in your Lentune Stock module. Files with an extension of .xls, .xlxs or .csv can be imported. A list of the available fields is shown below.

Return to Top of Page

Import Stock

The fields that can be imported are listed on the import screen. Fields are listed in sections for Compulsory columns, Optional columns and Additional recommended columns.

To import stock items:

• Start at Stock > Import Stock Items.

In the Upload section:

• Check the options you require from:
  • Insert new stock items.
  • Update existing stock items.
  • Ignore file size limit. 
  • Remove old supplier stock references (this will look at supplier stock codes and remove any that belong to the current preferred supplier)

• Select the file to import, or drag it to the import box.
• Click Upload stock from file.

Any errors detected are displayed on the right of the screen.

Return to Top of Page

Available fields to Import

The available fields for importing are:

Return to Top of Page

Field Lengths

Generally, text fields have a character limit of 255, e.g. Description, except the following:

These fields have a limit of 70 characters:

•  
  • SupplierStockCode (recommended 50 characters)
  • SupplierCategory
  • SupplierSubCategorySupplierPackSizeOptions

Return to Top of Page