Inventory items can be added to a Logbook individually or in batches.

Inventory items that are typically added individually are for Logbooks like Lost & Found, Packages, and Rentals, for example.

To upload inventory items in bulk, an Inventory Loader is available. The Inventory Loader also allows for edits and updates to inventory items to be made quickly and easily. This feature is primarily used to upload an equipment asset Logbook for Preventative Maintenance.

(blue star) User Type & Roles

To perform this action in ALICE, the user must have at least Employee User Type access.

The user must also have the following settings within “Roles” enabled”

Consider also granting access to “View”, “Edit”, “Close” and/or “Assign” Tickets depending on the tasks each user will be responsible for performing.
Users with “View” access will also receive notifications for unassigned tickets.

(lightbulb) Things to Consider

Jump to “Individually Add Inventory Items to Logbook

Jump to “Batch Add Inventory Items to Logbook

Jump to “Add Inventory Items using the Inventory Loader

Individually Add Inventory Items to Logbook

(blue star) Steps

  1. Select the “Logbooks” tab.

  2. Select a Logbook from the icon column on the left side of the screen.

  3. Select “Add” to begin adding Inventory Items to the Logbook.  

  4. Use the form to add information about the Inventory Item. Required fields are noted with a red asterisk.

    1. Select a “Type” from the dropdown.

    2. Name the Inventory Item with a unique identifier. Each name must be unique. Consider using numbers/locations to differentiate like-items. For example “HVAC - Fitness Room” or “Air Handler Unit 1

  5. Additional custom fields can be added by Hotel Admins to provide greater details about the Inventory Item. Examples of custom fields are circled in the screenshot below. 

  6. Select “Save” to add the Inventory Item.

Batch Add Inventory Items to Logbook

(blue star) Steps

  1. Select the “Logbooks” tab.

  2. Select a Logbook from the icon column on the left side of the screen.

  3. Select “Add” to begin adding Inventory Items to the Logbook.  

  4. If “Batch Add” is enabled, fields to add Inventory Items will be arranged in a grid view, providing the ability to add multiple Inventory Items at one time.

Add Inventory Items using the Inventory Loader

  1. Select the “Logbooks” tab.

  2. Select a Logbook from the icon column on the left side of the screen.

  3. Select “Add” to begin adding Inventory Items to the Logbook.  

  4. If “Inventory Loader” is enabled, an option to toggle to “Multiple” will appear. Select “Multiple”.

  5. Leave the “Type” dropdown as “All Types” or select the Inventory Type being uploaded from the dropdown.

  6. Select “Download Blank Sheet” to initiate a download of the excel template used to enter Inventory Item data.

  7. Open the downloaded excel file and add Inventory Item data. Required fields are noted with an asterisk.

  8. Save the file and return to ALICE and the Logbook tab.

  9. Select “Add”, then “Multiple” to return to the Inventory Loader.

  10. Select “Upload Sheet” then select the saved file to initiate the upload.

Edit Existing Inventory Items

  1. Select the “Logbooks” tab.

  2. Select a Logbook from the icon column on the left side of the screen.

  3. Select “Add” to begin adding Inventory Items to the Logbook.  

  4. Select “Multiple”.

  5. Select the “Type” of Inventory Items you are editing from the dropdown. If you are not editing one specific “Type”, select “All Types”

  6. Select “Download the Current Sheet” to initiate a download of an Excel template with the existing data pre-loaded.

  7. Open the file and make any necessary changes. DO NOT make any changes to the ALICE InventoryID. This column should remain unmodified as it is the unique identifier for the Inventory Items in ALICE.

  8. Save the file and return to ALICE and the Logbook tab.

  9. Select “Add”, then “Multiple” to return to the Inventory Loader.

  10. Select “Upload Sheet” then select the saved file to initiate the upload.

Inventory Item Loader Template

The following information outlines the default columns on the Inventory Loader Template. Note that additional columns may be present, reflecting property-specific configurations. If you have questions about what information should be added to additional columns not listed here, contact a Hotel Admin on property.

ALICE Inventory ID (Do not modify): Leave this column blank. ALICE will automatically generate a unique identifier for new Inventory Items. When editing Inventory Items, do not alter the information in this column.

Name: Name the Inventory Item. Each Inventory Item must have a unique name. Consider additional prefixes, codes, numbers, or letters as necessary.

Room# or Location: Select a cell in this column to access a dropdown list of available locations in the account. If a location is missing, contact a Hotel Admin on property to add the new location via ALICE Admin. If a room number or location is added that is not already available in ALICE, the cell will highlight red.

Workflow Status: Select a cell in this column to access a dropdown list of available workflow statuses. Select the workflow status appropriate to the Inventory Item. (Ex: Open/Active) If a workflow status is added that is not already available in ALICE, the cell will highlight red.

Troubleshooting the Inventory Loader

If there are issues uploading the file, an error message will appear.

Resolving Errors

  1. Download the file using the “Download here” link within the error message.

  2. Errors will be highlighted on the template to make them easy to find.

  3. Correct the highlighted cells. Common errors include missing information and/or duplicated names.

  4. Save the file and return to ALICE and the Logbook tab.

  5. Select “Add”, then “Multiple” to return to the Inventory Loader.

  6. Select “Upload Sheet” then select the saved file to initiate the upload.

(blue star) Related articles

The content by label feature automatically displays related articles based on labels you choose. To edit options for this feature, select the placeholder and tap the pencil icon.