Skip to main content
Skip table of contents

Product feed layout definition

The following table represents the feed layout definition.

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

System of Record Name

sor_name

(Required) Name of the system that is the authoritative data source for a record. 

char(100)

Source Product ID

source_product_id

(Required) This field is the natural primary key.

Uniquely identifies product in the client's source system.

This field is used in aggregate calculations.

char(200)

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.

Values are defined as part of on-boarding, in BUSINESS_UNIT_LOOKUP; NULL values will default to enterprise. Refer to Business unit for details.

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)

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)

Brand Code

brand_code

Defines a product's brand.

char(50)

Brand Description

brand_desc

A description of the brand.

char(100)

Product Category Code

product_category_code

(Required) 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). 

This field is used in aggregate calculations.

Values are defined as part of on-boarding, in PRODUCT_CATEGORY_LOOKUP. Refer to Product category for details.

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)

Department Code

department_code

Code associated with the department name.  

char(50)

Department Name

department_name

Department name.  

char(60)

Department Description

department_desc

Descriptive name of the department code.

char(100)

Sub Department Code

sub_department_code

Identifies sub-departments such as outerwear in a clothing department.  

char(50)

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.

Values are defined as part of on-boarding, in PRODUCT_STATUS_LOOKUP. Refer to Product status for details.

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)

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)

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.

Valid values are:

  • y

  • n

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 wrapping, restocking fee, gift card, monogramming, etc.

Valid values are:

  • y

  • n

char(1)

Vendor ID

vendor_id

Vendor ID.

char(5)

Vendor Description

vendor_desc

Vendor description (may be name).

char(100)

Gift Card Indicator

gift_card_ind

Indicates whether the product is a gift card.

Valid values are:

  • y

  • n

char(1)

Dimensions

dimensions

Product's dimensions.

char(100)

Weight

weight

Product's weight.

char(100)

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.