Schema Information
Schema Information
Structured details and metadata about the Kaufland connector and its corresponding tables and fields.
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 | 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 | 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 | 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 | 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 | 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
| Field | 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
| Field | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 |