Template for building internal catalogs.
Please reach out to Vroozi Support for questions or details regarding line item contractual agreements.
-
- Item Number
-
- Column Name: #ItemNumber
- Required/Optional: Required
- Description Display Location: Vroozi Standard Catalog Fields
- Description: A sequential number indicating the item in the load file; used for reporting to identify the row number for any errors in the file.
-
- Vendor Product Number
-
- Column Name: NEW_ITEM-VENDORMAT
- Required/Optional: Required
- Description Display Location: Vroozi Standard Catalog Fields
- Description: The vendor product part number of the product
- smartOCI Type - Length: CHAR - 40
- Example: "AB211-21"
-
- Description
-
- Column Name: NEW_ITEM-DESCRIPTION
- Required/Optional: Required
- Description Display Location: Vroozi Standard Catalog Fields
- Description: The description of the item to be ordered
- smartOCI Type - Length: CHAR - 120
- Example: "T110 Laptop"
-
- Product Group
-
- Column Name: NEW_ITEM-MATGROUP
- Required/Optional: Required
- Description Display Location: Vroozi Standard Catalog Fields
- Description: The product category/material group code stored in the client's ERP or eProcurement system (i.e., UNSPSC code)
- smartOCI Type - Length: CHAR - 10
- Example: "32161002"
-
- Unit of Measure
-
- Column Name: NEW_ITEM-UNIT
- Required/Optional: Required
- Description Display Location: Vroozi Standard Catalog Fields
- Description: Unit of measure of the item. Please use standard ISO codes. If UOM is maintained differently in your ERP or eProcurement system, please notify Vroozi Support.
- smartOCI Type - Length: CHAR - 3
- Example: "EA"
-
- Material Price
-
- Column Name: NEW_ITEM-PRICE
- Required/Optional: Required
- Description Display Location: Vroozi Standard Catalog Fields
- Description: Price of the item in the catalog. There can be a maximum of 11 digits to the left of the decimal point, and 3 digits to the right. If the product has tiered pricing, please leave this field blank and enter the pricing in the ITEM-TIERED_PRICING field.
- smartOCI Type - Length: CHAR - 15
- Example: "349.95"
-
- Currency
-
- Column Name: NEW_ITEM-PRICE
- Required/Optional: Required
- Description Display Location: Vroozi Standard Catalog Fields
- Description: Must be the ISO code for the currency.
- smartOCI Type - Length: CHAR - 5
- Example: “USD”
-
- Unique Supplier ID
-
- Column Name: NEW_ITEM-VENDOR
- Required/Optional: Optional
- Description Display Location: Vroozi Standard Catalog Fields
- Description: If the product is purchased through a multi-supplier catalog, this field contains the business partner number in the ERP system. Please leave this field empty and define the Supplier ID during the catalog upload process in smartOCI if the load file contains only items from one supplier
- smartOCI Type - Length: CHAR - 64
-
- Price Unit
-
- Column Name: NEW_ITEM-PRICEUNIT
- Required/Optional: Optional
- Description Display Location: Vroozi Standard Catalog Fields
- Description: The number entered here will divide the price entered in 'NEW_ITEM-PRICE' to create a price in the ERP Shopping Cart that is 'per unit.' For example, if the item purchased is a 3 pack and you desire 'per unit' or 'EA' pricing, you would enter 3 in this field.
- smartOCI Type - Length: CHAR - 9
-
- Tiered Pricing
-
- Column Name: ITEM-TIERED_PRICING
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: Pricing configuration based on quantity or volume. If tiered pricing is entered, please do not enter any value in the NEW_ITEM-PRICE field. Note, the closing semicolon is required.
- smartOCI Type - Length: CHAR - 255
- Example: 49.99 [1-50]; 45.99 [51+];
-
- Lead time
-
- Column Name: NEW_ITEM-LEADTIME
- Required/Optional: Optional
- Description Display Location: Vroozi Standard Catalog Fields
- Description: Number of days from today until the product will be available. If not specified, no assumptions will be made about the lead time.
- smartOCI Type - Length: CHAR - 5
- Example: “1”
-
- Manufacturer's code
-
- Column Name: NEW_ITEM-MANUFACTCODE
- Required/Optional: Optional
- Description Display Location: Vroozi Standard Catalog Fields
- Description: The manufacturer's code in the buyer system
- smartOCI Type - Length: CHAR - 10
-
- Manufacturer's product number
-
- Column Name: NEW_ITEM-MANUFACTMAT
- Required/Optional: Optional
- Description Display Location: Vroozi Standard Catalog Fields
- Description: The manufacturer's product part number
- smartOCI Type - Length: CHAR - 40
- Example: "S011245"
-
- Description
-
- Column Name: NEW_ITEM-LONGTEXT
- Required/Optional: Optional - Preferred to Receive
- Description Display Location: Vroozi Standard Catalog Fields
- Description: This is the long description of the item. There is no restriction of characters here. This allows for a much more robust description of the item, where the 'NEW_ITEM-DESCRIPTION' is more associated with the 'title' of the product. This field will also help enable the shoppers to find your product more easily. This field allows for HTML descriptions and tags to be entered for catalog enrichment
-
- Image
-
- Column Name: NEW_ITEM-IMAGE
- Required/Optional: Optional - Preferred to Receive
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: The image for an item. During the catalog upload process into the smartOCI marketplace, you have two options of uploading images:
- Enter a URL reference for the product image
- Upload the image files separately during the catalog upload process (in this process, the image must be named the Vendor Product Number of the Manufacturer Part Number in order for the image to be correctly associated with the catalog line item
- Example: http://i.dell.com/images/global/products/proj/proj_highlights/projector-dell-1510x-overview1.jpg
-
- Service flag
-
- Column Name: NEW_ITEM-SERVICE
- Required/Optional: Optional
- Description Display Location: Vroozi Standard Catalog Fields
- Description: A Boolean flag which indicates if the line refers to a service or to goods. If the line is a service item category, please enter '1’
- smartOCI Type - Length: CHAR - 1
- Example: “1”
-
- Contract number
-
- Column Name: NEW_ITEM-CONTRACT
- Required/Optional: Optional
- Description Display Location: Vroozi Standard Catalog Fields
- Description: The contract number (stored in the contract mgmt system) with the vendor.
- smartOCI Type - Length: CHAR - 10
-
- Item of a contract
-
- Column Name: NEW_ITEM-CONTRACT_ITEM
- Required/Optional: Optional
- Description Display Location: Vroozi Standard Catalog Fields
- Description: The number of an item within a contract with the vendor.
- smartOCI Type - Length: CHAR - 5
-
- Quotation Number
-
- Column Name: NEW_ITEM-EXT_QUOTE_ID
- Required/Optional: Optional
- Description Display Location: Vroozi Standard Catalog Fields
- Description: A reference to an external quotation ID. Example: A supplier provides a sales quote based on a RFQ. This is a reference to this quotation.
- smartOCI Type - Length: CHAR - 35
-
- Quotation item
-
- Column Name: NEW_ITEM-EXT_QUOTE_ITEM
- Required/Optional: Optional
- Description Display Location: Vroozi Standard Catalog Fields
- Description: A reference to an external quotation ID line item number. Example: A supplier provides a sales quote based on a RFQ. This is a reference to this quotation.
- smartOCI Type - Length: CHAR - 10
-
- Quote Quantity
-
- Column Name: ITEM-QUOTE_QUANTITY
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: This is the quantity of the item quoted by the supplier in the sales quotation. This field will be mapped to the Quantity field in the ERP shopping cart upon checkout.
- smartOCI Type - Length: CHAR - 10
-
- Attachment link
-
- Column Name: NEW_ITEM-ATTACHMENT
- Required/Optional: Optional
- Description Display Location: Vroozi Standard Catalog Fields
- Description: The field contains a URL to an attachment. The smartOCI system connects to the URL.
- smartOCI Type - Length: CHAR - 255
-
- Purpose of the attachment
-
- Column Name: NEW_ITEM-ATTACHMENT_TITLE
- Required/Optional: Optional
- Description Display Location: Vroozi Standard Catalog Fields
- Description: Purpose of the attachment
- smartOCI Type - Length: CHAR - 128
-
- Attachment title
-
- Column Name: NEW_ITEM-ATTACHMENT_PURPOSE
- Required/Optional: Optional
- Description Display Location: Vroozi Standard Catalog Fields
- Description: Title of the attachment (if this is empty the file name from the URL above is used)
- smartOCI Type - Length: CHAR - 255
- Example: "T110 Spec Sheet"
-
- Customer-specific field
-
- Column Name: NEW_ITEM-CUST_FIELD1
- Required/Optional: Optional
- Description Display Location: Vroozi Standard Catalog Fields
- Description: Customer-specific field, which may be handled in the buying company's ERP System
- smartOCI Type - Length: CHAR - 10
-
- Customer-specific field
-
- Column Name: NEW_ITEM-CUST_FIELD2
- Required/Optional: Optional
- Description Display Location: Vroozi Standard Catalog Fields
- Description: Customer-specific field, which may be handled in the buying company's ERP System
- smartOCI Type - Length: CHAR - 10
-
- Customer-specific field
-
- Column Name: NEW_ITEM-CUST_FIELD3
- Required/Optional: Optional
- Description Display Location: Vroozi Standard Catalog Fields
- Description: Customer-specific field, which may be handled in the buying company's ERP System
- smartOCI Type - Length: CHAR - 10
-
- Customer-specific field
-
- Column Name: NEW_ITEM-CUST_FIELD4
- Required/Optional: Optional
- Description Display Location: Vroozi Standard Catalog Fields
- Description: Customer-specific field, which may be handled in the buying company's ERP System
- smartOCI Type - Length: CHAR - 20
-
- Customer-specific field
-
- Column Name: NEW_ITEM-CUST_FIELD5
- Required/Optional: Optional
- Description Display Location: Vroozi Standard Catalog Fields
- Description: Customer-specific field, which may be handled in the buying company's ERP or eProcurement System
- smartOCI Type - Length: CHAR - 50
-
- External Category
-
- Column Name: NEW_ITEM-EXT_CATEGORY
- Required/Optional: Optional
- Description Display Location: Vroozi Standard Catalog Fields
- Description: Unique key for an external category from the NEW_ITEM-EXT_SCHEMA_TYPE, dependent on the version of the schema
- smartOCI Type - Length: CHAR - 64
-
- External Category ID
-
- Column Name: NEW_ITEM-EXT_CATEGORY_ID
- Required/Optional: Optional
- Description Display Location: Vroozi Standard Catalog Fields
- Description: Unique key for an external category from the NEW_ITEM-EXT_SCHEMA_TYPE, independent of the version of the schema
- smartOCI Type - Length: CHAR - 64
-
- Schema Name
-
- Column Name: NEW_ITEM-EXT_SCHEMA_TYPE
- Required/Optional: Optional
- Description Display Location: Vroozi Standard Catalog Fields
- Description: Name of a schema via which it was imported in the ERP system
- smartOCI Type - Length: CHAR - 64
-
- System Name
-
- Column Name: NEW_ITEM-SLD_SYS_NAME
- Required/Optional: Optional
- Description Display Location: Vroozi Standard Catalog Fields
- Description: Name of a system in the System Landscape Directory (SLD)
- smartOCI Type - Length: CHAR - 64
-
- Sustainability (Green)
-
- Column Name: ITEM-GREEN_ITEM
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: Flag to indicate if the item is green certified. Enter a 'X' if the item is green.
- smartOCI Type - Length: CHAR - 1
- Example: X
-
- Item Energy Star
-
- Column Name: ITEM-ENERGY_STAR
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: Flag to indicate if the item is EnergyStar certified. Enter a 'X' if it is.
- smartOCI Type - Length: CHAR - 64
- Example: X
-
- Free Shipping
-
- Column Name: ITEM-FREE_SHIP
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: Flag to indicate if an item has free shipping. Enter a 'X' if it does.
- smartOCI Type - Length: CHAR - 64
- Example: X
-
- Item Clearance
-
- Column Name: ITEM-CLEARANCE
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: Flag to indicate if item is on clearance. Enter a 'X' if it is.
- smartOCI Type - Length: CHAR - 64
- Example: X
-
- Item on sale
-
- Column Name: ITEM-ON_SALE
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: Flag to indicate if item is on sale. Enter a 'X' if it is.
- smartOCI Type - Length: CHAR - 64
- Example: X
-
- Preferred Item
-
- Column Name: ITEM-PREFERRED
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: Flag to indicate if item is a preferred item, from the vendor's catalog. Enter a 'X' if it is.
- smartOCI Type - Length: CHAR - 64
- Example: X
-
- Refurbished Item
-
- Column Name: ITEM-REFURB
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: Flag to indicate if an item is a refurbished item. Enter a 'X' if it is.
- smartOCI Type - Length: CHAR - 64
- Example: X
-
- Item Contract
-
- Column Name: ITEM-CONTRACT
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: Flags item for contract
- smartOCI Type - Length: CHAR - 64
- Example: X
-
- ROHS Classification
-
- Column Name: ITEM-ROHS
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: Flag to indicate if an item is classified as ROHS (Restriction of Hazardous Substance). Enter a 'X' if it is.
- smartOCI Type - Length: CHAR - 64
- Example: X
-
- Bundle ID
-
- Column Name: ITEM-BUNDLE_NO
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: Enter a numeric value in this field to indicate if the catalog item is part of a bundle. If the items are assigned to the same bundle number, they will be logically grouped as a bundle.
- smartOCI Type - Length: CHAR - 20
- Example: "73432"
-
- Bundle Quantity
-
- Column Name: ITEM-BUNDLE_QUANTITY
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: Enter the quantity of the item contained in the bundle. For example, a Laptop Bundle will contain 1 Laptop, 2 Adapters, and 1 Laptop Bag
- smartOCI Type - Length: CHAR - 15
- Example: “1”
-
- In Stock
-
- Column Name: ITEM-INSTOCK
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: Flag to indicate if item is in stock. Enter a 'X' if the item is in stock.
- smartOCI Type - Length: CHAR - 1
- Example: X
-
- Quantity on Hand
-
- Column Name: ITEM-QTY_ONHAND
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: Quantity in inventory
- smartOCI Type - Length: CHAR - 15
- Example: "35"
-
- Manufacturer Name
-
- Column Name: ITEM-MANUFACTURER_NAME
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: Name of manufacturer
- smartOCI Type - Length: CHAR - 80
- Example: "ACME MANUFACTURER"
-
- Brand Name
-
- Column Name: ITEM-BRAND_NAME
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: Name of brand
- smartOCI Type - Length: CHAR - 80
- Example: "FLAG"
-
- Minimum Order Qty
-
- Column Name: ITEM-MIN_ORDER_QTY
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: Minimum order quantity for item
- smartOCI Type - Length: CHAR - 15
- Example: "5"
-
- Item Order Interval
-
- Column Name: ITEM-ORDER_INTERVAL
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: Signifies item order interval. Item quantity being added to cart must be a multiple of this value.
- smartOCI Type - Length: CHAR - 64
-
- Model Number
-
- Column Name: ITEM-MODELNO
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: Model number for item
- smartOCI Type - Length: CHAR - 50
- Example: "MF343-232"
-
- UPC Code
-
- Column Name: ITEM-UPC
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: UPC code for item
- smartOCI Type - Length: CHAR - 15
- Example: 2143598123
-
- Case UPC Code
-
- Column Name: ITEM-CASE_UPC
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: Case UPC code for item
- smartOCI Type - Length: CHAR - 15
- Example: 2143593324
-
- List Price
-
- Column Name: ITEM-LIST_PRICE
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: Manufacturer list price for the item
- smartOCI Type - Length: CHAR - 15
- Example: "21.99"
-
- Color
-
- Column Name: ITEM-COLOR
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: The color of the item
- smartOCI Type - Length: CHAR - 50
- Example: "Green"
-
- Size
-
- Column Name: ITEM-SIZE
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: The size of the item
- smartOCI Type - Length: CHAR - 50
- Example: "Large"
-
- Gender
-
- Column Name: ITEM-GENDER
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: If the item is targeted for a specific gender
- smartOCI Type - Length: CHAR - 25
- Example: "Ladies"
-
- RAM
-
- Column Name: ITEM-RAM
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: If an electronic device, the amount of RAM
- smartOCI Type - Length: CHAR - 25
- Example: "4 GB"
-
- CPU
-
- Column Name: ITEM-CPU
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: If applicable, the device CPU type
- smartOCI Type - Length: CHAR - 25
- Example: "Intel Core2Duo"
-
- HDD
-
- Column Name: ITEM-HDD
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: If applicable, the hard disk or storage capacity
- smartOCI Type - Length: CHAR - 25
- Example: "300 GB"
-
- Screen Size
-
- Column Name: ITEM-SCREEN_SZ
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: The screen size of the device/item
- smartOCI Type - Length: CHAR - 25
- Example: "15.4"
-
- Screen Resolution
-
- Column Name: ITEM-SCREEN_REZ
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: The screen resolution of the item
- smartOCI Type - Length: CHAR - 25
- Example: "1024x768"
-
- Item Comments
-
- Column Name: ITEM-COMMENTS
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: Any comments on the item
- smartOCI Type - Length: CHAR - 255
- Example: "Free shipping on orders of 5 or more"
-
- Configurable Item Flag
-
- Column Name: ITEM-CONFIG
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: Flag to indicate if the item is configurable. Enter an 'X' against any item that is a configurable item.
- smartOCI Type - Length: CHAR - 1
- Example: X
-
- Policy Item Flag
-
- Column Name: ITEM-POLICY
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: Flag to indicate if the item is configurable. Enter an 'X' against any item that is a configurable item.
- smartOCI Type - Length: CHAR - 1
-
- Item Suppression Flag
-
- Column Name: ITEM-SUPPRESS
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: Flag to indicate if the item is suppressed. Enter an 'X' against any item that is suppressed.
- smartOCI Type - Length: CHAR - 1
-
- GL Account
-
- Column Name: ITEM-GL_ACCOUNT
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: A field to default the catalog line item to a specific GL Account. When the item is added to the Requisition, the GL account will be defaulted at the line item level. Only include the GL account code and not the description.
- smartOCI Type - Length: CHAR - 25
- Example: 35782
-
- Product Deletion Flag
-
- Column Name: DELETE
- Required/Optional: Optional
- Description Display Location: Specific to the smartOCI Catalog Manager
- Description: Flag to indicate if the item is deleted from the catalog. Enter a 'X' if the item is deleted from the catalog.
- smartOCI Type - Length: CHAR - 1
- Example: X
-
- Item Number