Note: As of v4.2.0, the inventory exports will include a “Tags” column and a “Created On”. |
We’ve created a few ways for you to extract your inventory data so you can manipulate it for further analysis. Before we dive in though there are a couple of distinctions to make:
First, what type of format do you want your data in?
Export your Inventory - Exporting your inventory will dump out your inventory data as you see it in the Inventory page of the Console. That means each device will be represented on its own line in Excel as a quantity of 1, with all of its associated data.
Stock Report - You also have the option of exporting a stock report which, instead, will dump out your inventory but it will sum up the inventory that has like characteristics. For instance, 15 pieces of loose inventory that have the same catalog number, lot number, and custodian will show as a quantity of 15 on one line in Excel. This can be a more helpful way of looking at your stock levels throughout your value chain.
Next, do you want active inventory only or do you also want to include deactivated inventory, or inventory that is only unused?
Unused inventory only: This represents devices with an Unused status only. Devices may be active or inactive. Devices that are still active but are marked as used in an open event are still considered Active, despite having a usage status. Selecting “Unused inventory only” will only give you items with a usage status of “Unused”.
All Inventory - this will export all inventory as you see it in the inventory list, including deactivated inventory (unless you check the “Active Inventory Only” checkbox.
Active Inventory Only - Select this checkbox if you want to see only your active inventory in your export.
Current Search Query Only - these options allow you to use the filters in the inventory screen to determine what data will be exported. Do you want expired inventory, active only, in a current user’s custody (or something else specific)? Then this is your option.
Note: You may now include Facility Stock in your inventory views and exports of current search queries by checking the “Include Facility Stock in view” box in your inventory search filters. This will allow you to view active inventory and facility stock together to get an idea of the usable inventory available in the field (as opposed to sellable inventory). |
To export your data follow these steps:
To export your inventory navigate to your Inventory screen in the console.
2. If you’d like to find any specific inventory then please enter search terms and filters and locate the data you’d like to export.
3. Click on the “export inventory’ button
4. You’ll then be presented with a set of options for the data you are exporting:
Unused inventory Only: This will export your unused inventory. Devices may be active and inactive (unless the “Active only” box is checked), but all will have the unused status meaning they have not been used in an Event.
All Inventory: This option will export all inventory including current active stock as well as all deactivated inventory. This will include inventory that has been manually deactivated and all single-use inventory that was removed from your stock as a result of an event.
Inventory in the current search query only: This option will export the data that has currently been returned to the screen as a result of your search/filter selections.
Stock export of inventory in the current search query only
Active Inventory Only Checkbox - As mentioned above, check this option to ensure your export only includes active inventory.
5. When the report has generated you will receive a notification bearing a link to download your file.
The content by label feature displays related articles automatically, based on labels you choose. To edit options for this feature, select the placeholder below and tap the pencil icon.