Connect Your Transactions

Connecting your transaction feed to ROIVENUE enables: gross profit margin evaluation, order delivery status consideration and segmentation of customers according to their lifetime value.

The feed is comprised of data from a user company’s internal systems. Connecting the transaction feed unlocks the steps of the Performance Monitor highlighted below.

Note: Transaction feeds are business unit specific, therefore each property needs to have a separate XML file.

1. Prepare the Structure of the File

For the feed to be readable by ROIVENUE, export the file from your internal system and adjust the elements according to our specifications. Some of the parameters are required and some of them are optional. Choose which parameters you would like to measure based on what's important for your business.

2. Name the File According to Our Naming Convention

Exported XML files have to be named with the following syntax:

oms-extract-orders_{code}_{start-date}-{end-date}.xml

Values inside of {} will be replaced. The file name has to be entirely lower case letters including the XML suffix.

code = business unit code (ask your CSM about your business unit code)

start-date = start date of the period in format yyyyMMdd

end-date = end date of the period in format yyyyMMdd

3. Upload the File to Our Azure Storage

Upload an XML file to Azure file storage using the HTTP PUT method to the url address generated by ROIVENUE.

URL for file import : https://roiimportexample.file.core.windows.net/

Example URL including file name: content-disposition: inline;filename=oms-extract-orders_examplecom_20170228-20170328.xml

After this initial load of historic data, the feed should be uploaded to our Azure Storage every day. The file has to contain updated orders for the last 13 weeks. This is used to update delivery status for existing orders. Beware of summer time changes. Changes in older orders will be ignored.