Product feed layout sample

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