Preparing files for campaign set up
To start an integration you need to submit:
- List of your items in Excel or XML/YML
- List of your competitors
- List of users of your company
- Scanning schedule (days, weeks and time)
Competitors
- Сompetitors list must be attached separately in the email body or added into the file with products as a separate tab (Excel)
- Competitor’s names must contain no extra symbols. It usually consists of the store’s web address, without https or www (example.com.ua)
- In case if category needs to be monitored only for a particular competitor, please submit the list as 'product category' — 'competitor'.
Preparing a product list
There are two ways to send your product list to upload into the system - MS Excel and XML/YML (feed).
Excel |
|
Advantages |
Disadvantages |
an Excel file is easy to form |
each time you want to update or delete a product from the list, you need to send us a new file |
no IT specialist’s assistance required |
difficulties may be experienced in further integration |
XML/YML |
|
assortment updates happen automatically in the campaign according to the estimated schedual |
You may need an IT specialist’s assistance |
prices and stock availability data updates several times faster |
The generation of this file type requires more time |
Preparing a product list in Excel:
- SKU (product ID) should not be duplicated, it is a unique unit for the system
- Product name should not be duplicated and should contain proper information for exact product match (brand name, model name, model code (for electronics), color, etc.)
- If a category contains a subcategory, state both category and subcategory in the same cell, using “>” white space character: Category > Subcategory
- No file units may contain formulas
File format:
SKU (Product ID) |
Product name |
Brand |
Category (>subcategory) |
your website URL |
123456 |
Printer HP Laserjet 892 |
HP |
Office electronics>Printers |
https://example.com/123456 |
234152 |
Nokia 1100 black |
Nokia |
Mobile phones |
https://example.com/234152 |
Preparing product list in XML
XML file is stored on customer’s back-end with an access to it through the link. The customer can update data in such file by himself at any time, request to mentioned file from Competera is sent following the estimated schedule.
Format and file requirements:
Most popular XML-file format is the on that is required by YandexMarket (YML)
Detailed describtion of YML
https://yandex.ru/support/partnermarket/yml/about-yml.xml?ncrnd=7032
For using this file type you need to include in it the following information:
- Availability(available="true"/”false”)
- Price (<price>)
- Name (<name> или <model>)
- Product ID (<offer id=123> или <sku>)
- Category (<categoryId= >)
- URL (<url>)
- Brand (<Vendor> или <brand>
YML structure example
https://yandex.st/market-export/1.0-17/partner/help/YML.xml
<yml_catalog date="2010-04-01 17:00">
<shop>
<name>Magazin</name>
<company>Magazin</company>
<url>http://www.magazin.ru/</url>
<currencies>
<currency id="RUR" rate="1" plus="0"/>
</currencies>
<categories>
<category id="1">Electronics</category>
<category id="10" parentId="1">Printers</category>
<category id="100" parentId="10">Ink jet printer</category>
<category id="101" parentId="10">Laser printer</category>
<category id="2">Phototechnique</category>
<category id="11" parentId="2">Photocameras</category>
<category id="12" parentId="2">Lenses</category>
<category id="3">Books</category>
<category id="13" parentId="3">Detective story</category>
<category id="14" parentId="3">Fiction</category>
<category id="15" parentId="3">Textbooks</category>
<category id="16" parentId="3">Childrens literature</category>
<category id="4">Music and video</category>
<category id="17" parentId="4">Music</category>
<category id="18" parentId="4">Movie</category>
</categories>
<local_delivery_cost>300</local_delivery_cost>
<offers>
<offer id="12341" type="vendor.model" bid="13" cbid="20" available="true">
<url>http://magazin.ru/product_page.asp?pid=14344</url>
<price>15000</price>
<currencyId>RUR</currencyId>
<categoryId type="Own">101</categoryId>
<picture>http://magazin.ru/img/device14344.jpg</picture>
<delivery>true</delivery>
<local_delivery_cost>300</local_delivery_cost>
<typePrefix>Printer</typePrefix>
<vendor>НP</vendor>
<vendorCode>Q7533A</vendorCode>
<model>Color LaserJet 3000</model>
<manufacturer_warranty>true</manufacturer_warranty>
<country_of_origin>Japan</country_of_origin>
</offer>
<offer id="12342" type="book" bid="17" available="true">
<url>http://magazin.ru/product_page.asp?pid=14345</url>
<price>100</price>
<currencyId>RUR</currencyId>
<categoryId type="Own">13</categoryId>
<picture>http://magazin.ru/img/book14345.jpg</picture>
<delivery>true</delivery>
<local_delivery_cost>300</local_delivery_cost>
<author>Ian Russell McEwan</author>
<name>Saturday</name>
<publisher>New York, N.A. Talese, 1999.</publisher>
<series>Arthur Conan Doyle - The Complete Sherlock Holmes</series>
<year>2009</year>
<ISBN>978-5-699-23647-3</ISBN>
<volume>2</volume>
<part>1</part>
<language>eng</language>
<binding>70x90/32</binding>
<page_extent>288</page_extent>
<downloadable>false</downloadable>
</offer>
</offers>
</shop>
</yml_catalog>
Users
To correctly display users in the system, you need to send out the following information: name, surname, email.
Comments
0 comments
Please sign in to leave a comment.