Kaufland: Most-used fields#
The table below gives information about most-used fields that you can import from Kaufland. Other fields might also be available in Adverity.
The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.
API name |
Adverity UI name |
Description |
Use in Adverity |
|---|---|---|---|
billing.city |
billing.city |
The city of the billing address for the order. |
dimension |
billing.company_name |
billing.company_name |
The company name associated with the billing address. |
dimension |
billing.country |
billing.country |
The country of the billing address for the order. |
dimension |
billing.first_name |
billing.first_name |
The first name of the recipient at the billing address. |
dimension |
billing.gender |
billing.gender |
The gender of the customer associated with a billing record or order. |
dimension |
billing.house_number |
billing.house_number |
The house number of the billing address. |
metric |
billing.last_name |
billing.last_name |
The last name of the recipient at the billing address. |
dimension |
billing.phone |
billing.phone |
The phone number associated with the billing address. |
dimension |
billing.postcode |
billing.postcode |
The postal code of the billing address. |
metric |
billing.street |
billing.street |
The street name of the billing address. |
dimension |
buyer.email |
buyer.email |
The email address of the buyer. |
dimension |
buyer.id_buyer |
buyer.id_buyer |
The unique identifier for the buyer. |
metric |
date |
date |
The date when the order was created. |
dimension |
delivery_time_expires |
delivery_time_expires |
The date and time when the delivery timeframe for the order expires. |
dimension |
delivery_time_max |
delivery_time_max |
The maximum estimated date and time for the delivery of the order. |
metric |
delivery_time_min |
delivery_time_min |
The minimum estimated date and time for the delivery of the order. |
metric |
id_sales_order |
id_sales_order |
The unique identifier for a sales order. |
metric |
item.EANs |
item.EANs |
European Article Number (EAN) or International Article Number (IAN) associated with a product item. |
metric |
item.id_item |
item.id_item |
A unique identifier for an item or product sold on the Kaufland marketplace. |
metric |
offer_id |
offer_id |
Unique identifier for a specific offer or unit listed by a seller. |
dimension |
order_number |
order_number |
The unique order number or identifier for a sales order. |
dimension |
payment_method |
payment_method |
The method used by the customer to pay for the order, such as credit card, PayPal, or invoice. This field is typically found within order or sales reports. |
dimension |
price |
price |
The selling price of the individual product item or unit. |
metric |
revenue_gross |
revenue_gross |
The total gross revenue generated from the sale, including taxes and other charges. |
metric |
revenue_net |
revenue_net |
The net revenue generated from sales or bookings, excluding taxes, discounts, or returns. |
metric |
shipping.city |
shipping.city |
The city of the shipping address for the order. |
dimension |
shipping.company_name |
shipping.company_name |
The company name associated with the shipping address. |
dimension |
shipping.country |
shipping.country |
The country of the shipping address for the order. |
dimension |
shipping.first_name |
shipping.first_name |
The first name of the recipient at the shipping address. |
dimension |
shipping.house_number |
shipping.house_number |
The house number of the shipping address. |
metric |
shipping.last_name |
shipping.last_name |
The last name of the recipient at the shipping address. |
dimension |
shipping.phone |
shipping.phone |
The phone number associated with the shipping address. |
dimension |
shipping.postcode |
shipping.postcode |
The postal code of the shipping address. |
metric |
shipping.street |
shipping.street |
The street name of the shipping address. |
dimension |
shipping_charges |
shipping_charges |
The cost charged to the customer for shipping the order. This field is generally part of order details or sales reports, related to ‘Orders’, ‘Order Units’, or ‘Shipments’ endpoints. |
metric |
unit_condition |
unit_condition |
The condition of the product unit, such as new or used. |
dimension |
unit_status |
unit_status |
The current status of the product unit, indicating its availability or state on the marketplace. |
dimension |