Description of fields in the XLS format

FieldDescriptionRequired

id

Product ID. May contain numbers, Latin letters, hyphens and underscores. Maximum length: 80 characters. Must be unique for each product.

Required

english-name

Full product name in English. Follow this format: what (type of product) + who (manufacturer or brand) + product (name and model) + key characteristics.

Examples:

  • Product type — smartphone, headphones.

  • Brand — Xiaomi, Samsung.

  • Model — iPhone X Mi Smart Band.

  • Key parameters — steel case.

Parameters that vary within a single product should be specified in param. For example: color, size, quantity in each package, etc.

Required

category

Product category.

Required

price

Current price of the product.

Required

currencyId

Product price currency: RUR, USD, EUR, UAH, KZT, BYN. The price and currency must match. For example, with USD the price should be specified in dollars, not rubles.

Required

weight

Item weight in kilograms including packaging. You can specify up to three decimal places (for example, 1.001). The decimal separator is a dot.

Required

cargo-type

Cargo classification code.

View codes
CodeDescription
0Unknown type
10Documents and securities
50Art objects
80Valuables and precious metals
100Consumer goods
200Appliances and electronics
220Batteries
230With battery
300Heavy and oversized cargo
400Dangerous cargo
420Weapons and explosives
440Cosmetics and perfumes
450Aerosols and gas cylinders
460Odorous cargo
470Powders
480Chemicals
500Wet cargo
700Perishables
750Foodstuffs
800Animals
900Medications

Required

hs-code

Customs code (Commodity Nomenclature of Foreign Economic Activity).

Required

picture

URL link to product image. In one picture field you can enter up to 10 links to images, separated by commas. The product parameters on the first image must match the parameters in param. For example, if paramspecifies the color green, the product in the first picture must be green.

The maximum URL length is 512 characters. Acceptable protocols: HTTP, HTTPS. Formats: JPEG, PNG, GIF. The maximum size is 3,500 pixels on the longest side. The minimum size is 600 pixels on either side. Acceptable backgrounds: white, transparent.

Required

name

Full product name in Russian.

Follow this format: what (type of product) + who (manufacturer or brand) + product (name and model) + key characteristics. Examples:

  • Product type — smartphone, pocket flashlight.

  • Brand — Xiaomi, Samsung.

  • Model — iPhone X Mi Smart Band.

  • The key parameters are steel casing and disappearing ink.

Parameters that vary within a single product should be specified in param. For example: color, size, quantity in each package, etc.

Optional

vendor

Name of manufacturer or brand.

Optional

description

Offer description. Maximum text length is 3,000 characters (including punctuation marks). The following are not allowed in the description:

  • Phone numbers, email addresses, postal addresses, ICQ numbers, instant messenger usernames, or any URL links.
  • The words “discount”, “sale”, “cheap”, “gift” (except for gift categories), “gratis”, “promotion”, “special price”, “free”, “new”, “equivalent”, “order”, “hit”.
  • Terms of sale of the product, such as information about promotions or prepayment.
  • Region where the product is sold.
  • Information about different product modifications (for example, you cannot write “variations available”). You must create a separate offer for each modification.

You can use the XHTML tags <h3>...</h3>, <ul><li>...</li></ul>, <p>...</p>, <img>...</img>, <table>...</table>, and <br/>, provided that:

  • They are enclosed in a CDATA block in the format <![CDATA[ Text with XHTML markup]]>.

  • They conform to the general rules of the XHTML standard.

Optional

english-description

Product description in English. The requirements are the same as the requirements for description:

Optional

oldprice

Old price for the product. Must be higher than the current price. Yandex.Market automatically calculates the difference between the old and current prices and shows users the discount.

Optional

param

All important characteristics of the product in Russian or English — color, size, volume, material, age, gender, etc.

An Excel file can only contain one param.

Structure
parameter X  | value X  | unit of measurement; parameter Y  | value Y  | unit of measurement;
  • Add a semicolon after each parameter in the field: ;.

  • Separate the parameter name, value, and units with a vertical bar: |. Only the name must be specified.

    If the parameter does not have a unit of measurement or value, do not specify anything, or use an empty value. For example: [Wi-Fi||;] or [Wi-Fi;] means that there is Wi-Fi.

Example

Screen size|27|inches;Material|aluminum;Wi-Fi;

Required if group-id is used. Optional in other cases.

dimensions

Product dimensions (length, width, height) including packaging. Specify dimensions in centimeters.

Format: three positive numbers with accuracy of 0.001, using a dot as the decimal separator. The numbers must be separated by the slash symbol “/” without spaces.

Optional

group-id

ID for grouping products (when multiple products are variations of the same model). The value group-id must be the same for all products from the same group. For example, cases of the same model in different colors.

The value can contain numbers, Latin letters (lowercase and uppercase), hyphens and underscores.

Optional

main-picture

URL link to a picture of the product group. For example, an image that shows cases of the same model in all possible colors.

Optional

adult

The product is of a sexual nature or pertains to sexual interest in any way. Possible values — true, false.

Optional