Schema Information

Structured details and metadata about the Kaufland connector and its corresponding tables and fields.

List of Tables/APIs

• accountListingWithShopPrice

• attributes

• bookingsNew

• cancellations

• carriers

• categories

• competitorsComparer

• eansNotFound

• orderInvoices

• orderUnits

• orders

• productDataChanges

• returnUnits

• returns

• salesNew

• shippingGroups

• ticketMessages

• tickets

• warehouses

accountListingWithShopPrice

Purpose: Lists all of the shop items along with their prices that are currently for sale on Kaufland Global Marketplace.

Source API Documentation: Kaufland- accountListingWithShopPrice

FIELDS

Field Name	Data Type
title_item	STRING
ean	STRING
condition	STRING
price	STRING
shop_price	STRING
comment	STRING
offer_id	STRING
location	STRING
count	STRING
delivery_time_min	STRING
delivery_time_max	STRING
minimum_price	STRING
price_cs	STRING
warehouse	STRING
shipping_group	STRING
shipping_cost_DE	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

attributes

Purpose: Retrieve product data that are currently for sale on Kaufland Global Marketplace through their attribute id or names.

Source API Documentation: Kaufland- attributes

FIELDS

Field Name	Data Type
id	INTEGER
name	STRING
title	STRING
explanation	STRING
is_multiple	BOOLEAN
seller_instructions	STRING
is_sharedset	BOOLEAN
type	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

bookingsNew

Purpose: Lists all of the bookings specified in a timeframe on Kaufland Global Marketplace.

Source API Documentation: Kaufland- bookingsNew

FIELDS

Field Name	Data Type
booking_date	DATETIME
booking_text	STRING
order_date	DATETIME
order_number	STRING
amount	STRING
balance	STRING
price_gross	STRING
shipping_charges_gross	STRING
sum_price_gross	STRING
fee__	STRING
fee_net	STRING
fee_vat__	STRING
fee_gross	STRING
payout	STRING
ean	STRING
id_item	STRING
title_item	STRING
offer_id	STRING
unit_condition	STRING
delivery_time_min	STRING
delivery_time_max	STRING
note	STRING
unit_sent_timestamp	DATETIME
delivery_time_expires	DATETIME
buyer_id_buyer	STRING
buyer_email	STRING
pseudonym	STRING
shipping_first_name	STRING
shipping_last_name	STRING
shipping_gender	STRING
shipping_company_name	STRING
shipping_street	STRING
shipping_house_number	STRING
shipping_additional_field	STRING
shipping_postcode	STRING
shipping_city	STRING
shipping_country	STRING
shipping_phone	STRING
billing_first_name	STRING
billing_last_name	STRING
billing_gender	STRING
billing_company_name	STRING
billing_street	STRING
billing_house_number	STRING
billing_additional_field	STRING
billing_postcode	STRING
billing_city	STRING
billing_country	STRING

cancellations

Purpose: Lists all orders in the canceled state on Kaufland Global Marketplace.

Source API Documentation: Kaufland- cancellations

FIELDS

Field Name	Data Type
cancel_timestamp	DATETIME
order_date	DATETIME
cancel_reason	STRING
ean	STRING
manufacturer	STRING
title_item	STRING
order_number	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

carriers

Purpose: Retrieve the data of the carriers transporting a product for a Kaufland Seller.

Source API Documentation: Kaufland- carriers

FIELDS

Field Name	Data Type
name	STRING
isHauler	BOOLEAN
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

categories

Purpose: Retrieve product categories and their relationships, fields, and values that are currently listed on Kaufland Global Marketplace. Also retrieves the category id and specific search terms data for listed products.

Source API Documentation: Kaufland- categories

FIELDS

Field Name	Data Type
data	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

competitorsComparer

Purpose: Lists all of the listed items along with the cheapest price of each item on Kaufland Global Marketplace.

Source API Documentation: Kaufland- competitorsComparer

FIELDS

Field Name	Data Type
EAN	STRING
Offer_id	STRING
Titel	STRING
G_nstigster_Gesamtpreis_neu	STRING
G_nstigster_Gesamtpreis_gebraucht	STRING
Ihr_Gesamtpreis	STRING
Differenz_zu_neu_absolut	STRING
Differenz_zu_neu__	STRING
Differenz_zu_gebraucht_absolut	STRING
Differenz_zu_gebraucht__	STRING
Zustand_des_Angebots	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

eansNotFound

Purpose: Lists all EANs of the Kaufland Seller, for that no or not enough product data was provided.

Source API Documentation: Kaufland- eansNotFound

FIELDS

Field Name	Data Type
ean	STRING
reason	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

orderInvoices

Purpose: Retrieve the data order invoice, order id, and invoice id data of the products listed for a Kaufland Seller.

Source API Documentation: Kaufland- orderInvoices

FIELDS

Field Name	Data Type
id_invoice	INTEGER
id_order	STRING
original_name	STRING
mime_type	STRING
url	STRING
ts_created_iso	TIMESTAMP
storefront	STRING
is_marketplace_deemed_supplier	BOOLEAN
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

orderUnits

Purpose: Retrieve the order units, unit id, canceled unit, and fulfillment status data of a unit listed on a Kaufland Seller.

Source API Documentation: Kaufland- orderUnits

FIELDS

Field Name	Data Type
id_order_unit	NUMERIC
id_order	STRING
ts_created_iso	TIMESTAMP
is_marketplace_deemed_supplier	BOOLEAN
fulfillment_type	STRING
ts_updated_iso	TIMESTAMP
status	STRING
price	INTEGER
id_offer	STRING
revenue_gross	INTEGER
revenue_net	INTEGER
unit_condition	STRING
storefront	STRING
currency	STRING
delivery_time_min	INTEGER
delivery_time_max	INTEGER
delivery_time_expires_iso	TIMESTAMP
shipping_rate	INTEGER
product	RECORD
buyer	RECORD
billing_address	RECORD
shipping_address	RECORD
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC
note	STRING
order_received_timestamp_iso	TIMESTAMP
cancel_reason	STRING

orders

Purpose: Retrieve the order details and order id of a product listed on a Kaufland Seller.

Source API Documentation: Kaufland- orders

FIELDS

Field Name	Data Type
order_units_count	INTEGER
ts_units_updated_iso	TIMESTAMP
id_order	STRING
ts_created_iso	TIMESTAMP
is_marketplace_deemed_supplier	BOOLEAN
storefront	STRING
fulfillment_type	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

productDataChanges

Purpose: Retrieves a list of all the import files for a Kaufland Seller.

Source API Documentation: Kaufland- productDataChanges

FIELDS

Field Name	Data Type
ean	STRING
title	STRING
changed_attributes	STRING
date_changed	DATETIME
id_item	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

returnUnits

Purpose: Retrieves the return units, unit id, reject unit, and fulfillment status data of a return unit for a Kaufland Seller.

Source API Documentation: Kaufland- returnUnits

FIELDS

Field Name	Data Type
id_return	INTEGER
id_return_unit	INTEGER
id_order_unit	NUMERIC
ts_created_iso	TIMESTAMP
status	STRING
note	STRING
reason	STRING
storefront	STRING
fulfillment_type	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

returns

Purpose: Retrieve the return order details and return id of a unit listed on a Kaufland Seller.

Source API Documentation: Kaufland- returns

FIELDS

Field Name	Data Type
id_return	INTEGER
ts_created_iso	TIMESTAMP
ts_updated_iso	TIMESTAMP
storefront	STRING
tracking_provider	STRING
tracking_code	STRING
status	STRING
fulfillment_type	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

salesNew

Purpose: Lists all of the bookings specified in a timeframe on Kaufland Global Marketplace.

Source API Documentation: Kaufland- salesNew

FIELDS

Field Name	Data Type
date_inserted	DATETIME
order_number	STRING
id_order_unit	STRING
ean	STRING
id_item	STRING
title_item	STRING
offer_id	STRING
price	STRING
shipping_charges	STRING
unit_condition	STRING
delivery_time_min	STRING
delivery_time_max	STRING
note	STRING
unit_status	STRING
cancel_status	STRING
return_status	STRING
payout_status	STRING
order_sent_timestamp	DATETIME
cancel_timestamp	STRING
cancel_reason	STRING
cancel_source	STRING
delivery_time_expires	DATETIME
buyer_id_buyer	STRING
buyer_email	STRING
buyer_pseudonym	STRING
shipping_first_name	STRING
shipping_last_name	STRING
shipping_gender	STRING
shipping_company_name	STRING
shipping_street	STRING
shipping_house_number	STRING
shipping_additional_field	STRING
shipping_postcode	STRING
shipping_city	STRING
shipping_country	STRING
shipping_phone	STRING
billing_first_name	STRING
billing_last_name	STRING
billing_gender	STRING
billing_company_name	STRING
billing_street	STRING
billing_house_number	STRING
billing_additional_field	STRING
billing_postcode	STRING
billing_city	STRING
billing_country	STRING
billing_phone	STRING
is_marketplace_deemed_supplier	STRING

shippingGroups

Purpose: Retrieve the shipping groups data and shipping group id of a Kaufland Seller.

Source API Documentation: Kaufland- shippingGroups

FIELDS

Field Name	Data Type
currency	STRING
id_shipping_group	INTEGER
name	STRING
is_default	BOOLEAN
type	STRING
storefront	STRING
regions	RECORD
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

ticketMessages

Purpose: Retrieve a list of the ticket messages or for a specific ticket for a Kaufland Seller.

Source API Documentation: Kaufland- ticketMessages

FIELDS

Field Name	Data Type
id_ticket_message	INTEGER
id_ticket	STRING
author	RECORD
text	STRING
ts_created_iso	TIMESTAMP
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

tickets

Purpose: Retrieve the list of tickets and their status on a Kaufland Seller account.

Source API Documentation: Kaufland- ticket

FIELDS

Field Name	Data Type
id_ticket	STRING
ids_order_units	STRING
id_buyer	INTEGER
ts_created_iso	TIMESTAMP
ts_updated_iso	TIMESTAMP
status	STRING
open_reason	STRING
topic	STRING
is_seller_responsible	BOOLEAN
fulfillment_type	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

warehouses

Purpose: Retrieve the list of warehouses and their status on a Kaufland Seller account.

Source API Documentation: Kaufland- warehouses

FIELDS

Field Name	Data Type
id_warehouse	INTEGER
name	STRING
address	RECORD
is_default	BOOLEAN
type	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC