Skip to content
English
  • There are no suggestions because the search field is empty.

How to Edit Inventory Items

SciNote inventories capture information specific to your items, and sometimes, that data needs to be updated (manually or via item file import).

In this article we will cover how to edit and update inventory items. If you are looking to edit inventory columns, you'll want to check out this article here.

To edit an Inventory, you need to hold the permissions of Team Owner or User. If you are trying to edit an inventory that is owned by a different team and shared with your team, you'll want to make sure that the sharing team granted editing permissions. 


1. How to edit an inventory item from the Inventory page

Inventory tables work like a spreadsheet. Click any cell to edit it directly. Your change is saved automatically when you click outside the cell or press Enter, and it is recorded in the activity log.

  1. Open the inventory that contains the item.
  2. Click the cell you want to change. Each column type has its own editor:
    • Text: type directly in the cell. For longer text, click more to open the full editor, then click Save.
    • Number: type the value.
    • Dropdown, Status, Checklist: choose from the list in the cell.
    • Date, Date & Time, Date reminder: use the date picker. For range columns, set both the start and end.
    • Stock: click Set stock.
    • File: click the cell to add a file.
  3. Click outside the cell to save.

Editing many items at once: Selecting multiple items and editing them together is no longer available in the table. To update many items in one go, use bulk update via import (section 1b below).


1b. How to edit multiple inventory items at once via bulk import changes of item data:

Learn more about how to add new items via file import in this article.

  1. Click on the Import items button.
  2. A pop-up will provide more info and instruct you to choose a file.
    1. Use the Export all items button to exports a file (choose .XLSX or .CSV) with the current inventory items’ data.  

.CSV exports have the dates exported in the same format as the user has set for Date Format in their individual user preferences. 

This also means, that if importing to inventories from .CSV, the dates in the file MUST match the preferences format to import correctly. If they don't match, the dates won't import.

 

3. Make necessary changes to existing item data in the exported item import file so that it's ready for upload.

*When EDITING existing Items within a SciNote Inventory, you must keep the 'Item ID' data in the import file, or else SciNote will create new items. Remove the 'Item ID' only if you wish to create a new Item with a new 'Item ID'.

Make sure the first row of your import file includes the names of the columns from your SciNote Inventory!

Columns 'Added By', 'Created On', 'Updated on', 'Updated by', 'Archived by', and 'Archived on' are system-defined and system-generated.

You can leave these columns empty in your import file. They will be automatically updated in SciNote during the import process. 

  • You can click Import to select a file from your device, or simply drag and drop an import file into the blue box area

*Please note that a) File custom columns, b) Item Relationships (parent/child relationships), and c) columns with the "range" setting (date, date&time, or time columns with "range" enabled) cannot be imported into SciNote

 

4. Next you will map data to match the columns of your uploaded file to the columns in the SciNote inventory.

    • SciNote will automatically map the columns by matching column names from your imported file with the ones in your SciNote inventory. Review the mapped columns and click Confirm to continue with the import.

      • If you want, you can unselect the Auto-mapping function in the upper left and map the columns yourself manually instead

      • Matched columns that will are set to fully import are marked with a check mark symbol (✔️) and those that will not import are shown with an X (✖️) symbol in the Status column  

5. Review and verify the Import preview.

  • From this popup, you can do a final review of the imported data. This preview displays pending changes resulting from the imported file. At this stage, you can still cancel the import by clicking Back. 

    • The preview indicates in green which items are newly added (New ) or which will be Updated after clicking Import.  
    • Any detected errors are marked in red (e.g., items with the same or a nonexistent Item ID in the file, items with no Name, etc.). These items/rows will be automatically omitted, however you can still import the other data. 
      • Duplicated rows indicate your import file has two rows with the same Item ID
      • Invalid rows indicate that the listed Item ID doesn't exist in the SciNote Inventory
      • Duplicated or Invalid Import Rows
    • If you have some Unchanged and or Archived items in the file, they will be marked in black (the default color).  

6. Once you've reviewed the Import review, click Import to finalize the import changes to your inventory items and complete the item data edit via import.

IMPORTANT: Please note that when bulk updating items via import, the data in your import file will override the existing data in your SciNote inventory!

This action can’t be undone. We recommend exporting your current inventory data beforehand in case you need to revert any changes. 

*Please Note: if you wish to import a date into SciNote, the Excel (.XSLX) format should be DD-MMM-YYYY. All inventory .XLSX export files export dates in this format, and the import for .XLSX will work best with this date format.

This does not apply when importing .CSV files.


2. How to edit an inventory item outside of the Inventory page (directly from Tasks or other SciNote pages)

 

2a. An inventory item can be edited anywhere you can access the item's card:

  1. Assign the inventory item to a designated task or use a hashtag to call the inventory item within any rich text field.
  2. Navigate to the specified location, where you will now find the inventory item represented as a clickable link.
    1. Clicking Inventory Item
  3. Click on the name of the inventory item link.
  4. An inventory item card will open on the right-hand side of the screen. Use the navigation on the right of the card to jump between sections: Custom columns, Relationships, Assigned, Locations, Schedule and QR. 
  5. Position your cursor over the desired properties, prompting a transformation into a pencil icon. This enables you to effortlessly edit the respective field.
    1. Edit Invnetory Card
  6. The edits are automatically saved when you click out of the field.

Please exercise caution when making alterations to inventory task cards within SciNote, as modifications are universally applied and will reflect in the updated format across all locations.


To learn more about how to bulk edit your inventory items in SciNote, check out our video below. 

____________________________________________________________________________________  

If you have any additional questions, contact us at support@scinote.net . For more information about the Premium plans, please request a quote.