Stratosphere
Premium Features
Product Catalog Additional Fields
11min
with the product catalog additional fields feature enabled in stratosphere, you can add additional context to your product catalog and reports with the new product category and product system fields specifically, when the product catalog additional fields feature is enabled, the following things will occur in your stratosphere organization products in the product catalog will have 2 additional fields, product category and product system, available when adding and editing products for existing products, the new fields will be null, but they can be edited the product catalog csv import functionality will also support adding new products with these new fields popluated product category and product system will appear as columns for the following pages products docid\ zgmg3kja8xguix6lssiiy items docid\ efi2n49gjycru tk5huqm reports docid 69h9muymh5tc3nwucxnde reports docid 69h9muymh5tc3nwucxnde par levels report (if the par levels docid\ uxwsjsf3ypur gs0fxwco feature is enabled for your organization) slow moving inventory report (if the slow moving inventory docid\ j3iltpr4zh6wbpxcofvem feature is enabled for your organization) reports docid 69h9muymh5tc3nwucxnde viewing and editing product catalog additional fields viewing and editing the product catalog with additional fields requires your organization to enable the product catalog additional fields feature see product catalog additional fields docid\ qoufnsd9 ig 8c68uyiip below for more information viewing and editing the product catalog with additional fields requires the "product management" role to be granted in your users docid\ oe8vd 0cdzxszxeukg19h record contact your system administrator to add this capability products are viewed and managed on the product catalog page available from the side menu if the kanban inventory management docid\ psukbrphk3mq53lotqyn3 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 additional fields product system and product category for your organization's rfid products to view or edit a product's details, including the product system and product category, 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 product system a free text field to add further context to the product product category a free text field to add further context to the product items in stock the number of items of this product that are currently being reported by stratosphere devices = required adding product with product catalog additional fields adding products with product category additional fields requires your organization to enable the product catalog additional fields feature see product catalog additional fields docid\ qoufnsd9 ig 8c68uyiip below for more information adding products requires the "product management" role to be granted in your users docid\ oe8vd 0cdzxszxeukg19h record contact your system administrator to add this capability there two methods to add products with product catalog additional fields manual entry and bulk import manual entry select "add product" in the top left of the product catalog page enter a product name enter a product # optionally, enter a product system or product category for the product click save changes to finish adding the product bulk import 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 #", "product system", and "product category" exactly, which will be imported as product name, product #, product system, and product category respectively additional columns may exist but will be ignored during import note if stratosphere inventory pricing docid\ rirjzdfsc3wu8ugn9xivy 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 #, product system, and product category 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 enabling product catalog additional fields enabling product catalog additional fields requires the "organization management" role to be granted in your users docid\ oe8vd 0cdzxszxeukg19h record contact your system administrator to add this capability to enable product catalog additional fields go to the organization page toggle the "product catalog additional fields" feature on press "save changes" disabling product catalog additional fields disabling product catalog additional fields requires the "organization management" role to be granted in your users docid\ oe8vd 0cdzxszxeukg19h record contact your system administrator to add this capability to disable product catalog additional fields go to the organization page select the "add/remove features" tab toggle the "product category additional fields" feature off press "save changes" confirm your intention to disable by pressing "save changes" in the resulting popup when product catalog additional fields is disabled, all data stored in the product category and product system fields for your product records will be cleared this cannot be reversed