INTERNAL CATALOG SPREADSHEET INCONTINENCE CARE PRODUCTS.xlsx

XLSX spreadsheet 27 KB Posted

Attached to
1130-26-R-NBID-00005
Solicitation number
3130002231
Issued by
Mississippi

About this file

This is an internal catalog spreadsheet template for incontinence care products submitted as part of a state and local contract opportunity. The document provides detailed instructions for suppliers to populate product information across multiple required and optional fields, including supplier name and ID, part numbers, product descriptions, pricing, delivery times, and manufacturer details. All products being offered on contract must be listed individually on the spreadsheet, though accessories and options may be submitted as separate attachments. The template specifies that products must be classified using NIGP 5-digit codes, with three primary categories available for incontinence-related items: clothing and hospital wear (code 20032), hospital accessories and paper goods (code 47564), and skin care products (code 65229). Suppliers must provide contract pricing and MSRP for each line item in USD and include delivery timeframes, unit of measure designations, manufacturer information, and hyperlinks to product images or websites.

The spreadsheet requires suppliers to complete mandatory fields including short and long descriptions, special search terms for product identification, base quantity and unit of measure information, and product category classification. The template includes comprehensive guidance on acceptable units of measure ranging from individual units (EA) to bulk quantities (pallets, cases, drums), and specifies that all data must follow standardized formatting conventions. The document emphasizes that product listings should be clearly organized with appropriate categorization to facilitate catalog management and procurement operations under the contract framework.

View the file

Other files

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Instructions

SortFieldUsageRequired/
OptionalField TypeExplanation/ ValuesExamples
1SupplierSupplier NameRequiredCHAR(50)Name of CompanyABC Medical Supplies
2Supplier IDSupplier IDRequiredCHAR(10)See Proposal, Format & Guidelines3000000121
3Supplier Part NumberSupplier Part NumberRequiredCHAR(50)Supplier Part Number9H.J6D77.13A
4Short DescriptionShort DescriptionRequiredCHAR(40)Short Description; Rephrase: noun, MFG, MPNAdult Diaper
5Long DescriptionLong DescriptionRequiredCHAR(2000)Full long description; Include any special information such as special packagingAdult Diaper, small size, elastic band, superabsorbency, 100 case ; 25 in a case
6Product GroupNIGP 5 digit codeRequiredCHAR(10)5 Digit NIGP Classification code; Must use from list provided in NIGP Choices Tab47564
8PriceDiscounted PriceRequiredRealAmount with 2 decimal places30.15
9MSRPMSRP PriceRequiredRealMSRP Amount with 2 decimal places63.25
15Special Search TermsSearch terms, tagsRequiredCHAR(100)Searchable term to identify your itemsdiaper, adult, incontinence
16Delivery In DaysDelivery daysRequiredInteger3
17UOMUnit of MeasureRequiredCHAR(3)Base unit of measure (refer to tab UOM)EA
18Price Base Qty UoMOrder UnitRequiredCHAR(3)Same as Base unit of measureEA
19ImageImageOptional
23Hyperlink URLHyperlink URLRequiredValue = Manufacturer websitewww.abcmedicalsupplies.com
25ManufacturerManufacturer NameRequiredName of the ManufacturerDiapers R US
26Manufacturer PNManufacturer Part NumberRequiredManufacturer Part NumberPG259
NOTESThe above spreadsheet is an example of how Sheet 1 should look once completed.
Populate Tab "Sheet1" with your data.
Do NOT change the name of the Tabs - other than Sheet 1 to reflect the Manufacturer Name.
See Examples column for ideas
Hyperlink - the preferred method is to send us the link to your website where the image can be viewed.
Use the NIGP choices tab to populate the Product Group Column in Sheet 1.
Use the UOM Tab to populate the UOM column in Sheet 1.
Please note: All products being offered on contract must be listed individually on Sheet 1. For those suppliers that are offering a long list of "options/accessories" for a product, you do
not have to list them individually on the spreadsheet. You may attach them separately to the Proposal as an individual document(s) and then name appropriately.
Example: If you are selling "adult diapers," the adult diapers should be listed on Sheet 1 as a line item. All accessories for adult diapers could then be attached and named: "Accessories
for adult diapers".

http://www.abcmedicalsupplies.com/ Sheet1

SupplierSupplier IDSupplier Part NumberShort DescriptionLong DescriptionProduct GroupService ItemContract PriceMSRPPrice Base QtyCurrencyContract NumberContract Item IDSAP Contract Item CategorySpecial Search TermsDelivery In DaysUOMPrice Base Qty UOMImageItem StatusHyperlink TypeHyperlink MIME TypeHyperlink URLHyperlink URL DescriptionManufacturerManufacturer PNSupplier Catalog NameCategory
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
FALSE1USDProduct CategoryOPTFMIncontinence Care Products
1USDProduct CategoryOPTFMIncontinence Care Products

NIGP Choices Please select the code that most correctly identifies the item you are submitting to be on the contract

Product CategoryDescription
20032Clothing, Hospital Wear, Patient: incontinence briefs, incontinence pads, dispoable underpads
47564Hospital Access., Paper Goods: diapers and wipes
65229Skin Care: protectants, creams, moisturizers

UOM

Unit of MeasureDescription
DDays
BAGBag
BDLBundle
BFTBoard Foot
BTBottle
BOXBOX
CHundred
COICoil
CSCase
CTGCartridge
CTRContainer
CYLCylinder
DRDrum
DZDozen
EAeach
FTFoot
FT2Square foot
FT3Cubic foot
GALUS gallon
HHour
HAHectare
INInch
IN2Square inch
"3Cubic inch
JARJar
YRYears
JOBJob
CANCanister
CARCarton
KEGKeg
KGKilogram
CRTCrate
KITKit
LLiter
LBUS pound
AUActivity unit
LGTLength
LOTLot
MGMilligram
MONMonths
OZOunce
FOZFluid Ounce US
PAAPair
PADPad
PAIPail
PACPack
PALPallet
PTPint
QTQuart
RLReel
RMReam
ROLRoll
SETSet
SHTSheet
SPLSpool
PCPiece
HRHours
DAYDays
TSThousands
TOTonne
TONUS ton
TUTube
VIAVial
WKWeeks
YDYards
YD2Square Yard
YD3Cubic yard

File details come from the government source that posted it. Updated .