login

Specification of import XML feeds for owlcure mailing

For connecting to owlcure mailing, you need to provide several feeds with customers, products and orders data. Based on these data owlcure mailing is predicting which products could be interesting for users. This specification is the just general interface, for each customer there could be another data which are unique in their custom solution.

Products feed

Contain information about products which will be used in email templates in automatically generated email parts.

We use same XML feed as heureka specified here.

You can add voluntary tags for us.

ADULT

Please add this tag to the items which are not supposed to be imported to app due to possible trouble. In format 1 for adult products and 0 for safe products.

REGULAR_PRICE

To this tag, you can add information about price before sale if the product is discounted.

RETENTION

If the product is usually sold repatetly, you can specify the average interval between orders of one piece of product.

RATING

Average rating of the product. Generally the float number from 0 to 5.

RATING_VOTES

The number of people who rates product.

Users feed

Feed of users is used for sending emails and algorithms counted with users data.

The best way how to create import with users is with random part of the name. There also should be the GET parameter ‘days’ which specified from how many previous days are data downloaded.

For example http://www.mywebsite.com/e3242mads343k-users.php?days=7 should return users who were created or modified in the past week.

USERS

The root element of XML file. Contains all users.

USER

The element contains data for the user.

USER_ID

Unique identification of the user.

NAME

First name and last name of the user.

BIRTH_DATE

Birthdate of the user. In format YYYY-MM-DD.

SEX

Sex of user. In format M or F.

EMAIL

Email address of the user.

CREATED_AT

Date and time when the user was registered to the newsletter. In format YYYY-MM-DD hh:mm:ss.

Example of users xml feed

<?xml version="1.0" encoding="utf-8"?>
<USERS>
 <USER>
  <USER_ID>121</USER_ID>
  <NAME>John Smith</NAME>
  <BIRTH_DATE>1980-03-31</BIRTH_DATE>
  <SEX>M</SEX>
  <EMAIL>john.smith@owlcureexample.com</EMAIL>
  <CREATED_AT>2016-08-28 19:45:15</CREATED_AT>
 </USER>
 <USER>
 ...
 </USER>
</USERS>

Orders feed

Orders feed should contain information about orders for providing enough data to learn our algorithms predict similarities among products.

Best way how to create import with orders is with random part of name. There also should be the GET parameter ‘days’ which specified from how many previous days are data downloaded.

For example http://www.mywebsite.com/e3242mads343k-orders.php?days=7 should return orders who were created or modified in past week.

ORDERS

Root element of XML file. Contains all orders.

ORDER

Element contains data for order.

ORDER_ID

Unique identification of order.

CREATED_AT

Date and time of finished order. In format YYYY-MM-DD hh:mm:ss.

USER_ID

Identification of user who finished order.

ITEMS

Element contains all things in order.

ITEM

Contain one item in order.

ITEM_ID

Identification of item.

PRICE

Price of one piece of item paid in order.

QUANTITY

Number of pieces of item in order.

SALE

Percentage of sale when the item was on sale.

Example of orders feed

<?xml version="1.0" encoding="utf-8"?>
<ORDERS>
 <ORDER>
  <ORDER_ID>521</ORDER_ID>
  <CREATED_AT>2016-08-28 19:45:15</CREATED_AT>
  <USER_ID>10</USER_ID>
  <ITEMS>
   <ITEM>
    <ITEM_ID>25</ITEM_ID>
    <PRICE>599.0</PRICE>
    <QUANTITY>2</QUANTITY>
    <SALE>0.2</SALE>
   </ITEM>
   <ITEM>
    <ITEM_ID>27</ITEM_ID>
    <PRICE>299.0</PRICE>
    <QUANTITY>1</QUANTITY>
    <SALE>0</SALE>
   </ITEM>
  </ITEMS>
 </ORDER>
 <ORDER>
 ...
 </ORDER>
</ORDERS>

Abandoned cart feed

It should be in the similar format like orders feed but only with orders which weren’t finished. It also contains these other elements.

UPDATED_AT

Date and time of last modification of the order. In format YYYY-MM-DD hh:mm:ss.

BASKET_URL

URL where the user can find this unfinished order in his basket.

Example of abandoned cart feed

<?xml version="1.0" encoding="utf-8"?>
<ORDERS>
 <ORDER>
  <ORDER_ID>521</ORDER_ID>
  <CREATED_AT>2016-08-28 19:45:15</CREATED_AT>
  <UPDATED_AT>2016-08-29 16:41:32</UPDATED_AT>
  <USER_ID>10</USER_ID>
  <BASKET_URL>http://www.sampleeshop.com/carts/11d868082aa70da0083</BASKET_URL>
  <ITEMS>
   <ITEM>
    <ITEM_ID>25</ITEM_ID>
    <PRICE>599.0</PRICE>
    <QUANTITY>2</QUANTITY>
    <SALE>0.2</SALE>
   </ITEM>
   <ITEM>
    <ITEM_ID>27</ITEM_ID>
    <PRICE>299.0</PRICE>
    <QUANTITY>1</QUANTITY>
    <SALE>0</SALE>
   </ITEM>
  </ITEMS>
 </ORDER>
 <ORDER>
 ...
 </ORDER>
</ORDERS>