Shoptet

Shoptet is an e-shop management system for the Czech market. Our connector is able to connect to the platform and download order data. Follow this tutorial to begin using this functionality.

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 connect the static XML URL to our connector.

To get the URL, login to Shoptet, click on "Objednávky" and then on "Export"

On the export page, click on "Vytvořit vlastní typ exportu"

and configure the export as seen in the above picture, on the right.

The initial settings of the export is quite detailed, 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":

<ORDER packageNumber="#packageNumber#">
	<ORDER_ID>#id#</ORDER_ID>
	<CODE>#code#</CODE>
	<DATE>#date#</DATE>
	<STATUS>#statusName#</STATUS>
	<CURRENCY>
		<CODE>#currencyCode#</CODE>
		<EXCHANGE_RATE>#currencyExchangeRate#</EXCHANGE_RATE>
	</CURRENCY>
	<CUSTOMER>
		<EMAIL>#email#</EMAIL>
		<PHONE>#phone#</PHONE>
		<BILLING_ADDRESS>
			<NAME>#billFullName#</NAME>
			<COMPANY>#billCompany#</COMPANY>
			<STREET>#billStreet#</STREET>
			<HOUSENUMBER>#billHouseNumber#</HOUSENUMBER>
			<CITY>#billCity#</CITY>
			<ZIP>#billZip#</ZIP>
			<COUNTRY>#billCountryName#</COUNTRY>
			<COMPANY_ID>#billCompanyId#</COMPANY_ID>
			<VAT_ID>#billVatId#</VAT_ID>
			<CUSTOMER_IDENTIFICATION_NUMBER>#customerIdentificationNumber#</CUSTOMER_IDENTIFICATION_NUMBER>
		</BILLING_ADDRESS>
		<SHIPPING_ADDRESS>
			<NAME>#deliveryFullName#</NAME>
			<COMPANY>#deliveryCompany#</COMPANY>
			<STREET>#deliveryStreet#</STREET>
			<HOUSENUMBER>#deliveryHouseNumber#</HOUSENUMBER>
			<CITY>#deliveryCity#</CITY>
			<ZIP>#deliveryZip#</ZIP>
			<COUNTRY>#deliveryCountryName#</COUNTRY>
		</SHIPPING_ADDRESS>
		<IP_ADDRESS>#customerIpAddress#</IP_ADDRESS>
	</CUSTOMER>
	<REMARK>#remark#</REMARK>
	<SHOP_REMARK>#shopRemark#</SHOP_REMARK>
	<REFERER><![CDATA[#referer#]]></REFERER>
	<PACKAGE_NUMBER>#packageNumber#</PACKAGE_NUMBER>
	<VARCHAR1>#varchar1#</VARCHAR1>
	<VARCHAR2>#varchar2#</VARCHAR2>
	<VARCHAR3>#varchar3#</VARCHAR3>
	<TEXT1>#text1#</TEXT1>
	<TEXT2>#text2#</TEXT2>
	<TEXT3>#text3#</TEXT3>
	<WEIGHT>#weight#</WEIGHT>
	<TOTAL_PRICE>
		<WITH_VAT>#totalPriceWithVat#</WITH_VAT>
		<WITHOUT_VAT>#totalPriceWithoutVat#</WITHOUT_VAT>
		<VAT>#totalPriceVat#</VAT>
		<ROUNDING>#totalPriceRounding#</ROUNDING>
		<PRICE_TO_PAY>#totalPriceToPay#</PRICE_TO_PAY>
		<PAID>#paid#</PAID>
                <PURCHACE_PRICE>#orderPurchasePrice#</PURCHACE_PRICE>
	</TOTAL_PRICE>
        <SHOP>
            <projectContactMerchantName>#projectContactMerchantName#</projectContactMerchantName>
            <projectOwnerIdentificationNumber>#projectOwnerIdentificationNumber#</projectOwnerIdentificationNumber>
            <projectOwnerCompanyOrFullName>#projectOwnerCompanyOrFullName#</projectOwnerCompanyOrFullName>
            <projectOwnerCin>#projectOwnerCin#</projectOwnerCin>
            <projectOwnerTin>#projectOwnerTin#</projectOwnerTin>
        </SHOP>

</ORDER>

and these to "Tělo XML pro položky objednávky":

<ITEM>
	<TYPE>#orderItemType#</TYPE>
	<NAME>#orderItemName#</NAME>
	<AMOUNT>#orderItemAmount#</AMOUNT>
	<CODE>#orderItemCode#</CODE>
	<VARIANT_NAME>#orderItemVariantName#</VARIANT_NAME>
	<MANUFACTURER>#orderItemManufacturer#</MANUFACTURER>
	<UNIT>#orderItemUnit#</UNIT>
	<WEIGHT>#orderItemWeight#</WEIGHT>
	<STATUS>#orderItemStatusName#</STATUS>
	<DISCOUNT>#orderItemDiscountPercent#</DISCOUNT>
	<UNIT_PRICE>
		<WITH_VAT>#orderItemUnitPriceWithVat#</WITH_VAT>
		<WITHOUT_VAT>#orderItemUnitPriceWithoutVat#</WITHOUT_VAT>
		<VAT>#orderItemUnitPriceVat#</VAT>
		<VAT_RATE>#orderItemUnitPriceVatRate#</VAT_RATE>
	</UNIT_PRICE>
	<TOTAL_PRICE>
		<WITH_VAT>#orderItemTotalPriceWithVat#</WITH_VAT>
		<WITHOUT_VAT>#orderItemTotalPriceWithoutVat#</WITHOUT_VAT>
		<VAT>#orderItemTotalPriceVat#</VAT>
		<VAT_RATE>#orderItemTotalPriceVatRate#</VAT_RATE>
	</TOTAL_PRICE>
</ITEM>

This is how your the settings of the XML look like.

This prevents you from encountering some unnecessary bugs and errors. After this, its almost time 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 the Shoptet platform and copy-paste the URL to the input field.

Step 3: See the data!

After this step, continue with the rest of the setup process. Once finished, the connector will be downloading your data every day, first thing in the morning.