Table of Contents


TABLE OF CONTENTS



Flat File Approach

This document defines the standard flat file approach for exchanging information between systems (pipe separated .csv). We request UTF-8 encoding. We also support excel (.xlsx) file. Elastic bulk reimports from files, i.e., each file is an update on previous data.


1. Product Information:

  • Products

  • Product Features

2. Inventory


The detail of these data sets is further described in this document. It should be noted that records that do not contain all the required information will not be imported.  

Note that key values are case sensitive. When matching across files it is important to not only match the characters but also the case. 

All columns should be maintained. If columns are unused, they should be left blank but included in the file.

File names should be in lower case.

Product Information

Product

The core of the application is based on product information. The quality and completeness of this data will

greatly influence the quality of the user experience. The following data elements are expected within the

Products file. Elastic is expecting a single row for each unique UPC. See the below video for an introduction to the Products file.


File Name: products_brand.csv (DOWNLOAD SAMPLE FILE) 


Field

Required

Type

Length

Usage

ExhibitorName

Y

String

50

The name of the brand as stated with Emerald. This is how your name will display within Exchange.

ItemNumber

Y

String

50

The displayed style number 

ProductName

Y

String

200

The displayed style name 

SKU

N

String

50

The internal identifier of the product

UPC

Y

String

50

The external identifier. UPC/EAN (Registered UPC’s only)

ColorCode

Y

String

50

A code the uniquely identifiers the color of the product
My Brand doesn’t use Color Codes. 

GeneralColor

N

String

50

This is used for the color palette filter. Note, text is case sensitive

Elastic General Colors for Filtering

ColorName

Y

String

200

The displayed color name

ColorSort

Y

Integer

11

The sequence the colors are displayed

AvailableDate

N

Date (YYYYMMDD)

Date (8)

A date that can be used to control when a product is ordered. This is not dependent on inventory. (Not required for Exchange, can be left blank)

SizeName

Y

String

200

The display name for size (e.g., L, or 8)

SizeSort

Y

Integer

11

Order of sizes within a colorway

AlternateSize

N

String

50

Inseam or width (e.g. wide shoes, x32 jeans)

Wholesale

Y

Decimal

decimal

Wholesale Price displayed

Retail

Y

Decimal

decimal

Retail Price displayed

TagName1

N

String

2,000

Filter option for product filtering, example Gender

TagValue1

N

String

2,000

Options available under TagName1, example Men’s, Women’s, Youth

TagName2

N

String

2,000

Filter option for product filtering

TagValue2

N

String

2,000

Options available under TagName2

TagName3

N

String

2,000

Filter option for product filtering

TagValue3

N

String

2,000

Options available under TagName3

TagName4

N

String

2,000

Filter option for product filtering

TagValue4

N

String

2,000

Options available under TagName4

TagName5

N

String

2,000

Filter option for product filtering

TagValue5

N

String

2,000

Options available under TagName5

TagName6

N

String

2,000

Filter option for product filtering

TagValue6

N

String

2,000

Options available under TagName6

TagName7

N

String

2,000

Filter option for product filtering

TagValue7

N

String

2,000

Options available under TagName7

TagName8

N

String

2,000

Filter option for product filtering

TagValue8

N

String

2,000

Options available under TagName8

Overview

N

String

2,000

Product overview description

Multiple

N

Integer

11

Product is sold in quantities of this value. Use 1 if not sold in multiples. (Not required for Exchange, can be left blank)

Keyword1

N

String

60

Used in Keyword search, e.g., Waterproof

Keyword2

N

String

60

Used in Keyword search, e.g., Breathable

Keyword3

N

String

60

Used in Keyword search, e.g., Hooded

Keyword4

N

String

60

Used in Keyword search, e.g., Full Zip

Keyword5

N

String

60

Used in Keyword search, e.g., Phone Pockets

PrimaryImage

Y

String

128

Primary/Hero Image of the product

Alternate1

N

String

128

Alternate shots of the product

Alternate2

N

String

128

Alternate shots of the product

Alternate3

N

String

128

Alternate shots of the product

Alternate4

N

String

128

Alternate shots of the product

Alternate5

N

String

128

Alternate shots of the product

Status

N

String

50

One value per style/color

  • Active (Visible to everyone)

  • Dropped (is visible but cannot be ordered)

(Not required for Ec, can be left blank)

Updating the ‘Status’ Field


AvailableDate* (Applicable only to Edge)

The available date will display as 'infinite' whether you are not loading inventory or if you want to utilize it as a prebook date. If the 'AvailableDate' data field in the Products file is entered with a:

- Past date, then the site will not load and display inventory and the item is available for purchase.

- Future date, then the site will load and display current and future availability. 


- Left blank, then the site will not load and display inventory and the item is available for purchase.


Approved Show Categories* 

In order for your brand's products to be displayed in search results by retailers in the Digital Market, the following fields must match the selections in the dependent files. 


FieldFilenameDownload File
Genderproducts_brand
Gender
Category/SubCategoryproducts_brand (for Surf Expo)Surf Expo Product Categories
Category/SubCategoryproducts_brand (for Outdoor Retailer)

Outdoor Retailer Product Categories

Category/SubCategoryproducts_brand (for NY NOW and SF NOW)NY/SF NOW Product Categories


Product Features

This table is used to list additional features of a product. Features can be grouped and segmented by

an attribute type. This information is displayed within browse and the product detail page. The product feature

table is linked to the product table based on the product number. Check out the below video for an introduction to the Features file.




File Name: features_brand.csv (DOWNLOAD SAMPLE FILE)

FieldRequiredTypeLengthUsage
ItemNumberY

String

50

Product/Style number used to join to the products table. 

AttributeNameY

String

50

The name of the attribute in plural form (e.g., Features, Specifications). This is a category of features.

AttributeNameSort

YInteger 

11

The sequence in which the attributes are displayed.  
AttributeValueY

String

2,000

The description of the attribute (e.g., Waterproof and breathable)

AttributeValueSortYInteger 

11

The sequence the descriptions appear.


Example display for a product:

Overview:

The product is designed to be lightweight and quick-drying for all activities

Fabric

  • Gore-Tex
  • Leather

Features

  • Zipper Pockets
  • Zip off hood
  • Internal Drawcord

 

The data for this would look like this:

ItemNumber

AttributeName

AttributeNameSort

AttributeValue

AttributeValueSort

AK50071

Overview

1

The product is designed to be lightweight and quick-drying for all activities

1

AK50071

Fabric

2

Gore-Tex

1

AK50071

Fabric

2

Leather

2

AK50071

Feature

3

Zipper Pockets

1

AK50071

Feature

3

Zipper Pockets

2

AK50071

Feature

3Internal Drawcord3


FTP Location


Elastic will provide login details for GoAnywhere, for all files from Brand to be posted. The data files should be placed in the “Data > Inbound” directory.  Files will be processed through Elastic Suite’s integration layer for DQA before being loaded on Elastic. 

For more information, check out our Catalog Setup support article.