Excel import – Modifying variant and batch references

The functionality Excel Import – Modify variant and batch part numbersThe Excel Import – Modify Variant and Batch part numbers feature of the K inventory online inventory management application makes it easy to modify product variants, batches and declinations via an Excel file.

This feature simplifies the updating of your variants and batches in the K inventory database, avoiding tedious manual modifications.

 

This feature is not available on the Mobile version.

1. In the left-hand screen frame, click on Import data.

 

Importing data from Excel onto an inventory management platform: K inventoryK inventory features

 

2. Go to Import dataclick on Update variants and batches.

 

Update part numbers from Excel on the K inventory management applicationChoice of data import mode

 

3. To download the file template, click on the K inventory file template.

 

The template file is automatically updated when a custom field is created, modified or deleted.

 

4. To modify variants and lots in the K inventory database, complete the fields to be modified.

Modified fields are highlighted in red.
To change the location of a product, enter the parent and target folders.

Variant and batch modification import file format

 

5. Save the Excel file.

 

6. Drag file into frame Drag the file to be imported or click here or click on the add a file icon to select the file.

 

7. Once the file has been integrated, the Data validation tab indicates whether errors have been detected or whether all lines can be inserted.

 

8. Confirm the import of the file into the database by clicking on Save.

 

Audit result

 

9. In the Resulttab, you’ll see confirmation that the import was successful.

 

Modify part numbers in Excel with K inventory, the inventory management software

Confirmation of reference modification

 

10. To check reference changes, click on Folders in the left-hand frame, then go to the folder where the new references have been modified.

 

Import - Creating variant and batch referencesDisplay modified references

 

To continue browsing, here are a few articles related to this page: