How to Edit Item List

How to Edit Item List

Log into the cloud console and navigate to the "view items list" tab.

First Export the items via the grid interface.

 

Open the file in excel –

 

Remove  - Columns : id_item_master, uuid_accounts_fk, date_updated , date_created

Move – Last scanned column to after last scanned by.

 

Select tag ID column and format it to number field with the formatting options in excel to number with no decimal points and the correct number of leading zeroes as excel removes the leading zeroes that some tags include.

 


You can then update the item descriptions as needed.

 

Once completed you can save as a tab delimited text file and drag and drop into the grid. The import is set as update append so it would be updating based on the tag-id number.


    • Related Articles

    • How to Bulk Update Rental Class Numbers in Item List

      Once you have updated the seed data and turned on the integration that will always stay in sync going forward. (ALERT ONLY) Next step would be to update the item data from the 4 digit code to the 8 digit fixed asset class number. To do this, have an ...

    • Seed Data List - Tents

      Here are some best practices for creating your Seed data list. Use this opportunity to fix all the things you wish you had done differently when you created your inventory list in your existing rental software. For example: 20x20 Pole Tent ...

    • Do item names have to match seed data names?

      They do not. You can change an item name on a specific item. However, be aware that changing the name will only change the name of that specific tag and will then create a separate item name under that same rental class.

    • Can you upload from Excel and add to the current Seed Data list?

      Yes! You can upload from one item to a million items from an excel spreadsheet and add into your seed data and it will simply add those items to the items that are already in your database. 

    • Can you pick a specific item and assign it to a contract and then go pick it?

      When you assign an item to "On Rent", the system will set that specific item to that contract # and name. You can later use the "Touch Scan" to check the items that you picked without changing the status.