Catalogs
Catalogs files containing a suppliers products can be loaded into many eProcurement systems to allow employees to shop from the catalog from within the eProcurement system.
File Formats
- CSV
- CIF (Catalog Interchange Format)
-
cXML Index
-
OCI 5 JSON
-
BMEcat
-
EDIFACT PRICAT
-
EDI X12 832 Price/Sales Catalog
Transmission Methods
-
Email
-
HTTP(S)
-
FTP / FTPS / SFTP
Considerations
-
Product images - image URL’s are most commonly used but an archive of image files may be utilized
-
Configurable products (ex. a t-shirt available in multiple sizes/colors)
-
Parametric attributes - custom attributes (ex. color, length)
-
Tiered pricing - unit prices that decrease as the quantity ordered increases
Common Fields
Supplier Part Number
The supplier’s unique identifier for a product. May be referred to as the supplier part number, supplier item id, or SKU.
Image URL
A URL for a publicly accessible image that can be displayed with the product information. The image file should be in JPEG or PNG format for compatibility with common web browsers.
Lead Time
Time from receipt of order to shipment of product. Typically measured by number of days.
Manufacturer
The name of the manufacturer of the product. Used to filter search results in some eProcurement systems.
Manufacturer Part Number
Part number used by the manufacturer to uniquely identify the item. This field may be used to help shoppers find items by part numbers. For suppliers, populating this field may increase the visibility of your products in search results.
Min/Max Order Quantity
Minimum and maximum order quantities set limits on the quantity a user can order.
Order in Multiples Of / Order Interval
The incremental ordering quantity of the UOM (eg. a value of 5 would require the user to order 5, 10, 15, etc of the UOM).
Unit of Measure (UOM)
The Unit of Measure (UOM) is the marketed units by which an item will be delivered when purchased and to which the unit price refers. Unit prices should be in reference to 1 UOM. Some e-procurement systems require the code to be one of a pre-defined list of UOM’s. Common standards for Units of Measure inclue ANSI and UNUOM.
UOM Quantity / Pack Quantity
The number of units included in the UOM. (eg. a UOM of BX and a UOM Quantity of 100 indicates 100 units per box)
UNSPSC
UNSPSC is an open classification system for products and services. UNSPSC codes are 8 numeric digits that correspond to a commodity such as Pencils or Air Filters. The UNSPSC classification system is organized as a 4 level hierarchy of: Segment, Family, Class, and Commodity. Each level of the hierarchy represents 2 digits in the UNSPSC code. Products should be classified at the commodity level whenever possible. Buying organizations use UNSPSC codes to generate reports of spend by category. Some buying organizations may require this field to be present.