Example of XLS file with description of elements

Download sample XLS file

Table with category descriptions

Element (column header)

Element description (column contents)

Example

Type

Table type. You can use any value from the list:

  • Category
  • Категория
  • Category/Категория
  • Категория/Category

Required element. The element column must be first.

Category

id

The category ID.

Required element.

101

parentId

A higher-level category ID.

Only mandatory for subcategories.

10

name

Name of the category.

Required element.

Can be in English or Russian.

Electronics

Table with product-model descriptions

Elements are optional unless stated otherwise.

Element (column header)

Element description (column contents)

Example

Type

Table type. You can use any value from the list:

  • Model
  • Модель
  • Model/Модель
  • Модель/Model

Required element. The element column must be first.

Model

id

ID of the modification.

Required element.

34121

categoryId

ID of the category that the model belongs to.

Required element.

101

name

Name of product-model. You do not need to specify the product category, type, vendor's name or specifications in the name element.

Required element.

Can be in English or Russian.

EOS 60D Body

alias

Alternative name of product-model. You can specify multiple alias elements (but not more than 10) for one product-model.

Can be in English or Russian.

EOS 60D W/O LENS

type

Product-model type. Specify this element if the category contains different types of products. For example, dolls and constructor sets in the “Children's products” category.

Digital camera

vendor

Name of vendor or brand.

Required element.

Canon

vendorCode

SKU (code assigned by vendor).

4460B007

promoUrl

Link to product-model page on vendor's site.

Required element.

http://canon.com/ eos-60d

pictureUrl

Link to image of product-model on vendor's site. There should be one element per link. You can enter several pictureUrl for one product-model.

Required element.

http://canon.com/ eos-60d.jpg

pictureType

Type of image indicated in pictureUrl.

main

instructionUrl

Link to product instructions on the vendor's site.

http://canon.com/ eos-60d.pdf

driversUrl

Link to product drivers on the vendor's site.

http://canon.com/ eos-60d.zip

barcode

Product barcode.

1234567890123

announceDate

Date of product announcement.

You need to enter the “Дата”/“Date” format for all cells in the column (except the first). This must be done using your XLS file editor.

2016-04-01

inStockDate

Start date of official sales.

You need to enter the “Дата”/“Date” format for all cells in the column (except the first). This must be done using your XLS file editor.

2016-05-01

addDate

Date product-model description was added to catalog.

You need to enter the “Дата”/“Date” format for all cells in the column (except the first). This must be done using your XLS file editor.

2016-03-01

updateDate

Date changes were made to product specifications.

You need to enter the “Дата”/“Date” format for all cells in the column (except the first). This must be done using your XLS file editor.

2016-06-01

isActual

Product-model's relevance:

  • 1 — product-model in production

  • 0 — model no longer in production.

1

recomendedPrice

Recommended price.

55000

priceCurrency

Currency for the recommended price (possible values: RUR, RUB, USD, EUR, UAH, BYN, KZT).

RUR

description

Description of product-model.

Can only be in Russian.

Зеркальная фотокамера любительского уровня

paramName

Name of product parameter.

Mandatory if you have at least one parameter. You can enter several parameters for one product-model.

Weight

paramValue

Parameter value.

Mandatory if paramName is specified.

750

paramUnit

Unit of measurement of parameter.

g

rec

Recommended or compatible product. For one model, you can specify multiple rec elements.

Olympus 45 mm f/1.8 objective

recType

Recommendation type.

component

isSupplement

Whether or not the recommended product is supplemental.

1

recInnerId

ID of recommended product-model in current file.

167

recMarketId

Profile ID of recommended product on Yandex.Market.

7888908