Create the Excel Import Template

To import data through LS One the Excel file has to have a certain layout. The Site Manager creates an template file for you so before you start you need to create such a template file.

Create an Excel import template file:

  1. Locate the Excel Import ticket on the Site Manager Dashboard.
  2. Press the Configure button and in the Select folder dialog select a folder where you want to keep your excel templates and import documents. LS One creates two new folders there, Default templates and Excel Import.

    In the Default templates folder you find the document Import Template.xlsx intended for all kinds of import. There is also an Basic Import Template.xlsx you can use if you are only importing items with prices, barcodes and their hierarchy.

  3. Open the document you want to use and save to the Excel Import folder.

-OR-

  1. To create the excel import template in the ribbon open Tools > New Excel templatee
  2. This brings up a dialog that asks you for where the template should be saved, its location and name.
  3. Save the document somewhere you can find it.

 

Next step is too Input the data into the excel template sheet document.

 

Last updated: 29th November 2016
Version: LS One 2016.1