Business XML feed (EN)
date of update 6/2020
Pairing
For pairing use: <ID> (<ID_SAPHO> is the old way for pairing valid till 04/2019, this tag will be eliminated in some time)
Price processing
These items are available for you:
<PRICE> the sale price of UBC
<RETAIL_PRICE> the catalog price of UBC
<PROMOTION> the product on special UBC offer
<TYPE_PRICES> categorization/the amount of the discount for the recommended price
How to determine the recommended discount for e-shop?
<PRICE> (sale price of UBC) reduce by value <TYPE_PRICES> according to the table (your dealer will deliver it to you):
Each product is marked <TYPE_PRICES>
Result
Catalog price <RETAIL_PRICE> will be crossed out on your portal
The price for a retail customer will be <PRICE> - <TYPE_PRICES>
Availability
Availability is defined by tag <DELIVERY_DATE> where:
0 = in stock
value bigger than 0 = number of days to the delivery
An example
In stock:
<DELIVERY_DATE>0</DELIVERY_DATE>
Delivery within 12 days:
<DELIVERY_DATE>12</DELIVERY_DATE>
Function
If the value changes daily, goods is on the way
Example:
Today <DELIVERY_DATE>12</DELIVERY_DATE> = Goods to order, delivery within 12 days
Tomorrow <DELIVERY_DATE>11</DELIVERY_DATE> = Goods on the way, in stock within 11 days
The day after tomorrow <DELIVERY_DATE>10</DELIVERY_DATE> = Goods on the way, in stock within 10 days
FEED Business, for fee
Update approx. 60 min
An example:
<SHOPITEM>
<ID>244</ID>
<ID_SAPHO>24</ID_SAPHO>
<PRODUCTNO>1209-04</PRODUCTNO>
<PRODUCT><![CDATA[Dual Bidet/Toilet Angled Valve]]></PRODUCT>
<MANUFACTURER><![CDATA[Sapho]]></MANUFACTURER>
<PRICE>78.00</PRICE>
<PRICE_VAT>94.38</PRICE_VAT>
<RETAIL_PRICE>78.00</RETAIL_PRICE>
<RETAIL_PRICE_VAT>94.38</RETAIL_PRICE_VAT>
<VAT>21.00</VAT>
<CURRENCY>EUR</CURRENCY>
<TYPE_PRICES>1</TYPE_PRICES>
<DESCRIPTION_SHORT><![CDATA[Bidet shower with dvojventilem for water connections for toilet tank.]]></DESCRIPTION_SHORT>
<CATEGORYTEXT><![CDATA[Mixer Taps | Taps | Bidet valves and mixers]]></CATEGORYTEXT>
<IN_STOCK>1</IN_STOCK>
<DELIVERY_DATE>0</DELIVERY_DATE>
<UNIT>ks</UNIT>
<WARRANTY>24</WARRANTY>
<WEIGHT_KG>1.07</WEIGHT_KG>
<EAN>8590913803369</EAN>
<URL>https://eshop.sapho.cz/en/dual-bidet-toilet-angled-valve</URL>
<IMGURL>https://eshop.sapho.cz/img/_/p.244.foto/1209-04-bidetova-sprcha-s-dvojventilem-5-cesta_.jpg?dt=20200630150129</IMGURL>
<DESCRIPTION><![CDATA[<p> Bidet shower with double valve for connection of water to toilet tank (in case of combined toilets) </p><ul><li> Package includes 100 cm shower hose and shower holder </li><li> Double valve material: brass / chrome </li><li> Bidet shower material: ABS / chrome </li></ul><p> The spray stop valve is used to immediately start the water. We recommend closing the bidet shower valve after use. </p>]]></DESCRIPTION>
<IMGURL_ALTERNATIVE>https://eshop.sapho.cz/img/_/p.244.foto/1209-04-bidetova-sprcha-s-dvojventilem-5-cesta_.jpg?dt=20200630150129</IMGURL_ALTERNATIVE>
<IMGURL_ALTERNATIVE>https://eshop.sapho.cz/img/_/p.244.foto/1209-041.jpg?dt=20170221122603</IMGURL_ALTERNATIVE>
<IMGURL_ALTERNATIVE>https://eshop.sapho.cz/img/_/p.244.foto/1209-04-bidetova-sprcha-s-dvojventilem-3.jpg?dt=20200408181747</IMGURL_ALTERNATIVE>
<IMGURL_ALTERNATIVE>https://eshop.sapho.cz/img/_/p.244.foto/1209-04-bidetova-sprcha-s-dvojventilem-2.jpg?dt=20200408181720</IMGURL_ALTERNATIVE>
<IMGURL_ALTERNATIVE>https://eshop.sapho.cz/img/_/p.244.foto/1209-04-bidetova-sprcha-s-dvojventilem-1.jpg?dt=20200408181707</IMGURL_ALTERNATIVE>
<IMGURL_ALTERNATIVE>https://eshop.sapho.cz/img/_/p.244.foto/1188-1.jpg?dt=20190719131226</IMGURL_ALTERNATIVE>
<IMGURL_ALTERNATIVE>https://eshop.sapho.cz/img/_/p.244.foto/24_001.jpg?dt=20140617205948</IMGURL_ALTERNATIVE>
<FILE_ATTACHMENTS>https://eshop.sapho.cz/download/_/p.244/1209-04_tv.pdf?dt=20170111101925</FILE_ATTACHMENTS>
<FILE_DESCRIPTION>Technical drawing</FILE_DESCRIPTION>
<FILE_ATTACHMENTS>https://eshop.sapho.cz/download/_/p.244/1209-04-sprska.pdf?dt=20170111085915</FILE_ATTACHMENTS>
<FILE_DESCRIPTION>Technical drawing</FILE_DESCRIPTION>
<SIMILAR_PRODUCTS_SAPHO_IDS>23014,22679</SIMILAR_PRODUCTS_SAPHO_IDS>
<PARAM_BARVA><![CDATA[Chrome]]></PARAM_BARVA>
<PARAM_MATERIAL><![CDATA[Brass]]></PARAM_MATERIAL>
<PARAM_INSTALACE><![CDATA[Wall]]></PARAM_INSTALACE>
<TARIFF_CODE><![CDATA[84818011]]></TARIFF_CODE>
<PARAM_TVAR><![CDATA[Circular]]></PARAM_TVAR>
</SHOPITEM>
Description:
ID = pairing number
ID_SAPHO = pairing number till 4/2019 (tag will be eliminated)
PRODUCTNO = code of product
PRODUCT = name of product
MANUFACTURER = manufacturer
PRICE = sale price of UBC
PRICE_VAT = sale price of UBC with VAT
RETAIL_PRICE = catalog price of UBC
RETAIL_PRICE_VAT = catalog price of UBC with VAT
VAT = amount of VAT
CURRENCY = code of currency
TYPE_PRICES = classification / the amount of the discount for the recommended price
DESCRIPTION_SHORT = short description of product
SALE = sale / clearance sale
CATEGORYTEXT = tree classification of the product /*Recommended to use only as indicative. It is better to match products to your own system's categories. */
IN_STOCK = in stock = 1 (tag will be eliminated, it is fully replaced with <DELIVERY_DATE>0</DELIVERY DATE>)
DELIVERY_DATE = delivery time in days
MINUMAMOUNT = minimum quantity/multiple that can be ordered (added 4/2020)
UNIT = unit of measurement
WARRANTY = warranty in months
WEIGHT_KG = gross weight of the product
EAN = EAN
TARIF_CODE = customs tariff (added 4/2020)
URL = link to our system / e-shop
IMGURL = main product image
DESCRIPTION = description of product
IMGURL_ALTERNATIVE = more product images
FILE_ATTACHMENTS = product annex
FILE_DESCRIPTION = description of annex
SIMILAR_PRODUCTS_SAPHO_IDS = similar products (there are (<ID>)
ACCESSORIES_SAPHO_IDS = accessories (there are (<ID>)
RECOMMENDED_ACCESSORIES_SAPHO_IDS = recommended to buy (there are (<ID>)
SERIE = the product series in which is the product classified
IMGUL_DRAFTING = pictures of technical drawings (added 12/2019)
TECHLIST = reference to technical sheet (4/2020)
MULTIPLE = more pcs / if the product consists of several parts
VIDEO = videos for products
PROMOTION = special offer
NEW = new release
M_AKCE = Business information, the net price is provided for the products, approx. -60% (added 4/2020)
PROMOTION_NEW = Business information, the introducing price is provided with product, approx. -65% (added 4/2020)
PACK_ITEMS = these are products that are part of a "package" (added 6/2020)
subordinate tag ITEM wraps the package of product (ID = pairing number on the product, AMOUNT = number of products in the package)
An example:
<PACK_ITEMS>
<ITEM>
<ID>21208</ID>
<AMOUNT>1</AMOUNT>
</ITEM>
<ITEM>
<ID>21778</ID>
<AMOUNT>1</AMOUNT>
</ITEM>
</PACK_ITEMS>
Parameters of goods:
Here the parameters are changed in time, they are not stable elements.
Example:
ID PARAM_BARVA
Meaning of ID parameter colour
PARAM_BARVA = parameter colour
PARAM_BARVY = parameter colours
PARAM_DELKA = parameter length
PARAM_DRUH = parameter kind
PARAM_FORMAT = parameter format
PARAM_HLOUBKA = parameter depth
PARAM_HLUK = parameter noisiness
PARAM_CHARAKTER = parameter character
PARAM_INSTALACE = parameter installation
PARAM_INSTALACE_VANY = parameter bath installation
PARAM_KRYTI = parameter cover
PARAM_M2 = parameter M2
PARAM_MATERIAL = parameter material
PARAM_MATERIAL_UMYV = parameter material basin
PARAM_NAPETI = parameter voltage
PARAM_OBJEM = parameter extent
PARAM_OBKLADY_POVRCH_LISTY = parameter tiles, surface, sheets
PARAM_OBKLADY_VYSKA_HRANY_LISTY = parameter tiles, height, edges, sheets
PARAM_ODKLADACI = parameter storage
PARAM_OTERUVZDORNOST = parameter abrasion resistance
PARAM_OVLADANI = parameter control
PARAM_PASEK = parameter strap
PARAM_PATICE = parameter socket
PARAM_POCET_OTVORU = parameter number of openings
PARAM_POUZITI = parameter use
PARAM_POVRCH = parameter surface
PARAM_PREPAD = parameter overflow
PARAM_PREPINAC = parameter switch
PARAM_PRIKON = parameter input
PARAM_PRIPOJENI = parameter connection
PARAM_PRIPOJENI_TOPENI = parameter attachment of heating
PARAM_PRIVOD_VODY = parameter water supply
PARAM_PROFIL = parameter profile
PARAM_PRUMER = parameter diameter
PARAM_PRUMER_ODPAD = parameter diameter of waste
PARAM_PRUMER_POTRUBI = parameter diameter of piping
PARAM_RADIUS = parameter radius
PARAM_ROZMER = parameter dimension
PARAM_ROZTEC = parameter pitch
PARAM_ROZTEC_50MM = parameter pitch 50 mm
PARAM_SERIE2 = parameter series 2
PARAM_SIFON = parameter siphon
PARAM_SIRKA = parameter width
PARAM_SLOUPY = parameter columns
PARAM_STYL = parameter style
PARAM_SVITIVOST = parameter luminosity
PARAM_TARIFF_CODE = parameter tariff code
PARAM_TECHLIST = parameter technical sheet
PARAM_TEPLOTNI_SPAD = parameter temperature downslope
PARAM_TEXTURY = parameter textures
PARAM_THICKNESS = parameter thickness
PARAM_TILE_AMOUNT = parameter tile amount
PARAM_TLOUSTKA_SKLA = parameter thickness of glass
PARAM_TVAR = parameter shape
PARAM_TVAR_TOPENI = parameter shape of heating
PARAM_TVARY = parameter shapes
PARAM_TYP = parameter type
PARAM_TYP_LIMCE = parameter type of collar
PARAM_TYP_OSVETLENI = parameter type of illumination
PARAM_TYP_SKRINKY = parameter type of cabinet
PARAM_TYP_UMYV = parameter type of sink
PARAM_TYP_ZRCADLA = parameter type of mirror
PARAM_UMISTENI = parameter location
PARAM_UPEVNENI = parameter fixing
PARAM_UPRAVA_SKLA = parameter glass modification
PARAM_VICEKUS = parameter multiple
PARAM_VYBAVA = parameter equipment
PARAM_VYKON = parameter output
PARAM_VYPLN = parameter filling
PARAM_VYSKA = parameter height
PARAM_ZAVIT = parameter thread