How to create an XML file for a socket

1. General data

To get started, download the xls file template that we have prepared for you, taking into account the structure you need to upload products.

Download templates and examples for creating a Rozetka XML file

On the first tab, you enter general data about your store.

You will need to fill in the following parameters:

• Date - the date and time the file was last modified. This parameter will need to be changed every time you make changes to the finished file - update availability or prices.
• Name - the name of your store on Rozetka Company - the name of the store owner - it can be a sole proprietorship or a legal entity Url - a link to your website (separate or on another marketplace, for example, on Prom.ua) Platform (optional parameter) - CMS, on which running a website, such as WordPress or Opencart. You may not fill out.

2. Categories

The next step is to create a list of your product categories. Find products similar to yours on the Rozetka and see in which category they are located. Copy the name so that it exactly matches the name on Rozetka.ua. For example, Calculators, or Fins for the pool.
Category ID - any number of your choice, unique for each new category. If you have only one product category, delete the second line. If more, add as many lines as needed.
ID - a unique identifier for the category Category - the name of the product category that matches the name on the Rozetka

3. Product filters

The next step is to determine the required filters and their values. Make yourself a list on a separate sheet or in another file, you will need it to add products.
Go to the Rozetka website with the category of products you need. And look at the list of available filters in this category.
For example, calculators will have the following filters:

• Manufacturer - the brand that produces the product. Let's say you sell Casio, Canon, and Samsung calculators. Copy the Casio and Canon names exactly as they appear in the filter. The third value of the filter will be Samsung, which is not in the filter yet. Rewrite the name from the product packaging without using the prefixes OOO, Co, ltd, etc. So, your possible values for the manufacturer filter are: Casio, Canon, Samsung. All other product filters are filled in the same way. Try to choose a suitable value from the existing ones, but if there is none, write your own.
• Type
• Nutrition
• Color - try to choose the value with the largest number of products in it. For example, if your calculator is black with a red stripe, it's better to set it to Black than to add a new color, Black with Red. After all, users would rather choose the Black filter than put down birds in all possible variations.
• Display bit depth
• Country of origin of goods
• Country of registration of the brand - the last two filters describe the country of the brand and the country of production of your product. For example, Casio is a Japanese brand that manufactures calculators at a factory in the Philippines. So the country of origin is the Philippines, the country of the brand is Japan.
• Interest-free credit - currently only used by Rozetka for its products. Do not add this filter.
• Seller - do not add this filter. You will be placed in the category Other sellers by default.
• The price is an automatic filter, you don't need to prescribe anything special.

Filters must be filled in to show your products to the maximum number of buyers. Let's say a client visits the Calculators section. Your product will always be in this list, regardless of the prescribed filters. But it is unlikely that the client will want to flip through a couple of dozen pages, looking through all the available options. So he refines his query by selecting the Pocket filter. And if you did not register this filter, or specified an incorrect value for it, you will not be included in the results for Pocket Calculators and the client will never see your wonderful product.
So give the filters enough attention and time.

4. Other features

All the filters you specified on Rosette will be displayed on your product page in the Characteristics section. But sometimes they are not enough to fully describe the product. The calculator may have additional characteristics Dimensions, Weight, Warranty. Look at examples of products similar to yours and add whatever you see fit.

5. Adding a product

We add the first product to your future xml. In the template file, go to the Offers tab.

The first line contains the names of the fields and the required separators. The second is an example of a product. Let's start editing it for our Casio calculator:

• Product code - a unique product identifier. You can put any number, the main thing is that each product has its own.
• Product on the site - a link to the card of this product on your site.
• Price - the price of the product, should not be higher than on your website.
• Category ID - ID of the category your product belongs to. Copy the number from the Header page we filled out earlier. For example, we assigned the category Calculators the number 111 - we will indicate it.
• Product photo - a link to the product photo on your website. The template contains one photo, but if you have more, you can add as many as you need, just insert tags between them: https://shop.com.ua/img1.jpg
  https://shop.com.ua/img2.jpg
  https://shop.com.ua/img3.jpg
• The manufacturer is the brand of the product. This is the filter we looked at earlier. In our example, Casio.
• Quantity - the number of items in stock. The outlet will only load items that are in stock. So mark all the products you plan to sell as having more than zero, and don't forget to check these numbers when your products appear on the marketplace.
• Product name - must be specified in a specific format. Usually this:
• Product type - Brand - Model - Size (if relevant) - Color (if relevant) - (Article (if applicable))
• You can navigate to other products similar to yours.
• In our example, Casio Calculator 12-bit Black
• Please note that the Brand in the product name must match the Manufacturer parameter specified earlier.
• Product description - a textual description of your product. If you write only text, it will appear in one paragraph without any formatting. For better display, you can use html markup if you are familiar with it. If not, just put a separator before each new paragraph, like so:
  Calculator pocket Casio for school and office.
  Convenient large buttons, many functions, anti-reflective screen. Impact and scratch resistant.
  It will be a great gift for a schoolboy or student!
  The product card will look like this:
  Calculator pocket Casio for school and office.
  Convenient large buttons, many functions, anti-reflective screen. Impact and scratch resistant.
  It will be a great gift for a schoolboy or student!
  The next columns are product characteristics. Each consists of three components:
  

1. Opening tag in a white cell, where instead of the word Characteristic, the name of a specific characteristic is written - as in our filters - Type, Color, and so on.
2. In the blue cell, you need to fill in the value for this characteristic - for example, Pocket for Type, Black for Color.
   
3. Closing tag in a white cell. It is glued with the opening tag of the following characteristic for greater compactness.
   

Now you will need to fill in the first and second components for each characteristic of your product. That is, to prescribe the names of the characteristics and their values.
The most common characteristics are already in the xml template, so just provide a value for them. Replace the rest with what suits your product. The order doesn't matter.
Let's go back to our example:

• Country of origin - Philippines
• Brand registration country - Japan
• Type - Pocket
• Black colour
• Power - Solar + lithium battery
• Display digit - 12
• Dimensions - 70 x 40 x 10 mm
• Weight - 50 g
• Warranty - 6 months

The last three characteristics - Article, Category and Delivery / Payment:
Article - product code at the Rosette. Suppose Rozetka is trading exactly the same calculator as you. Then you have the opportunity to take advantage of it. Copy the Rosette SKU from the product name (code in brackets) and add it to your product name and in the SKU column. The fact is that Rosette products in the search results are higher than the rest. And if the client opens the page with the Rosette calculator, he will see your calculator there at your price.
The option is useful if your prices are more profitable, or if the product on the Rozetka is out of stock.
Category - here you need to enter the name of your Product Category. Copy the value from the Header page we filled out earlier. In our example, these are Calculators.
Delivery/Payment - here you can add delivery and payment features specific to this particular product. For example, products under the order, prepayment 5%
If some characteristics are not useful to you, just delete unnecessary cells - white and then blue (do not delete columns!). The end tag for all characteristics is the same, so don't worry about it, it will be taken from the white cell of the next characteristic.

6. Adding other products

With the rest of the products it will be easier. Most likely, the set of characteristics and most of the values are the same for your entire group of products, so just copy the string you just created and paste it below. Don't forget to give it a unique code and product name, and change the values where necessary.
For each new product category, you will have to repeat all steps 3 - 6.

7. Creating an xml file

You are only a few steps away from the finished XML file.
Create a new text file and change its extension to xml.
Or use the empty xml file that you downloaded along with the rest of the templates.
Download templates and examples for creating a Rozetka XML file
Now go to the Header tab in our Excel file, copy the gray cells and paste them into an empty XML file.
Then go to the Offers tab, scroll right to the gray cells (column BF), copy them and paste them into the XML file between the tags and .
Select the Save As option from the xml file menu. In the window that opens, specify the UTF-8 encoding value.
Your file is ready!

8. Checking and sending

Working with an xml file requires great care and accuracy. Nobody is immune from mistakes.
Check your file for technical flaws before submitting. This can be done through the "XML validator" provided by the socket. Go to the site https://seller. rozetka.com.ua/gomer/pricevalidate/check/index, find the file input box, upload your xml file there. Click the Check or Validate button. The validator will either send you a report to your email.
Do not send the file to the manager until it is correct, because it will not be accepted anyway.
Now all you have to do is upload the XML to your site and inform the Rozetka manager that you are ready for moderation.

9. Subsequent work with the file

After your products are published on Rosette, your actions will be limited to monitoring prices and availability of products.
Change the prices or quantity of products in the xls file, do not forget to change the date and time to the current ones on the Header tab. These cells are marked in green.
Open the xml file, delete all the data and copy the gray cells from the Excel tabs into it again. That is, repeat step 7. Upload the xml file to your site instead of the old one.
You do not need to notify Rosette manager when this data changes, it will be loaded automatically.
Synchronization with Rosette usually occurs every hour. If your changes are not displayed within a few hours, write to Rozetka technical support.