Import Stock Items

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

Introduction

Import Stock

Available fields to Import

Field Lengths

Introduction

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:

• Go to 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. 

• 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

  Last updated: 27 March 2023