Shoptet Connector
Shoptet is an e-shop management system for the Czech market. Our connector is able to connect to the platform and download data about your orders. Follow this tutorial to see how.

Step 1: Preparation

To be able to download orders from your e-shop and analyse them, you will have to create an XML export of your orders. After you do that, you can then connect the XML static URL to our connector.
To get the URL, login to Shoptet, click on "Objednávky" and on "Export"
On the export page, click on "Vytvořit vlastní typ exportu"
and configure the export like this.
The initial settings of the export quite capacious, so let's split it into two parts - settings of the Order States and configuring the XML.

Order States

‌During the setup process; only check the “Možnosti” check box. Leave “Kód dopravy” and “Stav objednávky” unchecked. This will ensure that the export will contain all the necessary information.

Configuring the XML

The XML only needs to have some required columns for our connector to work, but to avoid any issues, we advise our clients to copy and paste all the following tags into "Tělo XML":
1
<ORDER packageNumber="#packageNumber#">
2
<ORDER_ID>#id#</ORDER_ID>
3
<CODE>#code#</CODE>
4
<DATE>#date#</DATE>
5
<STATUS>#statusName#</STATUS>
6
<CURRENCY>
7
<CODE>#currencyCode#</CODE>
8
<EXCHANGE_RATE>#currencyExchangeRate#</EXCHANGE_RATE>
9
</CURRENCY>
10
<CUSTOMER>
11
<EMAIL>#email#</EMAIL>
12
<PHONE>#phone#</PHONE>
13
<BILLING_ADDRESS>
14
<NAME>#billFullName#</NAME>
15
<COMPANY>#billCompany#</COMPANY>
16
<STREET>#billStreet#</STREET>
17
<HOUSENUMBER>#billHouseNumber#</HOUSENUMBER>
18
<CITY>#billCity#</CITY>
19
<ZIP>#billZip#</ZIP>
20
<COUNTRY>#billCountryName#</COUNTRY>
21
<COMPANY_ID>#billCompanyId#</COMPANY_ID>
22
<VAT_ID>#billVatId#</VAT_ID>
23
<CUSTOMER_IDENTIFICATION_NUMBER>#customerIdentificationNumber#</CUSTOMER_IDENTIFICATION_NUMBER>
24
</BILLING_ADDRESS>
25
<SHIPPING_ADDRESS>
26
<NAME>#deliveryFullName#</NAME>
27
<COMPANY>#deliveryCompany#</COMPANY>
28
<STREET>#deliveryStreet#</STREET>
29
<HOUSENUMBER>#deliveryHouseNumber#</HOUSENUMBER>
30
<CITY>#deliveryCity#</CITY>
31
<ZIP>#deliveryZip#</ZIP>
32
<COUNTRY>#deliveryCountryName#</COUNTRY>
33
</SHIPPING_ADDRESS>
34
<IP_ADDRESS>#customerIpAddress#</IP_ADDRESS>
35
</CUSTOMER>
36
<REMARK>#remark#</REMARK>
37
<SHOP_REMARK>#shopRemark#</SHOP_REMARK>
38
<REFERER><![CDATA[#referer#]]></REFERER>
39
<PACKAGE_NUMBER>#packageNumber#</PACKAGE_NUMBER>
40
<VARCHAR1>#varchar1#</VARCHAR1>
41
<VARCHAR2>#varchar2#</VARCHAR2>
42
<VARCHAR3>#varchar3#</VARCHAR3>
43
<TEXT1>#text1#</TEXT1>
44
<TEXT2>#text2#</TEXT2>
45
<TEXT3>#text3#</TEXT3>
46
<WEIGHT>#weight#</WEIGHT>
47
<TOTAL_PRICE>
48
<WITH_VAT>#totalPriceWithVat#</WITH_VAT>
49
<WITHOUT_VAT>#totalPriceWithoutVat#</WITHOUT_VAT>
50
<VAT>#totalPriceVat#</VAT>
51
<ROUNDING>#totalPriceRounding#</ROUNDING>
52
<PRICE_TO_PAY>#totalPriceToPay#</PRICE_TO_PAY>
53
<PAID>#paid#</PAID>
54
<PURCHACE_PRICE>#orderPurchasePrice#</PURCHACE_PRICE>
55
</TOTAL_PRICE>
56
<SHOP>
57
<projectContactMerchantName>#projectContactMerchantName#</projectContactMerchantName>
58
<projectOwnerIdentificationNumber>#projectOwnerIdentificationNumber#</projectOwnerIdentificationNumber>
59
<projectOwnerCompanyOrFullName>#projectOwnerCompanyOrFullName#</projectOwnerCompanyOrFullName>
60
<projectOwnerCin>#projectOwnerCin#</projectOwnerCin>
61
<projectOwnerTin>#projectOwnerTin#</projectOwnerTin>
62
</SHOP>
63
64
</ORDER>
Copied!
and these to "Tělo XML pro položky objednávky":
1
<ITEM>
2
<TYPE>#orderItemType#</TYPE>
3
<NAME>#orderItemName#</NAME>
4
<AMOUNT>#orderItemAmount#</AMOUNT>
5
<CODE>#orderItemCode#</CODE>
6
<VARIANT_NAME>#orderItemVariantName#</VARIANT_NAME>
7
<MANUFACTURER>#orderItemManufacturer#</MANUFACTURER>
8
<UNIT>#orderItemUnit#</UNIT>
9
<WEIGHT>#orderItemWeight#</WEIGHT>
10
<STATUS>#orderItemStatusName#</STATUS>
11
<DISCOUNT>#orderItemDiscountPercent#</DISCOUNT>
12
<UNIT_PRICE>
13
<WITH_VAT>#orderItemUnitPriceWithVat#</WITH_VAT>
14
<WITHOUT_VAT>#orderItemUnitPriceWithoutVat#</WITHOUT_VAT>
15
<VAT>#orderItemUnitPriceVat#</VAT>
16
<VAT_RATE>#orderItemUnitPriceVatRate#</VAT_RATE>
17
</UNIT_PRICE>
18
<TOTAL_PRICE>
19
<WITH_VAT>#orderItemTotalPriceWithVat#</WITH_VAT>
20
<WITHOUT_VAT>#orderItemTotalPriceWithoutVat#</WITHOUT_VAT>
21
<VAT>#orderItemTotalPriceVat#</VAT>
22
<VAT_RATE>#orderItemTotalPriceVatRate#</VAT_RATE>
23
</TOTAL_PRICE>
24
</ITEM>
Copied!
This prevents you from encountering some unnecessary bugs and errors. After that, you are ready to save the export and continue with authorizing the connector in ROIVENUE.
To get the URL, go to the export page again, select the correct export(by checking the radio button in the list) and you will see it down at the bottom.

Step 2: Authorization of the ROIVENUE connector

Now we have everything ready to finish the authorization. Go to ROIVENUE connectors, choose Shoptet platform and copy-paste the URL to the input field.

Step 3: See the data!

After this step, there is nothing that will stop you from using the connector. The connector will be downloading your data every day, first thing in the morning. Use it to your advantage.
Last modified 2mo ago