In an XLS file with a template


Last Updated 25 November 2021
Read 7 minutes
Uploading products

You can upload all products from the same category in one XLS-file at once.

If your product has several versions (for example, different color, size, or weight), each of them will be a separate product. For example, a size 42 T-shirt and a similar size 44 T-shirt are different products. You can combine them on a single PDP. Learn more about how to do it.

# Uploading products

Before each upload, download a new template in your profile. We regularly update templates to keep them as accurate and convenient as possible. Do not use templates that you have downloaded before or that someone has sent you. Errors may occur when uploading them.

  1. Go to Products → Upload products in an XLS file:

  2. Choose a category and download a template for it. If the product can be assigned to more than one category, select one priority category. If you cannot find the right category, message us by following the link or clicking on the message icon at the bottom of your profile and selecting Other → Create a request. Then select the Content / Working with PDPs section and the Invalid product category subsection.

  3. Fill in the template, specifying all the main characteristics. The description and images must comply with the requirements.

If you do not want to upload main images via links, you can leave the Link to main photo column empty in the template. You can add images later for all products at once.

When uploading products in the Fur coats, Footwear, Clothing, Cameras and flash lamps, Tires, Light industry goods, Perfumes and eau de toilette categories, in the OKPD/FEACN code field specify the FEACN or OKPD2 code for each product. If you do not know which category your product belongs to and it is not a banned product, select "FEACN 29.09.20.20 - CROSSBORDER PRODUCTS" or "2812 - Crossborder Products". It is better to choose the OKPD/FEACN code that matches your product.

What is OKPD/FEACN

  1. Go back to your profile and, on the Upload products in an XLS file page, upload the filled in file:

The system will check the correctness of all data you entered. The results of this check can be found on the Products → Update history page.The table shows the status of the check and the number of products with errors. To find out what kind of problems occurred, click on in the Actions column and select Learn more.

If there are many errors, fix them in the XLS-file and upload it again. Errors in individual products can be edited manually on the Manage Inventory → All Inventory page.

# Working with a template

# 1.Download templates in your profile

Before each upload, download a new template in your profile. We regularly update templates to keep them as accurate and convenient as possible. Do not use templates that you have downloaded before or that someone has sent you.

# 2.Do not change the file structure

Do not add or remove sheets or columns. Do not change the order of columns or hide them.

# 3.Fill the rows correctly

Use a separate row for each Product ID. For example:

Product ID Name Size
1 R17 Romance ring 17
2 R18 Romance ring 18

# 4.Fill in the fields you need

You can fill only some blocks from the file:

  • Specify the Ozon ID. The system will use it to find the product and add it to your catalog. How to find out the Ozon ID

  • Fill in all the blocks if the product is not yet on Ozon. Specify as many characteristics as possible. They are used when searching and filtering by parameters. The more details you provide about a product, the more often buyers will find it. On top of that, products with detailed characteristics appear more attractive to buyers.

  • Fill in the fields highlighted in red; they are mandatory.

  • Use the tooltips. There is a tooltip above each field on how to properly fill it in. Make sure you read it. If the tooltip is not fully visible, you can stretch the row.

# 5.Do not change the value type

There are several types of fields in the templates. Do not change them and make sure you fill them in correctly:

  • Drop-down list. When you click on a cell, an arrow icon will appear next to it: . This tooltip means "Choose a value from the list." Click on the arrow and select the appropriate value. Do not enter the value manually.

    Examples: Type, VAT.

    To select multiple values from the list:

    1. Click on the arrow and check the available values. For example, the Color field has the following values: white, blue, green.

    2. In any empty cell, write all the values you need, separated by a semicolon (without spaces). The values must be spelled exactly as they are in the drop-down list. For example: white;blue;green (no spaces).

    3. Copy the line with the values and paste it into the parameter field.

  • Number. When you click on the cell, a tooltip reading "Enter a value from 0 to 9999" will appear next to it. This information may also appear in a tooltip above the field. Enter only numbers without units in such fields.

    Examples: Weight, Width, Price.

  • Text. In such fields, you can write any information you need for the parameter.

    Examples: Product name, Brand, Detailed description.

# 6.Do not skip sheets

Some templates have several sheets. Fill them all in. There are the following types of sheets:

  • Instructions and Certificates: on this sheet, provide links to certificates and other documents for your products in .pdf format.

  • Videos: on this sheet, you can enter links to videos about products.

  • Sheets with product features: on these sheets, you can specify additional parameters. Such sheets are available, for example, in templates for electronics or cosmetics.

To learn how to find and remove links (external links), see Microsoft Help.

# Filling in the template

Fill in the following fields

# 1.Name and Prices

  • Product ID

    The product's ID or number in your database. The item must be unique for each product. For example, a notebook with a red cover and a similar notebook with a blue cover are different products. Add another separate product with a new ID.

    If you have repeating IDs in your product base, make them unique. You can add product colors, sizes, or simply "_1", "_2", "_3" to the existing IDs.

    Example:

    No. Product ID* Product name*
    1 DSPSWW_red HATBER Notebook "Color"
    2 DSPSWW_blue HATBER Notebook "Color"
  • Product name.

    The name is formed using one of the methods:

    • Compiled automatically from the mandatory characteristics, by default for all categories. The name is formed following this pattern: type + brand + model + important characteristics for the category. For the name to be compiled automatically, leave the Name field empty.

    • Manually set (specify the name to be shown on the PDP yourself). These names are subject to moderation and must meet the requirements.

  • Price and VAT, %.

    Set the price. In the VAT area, choose the Excempt or Not subject to You can enter additional prices:

    • The price before discounts (the old price) at which the item was sold earlier. Buyers will see the old price crossed out and the discount percentage. The old price must be higher than the current price.

    • Special price for Ozon Premium subscribers. Learn more about special prices.

# 2.Product information

  • Commercial type. Select the type of the product. The commercial type is the product category. We will calculate the referral fee based on it. To choose the right value, you can search the Ozon website for products similar to yours and check what type is specified in their names.

  • Barcode (Serial Number / EAN).

# 3.Advanced product information

  • Package weight, g, Package width, mm, Package height, mm, Package length, mm

Enter the weight and dimensions of the packaged product. The length should be the biggest of the dimensions; the height, the smallest. There are maximum and minimum values for each product category. The weight and dimensions of the packaged product must fall within the allowed value range. You cannot add a product whose weight and dimensions do not comply. You can specify the dimensions of the product without packaging in the Characteristics block.

  • Link to main photo

Enter a direct link to the main image. Such links end in the following characters: .jpeg, .jpeg, .jpg, .png. Getting direct links to images.

# 4.Characteristics

Fill in the characteristics that will appear on the PDP. To make the product more attractive to buyers, specify as many characteristics as possible. If you want to combine products on a single PDP, fill in the fields highlighted in yellow. This will allow the buyer to switch between product versions on the PDP. Learn more about combining products into a single PDP

If you plan to sell:

  • Several units in one product, e.g., three bars of soap in a single package, then, when uploading your products, enter the desired number of units, for example, "3", in the Units per product field.

  • Singular items, enter "1" in the Units per product field.

# Errors when uploading products

You can learn more about errors when working with products here