Database sync

Specification for product and stock synchronization

Overview

The products and categories are delivered in XML format. This is a data file of larger size, the generation of which is resource demanding therefore you should run it maximum once per day, preferably during the night and early morning hours (23:00 - 05:00).

Endpoint: https://apiv4.erotikamarket.hu/apiv1/products_export_xml

Authentication: HTTP Basic Authentication using your wholesale access credentials (email + password) for erotikamarket.eu

Important: The program must be created in a way that it should delete those products from the web store, the item number of which is NO longer included in the XML feed (handling of discontinued products).

Note: Prior to the synchronization, send the IP address of your server to info@erotikamarket.eu so that we could authorize your access.

XML Structure

Example

<document>
  <categoryList>
    <category>
      <id>852</id>
      <parent_id>865</parent_id>
      <name>Műpopsi</name>
    </category>
    <category>
      <id>853</id>
      <parent_id>865</parent_id>
      <name>Műszáj maszturbátor</name>
    </category>
  </categoryList>
  <products>
    <product>
      <partnumber>23400621111</partnumber>
      <common>23400621111</common>
      <subcounter>2</subcounter>
      <name>
        <hun>NO:XQSE - Csipke harisnyatartó szett - fekete</hun>
        <de>NO:XQSE - Schwarzes Spitzen-Strumpfhalterset</de>
        <en>NO:XQSE - Lace Garter Belt Set - Black</en>
        <sk>NO:XQSE - Čipkovaný podväzkový set - čierny</sk>
        <ro>NO:XQSE - Set portjartier dantelat - negru</ro>
        <cz>NO:XQSE - Krajkový podvazkový set - černý</cz>
      </name>
      <type>main</type>
      <subtype>S/M</subtype>
      <EAN>4024144026531</EAN>
      <shipping_date>[null]</shipping_date>
      <unit_qt>0</unit_qt>
      <unit></unit>
      <prices>
        <ar1>5110.236</ar1>
        <ar2>5060</ar2>
        <ar3>11.057</ar3>
        <ar4>0</ar4>
        <ar5>0</ar5>
        <ar6>12.5</ar6>
        <ar7>270.248</ar7>
        <akcios_ar>0</akcios_ar>
      </prices>
      <descriptions>
        <de>Product HTML description in German</de>
        <en>Product HTML description in English</en>
        <sk>Product HTML description in Slovakian</sk>
        <ro>Product HTML description in Romanian</ro>
        <cz>Product HTML description in Czech</cz>
      </descriptions>
      <product_category>
        <category>691</category>
      </product_category>
      <image modif="2024-11-06T21:28:26.000000Z">https://static.erotikamarket.hu/kepek/n_23400621111.jpg</image>
      <images>
        <image modif="2024-11-16T12:58:45.000000Z">https://static.erotikamarket.hu/kepek/n_23400621111-2.jpg</image>
        <image modif="2024-11-17T20:36:21.000000Z">https://static.erotikamarket.hu/kepek/n_23400621111-3.jpg</image>
      </images>
      <stock>2</stock>
      <property_list>
        <jell_1>4024144026531</jell_1>
        <jell_2>07704000000,92675700005</jell_2>
        ...
      </property_list>
    </product>
  </products>
</document>

Field	Description
`name`	Name of the category
`id`	Its identifier (always unique). The ID 81 means the grandparent category, which has no separate name.
`parent_id`	Identifier of parent category. Important: categories can change in the future (deletion, rename, creation) therefore it must be integrated dynamically.

Products

Basic Product Information

Field	Description
`partnumber`	Item number of the product
`common`	Item number that links the sub products. The item number of the main product is the common of the sub products (e.g. different sizes of clothes).
`type`	Product type: `main` / `sub`
`subtype`	Name of the sub product (e.g. S/M/L/XL/XXL)
`EAN`	The barcode of the product
`shipping_date`	If the product is not in store, its arrival is expected in this number of weeks. If `false`, we have no information on shipping, the product is not available.
`unit`	Quantitative unit for the unit price
`unit_qt`	The quantity of the product (ml/dl/g) for the unit price. Formula: `(ar1 / unit_qt) * 1.27 = unit price`
`stock`	Number of items currently in stock
`subcounter`	`1` = The product has no options (individual product) `2+` = The product has options and we provide the exact item number

Prices

Field	Description
`ar1`	Net retail price in HUF
`ar2`	Net wholesale base price in HUF (partner's discount is deducted from this)
`ar3`	Net retail price in EUR
`ar4`	Net retail promotional price in EUR
`ar5`	Fixed net wholesale price in HUF (for exceptional products; same price for all partners, no discount applied)
`ar6`	Net wholesale price in EUR (partner's discount is deducted from this)
`ar7`	Net retail price in CZK
`akcios_ar`	Net retail promotional price in HUF

Product Names

Field	Description
`name/hun`	Hungarian name of the product
`name/de`	German name of the product
`name/en`	English name of the product
`name/sk`	Slovak name of the product
`name/ro`	Romanian name of the product
`name/cz`	Czech name of the product

Product Descriptions

Field	Description
`descriptions/hun`	Hungarian description of the product
`descriptions/de`	German description of the product
`descriptions/en`	English description of the product
`descriptions/sk`	Slovak description of the product
`descriptions/ro`	Romanian description of the product
`descriptions/cz`	Czech description of the product

Categories & Images

Field	Description
`product_category`	Categories in which the product is listed. Note: It can happen that there will be a category ID which is not included in the category list. In this case, it must be disregarded (e.g. seasonal categories).
`image`	The main image of the product. Pay attention to the `modif` parameter - only download images when this changes. Every partner stores the images on their own server.
`images`	Additional images of the product. Same characteristics as the main image.

Image Handling: Please DO NOT download all images every time, only if the modif parameter changes. This saves bandwidth and server resources.