Stratosphere Inventory Pricing
The Stratosphere Inventory Pricing feature is a premium feature that allows you to add unit prices to your RFID Product Catalog, report on inventory pricing, and receive removal receipt email notifications when items associated with priced products are removed from inventory.
When the Inventory Pricing feature is enabled, the following will occur in your Stratosphere organization:
- The Product Catalog will include Unit Price and Total Price columns, where total price is the number of items in stock for that product multiplied by the unit price.
- The Transaction Report will include a Price column in the transaction detail rows. This column will report the unit price for the item at the time of the transaction.
- The Inventory Summary Report will include an Inventory Value column for header rows. This column displays the monetary value of in stock inventory for that product based on the unit price and in stock quantity. This report also includes a Device Inventory Value column on details rows. This column displays the monetary value of in stock inventory in the specified device for that product based on the unit price and in stock quantity.
- An optional setting to enable Removal Receipt Email Notifications will be available. By default, this setting sends a removal receipt confirmation email to the user who removed the item(s). Your organization can also configure a list of up to 10 additional email addresses to receive all removal receipt emails. Terso recommends utilizing distribution lists where possible to reduce the need for updates on this setting. Only items associated with products that have a unit price will be included in removal receipt email notification.
Use of Inventory Pricing requires your organization to subscribe to the feature. If you would like to learn more, please contact us.
Viewing and editing Inventory Pricing requires your organization to subscribe to the feature. If you would like to learn more, please contact us.
Viewing and editing Inventory Pricing requires the "Product Management" role to be granted in your user record. Contact your system administrator to add this capability.
Inventory pricing is viewed and managed on the Product Catalog page available from the side menu.
If the Kanban Inventory Management feature is enabled, the Product Catalog can be viewed and managed by selecting Products > RFID Product Catalog from the side menu.
The Product Catalog displays the Unit Price and Total Price for your organization's RFID products, where Unit Price is the price of one unit of that product and Total Price is the number of items in stock for that product multiplied by the Unit Price.
To view or edit a product's details, including the product's unit price, click the name of the product. The details page displays all the available information for that product, including:
- Product Name* - An easily recognizable description of the product. This field is editable.
- Product #* - The unique product code or number used to identify the product, usually present in the product’s barcode. Your organization may refer to it as a GTIN, part number, catalog code, or material code. This field is editable.
- Unit Price - The price in USD of one unit of the product. The field supports numeric values up to $9999999999.99 and supports up to 2 decimal places. This field is editable.
- Items in Stock - The number of items of this product that are currently being reported by Stratosphere devices.
* = Required
Adding Products with Inventory Pricing requires your organization to subscribe to the feature. If you would like to learn more, please contact us.
Adding products requires the "Product Management" role to be granted in your userrecord. Contact your system administrator to add this capability.
There two methods to add products with inventory pricing: manual entry and bulk import.
- Select "Add Product" in the top left of the Product Catalog page.
- Enter a Product Name.
- Enter a Product #.
- Optionally, enter a Unit Price for the product.
- Click Save Changes to finish adding the product.
There is no way to undo a bulk import, other than to edit or remove products from the Catalog individually. When bulk importing, take every opportunity to verify the accuracy of the import. Double-check to ensure that the data in the uploaded file is accurate. After importing the file, but before saving the imported records, open the "ready to Import" section and verify that the columns are mapped appropriately and the data is exactly as you want it.
Many GTIN (Global Trade Identification Numbers) that should imported in the Product # column as the Product # contain leading zeros. Many spreadsheet programs, including Excel, will remove these leading zeros by default. To prevent this, convert the Product # column to a number format of Text, and the leading zeros will be preserved for accurate import from CSV.
- Select "Import Catalog" at the top of the Product Catalog page.
- "Choose File" and select a file containing the products you want to import. The file must meet the following requirements:
- .CSV file format
- less than 1 MB file size
- Contain columns titled "Product Name", "Product #", and "Unit Price" exactly, which will be imported as Product Name, Product #, and Unit Price respectively. Additional columns may exist but will be ignored during import.
- Note: If Product Catalog Additional Fields is enabled for your organization, the file must include the following columns: "Product Name", "Product #", "Product System", "Product Category", and "Unit Price" exactly, which will be imported as Product Name, Product #, Product System, Product Category, and Unit Price respectively. Additional columns may exist but will be ignored during import.
- Once a file is chosen, select "Import Product Catalog"
- Before saving the import, validate that the import was completed as expected by reviewing the three lists:
- Ready to Import - These products were successfully read from the file. Verify that the Product Name, Product #, and Unit Price are displaying as expected.
- Already in Catalog - These products were successfully read from the file, but already exist in your Product Catalog and will be skipped in the import to avoid duplication.
- Errors - These products were not successfully read from the file. It could be due to in invalid character, excessive length, blank fields, or an unknown reason. Where possible, the reason for the error will be explained in this list.
- If you are happy with your import preview, click "Import Products" one last time to save all the Ready to Import products into your product catalog. Any errors can be handled individually and uploaded in a subsequent bulk import.
You can review the last 10 product imports, including the list of Already in Catalog Products and Errors, by clicking "Import Catalog" from the top of the Product Catalog page at any time.
Viewing Inventory Pricing in the Inventory Summary Report requires your organization to subscribe to the feature. If you would like to learn more, please contact us.
When Inventory Pricing is enabled, the Inventory Summary Report includes an Inventory Value column for header rows. This column displays the monetary value of in stock inventory in the specified location for that product based on the unit price and in stock quantity. This report also includes a Device Inventory Value column on details rows, displaying the monetary value of in stock inventory in that device for that product based on the unit price and in stock quantity.
Viewing Inventory Pricing in the Transaction Report requires your organization to subscribe to the feature. If you would like to learn more, please contact us.
When the Inventory Pricing feature is enabled, the Transaction Report includes a Price column in the transaction detail rows. This column will report the unit price for the item at the time of the transaction.
Enabling Inventory Pricing requires your organization to subscribe to the feature. If you would like to learn more, please contact us.
Enabling Inventory Pricing requires the "Organization Management" role to be granted in your user record. Contact your system administrator to add this capability.
To begin tracking inventory using the Inventory Pricing feature:
- Go to the organization page
- Select the "Add/Remove Features" tab
- Toggle the "Kanban Inventory Management" feature on
- Click "Save Changes"
Editing Removal Receipt Email Notifications alerts requires the "Organization Management" role to be granted in your user record. Contact your system administrator to add this capability.
The Inventory Pricing feature to enable email notifications when priced inventory is removed from Terso devices. To configure this setting:
- Go to the organization page
- Select the "Add/Remove Features" tab
- To enable the Removal Receipt Email Notifications functionality, toggle Removal Receipt Email Notifications on. When this is enabled, the user who performed the priced inventory removal will receive the removal receipt email.
- Add, edit, and remove email addresses as needed. With the Removal Receipt Email Notifications functionality, you can enter up to 10 email addresses to receive all removal receipt emails. It is recommended that you use distribution lists for Removal Receipt Email Notifications, so that updates are needed less frequently.
- Click "Save Changes"
Disabling Removal Receipt Email Notifications requires the "Organization Management" role to be granted in your user record. Contact your system administrator to add this capability.
- Go to the organization page
- Select the "Add/Remove Features" tab
- To disable the Removal Receipt Email Notifications functionality, toggle Removal Receipt Email Notifications off.
- Click "Save Changes"
Disabling Inventory Pricing requires the "Organization Management" role to be granted in your user record. Contact your system administrator to add this capability.
- Go to the organization page
- Select the "Add/Remove Features" tab
- Toggle the "Inventory Pricing" feature off.
- Click "Save Changes"
- Confirm your intention to disable by pressing "Save Changes" in the resulting popup