real.de Onlineshop
The table below gives information about all the data fields that you can import from real.de Onlineshop.
To see the fields you can collect from another data source, go back to the Available fields in Adverity overview.
|
Field UI name |
Field API name |
Data Type |
Description |
Use in Adverity |
Docs |
|---|---|---|---|---|---|
|
Amount |
amount |
currency |
The order amount. |
metric |
|
|
Angebotsnummer |
angebotsnummer |
long |
The ID of the offer (i.e. unit) that the purchase was made from. |
dimension |
|
|
Auszahlung Netto |
auszahlung_netto |
currency |
Net price of the item - real.de fee + net shipping cost. |
metric |
|
|
Balance |
balance |
currency |
The real.de account balance. |
metric |
|
|
Bestelldatum |
bestelldatum |
datetime |
The date and time when the order was placed. |
dimension |
|
|
Bestellnummer |
bestellnummer |
string |
The order number. |
dimension |
|
|
Betrag |
betrag |
currency |
The order amount. |
metric |
|
|
Billing Additional Field |
billing.additional_field |
string |
The billing information of the buyer: additional field. |
dimension |
|
|
Billing City |
billing.city |
string |
The billing information of the buyer: city. |
dimension |
|
|
Billing Company Name |
billing.company_name |
string |
The billing information of the buyer: company name. |
dimension |
|
|
Billing Country |
billing.country |
string |
The billing information of the buyer: country. |
dimension |
|
|
Billing First Name |
billing.first_name |
string |
The billing information of the buyer: first name. |
dimension |
|
|
Billing Gender |
billing.gender |
string |
The billing information of the buyer: gender. |
dimension |
|
|
Billing House Number |
billing.house_number |
string |
The billing information of the buyer: house number. |
dimension |
|
|
Billing Last Name |
billing.last_name |
string |
The billing information of the buyer: last name. |
dimension |
|
|
Billing Phone |
billing.phone |
string |
The billing information of the buyer: phone. |
dimension |
|
|
Billing Postcode |
billing.postcode |
long |
The billing information of the buyer: postcode. |
dimension |
|
|
Billing Street |
billing.street |
string |
The billing information of the buyer: street. |
dimension |
|
|
Booking Date |
booking_date |
datetime |
The date and time when the booking was placed |
dimension |
|
|
Booking Text |
booking_text |
string |
The text of the booking. |
dimension |
|
|
Buchungstext |
buchungstext |
string |
The booking text. |
dimension |
|
|
Buyer Email |
buyer.email |
string |
The buyer's email address. |
dimension |
|
|
Buyer ID |
buyer.id_buyer |
long |
The internal ID of the buyer's real.de account. |
dimension |
|
|
Buyer Pseudonym |
buyer.pseudonym |
string |
The name the buyer chose for his or her real.de account. |
dimension |
|
|
Cancel Reason |
cancel_reason |
string |
The reason for cancelling. |
dimension |
|
|
Cancel Source |
cancel_source |
string |
The source of cancelation. |
dimension |
|
|
Cancel Status |
cancel_status |
string |
The status of the cancelation. |
dimension |
|
|
Cancel Timestamp |
cancel_timestamp |
datetime |
The date of the cancellation. |
dimension |
|
|
Changed Attributes |
changed_attributes |
string |
Title and ID of an attribute, which value was changed. |
dimension |
|
|
Comment |
comment |
string |
If you added a note to the offer (i.e. unit), it is listed here. |
dimension |
|
|
Condition |
condition |
long |
The condition of the item (e.g. new or used - very good). |
dimension |
|
|
Count |
count |
long |
How many of the item you have in your inventory. |
metric |
|
|
Date Changed |
date_changed |
datetime |
The date of a value change. |
dimension |
|
|
Datum |
datum |
date |
The date. |
dimension |
|
|
Delivery Time |
delivery_time |
long |
The delivery time code for the purchased item (e.g. 'a' means it ships within 24 hours). |
metric |
|
|
Delivery Time Expires |
delivery_time_expires |
datetime |
When the delivery time ends. You must ship the item by this time. |
dimension |
|
|
Delivery Time Max |
delivery_time_max |
long |
The maximum delivery time class of the item (e.g. a if it ships within 24 hours). |
metric |
|
|
Delivery Time Min |
delivery_time_min |
long |
The minimum delivery time class of the item (e.g. a if it ships within 24 hours). |
metric |
|
|
Ean |
ean |
long |
The EAN of the item. |
dimension |
|
|
Ean |
ean |
long |
The EAN of the purchased item. |
dimension |
|
|
Ean |
ean |
long |
EAN of the offer or product. |
dimension |
|
|
Ean |
ean |
long |
EAN of the product. |
dimension |
|
|
|
|
string |
The email address of the buyer. |
dimension |
|
|
Empfangsdatum |
empfangsdatum |
datetime |
The date and time when the customer confirmed that the order was received. |
dimension |
|
|
Fee % |
fee_% |
percentage |
The real.de fee percentage. |
metric |
|
|
Fee Gross |
fee_gross |
currency |
The gross fee of the item. |
metric |
|
|
Fee Net |
fee_net |
currency |
The real.de fee for the sale. |
metric |
|
|
Fee VAT % |
fee_vat_% |
percentage |
The VAT fee percentage. |
metric |
|
|
Attribute ID |
id_attribute |
long |
The ID of the attribute. |
dimension |
|
|
Item ID |
id_item |
string |
The ID of the purchased item. |
dimension |
|
|
ID Item |
id_item |
long |
Real's Product ID. |
dimension |
|
|
Sales Order ID |
id_sales_order |
long |
The ID of the order unit. |
dimension |
|
|
Ihre UVP brutto |
ihre_uvp_brutto |
currency |
The gross price of the item in Euros, with taxes included. |
metric |
|
|
Ihre UVP Netto |
ihre_uvp_netto |
currency |
The net price of the item in Euros, without taxes included. |
metric |
|
|
Item EANs |
item.EANs |
string |
All EANs for the purchased item. |
dimension |
|
|
Item Produktbezeichnung |
item.Produktbezeichnung |
string |
The title (i.e. name) of the purchased item. |
dimension |
|
|
Item Item ID |
item.id_item |
long |
The internal real ID of the purchased item. |
dimension |
|
|
Land |
land |
string |
The country the buyer lives in. |
dimension |
|
|
Live Value |
live_value |
currency |
Price in EUR |
metric |
|
|
Location |
location |
string |
The location of the item (e.g. DE for Germany). |
dimension |
|
|
Log Message |
log_message |
string |
The log message |
dimension |
|
|
Manufacturer |
manufacturer |
string |
The manufacturer of the item. |
dimension |
|
|
Minimum Price |
minimum_price |
currency |
The minimum price you are willing to sell the item for in Eurocents. |
metric |
|
|
MWSt. |
mwst |
currency |
The amount of VAT for the booking in Euros. |
metric |
|
|
Nachname |
nachname |
string |
The buyer's last name (i.e. surname). |
dimension |
|
|
Attribute Name |
name_attribute |
string |
The name of the attribute. |
dimension |
|
|
Offer ID |
offer_id |
long |
The ID of this offer (i.e. unit). |
dimension |
|
|
Offer ID |
offer_id |
long |
The ID of the offer (i.e. unit) that the purchase was made from. |
dimension |
|
|
Order Date |
order_date |
datetime |
The date and time when the order was placed. |
dimension |
|
|
Order Date |
order_date |
datetime |
The date of the order. |
dimension |
|
|
Order Number |
order_number |
string |
The ID of the order in a more human-friendly form. |
dimension |
|
|
Order Sent Timestamp |
order_sent_timestamp |
datetime |
The date and time when the order was sent. |
dimension |
|
|
Original Value |
original_value |
currency |
Price in EUR |
metric |
|
|
Payment Method |
payment_method |
string |
This field always contains the value Standard. |
dimension |
|
|
Payout |
payout |
currency |
The payout. |
metric |
|
|
Payout Status |
payout_status |
string |
The status of payout. |
dimension |
|
|
Porto Brutto |
porto_brutto |
currency |
The gross shipping cost of the item in Euros, with VAT included. |
metric |
|
|
Porto Netto |
porto_netto |
currency |
The net shipping cost of the item in Euros, without VAT included. |
metric |
|
|
Price |
price |
currency |
The price at which you have listed the item in Eurocents (e.g. 4999). |
metric |
|
|
Price CS |
price_cs |
currency |
The price at which you have listed the item in Euros (e.g. 49,99). |
metric |
|
|
Price Gross |
price_gross |
currency |
The gross price of the item. |
metric |
|
|
Produktbezeichnung |
produktbezeichnung |
string |
The title (i.e. name) of the purchased item. |
dimension |
|
|
Pseudonym |
pseudonym |
string |
The name the buyer chose for his or her real.de account. |
dimension |
|
|
Rabatt in % |
rabbat_in_% |
percentage |
The real.de fee percentage. |
metric |
|
|
Rabbat Netto |
rabbat_netto |
currency |
The real.de fee for the sale in Euros. |
metric |
|
|
Reason |
reason |
string |
Error reason. |
dimension |
|
|
Return Status |
return_status |
string |
The status of returning. |
dimension |
|
|
Revenue Gross |
revenue_gross |
currency |
Your gross revenue for the sale. |
metric |
|
|
Revenue Net |
revenue_net |
currency |
Your net revenue for the sale. |
metric |
|
|
Saldo |
saldo |
currency |
The real.de account balance. |
metric |
|
|
Shipping Additional Field |
shipping.additional_field |
string |
The shipping information of the buyer: additional field. |
dimension |
|
|
Shipping City |
shipping.city |
string |
The shipping information of the buyer: city. |
dimension |
|
|
Shipping Company Name |
shipping.company_name |
string |
The shipping information of the buyer: company name. |
dimension |
|
|
Shipping Country |
shipping.country |
string |
The shipping information of the buyer: country. |
dimension |
|
|
Shipping First Name |
shipping.first_name |
string |
The shipping information of the buyer: first name. |
dimension |
|
|
Shipping Gender |
shipping.gender |
string |
The shipping information of the buyer: gender. |
dimension |
|
|
Shipping House Number |
shipping.house_number |
string |
The shipping information of the buyer: house number. |
dimension |
|
|
Shipping Last Name |
shipping.last_name |
string |
The shipping information of the buyer: last name. |
dimension |
|
|
Shipping Phone |
shipping.phone |
string |
The shipping information of the buyer: phone. |
dimension |
|
|
Shipping Postcode |
shipping.postcode |
long |
The shipping information of the buyer: postcode. |
dimension |
|
|
Shipping Street |
shipping.street |
string |
The shipping information of the buyer: street. |
dimension |
|
|
Shipping Charges |
shipping_charges |
currency |
The shipping rate paid by the customer, in Eurocents. |
metric |
|
|
Shipping Charges Gross |
shipping_charges_gross |
currency |
The gross shipping cost of the item. |
metric |
|
|
Shipping Cost DE |
shipping_cost_DE |
currency |
The shipping cost within Germany listed in Euros (e.g. 4,95). |
metric |
|
|
Shipping Group |
shipping_group |
string |
The name of the shipping group which the item is part of. |
dimension |
|
|
Status |
status |
string |
Status of error. |
dimension |
|
|
Sum Price Gross |
sum_price_gross |
currency |
The sum gross price of the item - price gross + shipping charges gross. |
metric |
|
|
Title |
title |
string |
The title of the product. |
dimension |
|
|
Title Item |
title_item |
string |
The title (i.e. name) of the item. |
dimension |
|
|
Title Item |
title_item |
string |
The title (i.e. name) of the purchased item. |
dimension |
|
|
Type Hook |
type_hook |
string |
Type of the hook. |
dimension |
|
|
Uhrzeit |
uhrzeit |
time |
The time. |
dimension |
|
|
Unit Condition |
unit_condition |
string |
The condition of the item in your inventory (e.g. "new" or "used - very good"). |
dimension |
|
|
Unit Sent Timestamp |
unit_sent_timestamp |
datetime |
The date and time when item was sent. |
dimension |
|
|
Unit Status |
unit_status |
string |
The status of your offer (i.e. unit) that was purchased. |
dimension |
|
|
Vorname |
vorname |
string |
The buyer's first name (i.e. given name). |
dimension |
|
|
Warehouse |
warehouse |
string |
The name of the warehouse where the item is. |
dimension |
|