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 
RequiredType Length Usage
ExhibitorName String 50 The name of the brand as stated with Emerald.
ItemNumber String 50 The displayed style number 
ProductName String 200 The displayed style name 
SKU String 50 The internal identifier of the product
UPC String 50 The external identifier. UPC/EAN (Registered UPC's only)
ColorCode String 50 The brand's internal code that uniquely identifies the color of the product

My brand doesn't use ColorCodes
GeneralColor String 50 This is used for the color palette filter.*note text is case  sensitive
Elastic General Colors for Filtering
ColorName String 200 The displayed color name
ColorSort Integer 11 The sequence the colors are displayed
AvailableDateDate (YYYYMMDD)Date (8) A date that can be used to control when a product is ordered. This determines when inventory is displayed. (Available Date*)
SizeName String 200 The display name for size (e.g. L, or 8)
SizeSort Integer 11 Order of sizes within a colorway
AlternateSize String 50 Inseam or width (e.g. wide shoes, x32 jeans)
Wholesale Decimal decimal Wholesale Price displayed
Retail Decimal decimal Retail Price displayed
Gender String 2,000 Filter option for Gender  (Approved Categories*)
CategoryString 2,000 Filter option for Product Category (Approved Categories*)
SubCategory String 2,000 Filter option for Product SubCategory (Approved Categories*)
Overview String 2,000 Product overview description
CurrentSeason String 2,000 Current season of the product (Value expected Y or N)
FutureSeason String 2,000 Future season of the product (Value expected Y or N)
Multiple Integer 11 Product is sold in quantities of this value. Use 1 if  not sold in multiples
Keyword1 
String 60 Used in Keyword search, e.g., Waterproof
Keyword2 String 60 Used in Keyword search, e.g., Breathable
Keyword3String 60 Used in Keyword search, e.g., Hooded
Keyword4
NString 60 Used in Keyword search, e.g., Full Zip
Keyword5
NString 60 Used in Keyword search, e.g., Phone Pockets
PrimaryImage String 128 Primary/Hero Image of the product
Alternate1 String 128 Alternate shots of the product
Alternate2 String 128 Alternate shots of the product
Alternate3 String 128 Alternate shots of the product
Alternate4 String 128 Alternate shots of the product
Alternate5 String 128 Alternate shots of the product
Status String 50 One value per style/color 
- In Review (Only Seller can see the item) 
- Active (can be ordered) 
- Dropped (is visible but cannot be ordered) 

Updating the 'Status' Field 


AvailableDate*

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.

Click here for Inventory Availability Example Scenarios


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_brandGender
Category/SubCategoryproducts_brand (for Surf Expo)Surf Expo Product Categories
Category/SubCategoryproducts_brand (for Outdoor Retailer)

Outdoor Retailer 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


Inventory Information

Inventory



This data lists the inventory information displayed in Digital Market. The data can include future availability or just current availability. Check out the below video for an introduction to the Inventory file. 

File Name: inventory_brand.csv (DOWNLOAD SAMPLE FILE)

Field

Required

Type

Length

Usage

UPC

Y

String

50

Primary key that joins products to inventory on a UPC level.

AvailableDate

Y

Date 

(YYYYMMDD)

Date (8)

This is the date inventory will be available. 

Quantity

Y

Integer 

11

The available quantity.


Click here for Inventory Availability Example Scenarios

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.