Excel import – Modifying equipment references

Functionality Excel Import – Modify equipment part numbersThe Excel Import – Modify Equipment part numbers feature of the K inventory online inventory management application makes it easy to modify equipment via an Excel file.

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

 

This feature is only available on the Web version.

 

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

 

Import part numbers into K inventory softwareK inventory features

 

2. Go to Import dataclick on Equipment update

 

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 template file

 

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

 

4. To modify equipment in the K inventory database, complete the following fields

 

Modify stock items on K inventory, online stock management softwareProduct modification import file format

 

Modified fields are highlighted in red.

 

5. Save the Excel file

 

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

 

7. Once the file has been integrated, the Data validation 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

 

Modify part numbers from Excel on the K inventory platformAudit 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 that the references have been modified, click on in the left-hand frame, then go to the folder where the new references have been modified.

 

Updating part numbers on K inventory softwareDisplay modified references

 

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