Skip to main content

Catalog Import

  • Updated

In eLabNext it is possible to import products into the Product Catalog. Navigate to Import Product Catalog under Imports in the System Admin Panel.

Start by creating a Catalog Import Template by selecting the group in which the products should be imported and click Download Import Template.

NewItem2074.png

Open the downloaded Excel Import Template and complete the Import Template by adding the data of the products in the corresponding fields according to the specification below. Each line will be imported as a separate product in the product catalogue. All fields with a "*" are mandatory.

NewItem1314.png

Open the downloaded file with a spreadsheet program and fill out the columns following the guidelines in the table below:

Column

Name *

Data entry:

Required field

Expected data:

Any text up to 255 characters

Data condition:

 

Data context:

Data in this column will be imported to the system as the product name

Exception handling

 

 

Column

Catalog Name 

Data entry:

 

Expected data:

Any text up to 255 characters

Data condition:

 

Data context:

Data in this column will be imported to the system as Catalog name

Exception handling

 

 

Column

Catalog Number *

Data entry:

Required field

Expected data:

Any text up to 255 characters

Data condition:

 

Data context:

Data in this column will be imported to the system as Catalog # 

Exception handling

 

 

Column

Amount *

Data entry:

Required field

Expected data:

Unit of quantity 

Data condition:

Use . to separate decimal numbers

Data context:

 

Exception handling

 

 

Column

Unit *

Data entry:

Required field

Expected data:

Any text up to 100 characters.

Data condition:

Accepted Values as specified in the drop down menu

- "Liter"
- "Milliliter"
- "Microliter"
- "Kilogram"
- "Gram"
- "Milligram"
- "Microgram"
- "Unit"

Data context:

 

Exception handling

 

 

Column

Supplier *

Data entry:

Required field

Expected data:

Any text up to 50 characters

Data condition:

To ensure that products are grouped correctly on the same supplier, make sure that the naming of the supplier is uniform.

Data context:

 

Exception handling

 

 

Column

Price *

Data entry:

Required field

Expected data:

Any text up to 180 characters

Data condition:

Use . to separate decimal numbers

Data context:

 

Exception handling

 



Column

Currency *

Data entry:

Required field

Expected data:

Numeric value  

Data condition:

Choose USD or EUR in the drop down

Data context:

 

Exception handling

 

 

Column

Barcode

Data entry:

Optional field

Expected data:

Numeric value  

Data condition:

 

Data context:

 

Exception handling

 

 

Column

Other Details 

Data entry:

Optional field

Expected data:

Any text up to 500 characters 

Data condition:

 

Data context:

Data in this column will be imported to the system as Other Information

Exception handling

  

 

To Import the Product Catalog, Click Import Catalog in step 2 and select the completed Import Template. After selecting the file, confirm that the correct group in which the products in the catalogue should be imported is selected, and click Import.

NewItem2075.png

All products are imported into the eLabNext Product Catalog of the corresponding group and can now be used. Make sure to check if the import has been executed correctly. In case of errors in the import, the Catalog Import Rollback option can be used, that allows the rollback of any import done in the last 7 days.

In the Catalog rollback page select the organization and the group in which the import has been executed and click Rollback to reverse the import.

NewItem2076.png

Note: Imports done longer than 7 days ago cannot be undone and must be removed manually

Related articles