Shoptet
How to build the Shoptet order export and connect it to Roivenue, which XML tags the connector reads, and how orders, revenue and profit are calculated.
Shoptet is an e-shop platform used mainly in the Czech market. The Roivenue connector reads order data from a custom XML export that you create in Shoptet, so most of the setup happens on the Shoptet side. Unlike the advertising connectors, it brings transactions rather than campaign performance.
Setting up the connector
1. Create a custom order export
In Shoptet, open Objednávky, then Export, and choose Vytvořit vlastní typ exportu.


2. Set the order states
Tick only Možnosti. Leave Kód dopravy and Stav objednávky unticked, so the export carries everything the connector needs without extra grouping.

3. Paste the XML bodies
Into Tělo XML:
Into Tělo XML pro položky objednávky:

4. Copy the export URL
Save the export, go back to the export page, select it in the list, and copy the URL shown at the bottom. This URL is static, so it keeps working once the connector is set up.

5. Authorise the connector in Roivenue
Add a Shoptet connector in Roivenue and paste the export URL into the field.

What the default setup downloads
The connector walks the export for each ORDER element and builds one row per order.
orderId
ORDER_ID
webId
CODE
orderedAt
DATE
status
STATUS
currencyCode
CURRENCY/CODE
userId
CUSTOMER/EMAIL, hashed
total
TOTAL_PRICE/WITH_VAT
revenue
TOTAL_PRICE/WITHOUT_VAT
tax
TOTAL_PRICE/VAT
profit
TOTAL_PRICE/WITHOUT_VAT minus TOTAL_PRICE/PURCHACE_PRICE
delivered
derived from STATUS, see below
The connector also reads SHOP/projectOwnerCompanyOrFullName, SHOP/projectOwnerCin, SHOP/projectOwnerTin, CUSTOMER/CUSTOMER_IDENTIFICATION_NUMBER, TOTAL_PRICE/PAID and the order's packageNumber.
Things worth knowing about these figures
Revenue is the amount without VAT, while total is the amount with VAT. Reports built on revenue will not match a Shoptet screen showing gross totals.
Customer e-mail addresses are hashed before they are stored, so orders can be tied to the same customer over time without Roivenue holding the address itself.
Amounts are parsed using Czech number formatting, so the export has to use a decimal comma.
When the data refreshes
The job reprocesses the last 90 days on every run, so late changes to an order, including a status moving to Vyřízena weeks after the sale, are picked up.
Troubleshooting
Was this helpful?