---
description: >-
  Structured details and metadata about the Kaufland connector and its
  corresponding tables and fields.
---

# Schema Information

List of Tables/APIs

* [accountListingWithShopPrice](#accountlistingwithshopprice)
* [attributes](#attributes)
* [bookingsNew](#bookingsnew)
* [cancellations](#cancellations)
* [carriers](#carriers)
* [categories](#categories)
* [competitorsComparer](#competitorscomparer)
* [eansNotFound](#eansnotfound)
* [orderInvoices](#orderinvoices)
* [orderUnits](#orderinvoices)
* [orders](#orders)
* [productDataChanges](#productdatachanges)
* [returnUnits](#returnunits)
* [returns](#returns)
* [salesNew](#salesnew)
* [shippingGroups](#shippinggroups)
* [ticketMessages](#ticketmessages)
* [tickets](#tickets)
* [warehouses](#warehouses)

#### accountListingWithShopPrice&#x20;

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](https://sellerapi.kaufland.com/?page=endpoints#/Reports/RequestAccountListingWithShopPriceReport)

**FIELDS**

<table><thead><tr><th width="153">Field Name</th><th width="71">Data Type</th></tr></thead><tbody><tr><td>title_item</td><td>STRING</td></tr><tr><td>ean</td><td>STRING</td></tr><tr><td>condition</td><td>STRING</td></tr><tr><td>price</td><td>STRING</td></tr><tr><td>shop_price</td><td>STRING</td></tr><tr><td>comment</td><td>STRING</td></tr><tr><td>offer_id</td><td>STRING</td></tr><tr><td>location</td><td>STRING</td></tr><tr><td>count</td><td>STRING</td></tr><tr><td>delivery_time_min</td><td>STRING</td></tr><tr><td>delivery_time_max</td><td>STRING</td></tr><tr><td>minimum_price</td><td>STRING</td></tr><tr><td>price_cs</td><td>STRING</td></tr><tr><td>warehouse</td><td>STRING</td></tr><tr><td>shipping_group</td><td>STRING</td></tr><tr><td>shipping_cost_DE</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### attributes &#x20;

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

Source API Documentation: [Kaufland- attributes](https://sellerapi.kaufland.com/?page=endpoints#/Attributes)

**FIELDS**

<table><thead><tr><th width="153">Field Name</th><th width="71">Data Type</th></tr></thead><tbody><tr><td>id</td><td>INTEGER</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>title</td><td>STRING</td></tr><tr><td>explanation</td><td>STRING</td></tr><tr><td>is_multiple</td><td>BOOLEAN</td></tr><tr><td>seller_instructions</td><td>STRING</td></tr><tr><td>is_sharedset</td><td>BOOLEAN</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### bookingsNew&#x20;

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

Source API Documentation: [Kaufland- bookingsNew](https://sellerapi.kaufland.com/?page=endpoints#/Reports/RequestNewBookingsReport)

**FIELDS**

<table><thead><tr><th width="168">Field Name</th><th width="72">Data Type</th></tr></thead><tbody><tr><td>booking_date</td><td>DATETIME</td></tr><tr><td>booking_text</td><td>STRING</td></tr><tr><td>order_date</td><td>DATETIME</td></tr><tr><td>order_number</td><td>STRING</td></tr><tr><td>amount</td><td>STRING</td></tr><tr><td>balance</td><td>STRING</td></tr><tr><td>price_gross</td><td>STRING</td></tr><tr><td>shipping_charges_gross</td><td>STRING</td></tr><tr><td>sum_price_gross</td><td>STRING</td></tr><tr><td>fee__</td><td>STRING</td></tr><tr><td>fee_net</td><td>STRING</td></tr><tr><td>fee_vat__</td><td>STRING</td></tr><tr><td>fee_gross</td><td>STRING</td></tr><tr><td>payout</td><td>STRING</td></tr><tr><td>ean</td><td>STRING</td></tr><tr><td>id_item</td><td>STRING</td></tr><tr><td>title_item</td><td>STRING</td></tr><tr><td>offer_id</td><td>STRING</td></tr><tr><td>unit_condition</td><td>STRING</td></tr><tr><td>delivery_time_min</td><td>STRING</td></tr><tr><td>delivery_time_max</td><td>STRING</td></tr><tr><td>note</td><td>STRING</td></tr><tr><td>unit_sent_timestamp</td><td>DATETIME</td></tr><tr><td>delivery_time_expires</td><td>DATETIME</td></tr><tr><td>buyer_id_buyer</td><td>STRING</td></tr><tr><td>buyer_email</td><td>STRING</td></tr><tr><td>pseudonym</td><td>STRING</td></tr><tr><td>shipping_first_name</td><td>STRING</td></tr><tr><td>shipping_last_name</td><td>STRING</td></tr><tr><td>shipping_gender</td><td>STRING</td></tr><tr><td>shipping_company_name</td><td>STRING</td></tr><tr><td>shipping_street</td><td>STRING</td></tr><tr><td>shipping_house_number</td><td>STRING</td></tr><tr><td>shipping_additional_field</td><td>STRING</td></tr><tr><td>shipping_postcode</td><td>STRING</td></tr><tr><td>shipping_city</td><td>STRING</td></tr><tr><td>shipping_country</td><td>STRING</td></tr><tr><td>shipping_phone</td><td>STRING</td></tr><tr><td>billing_first_name</td><td>STRING</td></tr><tr><td>billing_last_name</td><td>STRING</td></tr><tr><td>billing_gender</td><td>STRING</td></tr><tr><td>billing_company_name</td><td>STRING</td></tr><tr><td>billing_street</td><td>STRING</td></tr><tr><td>billing_house_number</td><td>STRING</td></tr><tr><td>billing_additional_field</td><td>STRING</td></tr><tr><td>billing_postcode</td><td>STRING</td></tr><tr><td>billing_city</td><td>STRING</td></tr><tr><td>billing_country</td><td>STRING</td></tr></tbody></table>

#### cancellations &#x20;

Purpose: Lists all orders in the canceled state on Kaufland Global Marketplace.&#x20;

Source API Documentation: [Kaufland- cancellations](https://sellerapi.kaufland.com/?page=endpoints#/Reports/RequestCancellationsReport)

**FIELDS**

<table><thead><tr><th width="153">Field Name</th><th width="72">Data Type</th></tr></thead><tbody><tr><td>cancel_timestamp</td><td>DATETIME</td></tr><tr><td>order_date</td><td>DATETIME</td></tr><tr><td>cancel_reason</td><td>STRING</td></tr><tr><td>ean</td><td>STRING</td></tr><tr><td>manufacturer</td><td>STRING</td></tr><tr><td>title_item</td><td>STRING</td></tr><tr><td>order_number</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### carriers &#x20;

Purpose: Retrieve the data of the carriers transporting a product for a Kaufland Seller.&#x20;

Source API Documentation: [Kaufland- carriers](https://sellerapi.kaufland.com/?page=endpoints#/Carriers/GetCarriers)

**FIELDS**

<table><thead><tr><th width="153">Field Name</th><th width="71">Data Type</th></tr></thead><tbody><tr><td>name</td><td>STRING</td></tr><tr><td>isHauler</td><td>BOOLEAN</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### categories &#x20;

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](https://sellerapi.kaufland.com/?page=endpoints#/Categories)

**FIELDS**

<table><thead><tr><th width="153">Field Name</th><th width="71">Data Type</th></tr></thead><tbody><tr><td>data</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### competitorsComparer &#x20;

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

Source API Documentation: [Kaufland- competitorsComparer](https://sellerapi.kaufland.com/?page=endpoints#/Reports/RequestCompetitorsComparerReport)

**FIELDS**

<table><thead><tr><th width="238">Field Name</th><th width="71">Data Type</th></tr></thead><tbody><tr><td>EAN</td><td>STRING</td></tr><tr><td>Offer_id</td><td>STRING</td></tr><tr><td>Titel</td><td>STRING</td></tr><tr><td>G_nstigster_Gesamtpreis_neu</td><td>STRING</td></tr><tr><td>G_nstigster_Gesamtpreis_gebraucht</td><td>STRING</td></tr><tr><td>Ihr_Gesamtpreis</td><td>STRING</td></tr><tr><td>Differenz_zu_neu_absolut</td><td>STRING</td></tr><tr><td>Differenz_zu_neu__</td><td>STRING</td></tr><tr><td>Differenz_zu_gebraucht_absolut</td><td>STRING</td></tr><tr><td>Differenz_zu_gebraucht__</td><td>STRING</td></tr><tr><td>Zustand_des_Angebots</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### eansNotFound &#x20;

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

Source API Documentation: [Kaufland- eansNotFound](https://sellerapi.kaufland.com/?page=endpoints#/Reports/RequestEansNotFoundReport)

**FIELDS**

<table><thead><tr><th width="153">Field Name</th><th width="71">Data Type</th></tr></thead><tbody><tr><td>ean</td><td>STRING</td></tr><tr><td>reason</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### orderInvoices &#x20;

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

Source API Documentation: Kaufland- [orderInvoices](https://sellerapi.kaufland.com/?page=endpoints#/Order%20Invoices)

**FIELDS**

<table><thead><tr><th width="220">Field Name</th><th width="83">Data Type</th></tr></thead><tbody><tr><td>id_invoice</td><td>INTEGER</td></tr><tr><td>id_order</td><td>STRING</td></tr><tr><td>original_name</td><td>STRING</td></tr><tr><td>mime_type</td><td>STRING</td></tr><tr><td>url</td><td>STRING</td></tr><tr><td>ts_created_iso</td><td>TIMESTAMP</td></tr><tr><td>storefront</td><td>STRING</td></tr><tr><td>is_marketplace_deemed_supplier</td><td>BOOLEAN</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### orderUnits &#x20;

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

Source API Documentation: [Kaufland- orderUnits](https://sellerapi.kaufland.com/?page=endpoints#/Order%20Units)

**FIELDS**

<table><thead><tr><th width="220">Field Name</th><th width="83">Data Type</th></tr></thead><tbody><tr><td>id_order_unit</td><td>NUMERIC</td></tr><tr><td>id_order</td><td>STRING</td></tr><tr><td>ts_created_iso</td><td>TIMESTAMP</td></tr><tr><td>is_marketplace_deemed_supplier</td><td>BOOLEAN</td></tr><tr><td>fulfillment_type</td><td>STRING</td></tr><tr><td>ts_updated_iso</td><td>TIMESTAMP</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>price</td><td>INTEGER</td></tr><tr><td>id_offer</td><td>STRING</td></tr><tr><td>revenue_gross</td><td>INTEGER</td></tr><tr><td>revenue_net</td><td>INTEGER</td></tr><tr><td>unit_condition</td><td>STRING</td></tr><tr><td>storefront</td><td>STRING</td></tr><tr><td>currency</td><td>STRING</td></tr><tr><td>delivery_time_min</td><td>INTEGER</td></tr><tr><td>delivery_time_max</td><td>INTEGER</td></tr><tr><td>delivery_time_expires_iso</td><td>TIMESTAMP</td></tr><tr><td>shipping_rate</td><td>INTEGER</td></tr><tr><td>product</td><td>RECORD</td></tr><tr><td>buyer</td><td>RECORD</td></tr><tr><td>billing_address</td><td>RECORD</td></tr><tr><td>shipping_address</td><td>RECORD</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr><tr><td>note</td><td>STRING</td></tr><tr><td>order_received_timestamp_iso</td><td>TIMESTAMP</td></tr><tr><td>cancel_reason</td><td>STRING</td></tr></tbody></table>

#### orders &#x20;

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

Source API Documentation: [Kaufland- orders](https://sellerapi.kaufland.com/?page=endpoints#/Orders)

**FIELDS**

<table><thead><tr><th width="220">Field Name</th><th width="83">Data Type</th></tr></thead><tbody><tr><td>order_units_count</td><td>INTEGER</td></tr><tr><td>ts_units_updated_iso</td><td>TIMESTAMP</td></tr><tr><td>id_order</td><td>STRING</td></tr><tr><td>ts_created_iso</td><td>TIMESTAMP</td></tr><tr><td>is_marketplace_deemed_supplier</td><td>BOOLEAN</td></tr><tr><td>storefront</td><td>STRING</td></tr><tr><td>fulfillment_type</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### productDataChanges &#x20;

Purpose: Retrieves a list of all the import files for a Kaufland Seller.&#x20;

Source API Documentation: [Kaufland- productDataChanges](https://sellerapi.kaufland.com/?page=endpoints#/Product%20Data)

**FIELDS**

<table><thead><tr><th width="153">Field Name</th><th width="72">Data Type</th></tr></thead><tbody><tr><td>ean</td><td>STRING</td></tr><tr><td>title</td><td>STRING</td></tr><tr><td>changed_attributes</td><td>STRING</td></tr><tr><td>date_changed</td><td>DATETIME</td></tr><tr><td>id_item</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### returnUnits &#x20;

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

Source API Documentation: [Kaufland- returnUnits](https://sellerapi.kaufland.com/?page=endpoints#/Return%20Units)

**FIELDS**

<table><thead><tr><th width="153">Field Name</th><th width="83">Data Type</th></tr></thead><tbody><tr><td>id_return</td><td>INTEGER</td></tr><tr><td>id_return_unit</td><td>INTEGER</td></tr><tr><td>id_order_unit</td><td>NUMERIC</td></tr><tr><td>ts_created_iso</td><td>TIMESTAMP</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>note</td><td>STRING</td></tr><tr><td>reason</td><td>STRING</td></tr><tr><td>storefront</td><td>STRING</td></tr><tr><td>fulfillment_type</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### returns &#x20;

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

Source API Documentation: [Kaufland- returns](https://sellerapi.kaufland.com/?page=endpoints#/Returns)

**FIELDS**

<table><thead><tr><th width="153">Field Name</th><th width="83">Data Type</th></tr></thead><tbody><tr><td>id_return</td><td>INTEGER</td></tr><tr><td>ts_created_iso</td><td>TIMESTAMP</td></tr><tr><td>ts_updated_iso</td><td>TIMESTAMP</td></tr><tr><td>storefront</td><td>STRING</td></tr><tr><td>tracking_provider</td><td>STRING</td></tr><tr><td>tracking_code</td><td>STRING</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>fulfillment_type</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### salesNew &#x20;

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

Source API Documentation: [Kaufland- salesNew](https://sellerapi.kaufland.com/?page=endpoints#/Reports/RequestNewSalesReport)

**FIELDS**

<table><thead><tr><th width="220">Field Name</th><th width="72">Data Type</th></tr></thead><tbody><tr><td>date_inserted</td><td>DATETIME</td></tr><tr><td>order_number</td><td>STRING</td></tr><tr><td>id_order_unit</td><td>STRING</td></tr><tr><td>ean</td><td>STRING</td></tr><tr><td>id_item</td><td>STRING</td></tr><tr><td>title_item</td><td>STRING</td></tr><tr><td>offer_id</td><td>STRING</td></tr><tr><td>price</td><td>STRING</td></tr><tr><td>shipping_charges</td><td>STRING</td></tr><tr><td>unit_condition</td><td>STRING</td></tr><tr><td>delivery_time_min</td><td>STRING</td></tr><tr><td>delivery_time_max</td><td>STRING</td></tr><tr><td>note</td><td>STRING</td></tr><tr><td>unit_status</td><td>STRING</td></tr><tr><td>cancel_status</td><td>STRING</td></tr><tr><td>return_status</td><td>STRING</td></tr><tr><td>payout_status</td><td>STRING</td></tr><tr><td>order_sent_timestamp</td><td>DATETIME</td></tr><tr><td>cancel_timestamp</td><td>STRING</td></tr><tr><td>cancel_reason</td><td>STRING</td></tr><tr><td>cancel_source</td><td>STRING</td></tr><tr><td>delivery_time_expires</td><td>DATETIME</td></tr><tr><td>buyer_id_buyer</td><td>STRING</td></tr><tr><td>buyer_email</td><td>STRING</td></tr><tr><td>buyer_pseudonym</td><td>STRING</td></tr><tr><td>shipping_first_name</td><td>STRING</td></tr><tr><td>shipping_last_name</td><td>STRING</td></tr><tr><td>shipping_gender</td><td>STRING</td></tr><tr><td>shipping_company_name</td><td>STRING</td></tr><tr><td>shipping_street</td><td>STRING</td></tr><tr><td>shipping_house_number</td><td>STRING</td></tr><tr><td>shipping_additional_field</td><td>STRING</td></tr><tr><td>shipping_postcode</td><td>STRING</td></tr><tr><td>shipping_city</td><td>STRING</td></tr><tr><td>shipping_country</td><td>STRING</td></tr><tr><td>shipping_phone</td><td>STRING</td></tr><tr><td>billing_first_name</td><td>STRING</td></tr><tr><td>billing_last_name</td><td>STRING</td></tr><tr><td>billing_gender</td><td>STRING</td></tr><tr><td>billing_company_name</td><td>STRING</td></tr><tr><td>billing_street</td><td>STRING</td></tr><tr><td>billing_house_number</td><td>STRING</td></tr><tr><td>billing_additional_field</td><td>STRING</td></tr><tr><td>billing_postcode</td><td>STRING</td></tr><tr><td>billing_city</td><td>STRING</td></tr><tr><td>billing_country</td><td>STRING</td></tr><tr><td>billing_phone</td><td>STRING</td></tr><tr><td>is_marketplace_deemed_supplier</td><td>STRING</td></tr></tbody></table>

#### shippingGroups &#x20;

Purpose: Retrieve the shipping groups data and shipping group id of a Kaufland Seller. &#x20;

Source API Documentation: [Kaufland- shippingGroups](https://sellerapi.kaufland.com/?page=endpoints#/Shipping%20Groups)

**FIELDS**

<table><thead><tr><th width="153">Field Name</th><th width="71">Data Type</th></tr></thead><tbody><tr><td>currency</td><td>STRING</td></tr><tr><td>id_shipping_group</td><td>INTEGER</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>is_default</td><td>BOOLEAN</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>storefront</td><td>STRING</td></tr><tr><td>regions</td><td>RECORD</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### ticketMessages &#x20;

Purpose: Retrieve a list of the ticket messages or for a specific ticket for a Kaufland Seller. &#x20;

Source API Documentation: [Kaufland- ticketMessages](https://sellerapi.kaufland.com/?page=endpoints#/Tickets/GetTicketMessages)

**FIELDS**

<table><thead><tr><th width="153">Field Name</th><th width="83">Data Type</th></tr></thead><tbody><tr><td>id_ticket_message</td><td>INTEGER</td></tr><tr><td>id_ticket</td><td>STRING</td></tr><tr><td>author</td><td>RECORD</td></tr><tr><td>text</td><td>STRING</td></tr><tr><td>ts_created_iso</td><td>TIMESTAMP</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### tickets &#x20;

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

Source API Documentation: [Kaufland- ticket](https://sellerapi.kaufland.com/?page=endpoints#/Tickets)

**FIELDS**

<table><thead><tr><th width="153">Field Name</th><th width="83">Data Type</th></tr></thead><tbody><tr><td>id_ticket</td><td>STRING</td></tr><tr><td>ids_order_units</td><td>STRING</td></tr><tr><td>id_buyer</td><td>INTEGER</td></tr><tr><td>ts_created_iso</td><td>TIMESTAMP</td></tr><tr><td>ts_updated_iso</td><td>TIMESTAMP</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>open_reason</td><td>STRING</td></tr><tr><td>topic</td><td>STRING</td></tr><tr><td>is_seller_responsible</td><td>BOOLEAN</td></tr><tr><td>fulfillment_type</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### warehouses&#x20;

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

Source API Documentation: [Kaufland- warehouses](https://sellerapi.kaufland.com/?page=endpoints#/Warehouses)

**FIELDS**

<table><thead><tr><th width="153">Field Name</th><th width="71">Data Type</th></tr></thead><tbody><tr><td>id_warehouse</td><td>INTEGER</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>address</td><td>RECORD</td></tr><tr><td>is_default</td><td>BOOLEAN</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>
