Product feed layout sample

The following table provides sample values for the feed layout definition. In addition, you can use the attached sample file for testing and baseline configuration.

ifl_Product_20240109.csv

Required fields are marked as (Required) in the field description column; fields not marked as required are optional.

Business name	Field name	Description	Field data type/length	Sample value
System of Record Name	`sor_name`	Name of the system that is the authoritative data source for a record. Population rules apply.	`char(100)`	`Merchant`
Source Product ID	`source_product_id`	Uniquely identifies product in the client's source system. Population rules apply.	`char(200)`	`1000000040007`
Business Unit Code	`business_unit_code`	Business Unit (BU) identifies the structure of brands within an organizational entity. It is the way in which the brands within a company’s portfolio are related to, and differentiated from, one another.	`char(50)`
Label	`label`	Product label.	`char(50)`
Label Description	`label_desc`	Product label description.	`char(100)`
SKU	`sku`	Uniquely identifies a product in Stock-Keeping Unit (SKU) notation.	`char(100)`	`1000000040007`
UPC	`upc`	Uniquely identifies a product in Universal Product Code (UPC) notation.	`char(100)`
Product Style	`product_style`	Defines a product style in the source system.	`char(50)`
Product Style Description	`product_style_desc`	A description of the product style.	`char(100)`
Product Name	`product_name`	Name of the product.	`char(200)`
Product Description	`product_desc`	A description of the product.	`char(1000)`	`STIHL`
Brand Code	`brand_code`	Defines a product's brand.	`char(50)`
Brand Description	`brand_desc`	A description of the brand.	`char(100)`	`utensil`
Product Category Code	`product_category_code`	Code that defines product's category. The range of products sold by a retailer is broken down into discrete groups of similar or related products (examples of grocery categories might be washing detergents, toothpastes). Population rules apply.	`char(50)`
Product Division Code	`product_division_code`	A code that identifies business subdivisions of products.	`char(50)`
Product Division Description	`product_division_desc`	Description of business subdivisions of products.	`char(100)`	`46`
Department Code	`department_code`	Code associated with the department name.	`char(50)`	`Variant SKU Spec Ordr`
Department Name	`department_name`	Department name.	`char(60)`
Department Description	`department_desc`	Descriptive name of the department code.	`char(100)`	`4699`
Sub Department Code	`sub_department_code`	Identifies sub-departments, such as outerwear in a clothing department.	`char(50)`	`Vndr Spec Ordr SKU`
Sub Department Name	`sub_department_name`	Name of sub-departments, such as outerwear in a clothing department.	`char(60)`
Sub Department Description	`sub_department_desc`	Descriptive name of sub-department code such as men's or women's shoes and clothing.	`char(100)`
Material ID	`material_id`	Product's vendor style/material ID.	`char(50)`
Product Status Code	`product_status_code`	Product status code, such as active, discontinued, pending, etc.	`char(50)`
Color Code	`color_code`	Standard product color code.	`char(50)`
Color Name	`color_name`	Standard product color name.	`char(60)`
Size Code	`size_code`	Standard product size code.	`char(50)`
Size Name	`size_name`	Standard product size name.	`char(60)`	`469999`
Class Code	`class_code`	Identifies merchandise class that groups similar products together that share specific qualities. For example, women’s evening wear can be broken down into floor-length dresses and street-length dresses.	`char(50)`	`[VendorSKU SpecOrder] Mozu Block`
Class Name	`class_name`	Name of merchandise class that groups similar products together that share specific qualities. For example, women’s evening wear can be broken down into floor-length dresses and street-length dresses.	`char(60)`
Custom Indicator	`custom_ind`	Indicates whether the product is custom (`y`).	`char(1)`
Model	`model`	Product model.	`char(200)`
Global MSRP Amount	`global_msrp_amount`	The manufacturer’s suggested retail price (MSRP) in global currency. This is the price that a product's manufacturer recommends it be sold for at point of sale. The MSRP is also referred to as the list price by some retailers.	`numeric(20,6)`
Local MSRP Amount	`local_msrp_amount`	The manufacturer’s suggested retail price (MSRP) in local currency. This is the price that a product's manufacturer recommends it be sold for at point of sale. The MSRP is also referred to as the list price by some retailers.	`numeric(20,6)`
Local Currency Code	`local_currency_code`	ISO standard 3 char currency code.	`char(3)`
EAN Check Digit	`ean_check_digit`	European Article numbering code (EAN) is a series of numbers in a unique order that helps identify specific products and is used to list products for retail businesses.	`char(1)`
Product Image URL	`product_image_url`	Fully qualified URL that locates an image asset for display on the web or within other digital channels.	`char(4000)`
Non-Merchandise Indicator	`non_merch_ind`	Indicates whether this is a non-merchandise product, such as shipping, gift wrap, restocking fee, gift card, monogramming, etc. Valid values: `y` `n`	`char(1)`
Vendor ID	`vendor_id`	Vendor ID.	`char(5)`
Vendor Description	`vendor_desc`	Vendor description (may be name).	`char(100)`	`n`
Gift Card Indicator	`gift_card_ind`	Indicates whether product is a gift card. Valid values: `y` `n`	`char(1)`
Dimensions	`dimensions`	Product's dimensions.	`char(100)`
Weight	`weight`	Product's weight.	`char(100)`	`D-SPEC ORDER STIHL 7193`