> For the complete documentation index, see [llms.txt](https://daton-sarasanalytics.gitbook.io/daton/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/ecommerce/kaufland/schema-information.md).

# Schema Information

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

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 

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>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/ecommerce/kaufland/schema-information.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.