What product is this article for?
GDSN Connect
Items in the Item Database are uploaded using the Vendor Item Upload tool or added manually throughout the year by searching GDSN Connect from the Item Database or from the Vendors Module. The GDSN Connect database houses thousands of items with all attributes associated with those items and allows menu planners to easily locate and add items to their Item Database capturing all of that data without further data entry. This article describes how to manually search for and add items to the local Item Database from the Item Database. For instructions on how to use the Vendor Item Upload tool, click here. For instructions on how to manually search for add items to the Item Database from the Vendors Module, clickhere.
- Login to GDSN Connect and click on the Item Database from the left side navigation panel
- Click the blue plus sign button on the bottom right hand side of your screen and select the [Search GDSN Connect] button
- Enter an item name, key word, GTIN, or manufacturer code for the item you're looking to add to your Item Database into the search bar and click the search icon or press [Enter]
- Note that entering the GTIN into the search bar is the recommended data point as it will search and return exact product results. All other data points entered may return several results which will need to be sorted through to find the exact product needed
- Note that entering the GTIN into the search bar is the recommended data point as it will search and return exact product results. All other data points entered may return several results which will need to be sorted through to find the exact product needed
- Scroll down the list of returned results and click on the item name when the desired product is located
- Note that the returned results will include items from all linked databases of items. If you'd like to search in specific databases (for example GDSN or Generic), you can use the Source filter to narrow down the results. Once searched, You can discern which database an item is pulled from by looking at the Source column
- Note that items returned highlighted in yellow are sponsored searches that always appear at the top of the list if a key word is entered
- Review the item data on the Item Info tab. Add data to any open field or edit any information for the item that you'd like stored with it.
- Item Info is separated into three categories - District Info, Product Info, and Additional Info. District Info is always editable, Product Info is editable only when not provided by the manufacturer, and Additional Info is never editable with the exception of the product image. An explanation of each data field is below:
- Menu Item Name - The Menu Item Name is the name of the item as you would like it to appear on a Base Menu, the Menu Calendar, or in Choosi on an online menu
- District Code - Enter an internal number for this item if the district utilizes a different numbering system for items than the vendor ID #
- Ingredient Only flag - Enable this flag if the item is only used as an ingredient in a recipe. When enabled, this item will only be searchable from the Recipes Module
- GDSN Connect Item Name - This is the item name as provided by the manufacturer of a product
- Brand Name - When applicable, this is the brand name of an item
- Manufacturer - When applicable, this is the brand name of an item
- Manufacturer Product ID - When applicable, this is the manufacturers identification number for this item
- GTIN - 14 digit unique identification code for this item (note that generic items by definition are not specific unique items and will not have a GTIN)
- GPC Classification - This is the global classification of a product and used for determining procurement categories in GDSN Connect for the purposes of Inventory, Ordering, and Forecasting
- Product Image - Usually provided by the manufacturer but this image can be overwritten if desired
- Ingredients - When provided by the manufacturer, a list of all ingredients in a product
- Country of Origin - When provided by the manufacturer, used for documentation purposes for Buy American provisions
- Item Info is separated into three categories - District Info, Product Info, and Additional Info. District Info is always editable, Product Info is editable only when not provided by the manufacturer, and Additional Info is never editable with the exception of the product image. An explanation of each data field is below:
- Review the item data on the Nutrients & Meal Components tab. Add data to any open field or edit any information for the item that you'd like stored with it.
- The Nutrients & Meal Components tab is separated into five categories - Serving Size, Meal Components, Documentation, Nutritional Information, and Allergens. Any data provided by the manufacturer on this tab will be read only and data not provided will be editable for users to enter data into. The exception is the Meal Components category where users can adjust the manufacturer provided information if necessary. An explanation of each category is below:
- Serving Size - Serving size is required data and without a weight and/or measure, GDSN Connect will not allow this item to be added to the Item Database. Users can fill in any data not provided in editable fields
- Meal Components - Many items in GDSN Connect have meal components as associated attributes but some do not. Careful review of this category is necessary to ensure the most accurate data is stored with the item
- Documentation - If a CN Label exists for this product, users can enable the CN Label flag, enter a CN Label #, CN Expiration Date, and can upload an image (such as a CN Label or Product Formulation Statement) to be stored with this item
- Nutritional Information - Only Calories, Saturated Fat, and Sodium are required data and without that data, GDSN Connect will not allow this item to be added to the Item Database. Users can fill in any data not provided in editable fields
- Allergens - Allergens declared by the manufacturer will display here. Once an item is added to the Item Database, it is possible for users to change the Allergen information in case this is provided incorrectly in GDSN Connect by the manufacturer. Careful review of this category is necessary to ensure the most accurate data is stored with the item
- The Nutrients & Meal Components tab is separated into five categories - Serving Size, Meal Components, Documentation, Nutritional Information, and Allergens. Any data provided by the manufacturer on this tab will be read only and data not provided will be editable for users to enter data into. The exception is the Meal Components category where users can adjust the manufacturer provided information if necessary. An explanation of each category is below:
- Once all desired data has been entered into any open field available for this item, click the [Add] button on the top right hand side of the screen to add this item to the local Item Database
At this point, the item has been added to the Item Database but it has not yet been assigned any Purchase Options. This means the item is not associated with any Vendor, does not have a price, Vendor Order number, or any other purchasing information. It is optional but recommended to complete the process below for each item manually added to the Item Database using GDSN Connect.
- From the Item Database, enter the Menu Item Name of the product into the search bar and click on the name of the item when located
- Click over to the Purchase Options tab and click anywhere on the purchase option record
- Under the Vendor header, click the drop-down button and select the appropriate Vendor from the list (note that the Vendor must have been previously setup in the Vendors module for it to display on this list)
- Enter any editable field on this General Info tab. A description of each field is below:
- Item Name - This field is used for inventory purposes and should reflect how staff know to identify this item for inventory management purposes
- Vendor Item Name - The name of the item as provided by your Vendor and how you refer to this item when purchasing it from your Vendor
- Pack Size - The number of inventory units in and type of inventory units in a purchase unit and sometimes the weight of a single serving
- Nominal Net Weight - The weight of a case based on the serving size and number of servings per case
- Purchase Unit GTIN - 14 digit code which represents the identification number for a purchase unit
- Vendor Product ID - The number of the item as provided by your Vendor and what you provide to your Vendor when purchasing this item
- Procurement Category - The category this item belongs to based on it's GPC code
- District ID - An internal number used for this item when applicable
- Purchase Unit ID - This is a system defined value for the Purchase Unit, and is uneditable by the user
- USDA Commodities flag - Enabled when the item is a USDA Commodity item
- Click the [Save] button to save any changes made. Note: you must save the Vendor to this item prior to being able to add a Price
- Click the [+ Add Price] button to open the Add Price flyout. Locate a contract (if applicable) from the drop down menu, enter an effective date for this pricing, enter the price, and click the [Save&Close] button
- Click over to the Inventory Setup tab and ensure all data appears as expected for how this item is purchased and stored in inventory. Note that this data comes via the manufacturer for most products but careful review is required to ensure accuracy. Generic items will all be setup per pound and may need further manipulation to ensure the item is setup correctly according to how you purchase it
- When all values are reviewed and confirmed, click the Confirm Values flag
- Select the drop down button on the [Save] button and select the Save & Close option. Click the [Save & Close] button
- You'll be returned to the Purchase Options detail page. Select the drop down button on the [Save] button and select the Save & Close option. Click the [Save & Close] button
- Note that if you purchase this item for multiple Vendors, you can complete steps 1-10 and assign this item to as many Vendors as you order it from by clicking the blue plus sign button and selecting the [Select Template] button. This will pre-fill most purchasing information for this item and allow you to enter a different Vendor, Vendor Product ID, and price
- Note that if you purchase this item for multiple Vendors, you can complete steps 1-10 and assign this item to as many Vendors as you order it from by clicking the blue plus sign button and selecting the [Select Template] button. This will pre-fill most purchasing information for this item and allow you to enter a different Vendor, Vendor Product ID, and price